donald burleson

Discussion Threads

Has anyone ever worked with Burleson Consulting?

October 4, 2010 6:05am PDT

Has anyone ever worked with Burleson Consulting? I'm curious. I'm working on quite a large Oracle project at the moment and there are a lot of questions I don't have the answers to, so what do I...

7 Started by kevaburg@...  |  Latest comment by Palmetto_CharlieSpencer

Articles

New Oracle10g SQL optimizer hints

April 26, 2004 7:00am PDT

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.

Articles

Database Optimization: Measuring Oracle disk I/O speed

March 1, 2004 8:00am PST

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...

2 Latest comment by StephenCairns

Articles

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

February 23, 2004 2:56pm PST

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...

Articles

Database Management: Auditing and reporting Oracle user activity

February 9, 2004 8:00am PST

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...

2 Latest comment by Cecilia_Haryanto

Articles

Database Optimization: Managing third-party Oracle vendor systems

February 2, 2004 8:00am PST

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...

Articles

Database Optimization: Tweaking Oracle SQL performance parameters

January 26, 2004 8:00am PST

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....

1

Articles

Database management: Tuning with Oracle replication

January 6, 2004 8:00am PST

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

1

Articles

Database management: Create a proper development environment for Oracle SQL

December 29, 2003 8:00am PST

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...

Articles

Database management: Optimizing your Oracle*Net configuration

December 16, 2003 8:00am PST

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...

Articles

Database administration: Causes of Oracle buffer busy waits

December 9, 2003 8:00am PST

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...

Articles

Use referential integrity to enforce basic business rules in Oracle

December 2, 2003 8:00am PST

To ensure the integrity of an Oracle database, basic business rules must be enforced. While applications can enforce these rules to a degree, it is often more efficient to use referential...

2 Latest comment by Allan Beatty

Articles

Optimize an Oracle network configuration

November 18, 2003 8:00am PST

Sharing Oracle databases across networks is standard procedure in many enterprises. Use the Transparent Network Substrate to optimize the distributed communications between databases, and find out...

Articles

Extend the capabilities of STATSPACK to measure Oracle disk I/O

November 11, 2003 8:00am PST

The measurement of disk I/O plays a vital role in Oracle performance optimization. The technique outlined by our Oracle guru Don Burleson extends the capabilities of STATSPACK, generating a more...

Articles

Hypercharge Oracle SQL by using histograms

October 31, 2003 8:00am PST

Column histograms can significantly increase SQL query performance, but they should be used only under certain skewed conditions. Follow these guidelines to find out whether histograms are right...

Articles

Optimize SQL query speed with the Oracle clustering_factor attribute

October 27, 2003 8:00am PST

Optimizing SQL query speed in Oracle involves numerous data characteristics. One of the most important determining characteristics is clustering_factor. Learn more about this attribute before you...

Articles

What to expect when you migrate to Oracle9i

October 16, 2003 7:00am PDT

The Oracle Corporation will not support Oracle8i after December 31, 2003. Are you ready to migrate to Oracle9i? Find out what to expect when transitioning to the latest version of this database...

4 Latest comment by sure_subha@...

Articles

CEO Ellison reveals the Oracle10g vision of enterprise grid computing

October 6, 2003 1:10pm PDT

Oracle CEO Larry Ellison discussed his vision for grid computing via Oracle10g at the OracleWorld conference. Our resident Oracle expert examines that vision and what it could mean to your...

1

Articles

Audit design with Oracle fine-grained auditing

September 22, 2003 7:00am PDT

With the passage of HIPAA, the importance of fine-grained auditing in Oracle databases cannot be overstated. See how Oracle's most powerful auditing tool can help you meet the steep audit trail...

2 Latest comment by danielj@...

Articles

Choose the proper Oracle design for auditing

September 8, 2003 7:00am PDT

Not only is auditing an Oracle database a good administrative practice, but in many cases it is now the law. Auditing methods should be decided during the design stages--not as an afterthought....

1