Oracle DBA 10g revolutionizes SQL performance tuning by providing you with automatic performance diagnosis and tuning recommendations. A brand new expert diagnosis tool called Automatic DBA Diagnostic Monitor (ADDM) uses the new Automatic Workload Repository contents to analyze instance performance. The ADDM’s analysis includes a summary of DBA problems ranked according to the amount of DBA time they’re costing, as well as a list of recommendations to eliminate these problems. The ADDM’s recommendations may include modifying configuration settings or running one of the advisors listed in the previous section. Automatic Storage Management a significant component of the Oracle database administrator 10g push towards easier management is the new Automatic Storage Management (ASM) feature.
Traditionally, we have relied on third-party vendors, such as VERITAS and EMC, to provide storage-management tools for larger systems. The new ASM feature allows the automated management of disks while not resorting to third-party logical volume managers (LVMs). You can use Oracle’s new storage virtualization layer to automate and simplify the layout and management of all Oracle DBA files when you use ASM. Instead of directly managing various files and disks, you can pay attention to a relatively small number of disk groups.
If you would like further storage, you simply add new physical disks to the logical disk groups.
The Oracle database administrator 10g server provides you with an easy way of managing the memory needs of your DBAs. Automatically shared memory management and automatic program world space management use info collected from the instance to expeditiously assign each the most important parts of Oracle’s memory allocation—the system world area (SGA) and the program global area (PGA). Oracle database administrator 10g DBAs can use the Resource Manager feature to control and channel scarce DBA resources among the various users of the grid.
You can additionally use the new computer hardware feature to manage and monitor jobs moreover as prioritize them.
TechnoKeen 