WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ USRSE 2414254159 usrse 1 10.2.0.4.0 NO rum.perflab. Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 390 03-Jan-13 21:15:27 42 3.3 End Snap: 394 03-Jan-13 22:15:40 45 4.4 Elapsed: 60.21 (mins) DB Time: 41.09 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 1,008M 1,008M Std Block Size: 8K Shared Pool Size: 1,008M 1,008M Log Buffer: 21,120K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 49,090.87 3,041.01 Logical reads: 1,337.88 82.88 Block changes: 304.57 18.87 Physical reads: 0.08 0.01 Physical writes: 28.31 1.75 User calls: 316.72 19.62 Parses: 130.30 8.07 Hard parses: 0.00 0.00 Sorts: 0.21 0.01 Logons: 0.02 0.00 Executes: 220.61 13.67 Transactions: 16.14 % Blocks changed per Read: 22.77 Recursive Call %: 7.05 Rollback per transaction %: 0.00 Rows per Sort: 92.41 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.99 Redo NoWait %: 100.00 Buffer Hit %: 99.99 In-memory Sort %: 100.00 Library Hit %: 100.00 Soft Parse %: 100.00 Execute to Parse %: 40.93 Latch Hit %: 99.73 Parse CPU to Parse Elapsd %: 92.04 % Non-Parse CPU: 94.80 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 35.40 35.41 % SQL with executions>1: 96.89 96.96 % Memory for SQL w/exec>1: 92.41 95.76 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- db file parallel write 73,702 2,913 40 118.1 System I/O log file sync 59,346 1,994 34 80.9 Commit log file parallel write 54,195 1,338 25 54.3 System I/O CPU time 473 19.2 control file parallel write 1,640 80 49 3.3 System I/O ------------------------------------------------------------- Time Model Statistics DB/Inst: USRSE/usrse Snaps: 390-394 -> Total time in database user-calls (DB Time): 2465.6s -> Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic -> Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time ------------------------------------------ ------------------ ------------ DB CPU 473.4 19.2 sql execute elapsed time 295.0 12.0 parse time elapsed 29.2 1.2 PL/SQL execution elapsed time 5.3 .2 repeated bind elapsed time 2.2 .1 sequence load elapsed time 1.4 .1 connection management call elapsed time 1.1 .0 hard parse elapsed time 0.0 .0 PL/SQL compilation elapsed time 0.0 .0 DB time 2,465.6 N/A background elapsed time 4,411.9 N/A background cpu time 153.9 N/A ------------------------------------------------------------- Wait Class DB/Inst: USRSE/usrse Snaps: 390-394 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc Avg %Time Total Wait wait Waits Wait Class Waits -outs Time (s) (ms) /txn -------------------- ---------------- ------ ---------------- ------- --------- System I/O 133,016 .0 4,332 33 2.3 Commit 59,346 .0 1,994 34 1.0 User I/O 329 .0 8 26 0.0 Concurrency 1,565 .1 3 2 0.0 Network 893,133 .0 3 0 15.3 Other 476 1.9 0 0 0.0 Configuration 11 .0 0 1 0.0 ------------------------------------------------------------- Wait Events DB/Inst: USRSE/usrse Snaps: 390-394 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- db file parallel write 73,702 .0 2,913 40 1.3 log file sync 59,346 .0 1,994 34 1.0 log file parallel write 54,195 .0 1,338 25 0.9 control file parallel write 1,640 .0 80 49 0.0 db file sequential read 300 .0 8 25 0.0 SQL*Net message to client 892,922 .0 3 0 15.3 enq: TX - index contention 49 .0 1 28 0.0 os thread startup 9 .0 1 148 0.0 direct path read 24 .0 1 37 0.0 control file sequential read 3,479 .0 1 0 0.1 latch: In memory undo latch 667 .0 0 0 0.0 buffer busy waits 697 .0 0 0 0.0 latch free 3 .0 0 30 0.0 latch: cache buffers chains 142 .0 0 0 0.0 enq: CF - contention 1 .0 0 41 0.0 rdbms ipc reply 21 .0 0 1 0.0 SQL*Net more data to client 149 .0 0 0 0.0 enq: SQ - contention 11 .0 0 1 0.0 cursor: pin S wait on X 1 100.0 0 10 0.0 LGWR wait for redo copy 111 .0 0 0 0.0 cursor: pin S 331 .0 0 0 0.0 SQL*Net more data from clien 62 .0 0 0 0.0 direct path write 5 .0 0 1 0.0 buffer deadlock 9 100.0 0 0 0.0 SQL*Net message from client 892,918 .0 95,489 107 15.3 Streams AQ: qmn slave idle w 129 .0 3,515 27249 0.0 Streams AQ: qmn coordinator 258 50.0 3,515 13625 0.0 Streams AQ: waiting for time 1 100.0 681 681306 0.0 class slave wait 10 .0 0 0 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- db file parallel write 73,706 .0 2,913 40 1.3 log file parallel write 54,193 .0 1,338 25 0.9 control file parallel write 1,640 .0 80 49 0.0 os thread startup 9 .0 1 148 0.0 control file sequential read 3,215 .0 0 0 0.1 db file sequential read 29 .0 0 5 0.0 events in waitclass Other 133 .0 0 1 0.0 buffer busy waits 2 .0 0 0 0.0 rdbms ipc message 247,144 5.6 43,908 178 4.2 pmon timer 1,205 100.0 3,522 2923 0.0 Streams AQ: qmn slave idle w 129 .0 3,515 27249 0.0 Streams AQ: qmn coordinator 258 50.0 3,515 13625 0.0 smon timer 16 56.3 3,381 211290 0.0 Streams AQ: waiting for time 1 100.0 681 681306 0.0 ------------------------------------------------------------- Operating System Statistics DB/Inst: USRSE/usrse Snaps: 390-394 Statistic Total -------------------------------- -------------------- AVG_BUSY_TIME 16,450 AVG_IDLE_TIME 344,739 AVG_IOWAIT_TIME 0 AVG_SYS_TIME 7,554 AVG_USER_TIME 8,777 BUSY_TIME 132,450 IDLE_TIME 2,758,760 IOWAIT_TIME 0 SYS_TIME 61,318 USER_TIME 71,132 LOAD 0 OS_CPU_WAIT_TIME 176,400 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 0 VM_OUT_BYTES 0 PHYSICAL_MEMORY_BYTES 33,727,037,440 NUM_CPUS 8 ------------------------------------------------------------- Service Statistics DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$USERS 2,458.3 473.2 232 4,796,205 SYS$BACKGROUND 0.0 0.0 60 37,465 usrse.world 0.0 0.0 0 0 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> Wait Class info for services in the Service Statistics section. -> Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network -> Time Waited (Wt Time) in centisecond (100th of a second) Service Name ---------------------------------------------------------------- User I/O User I/O Concurcy Concurcy Admin Admin Network Network Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time --------- --------- --------- --------- --------- --------- --------- --------- SYS$USERS 232 407 1554 162 0 0 892856 266 SYS$BACKGROUND 97 440 11 133 0 0 0 0 ------------------------------------------------------------- ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: USRSE/usrse Snaps: 390-394 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- CPU used by this session 49,916 13.8 0.9 CPU used when call started 49,802 13.8 0.9 CR blocks created 3,399 0.9 0.1 Cached Commit SCN referenced 106 0.0 0.0 Commit SCN cached 8 0.0 0.0 DB time 253,452 70.2 4.4 DBWR checkpoint buffers written 102,257 28.3 1.8 DBWR checkpoints 0 0.0 0.0 DBWR object drop buffers written 0 0.0 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR thread checkpoint buffers w 102,257 28.3 1.8 DBWR transaction table writes 800 0.2 0.0 DBWR undo block writes 9,386 2.6 0.2 IMU CR rollbacks 1,978 0.6 0.0 IMU Flushes 6,452 1.8 0.1 IMU Redo allocation size 14,005,572 3,876.6 240.1 IMU commits 51,872 14.4 0.9 IMU contention 1,296 0.4 0.0 IMU ktichg flush 0 0.0 0.0 IMU pool not allocated 0 0.0 0.0 IMU recursive-transaction flush 1 0.0 0.0 IMU undo allocation size 242,364,744 67,084.1 4,155.6 IMU- failed to get a private str 0 0.0 0.0 SMON posted for undo segment shr 6 0.0 0.0 SQL*Net roundtrips to/from clien 892,758 247.1 15.3 active txn count during cleanout 3,968 1.1 0.1 application wait time 0 0.0 0.0 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 15,598 4.3 0.3 branch node splits 3 0.0 0.0 buffer is not pinned count 844,879 233.9 14.5 buffer is pinned count 984,790 272.6 16.9 bytes received via SQL*Net from 139,597,536 38,639.2 2,393.6 bytes sent via SQL*Net to client 273,890,883 75,810.2 4,696.2 calls to get snapshot scn: kcmgs 1,265,174 350.2 21.7 calls to kcmgas 68,613 19.0 1.2 calls to kcmgcs 1,234 0.3 0.0 change write time 1,174 0.3 0.0 cleanout - number of ktugct call 6,154 1.7 0.1 cleanouts and rollbacks - consis 2,405 0.7 0.0 cleanouts only - consistent read 800 0.2 0.0 cluster key scan block gets 5,562 1.5 0.1 cluster key scans 195 0.1 0.0 commit batch/immediate performed 24 0.0 0.0 commit batch/immediate requested 24 0.0 0.0 commit cleanout failures: block 0 0.0 0.0 commit cleanout failures: buffer 4 0.0 0.0 commit cleanout failures: callba 10 0.0 0.0 commit cleanout failures: cannot 917 0.3 0.0 commit cleanouts 435,221 120.5 7.5 commit cleanouts successfully co 434,290 120.2 7.5 commit immediate performed 24 0.0 0.0 commit immediate requested 24 0.0 0.0 commit txn count during cleanout 6,750 1.9 0.1 concurrency wait time 295 0.1 0.0 consistent changes 30,026 8.3 0.5 consistent gets 3,126,127 865.3 53.6 consistent gets - examination 1,744,731 482.9 29.9 consistent gets direct 25 0.0 0.0 Instance Activity Stats DB/Inst: USRSE/usrse Snaps: 390-394 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- consistent gets from cache 3,126,102 865.3 53.6 cursor authentications 2 0.0 0.0 data blocks consistent reads - u 3,568 1.0 0.1 db block changes 1,100,372 304.6 18.9 db block gets 1,707,431 472.6 29.3 db block gets direct 19 0.0 0.0 db block gets from cache 1,707,412 472.6 29.3 deferred (CURRENT) block cleanou 180,573 50.0 3.1 dirty buffers inspected 0 0.0 0.0 doubling up with imu segment 0 0.0 0.0 enqueue conversions 55,741 15.4 1.0 enqueue releases 347,638 96.2 6.0 enqueue requests 347,638 96.2 6.0 enqueue timeouts 0 0.0 0.0 enqueue waits 61 0.0 0.0 exchange deadlocks 9 0.0 0.0 execute count 797,015 220.6 13.7 free buffer inspected 6,097 1.7 0.1 free buffer requested 15,239 4.2 0.3 heap block compress 1,038 0.3 0.0 hot buffers moved to head of LRU 9,002 2.5 0.2 immediate (CR) block cleanout ap 3,205 0.9 0.1 immediate (CURRENT) block cleano 11,136 3.1 0.2 index crx upgrade (found) 0 0.0 0.0 index crx upgrade (positioned) 5,560 1.5 0.1 index fast full scans (full) 0 0.0 0.0 index fetch by key 572,512 158.5 9.8 index scans kdiixs1 106,786 29.6 1.8 leaf node 90-10 splits 181 0.1 0.0 leaf node splits 1,406 0.4 0.0 lob reads 5,358 1.5 0.1 lob writes 6,716 1.9 0.1 lob writes unaligned 6,716 1.9 0.1 logons cumulative 73 0.0 0.0 messages received 296,065 82.0 5.1 messages sent 296,061 82.0 5.1 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 909,604 251.8 15.6 opened cursors cumulative 470,750 130.3 8.1 parse count (failures) 0 0.0 0.0 parse count (hard) 3 0.0 0.0 parse count (total) 470,765 130.3 8.1 parse time cpu 2,462 0.7 0.0 parse time elapsed 2,675 0.7 0.1 physical read IO requests 292 0.1 0.0 physical read bytes 2,392,064 662.1 41.0 physical read total IO requests 3,803 1.1 0.1 physical read total bytes 59,654,144 16,511.7 1,022.8 physical read total multi block 0 0.0 0.0 physical reads 292 0.1 0.0 physical reads cache 267 0.1 0.0 physical reads cache prefetch 0 0.0 0.0 physical reads direct 25 0.0 0.0 physical reads direct (lob) 24 0.0 0.0 physical write IO requests 74,779 20.7 1.3 physical write bytes 837,844,992 231,907.0 14,365.9 physical write total IO requests 188,287 52.1 3.2 physical write total bytes 1,310,436,352 362,715.5 22,469.0 physical write total multi block 122,605 33.9 2.1 physical writes 102,276 28.3 1.8 Instance Activity Stats DB/Inst: USRSE/usrse Snaps: 390-394 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical writes direct 19 0.0 0.0 physical writes direct (lob) 1 0.0 0.0 physical writes direct temporary 0 0.0 0.0 physical writes from cache 102,257 28.3 1.8 physical writes non checkpoint 5,645 1.6 0.1 pinned buffers inspected 0 0.0 0.0 prefetch clients - default 0 0.0 0.0 process last non-idle time 3,629 1.0 0.1 recursive calls 86,811 24.0 1.5 recursive cpu usage 2,746 0.8 0.1 redo blocks written 383,112 106.0 6.6 redo buffer allocation retries 0 0.0 0.0 redo entries 222,243 61.5 3.8 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo ordering marks 3,938 1.1 0.1 redo size 177,357,904 49,090.9 3,041.0 redo subscn max counts 9,672 2.7 0.2 redo synch time 204,232 56.5 3.5 redo synch writes 59,233 16.4 1.0 redo wastage 12,614,532 3,491.6 216.3 redo write time 137,338 38.0 2.4 redo writer latching time 0 0.0 0.0 redo writes 54,191 15.0 0.9 rollback changes - undo records 102 0.0 0.0 rollbacks only - consistent read 954 0.3 0.0 rows fetched via callback 384,890 106.5 6.6 session connect time 0 0.0 0.0 session cursor cache hits 468,578 129.7 8.0 session logical reads 4,833,544 1,337.9 82.9 session pga memory 2,909,096 805.2 49.9 session pga memory max 5,530,536 1,530.8 94.8 session uga memory 3,482,904 964.0 59.7 session uga memory max 52,144,192 14,433.0 894.1 shared hash latch upgrades - no 8,311 2.3 0.1 shared hash latch upgrades - wai 14 0.0 0.0 sorts (memory) 757 0.2 0.0 sorts (rows) 69,958 19.4 1.2 sql area evicted 0 0.0 0.0 sql area purged 0 0.0 0.0 summed dirty queue length 0 0.0 0.0 switch current to new buffer 14 0.0 0.0 table fetch by rowid 498,000 137.8 8.5 table fetch continued row 0 0.0 0.0 table scan blocks gotten 719,290 199.1 12.3 table scan rows gotten 2,956,001 818.2 50.7 table scans (long tables) 0 0.0 0.0 table scans (short tables) 79,904 22.1 1.4 total number of times SMON poste 7 0.0 0.0 transaction rollbacks 24 0.0 0.0 undo change vector size 62,142,156 17,200.3 1,065.5 user I/O wait time 846 0.2 0.0 user calls 1,144,260 316.7 19.6 user commits 58,322 16.1 1.0 user rollbacks 0 0.0 0.0 workarea executions - optimal 501 0.1 0.0 write clones created in backgrou 0 0.0 0.0 write clones created in foregrou 291 0.1 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: USRSE/usrse Snaps: 390-394 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session cursor cache count 103,677 105,478 opened cursors current 139 200 logons current 42 45 ------------------------------------------------------------- Instance Activity Stats - Thread Activity DB/Inst: USRSE/usrse Snaps: 390-394 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by IOs (Reads + Writes) desc Tablespace ------------------------------ Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ INDEX_LARGE 181 0 17.1 1.0 68,870 19 356 0.1 DATA_LARGE 26 0 0.0 1.0 3,215 1 128 0.2 UNDO 0 0 0.0 .0 1,669 0 213 0.2 SYSAUX 56 0 18.2 1.0 658 0 0 0.0 SYSTEM 29 0 3.4 1.0 107 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Av Av Av Buffer Av Buf Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms) -------------- ------- ------ ------- ------------ -------- ---------- ------ DATA_LARGE /oracle/oradata/usrse/data0/data_large01.dbf 26 0 0.0 1.0 3,215 1 128 0.2 INDEX_LARGE /oracle/oradata/usrse/data0/index_large01.dbf 181 0 17.1 1.0 68,870 19 356 0.1 SYSAUX /oracle/oradata/usrse/data0/sysaux01.dbf 56 0 18.2 1.0 658 0 0 0.0 SYSTEM /oracle/oradata/usrse/data0/system01.dbf 29 0 3.4 1.0 107 0 0 0.0 UNDO /oracle/oradata/usrse/data0/undo01.dbf 0 0 N/A N/A 1,669 0 213 0.2 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: USRSE/usrse Snaps: 390-394 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Writ Buffer Number of Pool Buffer Physical Physical Buff Comp Busy P Buffers Hit% Gets Reads Writes Wait Wait Waits --- ---------- ---- -------------- ------------ ----------- ---- ---- ---------- D 124,677 100 4,833,197 267 102,306 0 0 698 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> B: Begin snapshot, E: End snapshot Targt Estd Log File Log Ckpt Log Ckpt MTTR MTTR Recovery Actual Target Size Timeout Interval (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks - ----- ----- ---------- --------- --------- ---------- --------- ------------ B 0 2 2486 10548 10000 1887390 197661 10000 E 0 2 2444 10670 10000 1887390 196030 10000 ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: USRSE/usrse Snap: 394 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Size for Size Buffers for Read Estimated P Est (M) Factor Estimate Factor Physical Reads --- -------- ------ ---------------- ------ ------------------ D 96 .1 11,874 578.8 36,958,659 D 192 .2 23,748 116.8 7,459,354 D 288 .3 35,622 14.5 928,376 D 384 .4 47,496 3.9 250,776 D 480 .5 59,370 1.4 87,047 D 576 .6 71,244 1.2 75,587 D 672 .7 83,118 1.1 70,522 D 768 .8 94,992 1.1 67,641 D 864 .9 106,866 1.0 66,336 D 960 1.0 118,740 1.0 64,757 D 1,008 1.0 124,677 1.0 63,853 D 1,056 1.0 130,614 1.0 63,153 D 1,152 1.1 142,488 1.0 62,696 D 1,248 1.2 154,362 1.0 62,218 D 1,344 1.3 166,236 1.0 61,151 D 1,440 1.4 178,110 0.9 60,407 D 1,536 1.5 189,984 0.9 59,750 D 1,632 1.6 201,858 0.9 59,420 D 1,728 1.7 213,732 0.9 58,902 D 1,824 1.8 225,606 0.9 58,353 D 1,920 1.9 237,480 0.9 58,131 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: USRSE/usrse Snaps: 390-394 -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ------------------ -------------------------- 100.0 94 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval) -> Auto PGA Target - actual workarea memory target -> W/A PGA Used - amount of memory used for all Workareas (manual + auto) -> %PGA W/A Mem - percentage of PGA memory allocated to workareas -> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt -> %Man W/A Mem - percentage of workarea memory under manual control %PGA %Auto %Man PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K) - ---------- ---------- ---------- ---------- ------ ------ ------ ---------- B 420 333 100.7 0.0 .0 .0 .0 86,016 E 420 331 104.3 0.0 .0 .0 .0 86,016 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: USRSE/usrse Snaps: 390-394 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 376 376 0 0 64K 128K 16 16 0 0 256K 512K 8 8 0 0 512K 1024K 76 76 0 0 1M 2M 25 25 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: USRSE/usrse Snap: 394 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd PGA Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overalloc Est (MB) Factr Processed Written to Disk Hit % Count ---------- ------- ---------------- ---------------- -------- ---------- 53 0.1 7,434.4 1,899.8 80.0 194 105 0.3 7,434.4 283.4 96.0 6 210 0.5 7,434.4 87.9 99.0 0 315 0.8 7,434.4 87.9 99.0 0 420 1.0 7,434.4 0.0 100.0 0 504 1.2 7,434.4 0.0 100.0 0 588 1.4 7,434.4 0.0 100.0 0 672 1.6 7,434.4 0.0 100.0 0 756 1.8 7,434.4 0.0 100.0 0 840 2.0 7,434.4 0.0 100.0 0 1,260 3.0 7,434.4 0.0 100.0 0 1,680 4.0 7,434.4 0.0 100.0 0 2,520 6.0 7,434.4 0.0 100.0 0 3,360 8.0 7,434.4 0.0 100.0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: USRSE/usrse Snap: 394 -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor -> Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid. Est LC Est LC Est LC Est LC Shared SP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 112 .1 112 10,448 ####### 1.0 17,801 1.0 ########### 224 .2 224 22,110 ####### 1.0 17,798 1.0 ########### 336 .3 315 40,210 ####### 1.0 17,798 1.0 ########### 448 .4 315 40,210 ####### 1.0 17,798 1.0 ########### 560 .6 315 40,210 ####### 1.0 17,798 1.0 ########### 672 .7 315 40,210 ####### 1.0 17,798 1.0 ########### 784 .8 315 40,210 ####### 1.0 17,798 1.0 ########### 896 .9 315 40,210 ####### 1.0 17,798 1.0 ########### 1,008 1.0 315 40,210 ####### 1.0 17,798 1.0 ########### 1,120 1.1 315 40,210 ####### 1.0 17,798 1.0 ########### 1,232 1.2 315 40,210 ####### 1.0 17,798 1.0 ########### 1,344 1.3 315 40,210 ####### 1.0 17,798 1.0 ########### 1,456 1.4 315 40,210 ####### 1.0 17,798 1.0 ########### 1,568 1.6 315 40,210 ####### 1.0 17,798 1.0 ########### 1,680 1.7 315 40,210 ####### 1.0 17,798 1.0 ########### 1,792 1.8 315 40,210 ####### 1.0 17,798 1.0 ########### 1,904 1.9 315 40,210 ####### 1.0 17,798 1.0 ########### 2,016 2.0 315 40,210 ####### 1.0 17,798 1.0 ########### ------------------------------------------------------------- SGA Target Advisory DB/Inst: USRSE/usrse Snap: 394 No data exists for this section of the report. ------------------------------------------------------------- Streams Pool Advisory DB/Inst: USRSE/usrse Snap: 394 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: USRSE/usrse Snap: 394 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 483 0 0 undo header 156 0 0 undo block 57 0 0 1st level bmb 1 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: USRSE/usrse Snaps: 390-394 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- TX-Transaction (index contention) 49 49 0 49 1 28.29 CF-Controlfile Transaction 1,830 1,830 0 1 0 42.00 SQ-Sequence Cache 946 946 0 11 0 1.00 ------------------------------------------------------------- Undo Segment Summary DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Undo Segment Stats DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Latch Activity DB/Inst: USRSE/usrse Snaps: 390-394 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ASM db client latch 2,364 0.0 N/A 0 0 N/A AWR Alerted Metric Eleme 14,645 0.0 N/A 0 0 N/A Consistent RBA 54,192 0.0 N/A 0 0 N/A FAL request queue 72 0.0 N/A 0 0 N/A FAL subheap alocation 72 0.0 N/A 0 0 N/A FOB s.o list latch 237 0.0 N/A 0 0 N/A In memory undo latch 587,348 0.2 0.6 0 58,479 0.0 KMG MMAN ready and start 1,201 0.0 N/A 0 0 N/A KTF sga latch 8 0.0 N/A 0 1,212 0.0 KWQMN job cache list lat 1 0.0 N/A 0 0 N/A Memory Management Latch 0 N/A N/A 0 1,201 0.0 OS process 264 0.0 N/A 0 0 N/A OS process allocation 1,380 0.0 N/A 0 0 N/A OS process: request allo 143 0.0 N/A 0 0 N/A PL/SQL warning settings 116 0.0 N/A 0 0 N/A SQL memory manager latch 4 0.0 N/A 0 1,172 0.0 SQL memory manager worka 79,976 0.0 N/A 0 0 N/A Shared B-Tree 129 0.0 N/A 0 0 N/A active checkpoint queue 246,423 5.0 0.0 0 0 N/A active service list 1,806 0.0 N/A 0 1,205 0.0 archive control 64 0.0 N/A 0 0 N/A archive process latch 1,316 0.0 N/A 0 0 N/A begin backup scn array 5 0.0 N/A 0 0 N/A cache buffer handles 3,596 0.0 N/A 0 0 N/A cache buffers chains 12,513,021 0.0 0.1 0 12,016 0.0 cache buffers lru chain 210,816 0.1 0.0 0 18,540 0.0 channel handle pool latc 145 0.0 N/A 0 0 N/A channel operations paren 16,956 0.0 N/A 0 0 N/A checkpoint queue latch 1,163,249 0.0 0.0 0 86,559 0.0 client/application info 73 0.0 N/A 0 0 N/A compile environment latc 73 0.0 N/A 0 0 N/A dml lock allocation 565,605 0.0 0.0 0 0 N/A dummy allocation 143 0.0 N/A 0 0 N/A enqueue hash chains 751,089 0.0 0.0 0 142 0.0 enqueues 65,424 0.1 0.0 0 0 N/A event group latch 73 0.0 N/A 0 0 N/A file cache latch 62 0.0 N/A 0 0 N/A global KZLD latch for me 62 0.0 N/A 0 0 N/A hash table column usage 6 0.0 N/A 0 0 N/A hash table modification 7 0.0 N/A 0 0 N/A kks stats 6 0.0 N/A 0 0 N/A kokc descriptor allocati 12 0.0 N/A 0 0 N/A ksuosstats global area 249 0.0 N/A 0 0 N/A ktm global data 28 0.0 N/A 0 0 N/A kwqbsn:qsga 129 0.0 N/A 0 0 N/A lgwr LWN SCN 54,211 0.0 N/A 0 0 N/A library cache 263,951 0.1 0.0 0 0 N/A library cache lock 31,267 0.0 0.0 0 0 N/A library cache lock alloc 881 0.0 N/A 0 0 N/A library cache pin 129,014 0.0 0.0 0 0 N/A library cache pin alloca 16 0.0 N/A 0 0 N/A list of block allocation 173 0.0 N/A 0 0 N/A loader state object free 50 0.0 N/A 0 0 N/A message pool operations 2 0.0 N/A 0 0 N/A messages 882,001 3.0 0.0 0 0 N/A mostly latch-free SCN 54,286 0.0 0.0 0 0 N/A multiblock read objects 2 0.0 N/A 0 0 N/A ncodef allocation latch 57 0.0 N/A 0 0 N/A object queue header heap 55 0.0 N/A 0 186 0.0 object queue header oper 331,440 0.0 0.0 0 0 N/A Latch Activity DB/Inst: USRSE/usrse Snaps: 390-394 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ object stats modificatio 4 0.0 N/A 0 0 N/A parallel query alloc buf 468 0.0 N/A 0 0 N/A parameter list 6 0.0 N/A 0 0 N/A parameter table allocati 70 0.0 N/A 0 0 N/A post/wait queue 86,844 0.0 0.0 0 59,342 0.0 process allocation 143 0.0 N/A 0 73 0.0 process group creation 143 0.0 N/A 0 0 N/A qmn task queue latch 516 0.0 N/A 0 0 N/A redo allocation 279,689 0.0 0.0 0 222,219 0.1 redo copy 0 N/A N/A 0 222,262 0.1 redo writing 411,667 4.6 0.0 0 0 N/A row cache objects 21,527 0.0 0.0 0 0 N/A sequence cache 57,987 0.0 0.0 0 0 N/A session allocation 126,257 0.1 0.0 0 0 N/A session idle bit 2,348,185 0.0 0.0 0 0 N/A session state list latch 169 0.0 N/A 0 0 N/A session switching 57 0.0 N/A 0 0 N/A session timer 1,205 0.0 N/A 0 0 N/A shared pool 3,315 0.2 0.0 0 0 N/A shared pool simulator 433,900 0.0 0.0 0 0 N/A simulator hash latch 458,557 0.0 N/A 0 0 N/A simulator lru latch 102,313 0.0 0.0 0 355,628 0.0 slave class 9 0.0 N/A 0 0 N/A slave class create 36 5.6 1.0 0 0 N/A sort extent pool 85 0.0 N/A 0 0 N/A state object free list 8 0.0 N/A 0 0 N/A statistics aggregation 1,344 0.0 N/A 0 0 N/A temp lob duration state 3 0.0 N/A 0 0 N/A threshold alerts latch 60 0.0 N/A 0 0 N/A trace latch 1 0.0 N/A 0 0 N/A transaction allocation 163 0.0 N/A 0 0 N/A transaction branch alloc 1,205 0.0 N/A 0 0 N/A undo global data 311,685 0.0 0.0 0 0 N/A user lock 244 0.0 N/A 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- cache buffers chains 12,513,021 2,011 142 1,877 0 0 0 In memory undo latch 587,348 1,035 667 370 0 0 0 session idle bit 2,348,185 208 1 207 0 0 0 slave class create 36 2 2 0 0 0 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: USRSE/usrse Snaps: 390-394 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- In memory undo latch ktiFlush: child 0 519 75 In memory undo latch kticmt: child 0 197 41 In memory undo latch ktichg: child 0 55 436 cache buffers chains kcbgtcr: fast path 0 125 22 cache buffers chains kcbchg: kslbegin: bufs not 0 71 115 cache buffers chains kcbgtcr: kslbegin excl 0 21 12 cache buffers chains kcbget: pin buffer 0 8 6 cache buffers chains kcbzwb 0 7 1 cache buffers chains kcbrls: kslbegin 0 3 12 cache buffers chains kcbgcur: kslbegin 0 2 0 session idle bit ksupuc: set busy 0 1 0 slave class create ksvcreate 0 2 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: USRSE/usrse Snaps: 390-394 -> Total Logical Reads: 4,833,544 -> Captured Segments account for 88.3% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- OCPERF1PMS DATA_SMALL NAMESPACE TABLE 754,768 15.62 OCPERF1USR INDEX_LARG ENDP_CONST_PKEY INDEX 536,368 11.10 OCPERF1PMS DATA_LARGE SCOPE TABLE 358,416 7.42 OCPERF1PMS INDEX_LARG ENDPOINT_PK INDEX 355,984 7.36 OCPERF1PMS INDEX_LARG PROFILE_APP_PK INDEX 177,664 3.68 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: USRSE/usrse Snaps: 390-394 -> Total Physical Reads: 292 -> Captured Segments account for 78.1% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- OCPERF1PMS INDEX_LARG ENDPOINT_PK INDEX 36 12.33 OCPERF1PMS INDEX_LARG ENDPOINT_HOST_UN INDEX 29 9.93 OCPERF1PMS DATA_LARGE PROFILE TABLE 21 7.19 OCPERF1PMS INDEX_LARG PROFILE_PK INDEX 21 7.19 OCPERF1USR INDEX_LARG ENDPOINT_TYPE_INDEX INDEX 20 6.85 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: USRSE/usrse Snaps: 390-394 -> % of Capture shows % of row lock waits for each top segment compared -> with total row lock waits for all segments captured by the Snapshot Row Tablespace Subobject Obj. Lock % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- OCPERF1PMS INDEX_LARG ENDPOINT_HOST_UN INDEX 13 26.53 OCPERF1PMS INDEX_LARG ENDPOINT_PK INDEX 13 26.53 OCPERF1PMS INDEX_LARG PROFILE_APP_PK INDEX 9 18.37 OCPERF1USR INDEX_LARG ENDP_CONST_PKEY INDEX 4 8.16 OCPERF1PMS INDEX_LARG PROFILE_ENDPOINTID_I INDEX 3 6.12 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: USRSE/usrse Snaps: 390-394 -> % of Capture shows % of Buffer Busy Waits for each top segment compared -> with total Buffer Busy Waits for all segments captured by the Snapshot Buffer Tablespace Subobject Obj. Busy % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- OCPERF1USR INDEX_LARG ENDP_CONST_PKEY INDEX 126 26.03 OCPERF1PMS DATA_LARGE ENDPOINT TABLE 80 16.53 OCPERF1PMS INDEX_LARG ENDPOINT_HOST_UN INDEX 70 14.46 OCPERF1PMS INDEX_LARG ENDPOINT_PK INDEX 59 12.19 OCPERF1USR DATA_LARGE ENDPOINT TABLE 42 8.68 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: USRSE/usrse Snaps: 390-394 -> "Pct Misses" should be very low (< 2% in most cases) -> "Final Usage" is the number of cache entries being used Get Pct Scan Pct Mod Final Cache Requests Miss Reqs Miss Reqs Usage ------------------------- ------------ ------ ------- ----- -------- ---------- dc_awr_control 74 0.0 0 N/A 8 1 dc_database_links 128 0.0 0 N/A 0 1 dc_free_extents 9 0.0 0 N/A 0 2 dc_global_oids 114 0.0 0 N/A 0 117 dc_object_ids 661 0.0 0 N/A 0 3,904 dc_objects 421 0.0 0 N/A 0 5,575 dc_profiles 62 0.0 0 N/A 0 1 dc_rollback_segments 475 0.0 0 N/A 0 23 dc_segments 38 0.0 0 N/A 21 2,570 dc_sequences 935 0.0 0 N/A 935 85 dc_tablespace_quotas 4 0.0 0 N/A 4 19 dc_tablespaces 1,064 0.0 0 N/A 0 9 dc_usernames 252 0.0 0 N/A 0 38 dc_users 1,984 0.0 0 N/A 0 51 ------------------------------------------------------------- Library Cache Activity DB/Inst: USRSE/usrse Snaps: 390-394 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 41 0.0 2,805 0.0 0 0 INDEX 4 0.0 44 0.0 0 0 SQL AREA 2,011 0.3 800,525 -0.0 0 0 TABLE/PROCEDURE 44 0.0 40,344 0.0 0 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: USRSE/usrse Snaps: 390-394 -> B: Begin snap E: End snap -> All rows below contain absolute values (i.e. not diffed over the interval) -> Max Alloc is Maximum PGA Allocation size at snapshot time -> Hist Max Alloc is the Historical Max Allocation for still-connected processes -> ordered by Begin/End snapshot, Alloc (MB) desc Hist Avg Std Dev Max Max Alloc Used Alloc Alloc Alloc Alloc Num Num Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc - -------- --------- --------- -------- -------- ------- ------- ------ ------ B Other 95.7 N/A 2.3 5.5 22 22 42 42 Freeable 4.0 .0 .7 .4 1 N/A 6 6 SQL .9 .4 .0 .1 0 1 28 26 PL/SQL .2 .1 .0 .0 0 0 42 42 E Other 98.5 N/A 2.2 5.4 22 22 45 45 Freeable 4.6 .0 .7 .4 1 N/A 7 7 SQL 1.0 .5 .0 .1 0 3 31 29 PL/SQL .3 .1 .0 .0 0 0 45 45 ------------------------------------------------------------- SGA Memory Summary DB/Inst: USRSE/usrse Snaps: 390-394 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 1,056,964,608 Fixed Size 2,238,688 Redo Buffers 21,626,880 Variable Size 1,133,762,336 ------------------- sum 2,214,592,512 ------------------------------------------------------------- SGA breakdown difference DB/Inst: USRSE/usrse Snaps: 390-394 -> ordered by Pool, Name -> N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot Pool Name Begin MB End MB % Diff ------ ------------------------------ -------------- -------------- ------- java free memory 32.0 32.0 0.00 large free memory 32.0 32.0 0.00 shared ASH buffers 15.5 15.5 0.00 shared CCursor 23.8 23.8 0.17 shared KGLS heap 9.9 9.9 0.00 shared PCursor 10.5 10.5 0.09 shared PL/SQL DIANA 26.4 26.4 0.00 shared PL/SQL MPCODE 9.7 9.7 0.00 shared free memory 651.2 651.1 -0.02 shared library cache 19.2 19.2 0.02 shared sql area 85.0 85.0 0.01 buffer_cache 1,008.0 1,008.0 0.00 fixed_sga 2.1 2.1 0.00 log_buffer 20.6 20.6 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: USRSE/usrse Snaps: 390-394 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: USRSE/usrse Snap: 394 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: USRSE/usrse Snaps: 390-394 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _undo_autotune FALSE background_dump_dest /oracle/admin/usrse/bdump compatible 10.2.0 control_files /oracle/oradata/usrse/data0/contr core_dump_dest /oracle/admin/usrse/cdump db_block_size 8192 db_cache_size 1056964608 db_domain world db_file_multiblock_read_count 8 db_files 400 db_name usrse instance_name usrse java_pool_size 33554432 job_queue_processes 1 large_pool_size 33554432 log_archive_dest_1 location=/oracle/arch/usrse manda log_archive_dest_state_1 enable log_archive_format arch_%t_%r_%s.arc log_buffer 20971520 log_checkpoint_interval 10000 log_checkpoint_timeout 1800 max_dump_file_size 100K open_cursors 300 os_authent_prefix OPS$ processes 500 remote_login_passwordfile NONE remote_os_authent FALSE remote_os_roles FALSE service_names usrse.world session_cached_cursors 300 shared_pool_size 1056964608 sort_area_retained_size 2097152 sort_area_size 2097152 sql_trace FALSE undo_management AUTO undo_retention 3600 undo_tablespace undo user_dump_dest /oracle/admin/usrse/udump ------------------------------------------------------------- End of Report