WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Startup Time Release RAC ------------ ----------- ------------ -------- --------------- ----------- --- HDD 1283245756 hdd 1 10-3? -09 07:03 11.1.0.7.0 NO Host Name Platform CPUs Cores Sockets Memory(GB) ---------------- -------------------------------- ---- ----- ------- ---------- xxxxxxxxxxxxxxxx Linux x86 64-bit 24 24 4 125.97 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 111 10-3? -09 07:05:34 834 3.3 End Snap: 112 10-3? -09 07:13:26 30 1.0 Elapsed: 7.87 (mins) DB Time: 4,501.98 (mins) Cache Sizes Begin End ~~~~~~~~~~~ ---------- ---------- Buffer Cache: 1,856M 1,856M Std Block Size: 8K Shared Pool Size: 1,280M 1,280M Log Buffer: 40,008K Load Profile Per Second Per Transaction Per Exec Per Call ~~~~~~~~~~~~ --------------- --------------- ---------- ---------- DB Time(s): 572.3 4.9 0.09 0.03 DB CPU(s): 2.4 0.0 0.00 0.00 Redo size: 296,187.6 2,555.3 Logical reads: 47,243.0 407.6 Block changes: 1,682.0 14.5 Physical reads: 4,818.6 41.6 Physical writes: 155.3 1.3 User calls: 17,575.9 151.6 Parses: 6,363.1 54.9 Hard parses: 0.7 0.0 W/A MB processed: 148,440.3 1,280.6 Logons: 0.0 0.0 Executes: 6,371.1 55.0 Rollbacks: 0.0 0.0 Transactions: 115.9 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.97 Redo NoWait %: 100.00 Buffer Hit %: 89.80 In-memory Sort %: 100.00 Library Hit %: 99.97 Soft Parse %: 99.99 Execute to Parse %: 0.12 Latch Hit %: 99.93 Parse CPU to Parse Elapsd %: 0.00 % Non-Parse CPU: 96.15 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 29.51 27.91 % SQL with executions>1: 49.12 79.94 % Memory for SQL w/exec>1: 48.43 74.59 Top 5 Timed Foreground Events ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Avg wait % DB Event Waits Time(s) (ms) time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- db file sequential read 2,247,220 269,640 120 99.8 User I/O DB CPU 1,142 .4 log file sync 55,985 1,048 19 .4 Commit db file scattered read 21,259 716 34 .3 User I/O read by other session 6,382 626 98 .2 User I/O Host CPU (CPUs: 24 Cores: 24 Sockets: 4) ~~~~~~~~ Load Average Begin End %User %System %WIO %Idle --------- --------- --------- --------- --------- --------- 47.54 309.19 7.1 3.2 73.7 88.0 Instance CPU ~~~~~~~~~~~~ % of total CPU for Instance: 10.6 % of busy CPU for Instance: 87.6 %DB time waiting for CPU - Resource Mgr: 0.0 Memory Statistics ~~~~~~~~~~~~~~~~~ Begin End Host Mem (MB): 128,997.3 128,997.3 SGA use (MB): 3,328.0 3,328.0 PGA use (MB): 1,703.6 219.9 % Host Mem used for SGA+PGA: 3.90 3.90 Time Model Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> Total time in database user-calls (DB Time): 270119s -> 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 ------------------------------------------ ------------------ ------------ sql execute elapsed time 268,740.6 99.5 DB CPU 1,141.7 .4 parse time elapsed 292.7 .1 hard parse elapsed time 236.1 .1 connection management call elapsed time 213.5 .1 PL/SQL compilation elapsed time 54.8 .0 sequence load elapsed time 29.8 .0 hard parse (sharing criteria) elapsed time 5.3 .0 PL/SQL execution elapsed time 3.0 .0 hard parse (bind mismatch) elapsed time 1.4 .0 repeated bind elapsed time 0.0 .0 DB time 270,119.0 background elapsed time 386.4 background cpu time 12.3 ------------------------------------------------------------- Operating System Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> *TIME statistic values are diffed. All others display actual values. End Value is displayed if different -> ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name Statistic Value End Value ------------------------- ---------------------- ---------------- BUSY_TIME 131,713 IDLE_TIME 961,598 IOWAIT_TIME 805,951 NICE_TIME 30 SYS_TIME 35,030 USER_TIME 77,401 LOAD 48 309 PHYSICAL_MEMORY_BYTES 135,263,432,704 NUM_CPUS 24 NUM_CPU_CORES 24 NUM_CPU_SOCKETS 4 GLOBAL_RECEIVE_SIZE_MAX 4,194,304 GLOBAL_SEND_SIZE_MAX 262,144 TCP_RECEIVE_SIZE_DEFAULT 4,194,304 TCP_RECEIVE_SIZE_MAX 4,194,304 TCP_RECEIVE_SIZE_MIN 4,194,304 TCP_SEND_SIZE_DEFAULT 262,144 TCP_SEND_SIZE_MAX 262,144 TCP_SEND_SIZE_MIN 262,144 ------------------------------------------------------------- Operating System Statistics - Detail DB/Inst: HDD/hdd Snaps: 111-112 Snap Time Load %busy %user %sys %idle %iowait --------------- -------- -------- -------- -------- -------- -------- 10-3? 07:05:3 47.5 N/A N/A N/A N/A N/A 10-3? 07:13:2 309.2 12.0 7.1 3.2 73.7 88.0 ------------------------------------------------------------- Foreground Wait Class DB/Inst: HDD/hdd Snaps: 111-112 -> s - second, ms - millisecond - 1000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 -> Captured Time accounts for 101.3% of Total DB time 270,119.00 (s) -> Total FG Wait Time: 272,445.37 (s) DB CPU time: 1,141.70 (s) Avg %Time Total Wait wait Wait Class Waits -outs Time (s) (ms) %DB time -------------------- ---------------- ----- ---------------- -------- --------- User I/O 2,274,862 0 270,982 119 100.3 DB CPU 1,142 0.4 Commit 55,985 0 1,048 19 0.4 Other 2,665 66 159 60 0.1 Concurrency 5,662 57 140 25 0.1 Configuration 223 0 102 459 0.0 System I/O 700 0 8 11 0.0 Network 5,351,212 0 6 0 0.0 Application 1 0 0 1 0.0 Administrative 0 0 0.0 ------------------------------------------------------------- Foreground Wait Events DB/Inst: HDD/hdd Snaps: 111-112 -> s - second, ms - millisecond - 1000th of a second -> Only events with Total Wait Time (s) >= .001 are shown -> ordered by wait time desc, waits desc (idle events last) -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % DB Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ db file sequential read 2,247,220 0 269,640 120 41.1 99.8 log file sync 55,985 0 1,048 19 1.0 .4 db file scattered read 21,259 0 716 34 0.4 .3 read by other session 6,382 0 626 98 0.1 .2 buffer busy waits 718 0 123 171 0.0 .0 latch: session allocation 147 0 96 653 0.0 .0 enq: HW - contention 56 0 74 1316 0.0 .0 latch free 297 0 62 208 0.0 .0 enq: SQ - contention 167 0 29 172 0.0 .0 latch: cache buffers chain 1,552 0 8 5 0.0 .0 control file sequential re 700 0 8 11 0.0 .0 SQL*Net message to client 5,351,212 0 6 0 97.8 .0 library cache: mutex X 2,866 100 5 2 0.1 .0 latch: shared pool 81 0 3 32 0.0 .0 cursor: pin S wait on X 189 100 2 11 0.0 .0 buffer exterminate 37 95 0 11 0.0 .0 enq: TX - contention 9 0 0 40 0.0 .0 SGA: allocation forcing co 14 86 0 9 0.0 .0 latch: object queue header 97 0 0 1 0.0 .0 cursor: pin S 1,701 100 0 0 0.0 .0 latch: cache buffers lru c 330 0 0 0 0.0 .0 wait list latch free 1 0 0 40 0.0 .0 latch: In memory undo latc 96 0 0 0 0.0 .0 cursor: mutex X 160 100 0 0 0.0 .0 latch: enqueue hash chains 23 0 0 0 0.0 .0 enq: FB - contention 8 0 0 0 0.0 .0 SQL*Net message from clien 5,352,006 0 88,822 17 97.8 jobq slave wait 12 92 34 2810 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: HDD/hdd Snaps: 111-112 -> ordered by wait time desc, waits desc (idle events last) -> Only events with Total Wait Time (s) >= .001 are shown -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits % bg Event Waits -outs Time (s) (ms) /txn time -------------------------- ------------ ----- ---------- ------- -------- ------ log file parallel write 31,600 0 266 8 0.6 69.0 latch: session allocation 166 0 124 748 0.0 32.1 control file sequential re 561 0 56 100 0.0 14.5 db file sequential read 217 0 30 138 0.0 7.8 db file parallel write 776 0 18 24 0.0 4.8 control file parallel writ 207 0 4 18 0.0 1.0 db file scattered read 18 0 3 189 0.0 .9 enq: CF - contention 1 0 1 1192 0.0 .3 JS coord start wait 2 50 1 500 0.0 .3 latch free 40 0 1 23 0.0 .2 LGWR wait for redo copy 183 0 0 1 0.0 .0 SGA: allocation forcing co 15 93 0 11 0.0 .0 direct path write 14 0 0 11 0.0 .0 os thread startup 4 0 0 17 0.0 .0 latch: cache buffers lru c 246 0 0 0 0.0 .0 log file sync 2 0 0 8 0.0 .0 latch: object queue header 64 0 0 0 0.0 .0 SQL*Net message to client 803 0 0 0 0.0 .0 ASM file metadata operatio 94 0 0 0 0.0 .0 rdbms ipc message 28,450 7 6,906 243 0.5 DIAG idle wait 938 100 939 1001 0.0 Streams AQ: qmn coordinato 34 50 476 14005 0.0 Streams AQ: qmn slave idle 17 0 476 28010 0.0 ASM background timer 94 0 472 5017 0.0 pmon timer 167 94 471 2822 0.0 Space Manager: slave idle 94 100 470 5001 0.0 fbar timer 1 100 300 300005 0.0 class slave wait 3 33 300 100001 0.0 smon timer 1 100 300 300003 0.0 SQL*Net message from clien 802 0 18 22 0.0 ------------------------------------------------------------- Wait Event Histogram DB/Inst: HDD/hdd Snaps: 111-112 -> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000 -> % of Waits: value of .0 indicates value was <.05%. Value of null is truly 0 -> % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms -> Ordered by Event (idle events last) % of Waits ----------------------------------------------- Total Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s -------------------------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ASM file metadata operatio 90 100.0 JS coord start wait 2 50.0 50.0 LGWR wait for redo copy 171 98.2 .6 1.2 SGA: allocation forcing co 29 6.9 3.4 89.7 SQL*Net message to client 5178K 100.0 .0 .0 buffer busy waits 688 12.4 2.3 3.3 2.5 2.2 8.1 69.2 buffer exterminate 37 100.0 control file parallel writ 198 18.2 3.0 2.0 7.6 10.1 54.5 4.5 control file sequential re 1243 68.8 1.0 1.0 1.6 1.7 5.4 20.4 cursor: mutex X 160 98.8 1.3 cursor: pin S 1466 99.7 .2 .1 cursor: pin S wait on X 187 100.0 db file parallel write 770 18.3 2.5 1.3 1.2 3.4 45.7 27.7 db file scattered read 54 14.8 3.7 1.9 3.7 3.7 7.4 64.8 db file sequential read 2172K 1.5 .3 2.7 6.8 10.6 16.1 62.0 direct path read 6 100.0 direct path write 15 40.0 6.7 33.3 20.0 enq: CF - contention 1 100.0 enq: FB - contention 2 100.0 enq: HW - contention 40 5.0 2.5 27.5 65.0 enq: SQ - contention 167 1.2 .6 1.2 9.6 87.4 enq: TX - row lock content 1 100.0 latch free 295 49.2 3.1 1.4 .3 1.7 .3 44.1 latch: In memory undo latc 89 97.8 2.2 latch: cache buffers chain 1537 38.8 6.7 19.5 20.9 7.1 4.0 3.0 latch: cache buffers lru c 287 99.7 .3 latch: checkpoint queue la 1 100.0 latch: enqueue hash chains 21 100.0 latch: object queue header 146 98.6 .7 .7 latch: redo allocation 5 100.0 latch: session allocation 313 11.2 3.5 1.9 .3 1.9 .3 37.1 43.8 latch: shared pool 81 40.7 1.2 6.2 8.6 3.7 1.2 38.3 latch: undo global data 1 100.0 library cache: mutex X 2049 93.8 .4 .7 .8 .5 1.4 2.4 log file parallel write 30K 51.7 7.1 5.4 4.2 4.4 25.7 1.4 log file sync 54K 19.2 6.0 5.5 8.2 12.8 26.9 21.3 os thread startup 4 50.0 50.0 read by other session 6169 3.5 1.4 2.6 4.7 9.3 14.0 64.5 wait list latch free 1 100.0 ASM background timer 90 100.0 DIAG idle wait 902 99.8 .2 SQL*Net message from clien 5180K 89.3 .4 .1 .2 .4 .9 8.7 .0 Space Manager: slave idle 90 100.0 Streams AQ: qmn coordinato 32 46.9 3.1 50.0 Streams AQ: qmn slave idle 16 100.0 class slave wait 3 66.7 33.3 fbar timer 1 100.0 jobq slave wait 12 8.3 91.7 pmon timer 161 5.0 .6 94.4 rdbms ipc message 27K 33.1 7.2 11.7 15.9 16.1 7.5 2.8 5.8 smon timer 1 100.0 ------------------------------------------------------------- Service Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads (K) Reads (K) ---------------------------- ------------ ------------ ------------ ------------ hdd 273,351 1,183 2,350 22,542 SYS$USERS 391 2 1 13 SYS$BACKGROUND 0 0 0 6 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: HDD/hdd Snaps: 111-112 -> 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 seconds 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 --------- --------- --------- --------- --------- --------- --------- --------- hdd 2274009 270790 5649 140 0 0 5351594 6 SYS$USERS 1123 195 0 0 0 0 0 0 SYS$BACKGROUND 255 34 5 0 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: HDD/hdd Snaps: 111-112 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 -> Total DB Time (s): 270,119 -> Captured SQL account for 76.3% of Total -> Total DB Time (s): 270,119 -> Captured PL/SQL account for 0.1% of Total Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- 176,851 304 417,901 0.4 65.5 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 27,970 93 417,766 0.1 10.4 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 343 56 417,780 0.0 0.1 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 194 1 2 97.0 0.1 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 191 14 41,980 0.0 0.1 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, 133 1 801 0.2 0.0 fv1mwvtac3ttf Module: SQL*Plus insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, logoff$lread,logoff$pread,logoff$lwrite,logoff$dead, logoff$time,clientid,sessioncpu,proxy$sid,user$guid, instance#,process#,auditid ) values(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10, 104 3 41,983 0.0 0.0 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) 83 34 418,440 0.0 0.0 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 64 5 41,984 0.0 0.0 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') 45 0 9 5.0 0.0 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: HDD/hdd Snaps: 111-112 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> % Total is the CPU Time divided into the Total CPU Time times 100 -> Total CPU Time (s): 1,142 -> Captured SQL account for 47.5% of Total -> Total CPU Time (s): 1,142 -> Captured PL/SQL account for 0.2% of Total CPU Elapsed CPU per % Total Time (s) Time (s) Executions Exec (s) % Total DB Time SQL Id ---------- ---------- ------------ ----------- ------- ------- ------------- 304 176,851 417,901 0.00 26.6 65.5 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 93 27,970 417,766 0.00 8.2 10.4 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 56 343 417,780 0.00 4.9 0.1 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 34 83 418,440 0.00 3.0 0.0 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 19 20 417,810 0.00 1.7 0.0 fs760kgcs7qvh Module: java@in10-6b (TNS V1-V3) select catid, name, descn from category where catid = :1 14 191 41,980 0.00 1.3 0.1 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, 5 64 41,984 0.00 0.5 0.0 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') 5 22 41,981 0.00 0.4 0.0 2dpkrs1cfj2hz Module: java@in10-65 (TNS V1-V3) update inventory set qty = qty - 1 where itemid = upper(:1) 3 104 41,983 0.00 0.3 0.0 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) 3 34 41,984 0.00 0.3 0.0 139r2ptpyq7mn Module: java@in10-65 (TNS V1-V3) select ordernum.nextval from dual ------------------------------------------------------------- SQL ordered by Gets DB/Inst: HDD/hdd Snaps: 111-112 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 22,299,452 -> Captured SQL account for 76.4% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 5,857,598 417,901 14.0 26.3 304.02 1.8E+05 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 4,593,006 417,780 11.0 20.6 55.88 342.53 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 2,981,080 417,766 7.1 13.4 93.34 27969.61 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 2,091,170 418,440 5.0 9.4 34.14 82.94 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 430,554 41,980 10.3 1.9 14.46 190.93 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, 417,728 417,810 1.0 1.9 19.26 20.36 fs760kgcs7qvh Module: java@in10-6b (TNS V1-V3) select catid, name, descn from category where catid = :1 252,047 41,984 6.0 1.1 5.46 63.64 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') 210,229 41,981 5.0 0.9 4.75 22.49 2dpkrs1cfj2hz Module: java@in10-65 (TNS V1-V3) update inventory set qty = qty - 1 where itemid = upper(:1) 170,866 41,983 4.1 0.8 3.49 104.24 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) 14,745 1 14,745.0 0.1 0.76 14.73 2uw1dmxk125vf Module: SQL*Plus BEGIN dbms_workload_repository.create_snapshot(flush_level => 'ALL'); END; ------------------------------------------------------------- SQL ordered by Reads DB/Inst: HDD/hdd Snaps: 111-112 -> Total Disk Reads: 2,274,477 -> Captured SQL account for 73.9% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 1,452,977 417,901 3.5 63.9 304.02 1.8E+05 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 221,326 417,766 0.5 9.7 93.34 27969.61 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 1,839 417,780 0.0 0.1 55.88 342.53 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 1,792 41,980 0.0 0.1 14.46 190.93 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, 1,207 2 603.5 0.1 1.20 193.92 6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN : = FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date ; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; 607 1 607.0 0.0 0.76 14.73 2uw1dmxk125vf Module: SQL*Plus BEGIN dbms_workload_repository.create_snapshot(flush_level => 'ALL'); END; 520 41,984 0.0 0.0 5.46 63.64 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') 349 9 38.8 0.0 0.34 44.98 3am9cfkvx7gq1 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid,:metric_guid,:metric_val ues) 253 418,440 0.0 0.0 34.14 82.94 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 222 41,983 0.0 0.0 3.49 104.24 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) ------------------------------------------------------------- SQL ordered by Executions DB/Inst: HDD/hdd Snaps: 111-112 -> Total Executions: 3,007,249 -> Captured SQL account for 76.6% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 418,440 418,355 1.0 0.00 0.00 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 417,901 418,301 1.0 0.00 0.42 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 417,810 0 0.0 0.00 0.00 fs760kgcs7qvh Module: java@in10-6b (TNS V1-V3) select catid, name, descn from category where catid = :1 417,780 417,697 1.0 0.00 0.00 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 417,766 4,592,547 11.0 0.00 0.07 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 41,984 41,983 1.0 0.00 0.00 139r2ptpyq7mn Module: java@in10-65 (TNS V1-V3) select ordernum.nextval from dual 41,984 41,983 1.0 0.00 0.00 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') 41,983 41,980 1.0 0.00 0.00 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) 41,981 41,979 1.0 0.00 0.00 2dpkrs1cfj2hz Module: java@in10-65 (TNS V1-V3) update inventory set qty = qty - 1 where itemid = upper(:1) 41,980 41,979 1.0 0.00 0.00 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: HDD/hdd Snaps: 111-112 -> Total Parse Calls: 3,003,502 -> Captured SQL account for 76.6% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 418,440 418,440 13.93 bdam0rdbsf3xm Module: java@in10-6b (TNS V1-V3) select qty as value from inventory where itemid = upper(:1) 417,870 417,901 13.91 6nc8pzf4u00v0 Module: java@in10-65 (TNS V1-V3) select i.itemid, listprice, unitcost, supplier, i.productid, name, descn, catego ry, status, attr1, attr2, attr3, attr4, attr5, qty from item i, inventory v, pr oduct p where p.productid = i.productid and i.itemid = v.itemid and i.itemid = u pper(:1) 417,750 417,810 13.91 fs760kgcs7qvh Module: java@in10-6b (TNS V1-V3) select catid, name, descn from category where catid = :1 417,747 417,766 13.91 ak73zgvjq6mj6 Module: java@in10-6b (TNS V1-V3) select productid, name, descn, category from product where(lower(name) like :1) 417,729 417,780 13.91 0gmr66sn4rmaq Module: java@in10-6b (TNS V1-V3) select signon.username as userid, account.email, account.firstname, account.last name, account.status, account.addr1, account.addr2,account.city, account.state, account.zip, account.country, account.phone, profile.langpref, profile.favcatego ry, profile.mylistopt,profile.banneropt, bannerdata.bannername from account, pr 41,983 41,981 1.40 2dpkrs1cfj2hz Module: java@in10-65 (TNS V1-V3) update inventory set qty = qty - 1 where itemid = upper(:1) 41,983 41,983 1.40 2rucsfxw9dnts Module: java@in10-65 (TNS V1-V3) insert into lineitem (orderid, linenum, itemid, quantity, unitprice) values (:1, :2, :3, 1, 16.5) 41,982 41,980 1.40 gg58v9cs18u2h Module: java@in10-65 (TNS V1-V3) insert into orders (orderid, userid, orderdate, shipaddr1, shipaddr2, shipcity, shipstate, shipzip, shipcountry, billaddr1, billaddr2, billcity, billstate, bill zip, billcountry, courier, totalprice, billtofirstname, billtolastname, shiptofi rstname, shiptolastname, creditcard, exprdate, cardtype, locale) values (:1, :2, 41,981 41,984 1.40 139r2ptpyq7mn Module: java@in10-65 (TNS V1-V3) select ordernum.nextval from dual 41,978 41,984 1.40 7xnkhn8y17hun Module: java@in10-65 (TNS V1-V3) insert into orderstatus (orderid, linenum, timestamp, status) values (:1, :2, sy sdate, 'P') ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: HDD/hdd Snaps: 111-112 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- Batched IO (bound) vector count 0 0.0 0.0 Batched IO (full) vector count 0 0.0 0.0 Batched IO block miss count 0 0.0 0.0 Batched IO buffer defrag count 0 0.0 0.0 Batched IO double miss count 0 0.0 0.0 Batched IO same unit count 0 0.0 0.0 Batched IO single block count 0 0.0 0.0 Batched IO vector block count 0 0.0 0.0 Batched IO vector read count 0 0.0 0.0 Block Cleanout Optim referenced 27 0.1 0.0 CCursor + sql area evicted 0 0.0 0.0 CPU used by this session 93,913 199.0 1.7 CPU used when call started 93,690 198.5 1.7 CR blocks created 173 0.4 0.0 DB time 27,221,274 57,670.2 497.5 DBWR checkpoint buffers written 3,067 6.5 0.1 DBWR checkpoints 0 0.0 0.0 DBWR thread checkpoint buffers w 0 0.0 0.0 DBWR transaction table writes 278 0.6 0.0 DBWR undo block writes 4,413 9.4 0.1 HSC Heap Segment Block Changes 221,315 468.9 4.1 Heap Segment Array Inserts 469 1.0 0.0 Heap Segment Array Updates 80 0.2 0.0 IMU CR rollbacks 1 0.0 0.0 IMU Flushes 6,503 13.8 0.1 IMU Redo allocation size 10,152,192 21,508.2 185.6 IMU commits 48,209 102.1 0.9 IMU contention 371 0.8 0.0 IMU undo allocation size 156,971,064 332,554.5 2,869.0 RowCR - row contention 1 0.0 0.0 RowCR attempts 196 0.4 0.0 RowCR hits 151 0.3 0.0 SQL*Net roundtrips to/from clien 5,293,508 11,214.7 96.8 active txn count during cleanout 1,083 2.3 0.0 background checkpoints completed 1 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 2,190 4.6 0.0 buffer is not pinned count 17,594,417 37,275.0 321.6 buffer is pinned count 9,765,658 20,689.3 178.5 bytes received via SQL*Net from 1,613,984,981 3,419,343.8 29,499.7 bytes sent via SQL*Net to client 3,109,423,133 6,587,537.6 56,832.6 calls to get snapshot scn: kcmgs 3,066,098 6,495.8 56.0 calls to kcmgas 57,689 122.2 1.1 calls to kcmgcs 2,034 4.3 0.0 cell physical IO interconnect by 19,416,081,408 41,134,371.3 354,877.9 change write time 438 0.9 0.0 cleanout - number of ktugct call 1,771 3.8 0.0 cleanouts only - consistent read 4 0.0 0.0 cluster key scan block gets 800 1.7 0.0 cluster key scans 669 1.4 0.0 commit cleanout failures: block 100 0.2 0.0 commit cleanout failures: buffer 1 0.0 0.0 commit cleanout failures: callba 4 0.0 0.0 commit cleanout failures: cannot 509 1.1 0.0 commit cleanouts 330,045 699.2 6.0 commit cleanouts successfully co 329,431 697.9 6.0 commit txn count during cleanout 994 2.1 0.0 concurrency wait time 13,970 29.6 0.3 consistent changes 45 0.1 0.0 consistent gets 21,227,790 44,972.6 388.0 Instance Activity Stats DB/Inst: HDD/hdd Snaps: 111-112 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- consistent gets - examination 18,236,484 38,635.3 333.3 consistent gets from cache 21,227,789 44,972.6 388.0 consistent gets from cache (fast 2,655,772 5,626.4 48.5 cursor authentications 142 0.3 0.0 data blocks consistent reads - u 44 0.1 0.0 db block changes 793,946 1,682.0 14.5 db block gets 1,071,584 2,270.2 19.6 db block gets direct 918 1.9 0.0 db block gets from cache 1,070,666 2,268.3 19.6 db block gets from cache (fastpa 483,520 1,024.4 8.8 deferred (CURRENT) block cleanou 276,403 585.6 5.1 dirty buffers inspected 52,994 112.3 1.0 enqueue conversions 54 0.1 0.0 enqueue releases 445,184 943.2 8.1 enqueue requests 444,365 941.4 8.1 enqueue timeouts 1 0.0 0.0 enqueue waits 217 0.5 0.0 execute count 3,007,249 6,371.1 55.0 free buffer inspected 2,301,398 4,875.7 42.1 free buffer requested 2,293,997 4,860.0 41.9 heap block compress 11 0.0 0.0 hot buffers moved to head of LRU 612,839 1,298.3 11.2 immediate (CR) block cleanout ap 4 0.0 0.0 immediate (CURRENT) block cleano 546 1.2 0.0 index crx upgrade (positioned) 0 0.0 0.0 index fast full scans (full) 0 0.0 0.0 index fetch by key 4,969,115 10,527.4 90.8 index scans kdiixs1 549,317 1,163.8 10.0 leaf node 90-10 splits 240 0.5 0.0 leaf node splits 247 0.5 0.0 lob reads 0 0.0 0.0 logons cumulative 7 0.0 0.0 messages received 31,781 67.3 0.6 messages sent 31,781 67.3 0.6 min active SCN optimization appl 12 0.0 0.0 no work - consistent read gets 2,822,110 5,978.8 51.6 opened cursors cumulative 3,007,097 6,370.8 55.0 parse count (failures) 0 0.0 0.0 parse count (hard) 338 0.7 0.0 parse count (total) 3,003,502 6,363.1 54.9 parse time cpu 4,396 9.3 0.1 parse time elapsed 12,452 26.4 0.2 physical IO disk bytes 19,416,081,408 41,134,371.3 354,877.9 physical read IO requests 2,227,712 4,719.6 40.7 physical read bytes 18,632,499,200 39,474,295.8 340,556.0 physical read total IO requests 2,228,992 4,722.3 40.7 physical read total bytes 18,653,089,792 39,517,918.4 340,932.3 physical read total multi block 1 0.0 0.0 physical reads 2,274,477 4,818.6 41.6 physical reads cache 2,274,470 4,818.6 41.6 physical reads cache prefetch 46,744 99.0 0.9 physical reads direct 6 0.0 0.0 physical reads direct temporary 0 0.0 0.0 physical reads prefetch warmup 46,392 98.3 0.9 physical write IO requests 52,764 111.8 1.0 physical write bytes 600,604,672 1,272,424.4 10,977.6 physical write total IO requests 84,623 179.3 1.6 physical write total bytes 762,999,808 1,616,470.2 13,945.8 physical write total multi block 453 1.0 0.0 physical writes 73,316 155.3 1.3 Instance Activity Stats DB/Inst: HDD/hdd Snaps: 111-112 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical writes direct 924 2.0 0.0 physical writes from cache 72,392 153.4 1.3 physical writes non checkpoint 66,785 141.5 1.2 pinned buffers inspected 10 0.0 0.0 prefetch warmup blocks aged out 48,210 102.1 0.9 prefetched blocks aged out befor 1 0.0 0.0 process last non-idle time 472 1.0 0.0 recursive calls 140,585 297.8 2.6 recursive cpu usage 1,067 2.3 0.0 redo blocks checksummed by FG (e 188,516 399.4 3.5 redo blocks written 297,698 630.7 5.4 redo entries 109,302 231.6 2.0 redo ordering marks 1,571 3.3 0.0 redo size 139,805,292 296,187.6 2,555.3 redo size for direct writes 7,553,700 16,003.1 138.1 redo subscn max counts 5,594 11.9 0.1 redo synch time 104,542 221.5 1.9 redo synch writes 55,516 117.6 1.0 redo wastage 8,296,404 17,576.5 151.6 redo write time 26,760 56.7 0.5 redo writer latching time 18 0.0 0.0 redo writes 30,971 65.6 0.6 rollbacks only - consistent read 44 0.1 0.0 rows fetched via callback 4,367,640 9,253.2 79.8 session connect time 517 1.1 0.0 session cursor cache hits 3,002,572 6,361.2 54.9 session logical reads 22,299,452 47,243.0 407.6 shared hash latch upgrades - no 1,925,496 4,079.3 35.2 shared hash latch upgrades - wai 40 0.1 0.0 sorts (memory) 1,015 2.2 0.0 sorts (rows) 70,624 149.6 1.3 sql area evicted 156 0.3 0.0 sql area purged 0 0.0 0.0 summed dirty queue length 54,311 115.1 1.0 switch current to new buffer 26 0.1 0.0 table fetch by rowid 10,376,242 21,982.8 189.7 table fetch continued row 137 0.3 0.0 table scan blocks gotten 637 1.4 0.0 table scan rows gotten 31,644 67.0 0.6 table scans (short tables) 152 0.3 0.0 total number of times SMON poste 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 undo change vector size 36,965,236 78,313.5 675.6 user I/O wait time 26,998,189 57,197.6 493.5 user calls 8,296,123 17,575.9 151.6 user commits 54,712 115.9 1.0 workarea executions - optimal 706 1.5 0.0 write clones created in foregrou 48 0.1 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute Values DB/Inst: HDD/hdd Snaps: 111-112 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session pga memory max 1,178,456,032 149,989,008 session cursor cache count 9,650 15,209 session uga memory 207,523,088 8,633,935,976 opened cursors current 2,735 31 session uga memory max 399,208,552 416,085,016 session pga memory 1,041,141,056 127,558,640 logons current 834 30 ------------------------------------------------------------- Instance Activity Stats - Thread Activity DB/Inst: HDD/hdd Snaps: 111-112 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: HDD/hdd Snaps: 111-112 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ TEST 2,265,838 4,800 119.1 1.0 51,273 109 6,435 97.3 SYSAUX 1,289 3 118.6 1.4 501 1 0 0.0 UNDOTBS1 293 1 88.6 1.0 961 2 7 4.3 SYSTEM 1,173 2 164.6 1.1 17 0 673 182.2 BI 1 0 110.0 1.0 1 0 0 0.0 USERS 1 0 110.0 1.0 1 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: HDD/hdd Snaps: 111-112 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ BI +DG_HDD/hdd/bi.dbf 1 0 110.0 1.0 1 0 0 0.0 TEST +DG_HDD/hdd/test.dbf 2,265,838 4,800 119.1 1.0 51,273 109 6,435 97.3 SYSAUX +DG_HDD/hdd/datafile/sysaux.263.680785355 1,289 3 118.6 1.4 501 1 0 0.0 SYSTEM +DG_HDD/hdd/datafile/system.262.680785349 1,173 2 164.6 1.1 17 0 673 182.2 UNDOTBS1 +DG_HDD/hdd/datafile/undotbs1.264.680785383 293 1 88.6 1.0 961 2 7 4.3 USERS +DG_HDD/hdd/datafile/users.266.680785415 1 0 110.0 1.0 1 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> 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 227,885 90 22,440,497 2,317,660 72,392 0 0 7,062 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: HDD/hdd Snaps: 111-112 -> 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 17 6645 17734 3774870 3774870 N/A N/A E 0 26 10020 217096 3774870 3774870 N/A N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: HDD/hdd Snap: 112 -> 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 192 .1 23,670 2.9 748,049 D 384 .2 47,340 2.4 613,171 D 576 .3 71,010 2.1 532,743 D 768 .4 94,680 1.8 470,485 D 960 .5 118,350 1.6 417,846 D 1,152 .6 142,020 1.5 374,589 D 1,344 .7 165,690 1.3 339,526 D 1,536 .8 189,360 1.2 308,857 D 1,728 .9 213,030 1.1 279,613 D 1,920 1.0 236,700 1.0 256,099 D 2,112 1.1 260,370 0.9 231,902 D 2,304 1.2 284,040 0.8 212,990 D 2,496 1.3 307,710 0.8 194,375 D 2,688 1.4 331,380 0.7 176,532 D 2,880 1.5 355,050 0.6 160,054 D 3,072 1.6 378,720 0.6 144,557 D 3,264 1.7 402,390 0.5 129,950 D 3,456 1.8 426,060 0.5 115,907 D 3,648 1.9 449,730 0.4 102,665 D 3,840 2.0 473,400 0.4 90,938 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: HDD/hdd Snaps: 111-112 -> 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 69 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: HDD/hdd Snaps: 111-112 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 660 660 0 0 64K 128K 7 7 0 0 128K 256K 1 1 0 0 512K 1024K 27 27 0 0 1M 2M 28 28 0 0 2M 4M 2 2 0 0 4M 8M 2 2 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: HDD/hdd Snap: 112 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd P Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overallo Estd Est (MB) Factr Processed Written to Disk Hit % Count Time ---------- ------- ---------------- ---------------- ------ -------- ------- 224 0.1 97.6 23.6 81.0 10 727 448 0.3 97.6 23.6 81.0 10 727 896 0.5 97.6 13.4 88.0 8 666 1,344 0.8 97.6 13.4 88.0 7 666 1,792 1.0 97.6 0.0 100.0 0 585 2,150 1.2 97.6 0.0 100.0 0 585 2,509 1.4 97.6 0.0 100.0 0 585 2,867 1.6 97.6 0.0 100.0 0 585 3,226 1.8 97.6 0.0 100.0 0 585 3,584 2.0 97.6 0.0 100.0 0 585 5,376 3.0 97.6 0.0 100.0 0 585 7,168 4.0 97.6 0.0 100.0 0 585 10,752 6.0 97.6 0.0 100.0 0 585 14,336 8.0 97.6 0.0 100.0 0 585 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: HDD/hdd Snap: 112 -> 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 Obj Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Hits (K) -------- ----- -------- ------------ -------- ------ ------- ------ ------------ 576 .4 21 3,218 57,894 1.0 297 1.0 854 704 .5 32 4,923 57,894 1.0 297 1.0 1,306 832 .6 32 4,923 57,894 1.0 297 1.0 1,306 960 .7 32 4,923 57,894 1.0 297 1.0 1,306 1,088 .8 32 4,923 57,894 1.0 297 1.0 1,306 1,216 .9 32 4,923 57,894 1.0 297 1.0 1,306 1,344 1.0 32 4,923 57,894 1.0 297 1.0 1,306 1,472 1.1 32 4,923 57,894 1.0 297 1.0 1,306 1,600 1.2 32 4,923 57,894 1.0 297 1.0 1,306 1,728 1.3 32 4,923 57,894 1.0 297 1.0 1,306 1,856 1.4 32 4,923 57,894 1.0 297 1.0 1,306 1,984 1.5 32 4,923 57,894 1.0 297 1.0 1,306 2,112 1.6 32 4,923 57,894 1.0 297 1.0 1,306 2,240 1.7 32 4,923 57,894 1.0 297 1.0 1,306 2,368 1.8 32 4,923 57,894 1.0 297 1.0 1,306 2,496 1.9 32 4,923 57,894 1.0 297 1.0 1,306 2,624 2.0 32 4,923 57,894 1.0 297 1.0 1,306 ------------------------------------------------------------- SGA Target Advisory DB/Inst: HDD/hdd Snap: 112 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 832 0.3 349,452 1,094,907 1,664 0.5 312,705 687,322 2,496 0.8 284,337 372,504 3,328 1.0 273,822 255,700 4,160 1.3 264,047 147,283 4,992 1.5 262,513 130,049 5,824 1.8 262,515 130,049 6,656 2.0 262,515 130,049 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: HDD/hdd Snap: 112 No data exists for this section of the report. ------------------------------------------------------------- Java Pool Advisory DB/Inst: HDD/hdd Snap: 112 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 7,011 745 106 segment header 48 2 34 2nd level bmb 10 1 103 1st level bmb 16 1 46 file header block 3 0 83 undo header 7 0 4 ------------------------------------------------------------- Enqueue Activity DB/Inst: HDD/hdd Snaps: 111-112 -> 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) ------------ ------------ ----------- ----------- ------------ -------------- HW-Segment High Water Mark 1,085 1,085 0 56 74 1,316.07 SQ-Sequence Cache 172 172 0 167 29 171.98 CF-Controlfile Transaction 276 276 0 1 1 1,190.00 TX-Transaction 56,710 56,712 0 9 0 41.11 FB-Format Block 743 743 0 8 0 .00 TX-Transaction (row lock contention) 1 1 0 1 0 .00 ------------------------------------------------------------- Undo Segment Summary DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Undo Segment Stats DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Latch Activity DB/Inst: HDD/hdd Snaps: 111-112 -> "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 284 0.0 0 0 N/A ASM map operation freeli 3,113 0.3 0.1 0 0 N/A ASM map operation hash t 4,707,244 0.0 0.2 0 0 N/A ASM network background l 188 0.0 0 0 N/A AWR Alerted Metric Eleme 8,425 0.0 0 0 N/A Change Notification Hash 155 0.0 0 0 N/A Consistent RBA 31,567 0.0 0 0 N/A DML lock allocation 5,108,565 0.0 0.0 0 0 N/A Event Group Locks 6 0.0 0 0 N/A FAL request queue 11 0.0 0 0 N/A FIB s.o chain latch 16 0.0 0 0 N/A FOB s.o list latch 6,150 0.1 0.6 0 0 N/A File State Object Pool P 1 0.0 0 0 N/A IPC stats buffer allocat 1 0.0 0 0 N/A In memory undo latch 474,799 0.0 0.9 0 55,294 0.0 JS Sh mem access 3 0.0 0 0 N/A JS mem alloc latch 10 0.0 0 0 N/A JS queue access latch 21 0.0 0 0 N/A JS queue state obj latch 1,480 0.0 0 0 N/A JS slv state obj latch 4 0.0 0 0 N/A KFC FX Hash Latch 1 0.0 0 0 N/A KFC Hash Latch 1 0.0 0 0 N/A KFCL LE Freelist 1 0.0 0 0 N/A KFK SGA Libload latch 32 0.0 0 0 N/A KFMD SGA 4,239 0.1 0.0 0 0 N/A KFR redo allocation latc 1 0.0 0 0 N/A KGNFS-NFS:SHM structure 1 0.0 0 0 N/A KGNFS-NFS:SVR LIST 1 0.0 0 0 N/A KJC message pool free li 1 0.0 0 0 N/A KJCT flow control latch 1 0.0 0 0 N/A KMG MMAN ready and start 170 0.0 0 0 N/A KMG resize request state 8 0.0 0 0 N/A KTF sga latch 3 0.0 0 157 0.0 KWQMN job cache list lat 2 0.0 0 0 N/A KWQS pqsubs latch 1 0.0 0 0 N/A KWQS pqueue ctx latch 11 0.0 0 0 N/A Locator state objects po 1 0.0 0 0 N/A MQL Tracking Latch 0 N/A 0 12 8.0E Memory Management Latch 117 0.0 0 167 0.6 Memory Queue 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Message Sub 1 0.0 0 0 N/A Memory Queue Subscriber 1 0.0 0 0 N/A MinActiveScn Latch 2,916,784 0.3 0.0 0 0 N/A Mutex 1 0.0 0 0 N/A Mutex Stats 1 0.0 0 0 N/A OS process 2,453 0.0 0 0 N/A OS process allocation 987 0.1 0.0 0 0 N/A OS process: request allo 814 0.0 0 0 N/A PL/SQL warning settings 17 0.0 0 0 N/A QMT 1 0.0 0 0 N/A SGA IO buffer pool latch 32 0.0 0 32 0.0 SGA blob parent 1 0.0 0 0 N/A SGA bucket locks 1 0.0 0 0 N/A SGA heap locks 1 0.0 0 0 N/A SGA pool locks 1 0.0 0 0 N/A SQL memory manager latch 17 0.0 0 142 0.0 SQL memory manager worka 10,104 0.0 0 0 N/A Latch Activity DB/Inst: HDD/hdd Snaps: 111-112 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ Shared B-Tree 33 0.0 0 0 N/A Streams Generic 1 0.0 0 0 N/A Testing 1 0.0 0 0 N/A Token Manager 1 0.0 0 0 N/A Write State Object Pool 1 0.0 0 0 N/A XDB NFS Security Latch 1 0.0 0 0 N/A XDB unused session pool 1 0.0 0 0 N/A XDB used session pool 1 0.0 0 0 N/A active checkpoint queue 1,263 0.1 0.0 0 0 N/A active service list 1,365 3.4 0.8 1 167 0.0 archive control 13 0.0 0 0 N/A archive process latch 164 0.0 0 0 N/A begin backup scn array 32 0.0 0 0 N/A buffer pool 615 0.0 0 0 N/A business card 1 0.0 0 0 N/A cache buffer handles 5,130 0.1 0.0 0 0 N/A cache buffers chains 33,711,223 0.1 0.1 8 2,686,197 0.0 cache buffers lru chain 338,245 0.6 0.3 0 2,422,321 1.2 cache table scan latch 54 0.0 0 54 0.0 cas latch 1 0.0 0 0 N/A change notification clie 1 0.0 0 0 N/A channel handle pool latc 818 0.0 0 0 N/A channel operations paren 3,189 0.0 0.0 0 0 N/A checkpoint queue latch 116,964 0.0 0.0 0 93,322 0.0 client/application info 66 0.0 0 0 N/A commit callback allocati 23 0.0 0 0 N/A compile environment latc 7 0.0 0 0 N/A cp cmon/server latch 1 0.0 0 0 N/A cp pool latch 1 0.0 0 0 N/A cp server hash latch 1 0.0 0 0 N/A cp sga latch 10 0.0 0 0 N/A cvmap freelist lock 1 0.0 0 0 N/A deferred cleanup latch 10 0.0 0 0 N/A dml lock allocation 10 0.0 0 0 N/A done queue latch 1 0.0 0 0 N/A dummy allocation 819 0.0 0 0 N/A enqueue hash chains 901,625 0.1 0.0 0 16 0.0 enqueues 14,751 0.1 0.0 0 0 N/A fifth spare latch 1 0.0 0 0 N/A file cache latch 31 0.0 0 0 N/A flashback archiver latch 2 0.0 0 0 N/A flashback copy 1 0.0 0 0 N/A gc element 1 0.0 0 0 N/A gcs commit scn state 1 0.0 0 0 N/A gcs partitioned table ha 1 0.0 0 0 N/A gcs pcm hashed value buc 1 0.0 0 0 N/A gcs resource freelist 1 0.0 0 0 N/A gcs resource hash 1 0.0 0 0 N/A gcs resource scan list 1 0.0 0 0 N/A gcs shadows freelist 1 0.0 0 0 N/A ges domain table 1 0.0 0 0 N/A ges enqueue table freeli 1 0.0 0 0 N/A ges group table 1 0.0 0 0 N/A ges process hash list 1 0.0 0 0 N/A ges process parent latch 1 0.0 0 0 N/A ges resource hash list 1 0.0 0 0 N/A ges resource scan list 1 0.0 0 0 N/A ges resource table freel 1 0.0 0 0 N/A ges value block free lis 1 0.0 0 0 N/A global KZLD latch for me 1 0.0 0 0 N/A Latch Activity DB/Inst: HDD/hdd Snaps: 111-112 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ global tx hash mapping 1 0.0 0 0 N/A granule operation 1 0.0 0 0 N/A hash table column usage 0 N/A 0 15,911 0.0 hash table modification 413 0.0 0 0 N/A heartbeat check 1 0.0 0 0 N/A i/o slave adaptor 0 N/A 0 2 0.0 intra txn parallel recov 1 0.0 0 0 N/A io pool granule metadata 1 0.0 0 0 N/A job workq parent latch 1 0.0 0 4 0.0 job_queue_processes free 3 0.0 0 0 N/A job_queue_processes para 60 0.0 0 0 N/A k2q lock allocation 1 0.0 0 0 N/A kdlx hb parent latch 1 0.0 0 0 N/A kgb parent 1 0.0 0 0 N/A kks stats 508 0.0 0 0 N/A kokc descriptor allocati 72 0.0 0 0 N/A ksfv messages 1 0.0 0 0 N/A kss move lock 5 0.0 0 0 N/A ksuosstats global area 34 0.0 0 0 N/A ksv allocation latch 19 0.0 0 0 N/A ksv class latch 18 0.0 0 0 N/A ksv instance latch 3 0.0 0 0 N/A ksv msg queue latch 1 0.0 0 0 N/A ksz_so allocation latch 814 0.0 0 0 N/A ktm global data 2 0.0 0 0 N/A kwqbsn:qsga 17 0.0 0 0 N/A lgwr LWN SCN 31,657 0.0 0.3 0 0 N/A list of block allocation 904 0.0 0 0 N/A loader state object free 18 0.0 0 0 N/A lob segment dispenser la 1 0.0 0 0 N/A lob segment hash table l 1 0.0 0 0 N/A lob segment query latch 1 0.0 0 0 N/A lock DBA buffer during m 1 0.0 0 0 N/A logical standby cache 1 0.0 0 0 N/A logminer context allocat 1 0.0 0 0 N/A logminer work area 1 0.0 0 0 N/A longop free list parent 1 0.0 0 0 N/A mapped buffers lru chain 1 0.0 0 0 N/A message pool operations 1 0.0 0 0 N/A messages 103,279 0.1 0.0 0 0 N/A mostly latch-free SCN 32,012 0.6 0.0 0 0 N/A msg queue latch 1 0.0 0 0 N/A multiblock read objects 44,633 0.6 0.2 0 0 N/A name-service namespace b 1 0.0 0 0 N/A ncodef allocation latch 10 0.0 0 0 N/A object queue header heap 12,363 0.0 0.0 0 4,481 0.0 object queue header oper 4,772,909 0.0 0.2 0 14,648 0.0 object stats modificatio 4,591 0.0 0.0 0 0 N/A parallel query alloc buf 57 0.0 0 0 N/A parallel query stats 1 0.0 0 0 N/A parameter list 19 0.0 0 0 N/A parameter table manageme 826 0.0 0 0 N/A peshm 1 0.0 0 0 N/A pesom_free_list 1 0.0 0 0 N/A pesom_hash_node 1 0.0 0 0 N/A post/wait queue 54,335 0.0 0.1 0 56,446 0.1 process allocation 818 0.2 0.0 0 5 0.0 process group creation 814 0.1 0.0 0 0 N/A process queue 1 0.0 0 0 N/A process queue reference 1 0.0 0 0 N/A Latch Activity DB/Inst: HDD/hdd Snaps: 111-112 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ qmn task queue latch 68 0.0 0 0 N/A query server freelists 1 0.0 0 0 N/A queued dump request 1 0.0 0 0 N/A recovery domain hash lis 1 0.0 0 0 N/A redo allocation 205,784 0.1 0.1 0 115,250 0.4 redo copy 1 0.0 0 115,470 0.6 redo writing 96,528 0.0 0.0 0 0 N/A resmgr group change latc 13 0.0 0 0 N/A resmgr:active threads 819 0.0 0 0 N/A resmgr:actses change gro 7 0.0 0 0 N/A resmgr:actses change sta 1 0.0 0 0 N/A resmgr:free threads list 818 0.0 0 0 N/A resmgr:plan CPU method 1 0.0 0 0 N/A resmgr:resource group CP 1 0.0 0 0 N/A resmgr:schema config 1 0.0 0 0 N/A resmgr:session queuing 1 0.0 0 0 N/A rm cas latch 1 0.0 0 0 N/A row cache objects 57,743 0.0 0.0 0 2 0.0 rules engine aggregate s 1 0.0 0 0 N/A rules engine rule set st 2 0.0 0 0 N/A second spare latch 1 0.0 0 0 N/A sequence cache 165,813 0.0 0.0 0 0 N/A session allocation 254,133 0.7 0.2 220 0 N/A session idle bit 16,820,186 0.0 0.0 0 0 N/A session queue latch 1 0.0 0 0 N/A session state list latch 16 0.0 0 0 N/A session switching 11 0.0 0 0 N/A session timer 167 0.0 0 0 N/A shared pool 51,990 1.0 0.2 2 0 N/A shared pool sim alloc 40 0.0 0 0 N/A shared pool simulator 1,755 0.0 0 0 N/A sim partition latch 1 0.0 0 0 N/A simulator hash latch 973,190 0.0 0.1 0 0 N/A simulator lru latch 730 0.3 1.0 0 879,901 0.2 sort extent pool 11 0.0 0 0 N/A space background task la 345 0.0 0 314 0.0 state object free list 2 0.0 0 0 N/A statistics aggregation 336 0.0 0 0 N/A tablespace key chain 1 0.0 0 0 N/A test excl. parent l0 1 0.0 0 0 N/A test excl. parent2 l0 1 0.0 0 0 N/A third spare latch 1 0.0 0 0 N/A threshold alerts latch 10 0.0 0 0 N/A trace latch 1 0.0 0 0 N/A transaction allocation 1,086,106 0.0 1.0 0 0 N/A undo global data 282,511 0.0 0.1 0 0 N/A user lock 1,616 9.6 0.9 62 0 N/A virtual circuit buffers 1 0.0 0 0 N/A virtual circuit holder 1 0.0 0 0 N/A virtual circuit queues 1 0.0 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: HDD/hdd Snaps: 111-112 -> ordered by misses desc Get Spin Latch Name Requests Misses Sleeps Gets -------------------------- --------------- ------------ ----------- ----------- cache buffers chains 33,711,223 30,382 1,653 28,852 session idle bit 16,820,186 4,442 89 4,353 cache buffers lru chain 338,245 2,034 582 1,464 session allocation 254,133 1,873 337 1,562 object queue header operat 4,772,909 947 168 787 enqueue hash chains 901,625 601 24 578 shared pool 51,990 537 82 456 multiblock read objects 44,633 286 43 245 mostly latch-free SCN 32,012 192 5 187 user lock 1,616 155 137 22 DML lock allocation 5,108,565 143 6 138 redo allocation 205,784 123 7 116 In memory undo latch 474,799 114 97 18 ASM map operation hash tab 4,707,244 96 15 81 active service list 1,365 47 36 17 simulator hash latch 973,190 35 5 30 checkpoint queue latch 116,964 24 1 23 undo global data 282,511 15 1 14 lgwr LWN SCN 31,657 14 4 10 post/wait queue 54,335 12 1 11 ASM map operation freelist 3,113 8 1 7 FOB s.o list latch 6,150 7 4 3 simulator lru latch 730 2 2 0 transaction allocation 1,086,106 1 1 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- ASM map operation freeli kffmTranslate2 0 1 1 ASM map operation hash t kffmDoDone_1 0 9 7 ASM map operation hash t kffmTranslate 0 6 8 DML lock allocation ktadmc 0 5 1 DML lock allocation ktaidm 0 1 1 FOB s.o list latch ksfd_fobd 0 4 4 In memory undo latch ktiFlush: child 0 69 33 In memory undo latch kticmt: child 0 27 35 In memory undo latch ktichg: child 0 4 33 In memory undo latch ktiTxnPoolFree 0 1 0 active service list ksws_event: ksws event 0 46 46 cache buffers chains kcbgtcr_1 0 794 6 cache buffers chains kcbzwb 0 478 1,214 cache buffers chains kcbgtcr: fast path 0 220 334 cache buffers chains kcbgtcr: kslbegin shared 0 162 37 cache buffers chains kcbzgb: scan from tail. no 0 108 0 cache buffers chains kcbgcur_2 0 66 39 cache buffers chains kcbgtcr: fast path (cr pin 0 63 85 cache buffers chains kcbgtcr_9 0 20 46 cache buffers chains kcbgcur: fast path (shr) 0 11 8 cache buffers chains kcbget: exchange rls 0 4 7 cache buffers chains kcbrls_2 0 4 37 cache buffers chains kcbchg1: kslbegin: bufs no 0 3 23 cache buffers chains kcbgcur_6 0 3 1 cache buffers chains kcbzib: finish free bufs 0 3 22 cache buffers chains kcbget: exchange 0 2 9 cache buffers chains kcbnew: new latch again 0 2 0 cache buffers chains kcbnlc 0 2 7 cache buffers chains kcbrls: fast release 0 2 20 cache buffers chains kcbzib_1 0 2 0 cache buffers chains kcb_post_apply: kcbhq62 0 1 2 cache buffers chains kcbgtcr: kslbegin excl 0 1 4 cache buffers lru chain kcbzgws 0 356 0 cache buffers lru chain kcbz_prewarm_islocal 0 183 34 cache buffers lru chain kcbzgpwb: KSLBEGIN use pre 0 13 152 cache buffers lru chain kcbzgm 0 7 0 cache buffers lru chain kcbzfw 0 6 8 cache buffers lru chain kcbbxsv: move to being wri 0 4 159 cache buffers lru chain kcbo_link_q 0 3 9 cache buffers lru chain kcbbic2 0 1 54 channel operations paren ksrchdelete_sub() 0 1 1 checkpoint queue latch kcbkubc_4 0 1 1 cost function kzulrl 0 137 137 enqueue hash chains ksqrcl 0 13 10 enqueue hash chains ksqgtl3 0 11 14 lgwr LWN SCN kcs023 0 4 0 mostly latch-free SCN kcs024 0 4 0 mostly latch-free SCN kcslcu3 0 1 9 multiblock read objects kcbzib_1 0 30 18 multiblock read objects kcbzib: normal mbr free 0 12 24 object queue header oper kcbo_unlink_q 0 151 35 object queue header oper kcbo_link_q 0 76 36 object queue header oper kcbo_switch_cq 0 55 110 object queue header oper kcbo_switch_mq_bg 0 5 105 object queue header oper kcbo_switch_q_bg 0 5 6 post/wait queue ksliwat:add:nowait 0 1 0 redo allocation kcrfw_redo_gen: redo alloc 0 5 0 redo allocation kcrfw_redo_gen: redo alloc 0 1 0 session allocation ksuxds: KSUSFCLC not set 0 112 117 session allocation ksudlp 0 110 63 Latch Miss Sources DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- session allocation ksuxds: not user session 0 64 100 session allocation ksucri 0 44 56 session allocation kspallmod 0 3 0 session allocation ksuprc 0 3 1 session allocation ksudlc 0 1 0 session idle bit ksupuc: set busy 0 85 43 session idle bit ksupuc: clear busy 0 61 101 session idle bit ksuxds 0 1 3 shared pool kghfre 0 77 82 shared pool kghalo 0 5 0 simulator hash latch kcbs_lookup_setid: lookup 0 2 0 simulator hash latch kcbsacc: lookup dba 0 2 4 simulator hash latch kcbsacc: insert dba 0 1 0 simulator lru latch kcbs_grow_pool 0 1 0 simulator lru latch kcbs_reset_pool 0 1 0 transaction allocation ktcxbr 0 1 0 undo global data ktubnd:child 0 1 1 ------------------------------------------------------------- Mutex Sleep Summary DB/Inst: HDD/hdd Snaps: 111-112 -> ordered by number of sleeps desc Wait Mutex Type Location Sleeps Time (ms) --------------------- -------------------------------- ------------ ------------ Library Cache kglpin1 4 1,043 0 Library Cache kglpndl1 95 449 0 Library Cache kglpnal1 90 247 0 Cursor Stat kkocsStoreBindAwareStats [KKSSTA 160 10 Library Cache kgllkdl1 85 98 0 Library Cache kglhdgn2 106 40 0 Library Cache kgllkc1 57 18 0 Library Cache kglhdgn1 62 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps are shown -> ordered by name Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->3+ ----------------------------- -------------- ----------- ---------- ------------ ASM map operation freelist 3,016 8 1 7/0/0/0 FOB s.o list latch 5,993 7 4 3/0/0/0 active service list 1,365 47 36 17/0/0/0 lgwr LWN SCN 31,540 14 4 10/0/0/0 mostly latch-free SCN 31,895 192 5 187/0/0/0 multiblock read objects 42,279 281 42 241/0/0/0 session allocation 249,380 1,873 337 1562/0/0/0 user lock 1,616 155 137 22/0/0/0 ------------------------------------------------------------- Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ ASM map operation hash 1769 4,644 1 1 0/0/0/0 ASM map operation hash 1753 4,166 1 1 0/0/0/0 ASM map operation hash 1583 3,946 1 1 0/0/0/0 ASM map operation hash 1578 3,774 1 1 0/0/0/0 ASM map operation hash 1678 3,652 2 1 1/0/0/0 ASM map operation hash 1320 3,532 1 1 0/0/0/0 ASM map operation hash 1247 2,660 1 1 0/0/0/0 ASM map operation hash 1650 2,418 2 1 1/0/0/0 ASM map operation hash 1374 2,304 1 1 0/0/0/0 ASM map operation hash 472 2,254 1 1 0/0/0/0 ASM map operation hash 53 2,186 1 1 0/0/0/0 ASM map operation hash 1304 1,972 1 1 0/0/0/0 ASM map operation hash 803 1,776 1 1 0/0/0/0 ASM map operation hash 652 1,692 1 1 0/0/0/0 ASM map operation hash 818 1,456 1 1 0/0/0/0 DML lock allocation 31 161,337 18 3 16/0/0/0 In memory undo latch 6 44,479 16 12 4/0/0/0 In memory undo latch 9 38,960 12 11 1/0/0/0 In memory undo latch 10 38,501 6 6 0/0/0/0 In memory undo latch 7 38,100 2 2 0/0/0/0 In memory undo latch 8 36,162 8 8 0/0/0/0 In memory undo latch 5 35,836 12 10 3/0/0/0 In memory undo latch 4 33,187 10 8 2/0/0/0 In memory undo latch 11 30,589 6 5 1/0/0/0 In memory undo latch 3 29,172 11 9 2/0/0/0 In memory undo latch 2 25,000 13 9 4/0/0/0 In memory undo latch 12 22,101 4 4 0/0/0/0 In memory undo latch 13 16,869 3 2 1/0/0/0 In memory undo latch 1 15,684 8 8 0/0/0/0 In memory undo latch 14 13,527 1 1 0/0/0/0 In memory undo latch 17 6,840 2 2 0/0/0/0 cache buffers chains 11186 718,445 2,146 26 2127/0/0/0 cache buffers chains 13014 556,845 3,472 49 3429/0/0/0 cache buffers chains 2186 555,289 625 107 524/0/0/0 cache buffers chains 14099 553,507 2,650 50 2607/0/0/0 cache buffers chains 12870 553,089 2,277 98 2189/0/0/0 cache buffers chains 9358 552,961 1,648 49 1600/0/0/0 cache buffers chains 7530 552,809 1,288 97 1197/0/0/0 cache buffers chains 13858 552,532 2,595 242 2364/0/0/0 cache buffers chains 4354 552,511 2,876 56 2826/0/0/0 cache buffers chains 9647 350,750 321 6 316/0/0/0 cache buffers chains 15275 345,689 444 112 337/0/0/0 cache buffers chains 6386 233,350 212 3 210/0/0/0 cache buffers chains 9486 232,564 230 50 187/0/0/0 cache buffers chains 1938 169,076 239 78 164/0/0/0 cache buffers chains 13710 165,449 137 11 130/0/0/0 cache buffers chains 5875 111,312 111 34 78/0/0/0 cache buffers chains 15415 15,683 3 1 2/0/0/0 cache buffers chains 1239 15,072 5 4 2/0/0/0 cache buffers chains 5692 14,931 11 8 6/0/0/0 cache buffers chains 11900 14,879 8 6 3/0/0/0 cache buffers chains 14764 14,338 2 1 1/0/0/0 cache buffers chains 14740 14,301 8 3 5/0/0/0 cache buffers chains 1798 13,915 5 5 1/0/0/0 cache buffers chains 9159 13,778 9 4 7/0/0/0 cache buffers chains 11328 13,650 6 3 4/0/0/0 cache buffers chains 9135 13,631 6 1 5/0/0/0 cache buffers chains 14254 13,625 7 2 5/0/0/0 cache buffers chains 8067 13,550 8 2 6/0/0/0 cache buffers chains 10957 13,517 3 1 2/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 10088 13,377 4 3 1/0/0/0 cache buffers chains 761 13,367 3 2 2/0/0/0 cache buffers chains 16235 13,279 5 1 4/0/0/0 cache buffers chains 9194 13,272 4 1 3/0/0/0 cache buffers chains 7148 13,253 5 1 4/0/0/0 cache buffers chains 12492 13,140 8 3 5/0/0/0 cache buffers chains 2557 12,939 2 1 1/0/0/0 cache buffers chains 11369 12,801 2 1 1/0/0/0 cache buffers chains 5744 12,779 5 1 4/0/0/0 cache buffers chains 10650 12,442 4 1 3/0/0/0 cache buffers chains 4064 12,365 5 1 4/0/0/0 cache buffers chains 3580 12,285 2 1 1/0/0/0 cache buffers chains 5509 12,174 4 1 3/0/0/0 cache buffers chains 14190 12,152 2 3 0/0/0/0 cache buffers chains 3837 12,141 3 4 0/0/0/0 cache buffers chains 4242 12,107 7 4 4/0/0/0 cache buffers chains 8808 12,046 3 3 1/0/0/0 cache buffers chains 3455 11,438 7 2 6/0/0/0 cache buffers chains 15439 10,295 5 2 3/0/0/0 cache buffers chains 13593 9,636 6 3 3/0/0/0 cache buffers chains 82 7,236 3 2 1/0/0/0 cache buffers chains 7726 6,768 2 1 1/0/0/0 cache buffers chains 12681 6,442 6 7 1/0/0/0 cache buffers chains 7821 6,411 2 1 1/0/0/0 cache buffers chains 5279 5,970 2 2 0/0/0/0 cache buffers chains 3681 5,866 1 1 0/0/0/0 cache buffers chains 7760 5,843 2 1 1/0/0/0 cache buffers chains 7892 5,763 1 1 0/0/0/0 cache buffers chains 9505 5,700 3 2 1/0/0/0 cache buffers chains 11133 5,577 1 1 0/0/0/0 cache buffers chains 444 5,570 1 1 0/0/0/0 cache buffers chains 14653 5,537 2 1 1/0/0/0 cache buffers chains 7767 5,330 1 1 0/0/0/0 cache buffers chains 6125 5,250 3 1 2/0/0/0 cache buffers chains 12814 5,174 4 6 1/0/0/0 cache buffers chains 14079 5,138 5 4 2/0/0/0 cache buffers chains 8527 5,107 2 1 1/0/0/0 cache buffers chains 10933 5,046 1 1 0/0/0/0 cache buffers chains 8376 5,009 4 3 1/0/0/0 cache buffers chains 12670 4,933 2 1 1/0/0/0 cache buffers chains 12243 4,920 1 1 0/0/0/0 cache buffers chains 5441 4,910 1 1 0/0/0/0 cache buffers chains 4019 4,872 2 1 1/0/0/0 cache buffers chains 4512 4,851 1 1 0/0/0/0 cache buffers chains 4112 4,797 1 1 0/0/0/0 cache buffers chains 14443 4,775 1 1 0/0/0/0 cache buffers chains 1343 4,765 1 1 0/0/0/0 cache buffers chains 13799 4,756 3 1 2/0/0/0 cache buffers chains 2473 4,753 3 1 2/0/0/0 cache buffers chains 7466 4,726 1 1 0/0/0/0 cache buffers chains 293 4,711 1 1 0/0/0/0 cache buffers chains 6072 4,701 2 2 0/0/0/0 cache buffers chains 6635 4,685 2 1 1/0/0/0 cache buffers chains 3893 4,679 1 1 0/0/0/0 cache buffers chains 5721 4,678 1 1 0/0/0/0 cache buffers chains 645 4,633 1 1 0/0/0/0 cache buffers chains 8463 4,605 1 1 0/0/0/0 cache buffers chains 3118 4,597 2 3 1/0/0/0 cache buffers chains 393 4,582 1 1 0/0/0/0 cache buffers chains 4508 4,564 2 1 1/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 2416 4,546 1 1 0/0/0/0 cache buffers chains 1502 4,531 2 2 1/0/0/0 cache buffers chains 433 4,523 1 1 0/0/0/0 cache buffers chains 3330 4,507 1 1 0/0/0/0 cache buffers chains 5777 4,488 1 1 0/0/0/0 cache buffers chains 5158 4,456 1 1 0/0/0/0 cache buffers chains 6850 4,451 2 2 0/0/0/0 cache buffers chains 14638 4,428 2 2 0/0/0/0 cache buffers chains 10208 4,425 4 3 2/0/0/0 cache buffers chains 5430 4,408 1 1 0/0/0/0 cache buffers chains 709 4,334 1 1 0/0/0/0 cache buffers chains 8731 4,321 2 1 1/0/0/0 cache buffers chains 14362 4,319 1 1 0/0/0/0 cache buffers chains 9800 4,313 1 1 0/0/0/0 cache buffers chains 15061 4,312 1 1 0/0/0/0 cache buffers chains 4236 4,307 1 1 0/0/0/0 cache buffers chains 6684 4,302 5 4 1/0/0/0 cache buffers chains 15416 4,290 2 1 1/0/0/0 cache buffers chains 6950 4,268 9 4 5/0/0/0 cache buffers chains 10853 4,257 1 1 0/0/0/0 cache buffers chains 2344 4,223 1 1 0/0/0/0 cache buffers chains 9509 4,221 1 1 0/0/0/0 cache buffers chains 6241 4,216 127 82 51/0/0/0 cache buffers chains 6903 4,202 1 1 0/0/0/0 cache buffers chains 14018 4,188 3 3 2/0/0/0 cache buffers chains 10982 4,188 1 1 0/0/0/0 cache buffers chains 6703 4,167 1 1 0/0/0/0 cache buffers chains 426 4,153 2 3 0/0/0/0 cache buffers chains 14287 4,149 2 1 1/0/0/0 cache buffers chains 9592 4,148 2 1 1/0/0/0 cache buffers chains 6276 4,135 2 1 1/0/0/0 cache buffers chains 5369 4,107 1 1 0/0/0/0 cache buffers chains 3813 4,083 2 1 1/0/0/0 cache buffers chains 12806 4,070 4 2 2/0/0/0 cache buffers chains 2816 4,041 1 1 0/0/0/0 cache buffers chains 2548 4,033 3 1 2/0/0/0 cache buffers chains 7114 4,030 1 1 0/0/0/0 cache buffers chains 9297 3,994 2 2 0/0/0/0 cache buffers chains 2677 3,983 1 1 0/0/0/0 cache buffers chains 1774 3,971 1 1 0/0/0/0 cache buffers chains 4716 3,966 2 1 1/0/0/0 cache buffers chains 12251 3,964 1 2 0/0/0/0 cache buffers chains 16062 3,943 1 1 0/0/0/0 cache buffers chains 11688 3,939 3 1 2/0/0/0 cache buffers chains 4025 3,934 3 2 1/0/0/0 cache buffers chains 10072 3,931 1 1 0/0/0/0 cache buffers chains 498 3,928 1 1 0/0/0/0 cache buffers chains 6340 3,927 1 1 0/0/0/0 cache buffers chains 13524 3,908 1 1 0/0/0/0 cache buffers chains 12311 3,887 1 1 0/0/0/0 cache buffers chains 973 3,882 1 1 0/0/0/0 cache buffers chains 4720 3,875 1 1 0/0/0/0 cache buffers chains 15287 3,859 6 3 3/0/0/0 cache buffers chains 8466 3,828 2 2 1/0/0/0 cache buffers chains 13208 3,813 6 4 3/0/0/0 cache buffers chains 1430 3,810 4 2 2/0/0/0 cache buffers chains 86 3,805 1 1 0/0/0/0 cache buffers chains 3602 3,796 1 1 0/0/0/0 cache buffers chains 2325 3,781 4 3 2/0/0/0 cache buffers chains 308 3,779 1 1 0/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 13531 3,751 1 1 0/0/0/0 cache buffers chains 2408 3,732 2 1 1/0/0/0 cache buffers chains 12732 3,722 1 1 0/0/0/0 cache buffers chains 5933 3,716 3 1 2/0/0/0 cache buffers chains 14713 3,699 2 2 0/0/0/0 cache buffers chains 7277 3,684 1 1 0/0/0/0 cache buffers chains 13728 3,666 2 1 1/0/0/0 cache buffers chains 15376 3,664 2 1 1/0/0/0 cache buffers chains 11856 3,657 1 1 0/0/0/0 cache buffers chains 14968 3,652 1 1 0/0/0/0 cache buffers chains 13165 3,650 2 1 1/0/0/0 cache buffers chains 6351 3,650 1 1 0/0/0/0 cache buffers chains 9369 3,647 4 2 1/0/0/0 cache buffers chains 1358 3,643 1 1 0/0/0/0 cache buffers chains 15624 3,624 1 1 0/0/0/0 cache buffers chains 13752 3,616 1 1 0/0/0/0 cache buffers chains 12534 3,593 1 1 0/0/0/0 cache buffers chains 1007 3,588 1 1 0/0/0/0 cache buffers chains 14441 3,564 2 1 1/0/0/0 cache buffers chains 8942 3,558 1 1 0/0/0/0 cache buffers chains 15850 3,552 1 1 0/0/0/0 cache buffers chains 5301 3,547 1 1 0/0/0/0 cache buffers chains 14642 3,538 4 2 2/0/0/0 cache buffers chains 1630 3,530 1 1 0/0/0/0 cache buffers chains 412 3,520 2 2 0/0/0/0 cache buffers chains 5420 3,519 2 1 1/0/0/0 cache buffers chains 3135 3,515 1 1 0/0/0/0 cache buffers chains 13176 3,511 1 1 0/0/0/0 cache buffers chains 13448 3,511 2 1 1/0/0/0 cache buffers chains 10817 3,500 15 8 7/0/0/0 cache buffers chains 9590 3,480 1 1 0/0/0/0 cache buffers chains 3458 3,479 2 1 1/0/0/0 cache buffers chains 9990 3,466 1 1 0/0/0/0 cache buffers chains 13246 3,465 2 2 0/0/0/0 cache buffers chains 1381 3,448 1 1 0/0/0/0 cache buffers chains 11756 3,446 2 2 0/0/0/0 cache buffers chains 9688 3,438 1 1 0/0/0/0 cache buffers chains 11176 3,434 2 1 1/0/0/0 cache buffers chains 1024 3,432 1 1 0/0/0/0 cache buffers chains 12796 3,429 1 1 0/0/0/0 cache buffers chains 9365 3,425 1 1 0/0/0/0 cache buffers chains 4372 3,423 5 2 3/0/0/0 cache buffers chains 482 3,406 2 1 1/0/0/0 cache buffers chains 3462 3,406 1 1 0/0/0/0 cache buffers chains 11835 3,369 1 1 0/0/0/0 cache buffers chains 14900 3,352 1 2 0/0/0/0 cache buffers chains 3802 3,326 2 1 1/0/0/0 cache buffers chains 14628 3,320 1 1 0/0/0/0 cache buffers chains 3728 3,315 1 1 0/0/0/0 cache buffers chains 6002 3,294 3 2 1/0/0/0 cache buffers chains 12196 3,282 2 2 0/0/0/0 cache buffers chains 4986 3,254 1 1 0/0/0/0 cache buffers chains 13512 3,239 1 1 0/0/0/0 cache buffers chains 3239 3,229 2 1 1/0/0/0 cache buffers chains 1411 3,219 2 2 0/0/0/0 cache buffers chains 616 3,205 1 1 0/0/0/0 cache buffers chains 684 3,183 1 1 0/0/0/0 cache buffers chains 4438 3,164 1 1 0/0/0/0 cache buffers chains 3158 3,149 1 1 0/0/0/0 cache buffers chains 4443 3,110 2 1 1/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 9064 3,071 1 1 0/0/0/0 cache buffers chains 801 3,040 1 1 0/0/0/0 cache buffers chains 10150 3,019 1 1 0/0/0/0 cache buffers chains 6285 3,010 1 1 0/0/0/0 cache buffers chains 3056 2,973 1 1 0/0/0/0 cache buffers chains 7811 2,961 2 1 1/0/0/0 cache buffers chains 11429 2,952 1 1 0/0/0/0 cache buffers chains 437 2,940 2 1 1/0/0/0 cache buffers chains 15055 2,873 2 2 0/0/0/0 cache buffers chains 12600 2,813 2 2 0/0/0/0 cache buffers chains 14455 2,811 1 1 0/0/0/0 cache buffers chains 5643 2,775 1 1 0/0/0/0 cache buffers chains 5137 2,764 1 1 0/0/0/0 cache buffers chains 13801 2,719 1 1 0/0/0/0 cache buffers chains 1101 2,712 2 1 1/0/0/0 cache buffers chains 4305 2,627 1 1 0/0/0/0 cache buffers chains 14529 2,591 4 2 2/0/0/0 cache buffers chains 5842 2,568 1 1 0/0/0/0 cache buffers chains 9888 2,521 1 1 0/0/0/0 cache buffers chains 872 2,472 1 1 0/0/0/0 cache buffers chains 8739 2,372 2 1 1/0/0/0 cache buffers chains 510 2,360 1 1 0/0/0/0 cache buffers chains 8599 2,293 1 1 0/0/0/0 cache buffers chains 12693 2,280 1 1 0/0/0/0 cache buffers chains 4233 2,255 1 1 0/0/0/0 cache buffers chains 4959 2,229 2 1 1/0/0/0 cache buffers chains 3115 2,111 1 1 0/0/0/0 cache buffers chains 5734 2,102 1 1 0/0/0/0 cache buffers chains 13044 2,091 1 1 0/0/0/0 cache buffers chains 7957 2,089 1 1 0/0/0/0 cache buffers chains 9101 2,063 1 1 0/0/0/0 cache buffers chains 16023 2,020 1 1 0/0/0/0 cache buffers chains 2546 1,989 1 1 0/0/0/0 cache buffers chains 4956 1,973 1 1 0/0/0/0 cache buffers chains 4958 1,958 1 1 0/0/0/0 cache buffers chains 10359 1,950 1 1 0/0/0/0 cache buffers chains 1100 1,919 1 1 0/0/0/0 cache buffers chains 14486 1,879 1 1 0/0/0/0 cache buffers chains 4191 1,870 1 1 0/0/0/0 cache buffers chains 7691 1,865 1 1 0/0/0/0 cache buffers chains 5253 1,863 1 2 0/0/0/0 cache buffers chains 12188 1,853 1 1 0/0/0/0 cache buffers chains 692 1,812 10 2 8/0/0/0 cache buffers chains 14921 1,810 2 2 0/0/0/0 cache buffers chains 7258 1,805 1 1 0/0/0/0 cache buffers chains 3384 1,796 2 2 1/0/0/0 cache buffers chains 10136 1,770 4 2 2/0/0/0 cache buffers chains 222 1,740 1 1 0/0/0/0 cache buffers chains 9030 1,728 1 1 0/0/0/0 cache buffers chains 11006 1,714 1 1 0/0/0/0 cache buffers chains 10739 1,700 1 1 0/0/0/0 cache buffers chains 13313 1,699 3 1 2/0/0/0 cache buffers chains 11764 1,683 1 1 0/0/0/0 cache buffers chains 9379 1,682 1 1 0/0/0/0 cache buffers chains 12750 1,675 1 1 0/0/0/0 cache buffers chains 3471 1,667 1 1 0/0/0/0 cache buffers chains 14169 1,667 1 1 0/0/0/0 cache buffers chains 7322 1,660 1 1 0/0/0/0 cache buffers chains 1767 1,640 1 1 0/0/0/0 cache buffers chains 6831 1,623 1 1 0/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 7829 1,604 1 1 0/0/0/0 cache buffers chains 11616 1,561 3 3 0/0/0/0 cache buffers chains 4559 1,560 9 3 6/0/0/0 cache buffers chains 14185 1,557 1 1 0/0/0/0 cache buffers chains 2168 1,537 1 1 0/0/0/0 cache buffers chains 679 1,523 1 1 0/0/0/0 cache buffers chains 3082 1,492 19 8 11/0/0/0 cache buffers chains 527 1,491 2 2 0/0/0/0 cache buffers chains 12489 1,486 1 1 0/0/0/0 cache buffers chains 2262 1,486 1 1 0/0/0/0 cache buffers chains 16342 1,474 1 1 0/0/0/0 cache buffers chains 14167 1,465 1 1 0/0/0/0 cache buffers chains 3365 1,463 1 1 0/0/0/0 cache buffers chains 12463 1,456 1 1 0/0/0/0 cache buffers chains 14732 1,451 2 2 0/0/0/0 cache buffers chains 8538 1,429 1 1 0/0/0/0 cache buffers chains 6495 1,427 1 1 0/0/0/0 cache buffers chains 9322 1,423 1 1 0/0/0/0 cache buffers chains 15258 1,422 1 1 0/0/0/0 cache buffers chains 16335 1,422 1 1 0/0/0/0 cache buffers chains 9341 1,420 3 2 1/0/0/0 cache buffers chains 6356 1,411 2 1 1/0/0/0 cache buffers chains 1600 1,411 1 1 0/0/0/0 cache buffers chains 4574 1,409 1 1 0/0/0/0 cache buffers chains 9336 1,399 1 1 0/0/0/0 cache buffers chains 15599 1,395 1 1 0/0/0/0 cache buffers chains 1997 1,393 1 1 0/0/0/0 cache buffers chains 11243 1,378 1 1 0/0/0/0 cache buffers chains 2633 1,377 2 1 1/0/0/0 cache buffers chains 12157 1,367 2 1 1/0/0/0 cache buffers chains 10050 1,357 1 1 0/0/0/0 cache buffers chains 9256 1,348 1 1 0/0/0/0 cache buffers chains 1114 1,345 1 1 0/0/0/0 cache buffers chains 3694 1,338 1 1 0/0/0/0 cache buffers chains 11428 1,329 1 1 0/0/0/0 cache buffers chains 8883 1,310 1 1 0/0/0/0 cache buffers chains 16232 1,280 1 1 0/0/0/0 cache buffers chains 13032 1,276 1 1 0/0/0/0 cache buffers chains 14454 1,273 2 1 1/0/0/0 cache buffers chains 2621 1,210 1 1 0/0/0/0 cache buffers chains 1680 1,208 1 1 0/0/0/0 cache buffers chains 11161 1,206 1 1 0/0/0/0 cache buffers chains 1328 1,203 1 1 0/0/0/0 cache buffers chains 14798 1,201 1 1 0/0/0/0 cache buffers chains 9065 1,199 1 1 0/0/0/0 cache buffers chains 6615 1,191 2 1 1/0/0/0 cache buffers chains 1334 1,188 1 1 0/0/0/0 cache buffers chains 5175 1,187 1 1 0/0/0/0 cache buffers chains 2051 1,166 1 1 0/0/0/0 cache buffers chains 10368 1,157 1 1 0/0/0/0 cache buffers chains 4812 1,151 1 1 0/0/0/0 cache buffers chains 11259 1,147 1 1 0/0/0/0 cache buffers chains 12505 1,144 1 1 0/0/0/0 cache buffers chains 10836 1,139 1 1 0/0/0/0 cache buffers chains 2636 1,128 1 1 0/0/0/0 cache buffers chains 555 1,126 1 1 0/0/0/0 cache buffers chains 1679 1,123 1 1 0/0/0/0 cache buffers chains 400 1,116 1 1 0/0/0/0 cache buffers chains 10504 1,113 1 1 0/0/0/0 cache buffers chains 7303 1,112 1 1 0/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ cache buffers chains 4789 1,108 1 1 0/0/0/0 cache buffers chains 13136 1,092 1 1 0/0/0/0 cache buffers chains 12992 1,085 1 1 0/0/0/0 cache buffers chains 15892 1,043 1 1 0/0/0/0 cache buffers chains 8652 1,042 1 1 0/0/0/0 cache buffers chains 10441 1,021 1 1 0/0/0/0 cache buffers chains 9654 1,013 1 1 0/0/0/0 cache buffers chains 9205 1,007 1 1 0/0/0/0 cache buffers chains 8873 1,000 1 1 0/0/0/0 cache buffers chains 4862 993 1 1 0/0/0/0 cache buffers chains 4123 978 1 1 0/0/0/0 cache buffers chains 10636 976 1 1 0/0/0/0 cache buffers chains 2459 960 1 1 0/0/0/0 cache buffers chains 16110 959 1 1 0/0/0/0 cache buffers chains 923 957 1 1 0/0/0/0 cache buffers chains 9643 956 1 1 0/0/0/0 cache buffers chains 14839 944 1 1 0/0/0/0 cache buffers chains 8294 929 1 1 0/0/0/0 cache buffers chains 6055 921 2 1 1/0/0/0 cache buffers chains 4065 919 1 1 0/0/0/0 cache buffers chains 10324 914 1 1 0/0/0/0 cache buffers chains 16303 911 1 1 0/0/0/0 cache buffers chains 13028 909 1 1 0/0/0/0 cache buffers chains 701 890 1 1 0/0/0/0 cache buffers chains 14569 875 1 1 0/0/0/0 cache buffers chains 16019 846 1 1 0/0/0/0 cache buffers chains 210 844 1 1 0/0/0/0 cache buffers chains 9917 816 1 1 0/0/0/0 cache buffers chains 6196 804 1 1 0/0/0/0 cache buffers chains 14689 799 1 1 0/0/0/0 cache buffers chains 2022 785 1 1 0/0/0/0 cache buffers chains 14365 737 1 1 0/0/0/0 cache buffers chains 6275 732 1 1 0/0/0/0 cache buffers chains 12665 732 1 1 0/0/0/0 cache buffers chains 4517 732 1 1 0/0/0/0 cache buffers chains 13606 703 1 1 0/0/0/0 cache buffers chains 7737 699 2 1 1/0/0/0 cache buffers chains 16117 695 1 1 0/0/0/0 cache buffers chains 13013 675 1 1 0/0/0/0 cache buffers chains 12952 636 1 1 0/0/0/0 cache buffers chains 3472 623 2 1 1/0/0/0 cache buffers chains 15600 611 1 1 0/0/0/0 cache buffers lru chai 28 28,366 177 47 131/0/0/0 cache buffers lru chai 26 28,304 167 46 121/0/0/0 cache buffers lru chai 31 28,261 154 47 107/0/0/0 cache buffers lru chai 34 28,206 166 56 112/0/0/0 cache buffers lru chai 25 28,200 192 48 144/0/0/0 cache buffers lru chai 35 28,135 156 45 111/0/0/0 cache buffers lru chai 30 28,121 165 51 118/0/0/0 cache buffers lru chai 29 28,086 172 48 125/0/0/0 cache buffers lru chai 33 28,043 187 51 137/0/0/0 cache buffers lru chai 27 28,009 156 36 122/0/0/0 cache buffers lru chai 36 27,988 177 48 130/0/0/0 cache buffers lru chai 32 27,937 165 59 106/0/0/0 checkpoint queue latch 53 3,858 3 1 2/0/0/0 enqueue hash chains 11 234,188 309 6 303/0/0/0 enqueue hash chains 9 124,203 122 2 120/0/0/0 enqueue hash chains 6 14,440 17 12 6/0/0/0 enqueue hash chains 16 14,134 1 1 0/0/0/0 enqueue hash chains 15 14,029 2 1 1/0/0/0 Child Latch Statistics DB/Inst: HDD/hdd Snaps: 111-112 -> only latches with sleeps/gets > 1/100000 are shown -> ordered by name, gets desc Child Get Spin & Latch Name Num Requests Misses Sleeps Sleeps 1->3+ ---------------------- ------- ------------ ----------- ---------- ------------ object queue header op 25 398,172 67 13 54/0/0/0 object queue header op 28 398,098 99 17 83/0/0/0 object queue header op 30 397,956 66 13 55/0/0/0 object queue header op 26 397,898 79 18 61/0/0/0 object queue header op 27 397,852 72 16 56/0/0/0 object queue header op 29 397,828 91 14 78/0/0/0 object queue header op 31 397,657 74 15 59/0/0/0 object queue header op 34 397,562 87 17 70/0/0/0 object queue header op 32 397,550 88 13 77/0/0/0 object queue header op 33 397,257 61 4 57/0/0/0 object queue header op 35 397,129 83 13 71/0/0/0 object queue header op 36 396,983 80 15 66/0/0/0 post/wait queue 6 31,684 10 1 9/0/0/0 redo allocation 1 63,106 119 6 113/0/0/0 redo allocation 2 32,064 3 1 2/0/0/0 session idle bit 8 692,903 198 7 191/0/0/0 session idle bit 12 692,138 195 7 188/0/0/0 shared pool 2 15,878 133 23 110/0/0/0 shared pool 1 13,955 126 13 113/0/0/0 shared pool 3 7,512 100 23 78/0/0/0 shared pool 5 7,457 127 14 113/0/0/0 shared pool 4 6,808 51 9 42/0/0/0 simulator hash latch 161 8,111 1 1 0/0/0/0 simulator hash latch 175 4,123 1 1 0/0/0/0 simulator hash latch 174 2,721 1 1 0/0/0/0 simulator hash latch 214 2,669 1 1 0/0/0/0 simulator hash latch 182 2,381 1 1 0/0/0/0 simulator lru latch 13 8 1 1 0/0/0/0 simulator lru latch 67 8 1 1 0/0/0/0 transaction allocation 6 33,950 1 1 0/0/0/0 undo global data 21 9,012 2 1 1/0/0/0 ------------------------------------------------------------- Segments by Logical Reads DB/Inst: HDD/hdd Snaps: 111-112 -> Total Logical Reads: 22,299,452 -> Captured Segments account for 98.0% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TESTSTORE TEST PK_INVENTORY INDEX 4,632,992 20.78 TESTSTORE TEST PRODUCT_NAME INDEX 2,769,264 12.42 TESTSTORE TEST PK_ITEM INDEX 2,212,592 9.92 TESTSTORE TEST PRODUCT TABLE 1,716,096 7.70 TESTSTORE TEST PK_PRODUCT INDEX 1,659,776 7.44 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: HDD/hdd Snaps: 111-112 -> Total Physical Reads: 2,274,477 -> Captured Segments account for 103.3% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TESTSTORE TEST ITEM TABLE 515,337 22.66 TESTSTORE TEST PK_ITEM INDEX 487,307 21.43 TESTSTORE TEST PK_INVENTORY INDEX 487,190 21.42 TESTSTORE TEST INVENTORY TABLE 458,066 20.14 TESTSTORE TEST PRODUCT TABLE 327,763 14.41 ------------------------------------------------------------- Segments by Direct Physical Reads DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Segments by Physical Writes DB/Inst: HDD/hdd Snaps: 111-112 -> Total Physical Writes: 73,316 -> Captured Segments account for 80.5% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- TESTSTORE TEST INVENTORY TABLE 50,228 68.51 TESTSTORE TEST LINEITEM TABLE 1,641 2.24 SYS SYSAUX WRH$_ACTIVE_SESSION_ 3245756_70 TABLE 932 1.27 SYS SYSAUX WRH$_LATCH_CHILDREN 3245756_70 TABLE 217 .30 SYS SYSAUX WRH$_ACTIVE_SESSION_ 3245756_70 INDEX 126 .17 ------------------------------------------------------------- Segments by Direct Physical Writes DB/Inst: HDD/hdd Snaps: 111-112 -> Total Direct Physical Writes: 924 -> Captured Segments account for 99.4% of Total Tablespace Subobject Obj. Direct Owner Name Object Name Name Type Writes %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_ACTIVE_SESSION_ 3245756_70 TABLE 918 99.35 ------------------------------------------------------------- Segments by Table Scans DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Segments by DB Blocks Changes DB/Inst: HDD/hdd Snaps: 111-112 -> % of Capture shows % of DB Block Changes for each top segment compared -> with total DB Block Changes for all segments captured by the Snapshot Tablespace Subobject Obj. DB Block % of Owner Name Object Name Name Type Changes Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- TESTSTORE TEST LINEITEM TABLE 8,064 27.98 TESTSTORE TEST INVENTORY TABLE 6,512 22.60 SYS SYSAUX WRH$_LATCH_CHILDREN_ 3245756_70 INDEX 1,408 4.89 SYS SYSAUX WRH$_ACTIVE_SESSION_ 3245756_70 INDEX 1,168 4.05 SYS SYSAUX WRH$_LATCH_CHILDREN 3245756_70 TABLE 1,040 3.61 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: HDD/hdd Snaps: 111-112 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- TESTSTORE TEST INVENTORY TABLE 1 100.00 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: HDD/hdd Snaps: 111-112 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSTEM AUD$ TABLE 668 93.30 TESTSTORE TEST ORDERSTATUS SYS_P478 TABLE 6 .84 TESTSTORE TEST LINEITEM TABLE 4 .56 TESTSTORE TEST PK_ORDERSTATUS SYS_P847 INDEX 3 .42 TESTSTORE TEST PK_ORDERSTATUS SYS_P863 INDEX 3 .42 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: HDD/hdd Snaps: 111-112 -> "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 17 0.0 0 N/A 2 1 dc_database_links 2 0.0 0 N/A 0 1 dc_global_oids 95 9.5 0 N/A 0 115 dc_histogram_data 1,174 12.5 0 N/A 0 500 dc_histogram_defs 4,522 28.2 0 N/A 0 3,179 dc_object_grants 40 5.0 0 N/A 0 51 dc_objects 4,036 10.4 0 N/A 0 3,076 dc_profiles 3 0.0 0 N/A 0 1 dc_rollback_segments 1,861 0.0 0 N/A 0 324 dc_segments 787 30.0 0 N/A 18 1,855 dc_sequences 5 0.0 0 N/A 5 4 dc_tablespace_quotas 12 0.0 0 N/A 0 2 dc_tablespaces 2,589 0.0 0 N/A 0 7 dc_users 3,076 0.1 0 N/A 0 107 global database name 315 0.0 0 N/A 0 1 outstanding_alerts 1 100.0 0 N/A 1 8 ------------------------------------------------------------- Library Cache Activity DB/Inst: HDD/hdd Snaps: 111-112 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 61 6.6 93 7.5 0 0 CLUSTER 72 0.0 41 0.0 0 0 INDEX 17 64.7 17 70.6 1 0 SQL AREA 8,020 4.6 3,031,052 0.0 73 0 TABLE/PROCEDURE 2,689 5.8 112,811 0.5 84 0 TRIGGER 5 0.0 11 0.0 0 0 ------------------------------------------------------------- Memory Dynamic Components DB/Inst: HDD/hdd Snaps: 111-112 -> Min/Max sizes since instance startup -> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred -> ordered by Component Begin Snap Current Min Max Oper Last Op Component Size (Mb) Size (Mb) Size (Mb) Size (Mb) Count Typ/Mod --------------- ----------- ----------- ----------- ----------- ------ ------- ASM Buffer Cach .00 .00 .00 .00 0 STA/ DEFAULT 16K buf .00 .00 .00 .00 0 STA/ DEFAULT 2K buff .00 .00 .00 .00 0 STA/ DEFAULT 32K buf .00 .00 .00 .00 0 STA/ DEFAULT 4K buff .00 .00 .00 .00 0 STA/ DEFAULT 8K buff .00 .00 .00 .00 0 STA/ DEFAULT buffer 1,856.00 1,856.00 1,856.00 1,920.00 4 SHR/IMM KEEP buffer cac .00 .00 .00 .00 0 STA/ PGA Target 1,792.00 1,792.00 1,792.00 1,792.00 0 STA/ RECYCLE buffer .00 .00 .00 .00 0 STA/ SGA Target 3,328.00 3,328.00 3,328.00 3,328.00 0 STA/ Shared IO Pool .00 .00 .00 .00 0 STA/ java pool 64.00 64.00 64.00 64.00 0 STA/ large pool 64.00 64.00 64.00 64.00 0 STA/ shared pool 1,280.00 1,280.00 1,216.00 1,280.00 4 GRO/IMM streams pool .00 .00 .00 .00 0 STA/ ------------------------------------------------------------- Memory Resize Operations Summary DB/Inst: HDD/hdd Snaps: 111-112 -> Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured -> ordered by Component Min Max Avg Re- Component Size (Mb) Size (Mb) Size (Mb) Sizes Grows Shrink --------------- ----------- ----------- ----------- ------ ------ ------ DEFAULT buffer 1,856.00 1,920.00 1,888.00 4 2 2 shared pool 1,216.00 1,280.00 1,248.00 4 2 2 ------------------------------------------------------------- Memory Resize Ops DB/Inst: HDD/hdd Snaps: 111-112 -> Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size -> Status: COMplete/CANcelled/INActive/PENding/ERRor -> ordered by start_time desc,component Ela Oper Init Target Final Start (s) Component Typ/Mod Size (M Delta Delta (M) Sta -------------- ----- ----------- ------- ------- ------ ------ ------ --- 03/10 07:11:53 0 bufcache SHR/IMM 1,920 -64 N/A 1,856 COM 03/10 07:11:53 0 bufcache GRO/DEF 1,856 64 N/A 1,920 COM 03/10 07:11:53 0 shared SHR/DEF 1,280 -64 N/A 1,216 COM 03/10 07:11:53 0 shared GRO/IMM 1,216 64 N/A 1,280 COM 03/10 07:08:40 1 bufcache SHR/IMM 1,920 -64 N/A 1,856 COM 03/10 07:08:40 1 shared GRO/IMM 1,216 64 N/A 1,280 COM 03/10 07:07:47 0 bufcache GRO/DEF 1,856 64 N/A 1,920 COM 03/10 07:07:47 0 shared SHR/DEF 1,280 -64 N/A 1,216 COM ------------------------------------------------------------- Process Memory Summary DB/Inst: HDD/hdd Snaps: 111-112 -> 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 1,851.0 N/A 2.2 2.2 25 25 834 834 Freeable 129.9 .0 .2 .1 2 N/A 589 589 SQL 15.7 9.9 .0 .0 0 2 814 813 PL/SQL 1.7 .2 .0 .0 0 0 834 834 E Other 204.3 N/A 6.8 8.4 25 25 30 30 Freeable 14.7 .0 1.0 1.3 4 N/A 14 14 SQL .8 .5 .1 .1 0 3 12 10 PL/SQL .1 .0 .0 .0 0 0 30 30 ------------------------------------------------------------- SGA Memory Summary DB/Inst: HDD/hdd Snaps: 111-112 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 1,946,157,056 Fixed Size 2,159,472 Redo Buffers 40,968,192 Variable Size 3,355,446,416 ------------------- sum 5,344,731,136 ------------------------------------------------------------- SGA breakdown difference DB/Inst: HDD/hdd Snaps: 111-112 -> 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 64.0 64.0 0.00 large PX msg pool 1.0 1.0 0.00 large free memory 62.6 62.6 0.00 shared ASH buffers 40.5 40.5 0.00 shared KGH: NO ACCESS N/A 56.8 N/A shared KTI-UNDO 16.3 16.3 0.00 shared PL/SQL DIANA 18.1 17.6 -3.25 shared dbktb: trace buffer 15.6 15.6 0.00 shared event statistics per sess 24.0 24.0 0.00 shared free memory 902.3 922.7 2.27 shared parameter table block 13.0 N/A -100.00 shared private strands 31.4 31.4 0.00 shared sessions 23.3 23.3 0.00 buffer_cache 1,856.0 1,856.0 0.00 fixed_sga 2.1 2.1 0.00 log_buffer 39.1 39.1 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Streams Capture DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Persistent Queues DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Persistent Subscribers DB/Inst: HDD/hdd Snaps: 111-112 No data exists for this section of the report. ------------------------------------------------------------- Resource Limit Stats DB/Inst: HDD/hdd Snap: 112 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: HDD/hdd Snaps: 111-112 -> if IP/Public/Source at End snap is different a '*' is displayed End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- audit_file_dest /u01/app/oracle/admin/hdd/adump audit_trail DB compatible 11.1.0.0.0 control_files +DG_HDD/hdd/control01.ctl, +DG_HD db_block_size 8192 db_domain db_name hdd diagnostic_dest /u01/app/oracle filesystemio_options SETALL log_archive_dest +DG_HDD/HDD/arch memory_target 5368709120 nls_language JAPANESE nls_territory JAPAN open_cursors 300 processes 2000 remote_login_passwordfile EXCLUSIVE sessions 2205 undo_tablespace UNDOTBS1 ------------------------------------------------------------- End of Report