donaldburleson, Author at TechRepublic

donaldburleson

Latest from donaldburleson

Data Management

New Oracle10g SQL optimizer hints

With the introduction of Oracle 10g, there are many new optimizer hints available to control optimizer behavior. Take a quick tour of these powerful new hints.

Data Management

Database Optimization: Measuring Oracle disk I/O speed

An effective Oracle database optimization plan requires the measurement of physical disk access and an assessment of relative costs. Valuable processing information for this assessment can be gleaned from the standard Oracle STATSPACK report.

Data Centers

Database Optimization: Determine if the 64-bit architecture is right for your database

Sometimes, the implementation of 64-bit architecture will improve the performance of your Oracle database, but as our Oracle expert explains, 64-bit architecture isn't always the answer to your database optimization needs.

Banking

Database Management: Auditing and reporting Oracle user activity

New federal legislation on security and privacy has made the auditing and logging of activity in an enterprise Oracle database imperative. This technique automates the tracking of user activity and generates reports necessary to meet regulatory mandates.

Data Management

Database Optimization: Managing third-party Oracle vendor systems

Optimizing a third-party vendor Oracle database system can be near impossible when you do not have access to reliable documentation. Know what you need to manage Oracle and insist on the proper documentation to make it a reality.

Data Management

Database Optimization: Tweaking Oracle SQL performance parameters

Oracle's cost-based SQL optimizer is a sophisticated tool for tuning database performance, but the dynamic nature of database environments means that the default values are not always the best. Optimization may require CBO parameter tweaking.

Data Centers

Database management: Tuning with Oracle replication

Oracle replication is often necessary for large enterprises with dispersed processing requirements. However, replication requires a thorough understanding of the complexities such an environment introduces to a database system.

Data Management

Database management: Create a proper development environment for Oracle SQL

Optimal performance in an Oracle database requires a query development environment that enforces standards of efficiency. The guidelines outlined in this article will ensure that SQL execution plans perform as intended.

Networking

Database management: Optimizing your Oracle*Net configuration

Because Oracle databases are often shared across geographical areas, it's imperative that DBAs optimize the configuration parameters they can control. This analysis will show you where optimization may be lacking in your database network.

Data Management

Database administration: Causes of Oracle buffer busy waits

Resolving buffer busy wait events in an Oracle database can be vital to your optimization efforts. Insight into the causes of this performance problem is provided in this examination by Oracle guru Don Burleson.

PURPOSE These guidelines from TechRepublic Premium will help you define the necessary ingredients of a security policy and assist in its proper construction. They’re designed to work hand in hand with the subjective knowledge you have of your company, environment and employees. Using this information, your business can establish new policies or elaborate on those ...

PURPOSE Recruiting an Artificial Intelligence Architect with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, DESIRABLE PERSONALITY ...

PURPOSE Hiring the right Autonomous Systems Engineer requires a specific and precise recruitment process, supported by a thorough understanding of the project requirements. This Hiring Kit from TechRepublic Premium provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job. From the hiring kit: DETERMINING FACTORS, ...

donaldburleson

New Oracle10g SQL optimizer hints

Database Optimization: Measuring Oracle disk I/O speed

Database Optimization: Determine if the 64-bit architecture is right for your database

Database Management: Auditing and reporting Oracle user activity

Database Optimization: Managing third-party Oracle vendor systems

Database Optimization: Tweaking Oracle SQL performance parameters

Database management: Tuning with Oracle replication

Database management: Create a proper development environment for Oracle SQL

Database management: Optimizing your Oracle*Net configuration

Database administration: Causes of Oracle buffer busy waits

Guidelines for building security policies

Hiring kit: Artificial intelligence architect

Hiring kit: Autonomous systems engineer

Hiring kit: Application support engineer