Oracle9i Performance Tuning Tips & Techniques
From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!
What people are saying - Write a review
We haven't found any reviews in the usual places.
ADDR allocated alter ANALYZED b-tree backup bitmap indexes block buffer cache bytes Chapter cluster column command cost-based optimization create cursor data dictionary database datafiles DB_CACHE_SIZE decode default deptno disk reads driving table empno ename example execution plan EXPLAIN PLAN FALSE FALSE full table scan HASH join hash table hint INDEX RANGE SCAN INDX init.ora parameters initialization parameters inst_id instance latch library cache memory monitor multiple NESTED LOOPS NESTED LOOPS join NULL objects option Oracle Oracle Corporation Oracle database Oracle Enterprise Manager Oracle9 output package parallel DML parallel operations parallel query parse partition percent PL/SQL problem query in Listing redo log retrieve rollback segments ROWID script SELECT STATEMENT server session shared pool SHARED_POOL_SIZE shown in Listing shows SMPDEMO-LAP SORT SORT-MERGE join specified spfile SQL statements SQL*Plus statistics STATSPACK tablespace tuning undo UPDATE USERENVI'Instance v$session V$SQLAREA View Name wait