In Oracle, whenever a query is made, a component called the optimizer makes a decision as to how to best retrieve the return query set. Oracle supports two optimizers: the Rule-Based Optimizer (RBO), the “original” optimizer, and the Cost-Based Optimizer (CBO), first introduced in Oracle7. The CBO has been enhanced greatly since and is now . . . → Read More: Siebel CRM with Oracle® Cost-Based Optimizer (CBO)
|
|||||
|
The purpose of RMAN performance tuning is to identify the bottlenecks for a given backup or restore job and use RMAN commands, initialization parameters, or adjustments to physical media to improve overall performance. As database sizes continue to grow unabated, with tens to hundreds of terabytes prevalent in customer’s environments, server and storage systems have . . . → Read More: RMAN Performance Tuning Using Buffer Memory Parameters Traditional Oracle database performance tuning methodologies based on ratios are quickly becoming outdated and unusable as applications and databases continue to grow significantly across varying types of businesses. The “Ratio Tuning” technique involves finding bad ratios (e.g., the buffer cache hit ratio, latch-hit ratio) and addressing each separately. This technique is very simple and straightforward, . . . → Read More: Yet Another Performance Profiling Method (Or YAPP-Method) |
|
||||
|
Copyright © 2012 Oracle Clinic – Maclean Liu的个人技术博客 - All Rights Reserved |
|||||
最新评论