WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ PRDUN 2299686464 PRDUN 1 10.2.0.5.0 NO sr-app-2 Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 32051 24-May-11 00:00:19 106 6.3 End Snap: 32227 27-May-11 15:00:16 1,052 29.6 Elapsed: 5,219.95 (mins) DB Time: 2,906.26 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 2,176M 2,272M Std Block Size: 8K Shared Pool Size: 1,312M 1,120M Log Buffer: 14,328K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 201,044.61 25,285.10 Logical reads: 31,842.47 4,004.78 Block changes: 1,028.07 129.30 Physical reads: 594.05 74.71 Physical writes: 60.26 7.58 User calls: 1,056.92 132.93 Parses: 233.69 29.39 Hard parses: 10.08 1.27 Sorts: 224.42 28.23 Logons: 0.27 0.03 Executes: 1,105.96 139.09 Transactions: 7.95 % Blocks changed per Read: 3.23 Recursive Call %: 76.34 Rollback per transaction %: 15.78 Rows per Sort: 25.31 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 99.96 Redo NoWait %: 100.00 Buffer Hit %: 98.53 In-memory Sort %: 100.00 Library Hit %: 97.54 Soft Parse %: 95.69 Execute to Parse %: 78.87 Latch Hit %: 99.92 Parse CPU to Parse Elapsd %: 54.52 % Non-Parse CPU: 94.34 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 77.95 70.57 % SQL with executions>1: 89.04 84.84 % Memory for SQL w/exec>1: 84.71 81.64 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- CPU time 120,538 69.1 db file sequential read 38,327,591 21,072 1 12.1 User I/O db file scattered read 3,364,177 7,381 2 4.2 User I/O enq: TX - row lock contention 2,371 6,640 2801 3.8 Applicatio RMAN backup & recovery I/O 201,829 6,622 33 3.8 System I/O ------------------------------------------------------------- Time Model Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total time in database user-calls (DB Time): 174375.4s -> 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 143,838.3 82.5 DB CPU 120,537.6 69.1 parse time elapsed 15,483.2 8.9 hard parse elapsed time 14,190.6 8.1 PL/SQL execution elapsed time 5,629.5 3.2 inbound PL/SQL rpc elapsed time 4,184.3 2.4 RMAN cpu time (backup/restore) 2,564.6 1.5 hard parse (sharing criteria) elapsed time 1,239.6 .7 hard parse (bind mismatch) elapsed time 998.2 .6 PL/SQL compilation elapsed time 817.3 .5 connection management call elapsed time 507.6 .3 sequence load elapsed time 320.7 .2 failed parse elapsed time 143.4 .1 repeated bind elapsed time 41.9 .0 Java execution elapsed time 2.2 .0 DB time 174,375.4 N/A background elapsed time 20,761.7 N/A background cpu time 5,849.9 N/A ------------------------------------------------------------- Wait Class DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Total %Time Total Wait wait Call Wait Class Waits -outs Time (s) (ms) Time -------------------- ---------------- ----- ---------------- -------- ------- CPU time N/A N/A 120,538 N/A 69.1 User I/O 48,107,543 N/A 31,042 1 17.8 System I/O 6,620,061 N/A 10,682 2 6.1 Network 422,259,669 N/A 7,817 0 4.5 Application 444,399 1 6,769 15 3.9 Commit 1,807,490 0 1,810 1 1.0 Concurrency 191,780 5 226 1 0.1 Other 125,552 0 59 0 0.0 Configuration 436 21 14 32 0.0 Administrative 37 N/A 1 14 0.0 ------------------------------------------------------------- Wait Events DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) -> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0 Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ----- ----------- ------- --------- db file sequential read 38,327,591 N/A 21,072 1 15.4 db file scattered read 3,364,177 N/A 7,381 2 1.4 enq: TX - row lock contentio 2,371 94 6,640 2801 0.0 RMAN backup & recovery I/O 201,829 N/A 6,622 33 0.1 SQL*Net more data to client 88,824,255 N/A 2,864 0 35.7 log file parallel write 2,366,631 N/A 2,604 1 1.0 ARCH wait on SENDREQ 63,654 N/A 2,459 39 0.0 SQL*Net more data from clien 5,688,443 N/A 2,234 0 2.3 log file sync 1,807,490 0 1,810 1 0.7 read by other session 3,713,483 N/A 1,258 0 1.5 direct path read temp 806,809 N/A 743 1 0.3 control file sequential read 3,586,223 N/A 713 0 1.4 log file sequential read 64,902 N/A 570 9 0.0 direct path read 1,207,114 N/A 334 0 0.5 direct path write temp 445,945 N/A 236 1 0.2 SQL*Net message to client 327,664,475 N/A 236 0 131.6 ... ... Operating System Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 Statistic Total -------------------------------- -------------------- NUM_LCPUS 0 NUM_VCPUS 0 AVG_BUSY_TIME 3,126,572 AVG_IDLE_TIME 28,229,190 AVG_IOWAIT_TIME 457,925 AVG_SYS_TIME 912,262 AVG_USER_TIME 2,205,285 BUSY_TIME 25,086,287 IDLE_TIME 225,907,099 IOWAIT_TIME 3,730,612 SYS_TIME 7,371,002 USER_TIME 17,715,285 LOAD 1 OS_CPU_WAIT_TIME 27,292,700 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 409,877,573,632 VM_OUT_BYTES 386,908,962,816 PHYSICAL_MEMORY_BYTES 16,508,780,544 NUM_CPUS 8 NUM_CPU_CORES 4 ------------------------------------------------------------- Service Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$USERS 96,160.6 62,305.7 1.15E+08 4.80E+09 HHR 39,444.0 31,090.0 5.23E+07 1.02E+09 SAP 19,315.2 13,849.7 2,105,456 3.07E+09 SRS 4,151.0 3,460.7 1,679,212 1.90E+08 SPE5 3,340.9 2,458.6 824,924 7.49E+07 GDS 2,865.6 1,806.2 2,049,682 2.20E+08 GDB 2,508.3 1,316.2 53,519 2.55E+08 UMS 1,968.5 1,684.3 481,106 6.11E+07 prdun.cg13.fr 1,240.7 498.0 8,166,577 2.34E+07 GDM 1,131.0 822.9 623,916 3.19E+07 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 --------- --------- --------- --------- --------- --------- --------- --------- SYS$USERS 27888077 18748 73153 61 20 0 2.8E+08 3674 HHR 14303148 8988 77445 47 0 0 1.2E+08 195 SAP 1766418 625 12893 1 0 0 3956304 314 SRS 713565 459 3175 1 0 0 2068614 156 ... ... ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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): 174,375 -> Captured SQL account for 56.4% of Total Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- 14,288 14,094 53,468 0.3 8.2 afg5uz83ufjnn Module: RTSDGN@sr-app-9 (TNS V1-V3) select A.NUDOSS ,TO_CHAR(A.DTEF00,'YYYY-MM-DD') ,TO_CHAR(A.DTEN00,'YYYY-MM-DD' ) from ZY3B A where (((A.IDPS00=:b1 and (TO_CHAR(A.DTEF00,'YYYY-MM-DD')<:b2 or TO_CHAR(A.DTEF00,'YYYY-MM-DD')=:b2)) and (TO_CHAR(A.DTEN00,'YYYY-MM-DD')>:b3 or TO_CHAR(A.DTEN00,'YYYY-MM-DD')=:b3)) and A.TYASSI='1') order by A.DTEF00,A.NUDO 4,503 1,963 2 2251.6 2.6 b6usrg82hwsa3 Module: DBMS_SCHEDULER call dbms_stats.gather_database_stats_job_proc ( ) 4,093 3,988 1,644 2.5 2.3 az33m61ym46y4 ... ... SQL ordered by Gets DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 9,972,970,318 -> Captured SQL account for 54.0% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 8,589,903,432 16 5.3687E+08 86.1 12.85 21.02 50jjqhxxj9uxw Module: ASE.EXE BEGIN PKG_GEN_BTCH.P_Trt_Btch(:P_ID_PLN); END; 741,586,587 1,644 451,086.7 7.4 3988.07 4093.47 az33m61ym46y4 Module: JDBC Thin Client SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM a ll_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ES CAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_ 512,137,103 93,512 5,476.7 5.1 705.48 1149.61 81xv812rrxj0m Module: exp@sr-synchrony.cg13.fr (TNS V1-V3) SELECT SCHEMAOID FROM SYS.EXU9XMLST WHERE TOBJID = :1 291,098,956 142 2,049,992.6 2.9 1121.44 1287.61 ddwu7kb2s371y Module: frmweb@sli-as-4.cg13.fr (TNS V1-V3) SELECT VPA.VPA_DOS_NUM_CLASS,VPA.VPA_PER_NOM_USAGE,VPA.VPA_PER_NOM_PATRO,VPA.VPA _PER_PRENOM,VPA.VPA_AID_TAI_COD,VPA.VPA_TYPE_PRESTATION,VPA.VPA_NOM_TIERS,VPA.VP A_TIE_AD6_CP,VPA.VPA_PER_AD6_VILLE,VPA.VPA_ACT_COD,VPA.VPA_AID_DAT_DEB_EFFET,VPA .VPA_DEC_DAT_NOTIF_BNF,VPA.VPA_DEC_TOP_TRANS_URG,VPA.VPA_TUTELLE,VPA.VPA_AID_DOS ... ... Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 114,530,087 164 698,354.2 1.1 3031.33 3013.65 9rnm4nk511bfr Module: SQL*Plus SELECT DOS_NUM_INT, DOS_NUM_CLASS, DOS_NUM_MDPH, PER_NUM_INT, PER_CIVILITE, PER_ NOM_USAGE, PER_NOM_PATRO, PER_PRENOM, PER_DAT_NAISS, PER_AD6_CP, PER_AD6_VILLE, PER_VCC_CMN_NUM_INSEE, TUT_NUM_INT FROM V_SGL_CORRESPONDANCE_DAPHNEE WHERE (:B5 IS NOT NULL AND ((PER_CIVILITE NOT IN ('Mme') AND PER_NOM_USAGE = :B5 ) OR (PER_ 113,357,954 56,678,978 2.0 1.1 1074.07 1078.87 d7w82w90d3rcu Module: SQL*Plus SELECT POI_POURCENTAGE FROM POINTS WHERE POI_CODE = :B1 112,829,643 4 2.8207E+07 1.1 945.22 1015.27 gkkrj59f4rmyn Module: SQL Developer ( SELECT DISTINCT UGST1.LB_UGST_UGST AS MDS_SUIVI, DECODE (BEN.IN_SEXE_BEN, 1, 'F', 'M') AS SEXE , PER.NM_PER AS NOM, PER.P R_PER AS PRENOM, BEN.DT_NAIS_BEN ------------------------------------------------------------- SQL ordered by Reads DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total Disk Reads: 186,054,868 -> Captured SQL account for 31.6% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 8,589,933,952 16 5.36871E+08 4.6E+03 12.85 21.02 50jjqhxxj9 Module: ASE.EXE BEGIN PKG_GEN_BTCH.P_Trt_Btch(:P_ID_PLN); END; 19,402,268 2 9,701,134.0 10.4 1963.46 4503.29 b6usrg82hwsa3 Module: DBMS_SCHEDULER call dbms_stats.gather_database_stats_job_proc ( ) 3,657,929 5 731,585.8 2.0 175.27 1502.33 btx2parzcp8gq Module: SQL*Plus SELECT P.NUMDEMRSA, P.NOM, P.PRENOM, P.DTNAI, P.ROLEPERS, P.CODE_PER FROM PERSON NE P WHERE P.ROLEPERS IN ('DEM', 'CJT') AND P.NATPREST = 'RSA' AND EXISTS (SELEC T 1 FROM HISTO_PERS H WHERE H.DATE_TRANS IS NULL AND LTRIM(H.NUMDEMRSA, '0') = P .NUMDEMRSA) AND NOT EXISTS (SELECT 1 FROM HISTO_PERS H WHERE H.DATE_TRANS IS NUL ... ... ------------------------------------------------------------- SQL ordered by Executions DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total Executions: 346,383,271 -> Captured SQL account for 68.1% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 56,678,978 56,678,977 1.0 0.00 0.00 d7w82w90d3rcu Module: SQL*Plus SELECT POI_POURCENTAGE FROM POINTS WHERE POI_CODE = :B1 26,317,855 26,308,056 1.0 0.00 0.00 d6d7984wk5j6m Module: frmweb@sr-midp-4.cg13.fr (TNS V1-V3) SELECT MODIFICATION FROM HABILITATION WHERE CODE_NCT = :B1 AND CODE_PRF IN (SELE CT CODE_PRF FROM AGENT WHERE LOGORA = USER) 16,008,272 14,116,573 0.9 0.00 0.00 319y4ru5u0yvv Module: APEX:APPLICATION 134 SELECT P.NOMREF,P.VALID_PI FROM PERSONNE P WHERE P.MATRICULE = :B2 AND P.FLG_COU R = 'O' AND P.ROLEPERS = :B1 ... ... CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 4,142,070 4,141,962 1.0 0.00 0.00 abjnurg3m6hzk Module: CORIOLIS@sr-app-3 (TNS V1-V3) select /*+ INDEX(WAPI,CLE_WAPI) + +*/ * into :b0:b1,:b2:b3,:b4:b5,:b6:b7,:b8:b 9 from WAPI where WAPINOM=:b0 ------------------------------------------------------------- ... SQL ordered by Parse Calls DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total Parse Calls: 73,190,817 -> Captured SQL account for 57.1% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 3,881,781 4,142,070 5.30 abjnurg3m6hzk Module: CORIOLIS@sr-app-3 (TNS V1-V3) select /*+ INDEX(WAPI,CLE_WAPI) + +*/ * into :b0:b1,:b2:b3,:b4:b5,:b6:b7,:b8:b 9 from WAPI where WAPINOM=:b0 3,718,965 5,134,734 5.08 fu8fkgfsp76hp Module: CORIOLIS@sr-app-3 (TNS V1-V3) select /*+ INDEX(WDAT,CLE_WDAT) + +*/ * into :b0:b1,:b2:b3,:b4:b5,:b6:b7 from WDAT where ((WDATOBJET=:b0 and WDATNOM=:b2) and WDATLIG=:b4) 2,180,914 2,180,914 2.98 4m7m0t6fjcs5x update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= :7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 ... ... ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 2,435,926 663,170 0.21 7ng34ruy5awxq select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctf ree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.cl ufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instance s,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl( 1,477,431 813,062 0.13 04xtrk7uyhknh select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f rom obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null an d linkname is null and subname is null 1,126,468 40,057 0.10 axm5005kdufpd select ROLE GRPNAME ,FLAG GRPFLG from FRM50_ENABLED_ROLES order by ROLE desc ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 288 53,380 5wc2915k44m38 select user#,type# from user$ where name=:1 288 53,380 5wc2915k44m38 select user#,type# from user$ where name=:1 186 89,079 0xwby571mq3n2 select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, lt ime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschcla ss),spare1 from user$ where user#=:1 ... SQL ordered by Version Count DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- = :1 33 306 05sghzkq6r6yv select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans,maxtrans,h ashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1),nvl(flags,0),nvl(spare 1,0)from clu$ where obj#=:1 33 391 a4mgryuk8162s Module: CORIOLIS@sr-app-3 (TNS V1-V3) select /*+ INDEX(PENT,CLE_PENT) + +*/ * from PENT where (COLLCOD>=:b0 and PEN TNUM>=:b1) 32 4,310 1yxg81y3saskx Module: frmweb@sli-as-4.cg13.fr (TNS V1-V3) SELECT ICR_MESSAGE , ICR_BLOCAGE FROM ICR_PARAM WHERE ICR_TYPE = 'VERSION' A ND ICR_VERSION = :1 ... ------------------------------------------------------------- Instance Activity Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- CPU used by this session 9,382,009 30.0 3.8 CPU used when call started 8,968,037 28.6 3.6 CR blocks created 477,005 1.5 0.2 Cached Commit SCN referenced 40,889,378 130.6 16.4 Commit SCN cached 1,724 0.0 0.0 DB time 62,157,279 198.5 25.0 DBWR checkpoint buffers written 3,116,586 10.0 1.3 DBWR checkpoints 10,069 0.0 0.0 DBWR object drop buffers written 13,700 0.0 0.0 DBWR tablespace checkpoint buffe 8,250 0.0 0.0 DBWR thread checkpoint buffers w 32,753 0.1 0.0 DBWR transaction table writes 40,765 0.1 0.0 DBWR undo block writes 3,576,478 11.4 1.4 DFO trees parallelized 10 0.0 0.0 IMU CR rollbacks 0 0.0 0.0 IMU Flushes 0 0.0 0.0 IMU Redo allocation size 0 0.0 0.0 IMU commits 0 0.0 0.0 IMU contention 0 0.0 0.0 IMU ktichg flush 0 0.0 0.0 IMU pool not allocated 2,799,597 8.9 1.1 IMU recursive-transaction flush 0 0.0 0.0 IMU undo allocation size 0 0.0 0.0 IMU- failed to get a private str 2,799,597 8.9 1.1 Misses for writing mapping 3 0.0 0.0 PX local messages recv'd 453 0.0 0.0 PX local messages sent 466 0.0 0.0 Parallel operations downgraded 2 10 0.0 0.0 Parallel operations downgraded 5 0 0.0 0.0 Parallel operations downgraded t 49 0.0 0.0 RowCR - row contention 5,465 0.0 0.0 RowCR attempts 2,072,621 6.6 0.8 RowCR hits 2,095,765 6.7 0.8 SMON posted for undo segment rec 3 0.0 0.0 SMON posted for undo segment shr 554 0.0 0.0 SQL*Net roundtrips to/from clien 394,907,039 1,260.9 158.6 SQL*Net roundtrips to/from dblin 4,154 0.0 0.0 active txn count during cleanout 3,094,410 9.9 1.2 application wait time 673,616 2.2 0.3 background checkpoints completed 428 0.0 0.0 background checkpoints started 427 0.0 0.0 background timeouts 1,271,983 4.1 0.5 branch node splits 1,327 0.0 0.0 buffer is not pinned count 5,584,333,819 17,830.1 2,242.5 buffer is pinned count 9,533,325,112 30,438.7 3,828.2 bytes received via SQL*Net from 66,656,057,277 212,824.6 26,766.7 bytes received via SQL*Net from 13,075,177 41.8 5.3 bytes sent via SQL*Net to client 9.0657408527E+14 2.894580E+09 3.64047E+08 bytes sent via SQL*Net to dblink 286,672,073,224 915,308.9 115,117.1 calls to get snapshot scn: kcmgs 380,939,009 1,216.3 153.0 calls to kcmgas 12,698,976 40.6 5.1 calls to kcmgcs 3,832,732 12.2 1.5 change write time 98,838 0.3 0.0 cleanout - number of ktugct call 3,621,847 11.6 1.5 cleanouts and rollbacks - consis 356,537 1.1 0.1 cleanouts only - consistent read 227,818 0.7 0.1 cluster key scan block gets 152,201,972 486.0 61.1 cluster key scans 61,253,530 195.6 24.6 commit batch performed 363 0.0 0.0 commit batch requested 363 0.0 0.0 Instance Activity Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 Instance Activity Stats - Thread ActivityDB/Inst: PRDUN/PRDUN Snaps: 32051-32 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 424 4.87 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ FCS_DAT 9,248,093 30 1.6 2.2 161,471 1 164,351 0.3 HRZX 5,711,970 18 4.4 16.4 637,799 2 67,438 1.3 SRS_DAT 5,841,614 19 1.5 5.5 200,391 1 143 1.4 HRZXI 4,611,577 15 1.9 3.4 411,529 1 3,482,442 0.3 HRT_DAT 3,795,805 12 4.0 7.2 494,526 2 457 0.4 SYSTEM 2,445,422 8 0.8 1.5 59,269 0 30 0.7 TEMP 1,220,244 4 54.5 7.4 983,452 3 0 0.0 UNDO 175,423 1 35.3 54.9 1,938,719 6 428 0.6 S Tablespace IO Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ HAM_DAT 854 0 2.4 1.4 412 0 0 0.0 SFA_DAT 758 0 21.4 19.9 412 0 0 0.0 CRA_DAT 558 0 4.1 3.0 412 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ACT_DAT /data/prdun/act_dat.dbf 1,780 0 3.3 8.7 609 0 0 0.0 ADB_DAT /data/prdun/adb_dat.dbf 8,244 0 1.3 1.5 9,888 0 11 0.0 BAL_DAT /data/prdun/bal_dat.dbf 8,646 0 37.8 34.2 728 0 0 0.0 CCNT32 /data/prdun/ccnt32.dbf 2,442 0 12.9 10.9 412 0 0 0.0 CGP_DAT /data/prdun/cgp_dat.dbf 8,391 0 12.5 13.1 874 0 0 0.0 COMMUN_DAT /data/prdun/commun_dat.dbf ... Buffer Pool Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 278,751 99 9,894,551,702 147,947,770 7,426,681 0 0 3,725,186 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 44 13 461 2356 2831130 2831130 N/A N/A E 51 14 2716 27859 2831130 2831130 N/A N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 -> 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 224 .1 27,706 3.6 644,178,838 D 448 .2 55,412 2.8 493,250,534 D 672 .3 83,118 2.2 391,422,098 D 896 .4 110,824 1.8 320,652,878 D 1,120 .5 138,530 1.5 272,380,101 D 1,344 .6 166,236 1.3 238,390,587 ... ------------------------------------------------------------- PGA Aggr Summary DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 --------------- ------------------ -------------------------- 89.0 1,012,878 124,616 ------------------------------------------------------------- Warning: pga_aggregate_target was set too low for current workload, as this value was exceeded during this interval. Use the PGA Advisory view to help identify a different value for pga_aggregate_target. PGA Aggr Target Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval) -> Auto PGA Target - actual workarea memory target -> W/A PGA Used - amount of memory used for all Workareas (manual + auto) -> %PGA W/A Mem - percentage of PGA memory allocated to workareas -> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt -> %Man W/A Mem - percentage of workarea memory under manual control %PGA %Auto %Man PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K) - ---------- ---------- ---------- ---------- ------ ------ ------ ---------- B 1,024 711 329.4 12.6 3.8 100.0 .0 104,850 E 1,024 129 1,551.2 95.4 6.2 100.0 .0 104,850 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 19,842,635 19,842,635 0 0 64K 128K 129,218 129,218 0 0 128K 256K 49,170 49,170 0 0 256K 512K 38,863 38,855 8 0 512K 1024K 451,248 451,207 41 0 1M 2M 120,181 118,973 1,208 0 ... PGA Memory Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0 Estd Extra Estd PGA Estd PGA PGA Target Size W/A MB W/A MB Read/ Cache Overalloc Est (MB) Factr Processed Written to Disk Hit % Count ---------- ------- ---------------- ---------------- -------- ---------- 128 0.1 1,026,305.4 214,756.3 83.0 10,382 256 0.3 1,026,305.4 192,398.0 84.0 8,558 512 0.5 1,026,305.4 66,907.3 94.0 271 768 0.8 1,026,305.4 30,832.9 97.0 29 1,024 1.0 1,026,305.4 17,742.2 98.0 0 1,229 1.2 1,026,305.4 17,043.0 98.0 0 ... ------------------------------------------------------------- Shared Pool Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 -> 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) -------- ----- -------- ------------ -------- ------ ------- ------ ------------ 672 .6 129 16,893 1.8E+06 1.0 28,573 1.5 308,67 784 .7 233 21,689 1.8E+06 1.0 25,765 1.3 309,43 896 .8 344 25,354 1.8E+06 1.0 23,171 1.2 310,13 1,008 .9 455 30,074 1.8E+06 1.0 20,956 1.1 310,73 1,120 1.0 566 35,219 1.8E+06 1.0 19,170 1.0 311,22 1,232 1.1 677 40,133 1.8E+06 1.0 17,780 .9 311,61 ... ------------------------------------------------------------- SGA Target Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 2,304 0.5 414,318 509,225,055 3,456 0.8 245,413 222,004,847 4,608 1.0 212,700 177,023,241 5,760 1.3 200,980 161,073,447 6,912 1.5 192,026 146,946,992 8,064 1.8 189,728 146,946,992 9,216 2.0 189,728 146,946,992 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 Size for Size Est Spill Est Spill Est Unspill Est Unspill Est (MB) Factor Count Time (s) Count Time (s) ---------- --------- ----------- ----------- ----------- ----------- 16 0.3 0 0 0 0 32 0.7 0 0 0 0 48 1.0 0 0 0 0 64 1.3 0 0 0 0 80 1.7 0 0 0 0 96 2.0 0 0 0 0 112 2.3 0 0 0 0 ... ------------------------------------------------------------- Java Pool Advisory DB/Inst: PRDUN/PRDUN Snap: 32227 Est LC Est LC Est LC Est LC Java JP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 16 .3 7 116 2 1.0 19,170 1.0 116 32 .5 7 116 2 1.0 19,170 1.0 116 48 .8 7 116 2 1.0 19,170 1.0 116 64 1.0 7 116 2 1.0 19,170 1.0 116 80 1.3 7 116 2 1.0 19,170 1.0 116 96 1.5 7 116 2 1.0 19,170 1.0 116 112 1.8 7 116 2 1.0 19,170 1.0 116 128 2.0 7 116 2 1.0 19,170 1.0 116 ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> ordered by wait time desc, waits desc Class Waits Total Wait Time (s) Avg Time (ms) ------------------ ----------- ------------------- -------------- data block 3,708,755 1,293 0 segment header 556 0 1 undo block 186 0 1 1st level bmb 185 0 0 2nd level bmb 81 0 1 undo header 242 0 0 ------------------------------------------------------------- Enqueue Activity DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> only enqueues with waits are shown -> Enqueue stats gathered prior to 10g should not be compared with 10g data -> ordered by Wait Time desc, Waits desc Enqueue Type (Request Reason) ------------------------------------------------------------------------------ Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms) ------------ ------------ ----------- ----------- ------------ -------------- TX-Transaction (row lock contention) 763 222 530 145 6,806 46,938.33 CF-Controlfile Transaction 668,818 668,756 62 283 5 17.65 RO-Multiple Object Reuse (fast object reuse) 21,609 21,609 0 2,308 5 2.06 TQ-Queue table enqueue (DDL contention) 500 500 0 234 2 9.73 JS-Job Scheduler (queue lock) 12,691,461 12,691,461 0 92 2 17.11 ... ------------------------------------------------------------- Undo Segment Summary DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Min/Max TR (mins) - Min and Max Tuned Retention (minutes) -> STO - Snapshot Too Old count, OOS - Out of Space count -> Undo segment block stats: -> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed -> eS - expired Stolen, eR - expired Released, eU - expired reUsed Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/ TS# Blocks (K) Transactions Len (s) Concurcy TR (mins) OOS eS/eR/eU ---- ---------- --------------- -------- -------- --------- ----- -------------- 1 3,529.7 5,361,689 28,676 41 180/493 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Most recent 35 Undostat rows, ordered by Time desc Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/ End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU ------------ ----------- ------------ ------- ------- ------- ----- ------------ 27-May 14:56 1,508 7,239 2,946 20 180 0/0 0/0/0/0/0/0 27-May 14:46 7,912 6,443 1,927 19 180 0/0 0/0/0/0/0/0 27-May 14:36 110,201 35,185 1,899 16 180 0/0 0/0/0/0/0/0 27-May 14:26 26,268 8,450 1,547 17 180 0/0 0/0/0/0/0/0 27-May 14:16 1,109 4,809 1,720 15 180 0/0 0/0/0/0/0/0 27-May 14:06 2,003 4,771 1,653 20 180 0/0 0/0/0/0/0/0 27-May 13:56 1,932 3,884 1,784 19 180 0/0 0/0/0/0/0/0 ... ------------------------------------------------------------- Latch Activity DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> "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 249,358 0.0 N/A 0 0 N/A AWR Alerted Metric Eleme 4,646,770 0.0 N/A 0 0 N/A Consistent RBA 2,367,189 0.0 0.0 0 0 N/A DMON Network Error List 1 0.0 N/A 0 0 N/A DMON Work Queues Latch 110,020 0.0 N/A 0 0 N/A FAL request queue 15,491 0.0 N/A 0 0 N/A FAL subheap alocation 15,061 0.0 0.0 0 0 N/A FIB s.o chain latch 363,470 0.0 0.0 0 0 N/A FOB s.o list latch 712,829 0.0 0.0 0 0 N/A Fast-Start Failover Stat 20,886 0.0 N/A 0 0 N/A In memory undo latch 14,693,850 0.0 N/A 0 2,799,595 0.0 JOX SGA heap latch 432 0.0 N/A 0 0 N/A ... ... --------------------------------- Latch Sleep Breakdown DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- cache buffers chains 1.840176E+10 17,422,457 62,455 1.74E+07 0 0 0 row cache objects 1,339,774,960 1,550,843 843 1,550,021 0 0 0 virtual circuit buffers 771,814,402 508,341 3,345 505,003 0 0 0 library cache 488,287,397 316,062 68,776 249,524 0 0 0 shared pool 285,504,036 297,761 36,108 271,201 0 0 0 ----------------------------- Latch Miss Sources DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- JS Sh mem access jsksGetShMemLatch 0 152 152 SQL memory manager latch qesmmIQueryRefreshBound 0 299 306 SQL memory manager latch qesmmIDeamonCb 0 7 0 active checkpoint queue kcbbacq: scan active check 0 1 2 active checkpoint queue kcbkcpa: Checkpoint post-p 0 1 0 active service list kswssvid: get id from svc 0 936 20 active service list kswssyis: find service ent 0 196 3 Parent Latch Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total Logical Reads: 9,972,970,318 -> Captured Segments account for 87.6% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SAP SAP_DAT FOY_BEN_FK_I INDEX 2.0068E+09 20.12 SAP SAP_DAT FOYER TABLE 623,081,008 6.25 SYS SYSTEM OPQTYPE$ TABLE 545,918,784 5.47 SYS SYSTEM I_OBJAUTH1 INDEX 329,821,440 3.31 FCS FCS_DAT CADG TABLE 290,725,600 2.92 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Total Physical Reads: 186,054,868 -> Captured Segments account for 50.3% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- HR HRZX ZX8K MT201106 TABLE 30,973,017 16.65 SRS SRS_DAT HISTO_PERS TABLE 10,962,106 5.89 FCS FCS_DAT CNDG TABLE 7,483,222 4.02 SRS SRS_DAT HISTO_DONNADM TABLE 3,819,158 2.05 HR HRZXI X3ZX8K INDEX 3,351,577 1.80 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- HR HRZXI X1ZX5C INDEX 10,676 27.43 HR HRZXI X1ZX8K INDEX 5,849 15.03 HR HRZXI X1ZX8C INDEX 4,459 11.46 HR HRZXI IX1ZXTD12 INDEX 1,501 3.86 HR HRZXI X1ZX5G INDEX 1,346 3.46 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> % of Capture shows % of ITL waits for each top segment compared -> with total ITL waits for all segments captured by the Snapshot Tablespace Subobject Obj. ITL % of Owner Name Object Name Name Type Waits Capture ---------- ---------- -------------------- ---------- ----- ------------ ------- HR HRZXI X2ZX8C INDEX 8 17.02 ** UNAVAIL ** UNAVAIL ** UNAVAILABLE ** AILABLE ** UNDEF 7 14.89 HR HRZXI X2ZXMD INDEX 7 14.89 SYS SYSAUX WRH$_SERVICE_STAT_PK 6464_32152 INDEX 5 10.64 HR HRZXI X2ZX8K INDEX 5 10.64 ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- HR HRZXI X3ZX8K INDEX 11,535 98.78 HR HRZXI X2ZX8K INDEX 92 .79 SYSTEM ADB_DAT USERS_MON TABLE 10 .09 FCS FCS_DAT BUDG TABLE 7 .06 HR HRTE MX10 TABLE 6 .05 ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> "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 5,976 4.6 0 N/A 357 1 dc_constraints 19,786 47.3 0 N/A 18,932 0 dc_database_links 160,871 0.1 0 N/A 0 1 dc_files 7,122 51.7 0 N/A 3 0 dc_global_oids 1,561,835 0.4 0 N/A 4 8 dc_histogram_data 77,106,688 6.1 0 N/A 32,104 16,011 dc_histogram_defs 55,692,465 10.5 0 N/A 28,816 9,181 ------------------------------------------------------------- Library Cache Activity DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 1,196,726 0.6 6,104,022 0.4 15,486 0 CLUSTER 52,808 1.0 87,307 1.0 306 0 INDEX 11,520 62.5 33,341 32.3 692 0 JAVA DATA 337 0.0 0 N/A 0 0 JAVA SOURCE 19 63.2 38 78.9 3 0 SQL AREA 16,219,850 27.0 441,960,160 2.1 1,207,925 419,529 TABLE/PROCEDURE 6,188,498 5.6 45,290,413 5.8 1,119,196 0 TRIGGER 385,372 1.5 869,458 1.8 10,096 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 244.3 N/A 2.7 5.9 23 24 89 89 Freeable 62.0 .0 1.6 2.6 14 N/A 40 40 SQL 21.0 16.8 .3 1.2 9 132 62 26 PL/SQL 2.2 1.3 .0 .0 0 0 79 79 JAVA .0 .0 .0 .0 0 3 3 2 E Other 1,091.8 N/A 2.5 17.9 372 372 438 438 SQL 247.9 174.8 .6 2.7 54 153 413 379 Freeable 193.1 .0 .8 .6 8 N/A 248 248 PL/SQL 17.6 10.1 .0 .0 0 257 428 428 JAVA .0 .0 .0 .0 0 3 6 5 ------------------------------------------------------------- SGA Memory Summary DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 2,281,701,376 2,382,364,672 Fixed Size 2,102,904 Redo Buffers 14,671,872 Variable Size 2,533,362,056 2,432,698,760 ------------------- sum 4,831,838,208 ------------------------------------------------------------- SGA breakdown difference DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> 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 58.5 58.5 0.00 java joxlod exec hp 5.5 5.5 0.00 large free memory 920.9 9.1 -99.01 large session heap 70.9 1,078.7 1.4E+03 shared ASH buffers 15.5 N/A -100.00 shared CCursor 108.5 63.1 -41.79 shared Heap0: KGL 14.6 N/A -100.00 shared KGH: NO ACCESS 95.2 814.7 756.17 shared KGLS heap 16.5 22.2 34.52 shared KQR M PO 19.1 N/A -100.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Streams processes ordered by CPU usage -> CPU and I/O Time in micro seconds Session Type CPU Time User I/O Time Sys I/O Time ------------------------- -------------- -------------- -------------- QMON Coordinator 2,450,000 0 0 QMON Slaves 1,800,000 1,289,996 0 ------------------------------------------------------------- Streams Capture DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 -> Rule Sets ordered by Evaluations Fast SQL CPU Elapsed Ruleset Name Evals Evals Execs Time Time ------------------------- -------- -------- -------- -------- -------- SYS.ALERT_QUE_R 36 0 0 87 171 ------------------------------------------------------------- Resource Limit Stats DB/Inst: PRDUN/PRDUN Snap: 32227 -> only rows with Current or Maximum Utilization > 80% of Limit are shown -> ordered by resource name Current Maximum Initial Resource Name Utilization Utilization Allocation Limit ------------------------------ ------------ ------------ ---------- ---------- max_shared_servers 35 35 40 40 ------------------------------------------------------------- init.ora Parameters DB/Inst: PRDUN/PRDUN Snaps: 32051-32227 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _b_tree_bitmap_plans FALSE _fix_control 4728348:off _kgl_keep_cache_pct 255 _optimizer_transitivity_retai FALSE _projection_pushdown FALSE archive_lag_target 900 audit_file_dest /work/oracle/log audit_trail DB background_dump_dest /work/oracle/log compatible 10.2.0.5 control_files /data/prdun/ctrl1PRDUN.ctl, /data core_dump_dest /work/oracle/log cursor_sharing EXACT db_block_size 8192 ...