Oracle Archives - Page 29 of 31

Why Virtualization Matters to Your Career as an Oracle RAC DBA

Learn what every DBA should know about how to deploy, manage and optimize performance of Oracle RAC in a virtualized environment.

Reading Oracle Explain Plans, Part 2: the RBO and the CBO

Learn how Oracle uses the rule-based optimizer (RBO) and the cost-based optimizer (CBO) to decide on an execution plan.

Reading Oracle Explain Plans, Part 1: The Basics

Learn exactly how Oracle arrives at an execution plan for both the Oracle rule-based optimizer (RBO) and the cost-based optimizer (CBO).

Understanding Oracle Explain Plans

Learn how to use the Oracle PLAN_TABLE and explain plans to guide performance tuning.

How Oracle Architecture Affects Performance Tuning

Key aspects of Oracle architecture may impact tuning efforts. Learn more.

Have you made these 5 database design mistakes?

Want to save your company money, headaches for end-users, and ensure data quality? Avoid these five database design mistakes.

Oracle Log File Switch Completion

Log file switch completion is the time a session waits for recording and archiving changes to data through redo log generation. Learn about performance hits.

Oracle Buffer Busy Wait Event

Buffer busy wait occurs when a session tries to access a block in the buffer cache but the buffer is busy. Learn about performance impact.

Oracle Control File Read & Write Wait Events

The three control file read and write wait events all contribute to the time Oracle takes to keep the control file current. Learn more.

Oracle Row Cache Lock Wait Event Explained

The row cache lock wait event is associated with a specific enqueue type on a data dictionary row. Learn why this happens and what you can do to tune for it.

Solving Oracle enq: TM Contention Wait Events

Waits on enq: TM – contention in Oracle indicate there are unindexed foreign key constraints. Learn more about how foreign key constraints relate to this wait and how to tune for it.