WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ FONESBH 1452415117 fonesbh 1 10.2.0.3.0 NO BHIMA Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 1103 18-Sep-08 02:30:25 25 1.0 End Snap: 1104 18-Sep-08 03:30:55 28 1.1 Elapsed: 60.50 (mins) DB Time: 26.53 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 512M 512M Std Block Size: 8K Shared Pool Size: 512M 512M Log Buffer: 10,400K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 472.28 90,233.68 Logical reads: 3,346.76 639,433.21 Block changes: 1.89 361.58 Physical reads: 138.71 26,501.53 Physical writes: 6.06 1,158.63 User calls: 1,604.04 306,468.89 Parses: 0.72 137.95 Hard parses: 0.01 2.74 Sorts: 0.60 114.68 Logons: 0.04 7.00 Executes: 1.37 262.11 Transactions: 0.01 % Blocks changed per Read: 0.06 Recursive Call %: 0.60 Rollback per transaction %: 0.00 Rows per Sort: 400.63 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 96.01 In-memory Sort %: 99.95 Library Hit %: 93.43 Soft Parse %: 98.02 Execute to Parse %: 47.37 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 26.79 % Non-Parse CPU: 99.98 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 39.99 40.78 % SQL with executions>1: 84.10 82.40 % Memory for SQL w/exec>1: 80.71 71.58 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- db file sequential read 461,509 1,401 3 88.0 User I/O CPU time 978 61.5 db file scattered read 3,780 4 1 0.3 User I/O control file parallel write 1,212 2 2 0.1 System I/O SQL*Net message to client 5,821,214 2 0 0.1 Network ------------------------------------------------------------- Time Model Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total time in database user-calls (DB Time): 1591.6s -> Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic -> Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time ------------------------------------------ ------------------ ------------ sql execute elapsed time 1,582.9 99.5 DB CPU 978.4 61.5 parse time elapsed 1.7 .1 hard parse elapsed time 1.6 .1 connection management call elapsed time 0.3 .0 PL/SQL compilation elapsed time 0.2 .0 PL/SQL execution elapsed time 0.0 .0 repeated bind elapsed time 0.0 .0 sequence load elapsed time 0.0 .0 DB time 1,591.6 N/A background elapsed time 20.6 N/A background cpu time 10.9 N/A ------------------------------------------------------------- Wait Class DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc Avg %Time Total Wait wait Waits Wait Class Waits -outs Time (s) (ms) /txn -------------------- ---------------- ------ ---------------- ------- --------- User I/O 465,788 .0 1,407 3 24,515.2 System I/O 3,425 .0 3 1 180.3 Network 5,821,247 .0 2 0 ######### Concurrency 3 .0 0 125 0.2 Other 10 .0 0 13 0.5 Commit 14 .0 0 1 0.7 Application 4 .0 0 0 0.2 ------------------------------------------------------------- Wait Events DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> s - second -> cs - centisecond - 100th of a second -> ms - millisecond - 1000th of a second -> us - microsecond - 1000000th of a second -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- db file sequential read 461,509 .0 1,401 3 24,289.9 db file scattered read 3,780 .0 4 1 198.9 control file parallel write 1,212 .0 2 2 63.8 SQL*Net message to client 5,821,214 .0 2 0 ######### direct path read temp 496 .0 1 2 26.1 control file sequential read 1,837 .0 1 0 96.7 os thread startup 3 .0 0 125 0.2 db file parallel write 184 .0 0 1 9.7 latch free 2 .0 0 64 0.1 log file parallel write 191 .0 0 0 10.1 log file sync 14 .0 0 1 0.7 direct path write 2 .0 0 2 0.1 direct path write temp 1 .0 0 1 0.1 SQL*Net break/reset to clien 4 .0 0 0 0.2 SQL*Net more data to client 27 .0 0 0 1.4 control file single write 1 .0 0 0 0.1 LGWR wait for redo copy 7 .0 0 0 0.4 rdbms ipc reply 1 .0 0 0 0.1 SQL*Net more data from clien 6 .0 0 0 0.3 Streams AQ: qmn coordinator 261 50.2 3,555 13622 13.7 Streams AQ: qmn slave idle w 130 .0 3,555 27350 6.8 Streams AQ: waiting for time 1 100.0 1,917 ####### 0.1 SQL*Net message from client 5,821,211 .0 1,100 0 ######### jobq slave wait 20 100.0 59 2930 1.1 class slave wait 2 .0 0 1 0.1 ------------------------------------------------------------- Background Wait Events DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- control file parallel write 1,212 .0 2 2 63.8 control file sequential read 1,265 .0 1 0 66.6 os thread startup 3 .0 0 125 0.2 db file parallel write 184 .0 0 1 9.7 log file parallel write 191 .0 0 0 10.1 db file scattered read 11 .0 0 7 0.6 db file sequential read 18 .0 0 3 0.9 direct path write 1 .0 0 2 0.1 events in waitclass Other 9 .0 0 0 0.5 control file single write 1 .0 0 0 0.1 rdbms ipc message 18,296 99.4 66,480 3634 962.9 Streams AQ: qmn coordinator 261 50.2 3,555 13622 13.7 Streams AQ: qmn slave idle w 130 .0 3,555 27350 6.8 pmon timer 1,221 100.0 3,542 2901 64.3 smon timer 13 84.6 3,426 263567 0.7 Streams AQ: waiting for time 1 100.0 1,917 ####### 0.1 ------------------------------------------------------------- Operating System Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 Statistic Total -------------------------------- -------------------- AVG_BUSY_TIME 40,129 AVG_IDLE_TIME 322,639 AVG_IOWAIT_TIME 99,032 AVG_SYS_TIME 28,392 AVG_USER_TIME 11,609 BUSY_TIME 1,448,789 IDLE_TIME 11,619,371 IOWAIT_TIME 3,569,505 SYS_TIME 1,026,533 USER_TIME 422,256 LOAD 0 OS_CPU_WAIT_TIME 178,541,239,200 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 10,960,884 VM_OUT_BYTES 0 PHYSICAL_MEMORY_BYTES 42,795,532,288 NUM_CPUS 36 ------------------------------------------------------------- Service Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$USERS 1,591.4 978.2 503,275 ########## fonesbh.sbh_fone 0.0 0.0 0 0 SYS$BACKGROUND 0.0 0.0 231 23,017 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Wait Class info for services in the Service Statistics section. -> Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network -> Time Waited (Wt Time) in centisecond (100th of a second) Service Name ---------------------------------------------------------------- User I/O User I/O Concurcy Concurcy Admin Admin Network Network Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time Total Wts Wt Time --------- --------- --------- --------- --------- --------- --------- --------- SYS$USERS 465575 140561 0 0 0 0 5821225 199 SYS$BACKGROUND 217 106 3 37 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 Elapsed CPU Elap per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ---------- ------- ------------- 1,511 906 1 1511.2 94.9 7ntgjqvcr27zb Module: rtsf1@BHIMA (TNS V1-V3) select GDET_REFER ,GDET_SITE ,GDET_YEAR ,GDET_ENTITY ,GDET_UNIT ,GDET_CURR ,GDET_ACCT ,GDET_VEND ,GDET_INVC ,GDET_DESC ,GDET_AMT ,GDET_PER ,GDET_DOC N ,GDET_REV ,GDET_3LA ,GDET_SUB_ACC ,GDET_DATE ,GDET_CODE ,GDET_CIND ,GDE T_DIND ,GDET_RECON ,GDET_EXPN from F1_GDET where (((GDET_SITE=:b1 and GDET_Y 24 19 1 24.5 1.5 23g0cszz0cdaw Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_GLYR where (GLYR_SITE=:b1 and GLYR_YEAR=:b2) order by GLYR_SIT E,GLYR_YEAR,GLYR_ENTITY,GLYR_UNIT,GLYR_CURR,GLYR_ACCT 2 0 2 0.8 0.1 8bj2bkbyvg62w Module: SQL*Plus begin dbms_output.put_line(to_char(statspack.snap(7))); end; 1 0 1 0.5 0.0 bxywuzvtp6wjg Module: DBMS_SCHEDULER call dbms_scheduler.auto_purge ( ) 1 0 1 0.5 0.0 d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; 0 0 2 0.2 0.0 d3288hhvfnm1g Module: SQL*Plus INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP _TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_R EADS_TH , BUFFER_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR 0 0 2 0.1 0.0 cp5ttdtnu3rky Module: SQL*Plus SELECT NVL(MAX(BEGIN_TIME), TO_DATE('01011900','DDMMYYYY')) FROM STATS$UNDOSTAT WHERE DBID = :B2 AND INSTANCE_NUMBER = :B1 0 0 11 0.0 0.0 cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ wher e obj#=:1 and part=:2 and version=:3 order by piece# 0 0 1 0.2 0.0 7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_c hange#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phy blkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_num ber, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts. 0 0 2 0.1 0.0 9k7y61abzsuqb Module: SQL*Plus INSERT INTO STATS$FILESTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILEN AME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PH YBLKRD , PHYBLKWRT , WAIT_COUNT , TIME ) SELECT :B3 , :B2 , :B1 , TSNAME , FILEN AME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PH ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 CPU Elapsed CPU per % Total Time (s) Time (s) Executions Exec (s) DB Time SQL Id ---------- ---------- ------------ ----------- ------- ------------- 906 1,511 1 906.29 94.9 7ntgjqvcr27zb Module: rtsf1@BHIMA (TNS V1-V3) select GDET_REFER ,GDET_SITE ,GDET_YEAR ,GDET_ENTITY ,GDET_UNIT ,GDET_CURR ,GDET_ACCT ,GDET_VEND ,GDET_INVC ,GDET_DESC ,GDET_AMT ,GDET_PER ,GDET_DOC N ,GDET_REV ,GDET_3LA ,GDET_SUB_ACC ,GDET_DATE ,GDET_CODE ,GDET_CIND ,GDE T_DIND ,GDET_RECON ,GDET_EXPN from F1_GDET where (((GDET_SITE=:b1 and GDET_Y 19 24 1 18.69 1.5 23g0cszz0cdaw Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_GLYR where (GLYR_SITE=:b1 and GLYR_YEAR=:b2) order by GLYR_SIT E,GLYR_YEAR,GLYR_ENTITY,GLYR_UNIT,GLYR_CURR,GLYR_ACCT 0 2 2 0.22 0.1 8bj2bkbyvg62w Module: SQL*Plus begin dbms_output.put_line(to_char(statspack.snap(7))); end; 0 1 1 0.18 0.0 d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; 0 0 723 0.00 0.0 6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j ob 0 1 1 0.09 0.0 bxywuzvtp6wjg Module: DBMS_SCHEDULER call dbms_scheduler.auto_purge ( ) 0 0 2 0.04 0.0 d3288hhvfnm1g Module: SQL*Plus INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP _TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_R EADS_TH , BUFFER_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR 0 0 111 0.00 0.0 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 0 0 129 0.00 0.0 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege# >0 0 0 2 0.04 0.0 9k7y61abzsuqb Module: SQL*Plus INSERT INTO STATS$FILESTATXS ( SNAP_ID , DBID , INSTANCE_NUMBER , TSNAME , FILEN AME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PH YBLKRD , PHYBLKWRT , WAIT_COUNT , TIME ) SELECT :B3 , :B2 , :B1 , TSNAME , FILEN AME , PHYRDS , PHYWRTS , SINGLEBLKRDS , READTIM , WRITETIM , SINGLEBLKRDTIM , PH ------------------------------------------------------------- SQL ordered by Gets DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 12,149,231 -> Captured SQL account for 99.9% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 12,068,370 1 ############ 99.3 906.29 1511.17 7ntgjqvcr27zb Module: rtsf1@BHIMA (TNS V1-V3) select GDET_REFER ,GDET_SITE ,GDET_YEAR ,GDET_ENTITY ,GDET_UNIT ,GDET_CURR ,GDET_ACCT ,GDET_VEND ,GDET_INVC ,GDET_DESC ,GDET_AMT ,GDET_PER ,GDET_DOC N ,GDET_REV ,GDET_3LA ,GDET_SUB_ACC ,GDET_DATE ,GDET_CODE ,GDET_CIND ,GDE T_DIND ,GDET_RECON ,GDET_EXPN from F1_GDET where (((GDET_SITE=:b1 and GDET_Y 41,277 1 41,277.0 0.3 18.69 24.46 23g0cszz0cdaw Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_GLYR where (GLYR_SITE=:b1 and GLYR_YEAR=:b2) order by GLYR_SIT E,GLYR_YEAR,GLYR_ENTITY,GLYR_UNIT,GLYR_CURR,GLYR_ACCT 6,718 2 3,359.0 0.1 0.43 1.55 8bj2bkbyvg62w Module: SQL*Plus begin dbms_output.put_line(to_char(statspack.snap(7))); end; 5,978 122 49.0 0.0 0.07 0.07 cquhfjyvm6340 Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_BCHM where BCHM_E_DATE=:b1 order by BCHM_S_DATE,BCHM_S_TIME 5,708 1 5,708.0 0.0 0.18 0.51 d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; 5,391 8 673.9 0.0 0.04 0.04 g337099aatnuj update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:2, scn=:3, scn_wrp =:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where thread=0 and scn = (sel ect min(scn) from smon_scn_time where thread=0) 2,967 2 1,483.5 0.0 0.08 0.32 d3288hhvfnm1g Module: SQL*Plus INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP _TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_R EADS_TH , BUFFER_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR 1,598 1 1,598.0 0.0 0.09 0.54 bxywuzvtp6wjg Module: DBMS_SCHEDULER call dbms_scheduler.auto_purge ( ) 1,446 723 2.0 0.0 0.12 0.12 6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j ob 997 115 8.7 0.0 0.01 0.10 3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) ------------------------------------------------------------- SQL ordered by Reads DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total Disk Reads: 503,529 -> Captured SQL account for 100.0% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 459,136 1 459,136.0 91.2 906.29 1511.17 7ntgjqvcr27zb Module: rtsf1@BHIMA (TNS V1-V3) select GDET_REFER ,GDET_SITE ,GDET_YEAR ,GDET_ENTITY ,GDET_UNIT ,GDET_CURR ,GDET_ACCT ,GDET_VEND ,GDET_INVC ,GDET_DESC ,GDET_AMT ,GDET_PER ,GDET_DOC N ,GDET_REV ,GDET_3LA ,GDET_SUB_ACC ,GDET_DATE ,GDET_CODE ,GDET_CIND ,GDE T_DIND ,GDET_RECON ,GDET_EXPN from F1_GDET where (((GDET_SITE=:b1 and GDET_Y 43,379 1 43,379.0 8.6 18.69 24.46 23g0cszz0cdaw Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_GLYR where (GLYR_SITE=:b1 and GLYR_YEAR=:b2) order by GLYR_SIT E,GLYR_YEAR,GLYR_ENTITY,GLYR_UNIT,GLYR_CURR,GLYR_ACCT 613 2 306.5 0.1 0.43 1.55 8bj2bkbyvg62w Module: SQL*Plus begin dbms_output.put_line(to_char(statspack.snap(7))); end; 430 2 215.0 0.1 0.07 0.21 cp5ttdtnu3rky Module: SQL*Plus SELECT NVL(MAX(BEGIN_TIME), TO_DATE('01011900','DDMMYYYY')) FROM STATS$UNDOSTAT WHERE DBID = :B2 AND INSTANCE_NUMBER = :B1 105 1 105.0 0.0 0.09 0.54 bxywuzvtp6wjg Module: DBMS_SCHEDULER call dbms_scheduler.auto_purge ( ) 82 1 82.0 0.0 0.18 0.51 d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end; 56 11 5.1 0.0 0.04 0.17 cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ wher e obj#=:1 and part=:2 and version=:3 order by piece# 43 1 43.0 0.0 0.00 0.14 cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 26843545 6), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user# 41 2 20.5 0.0 0.08 0.32 d3288hhvfnm1g Module: SQL*Plus INSERT INTO STATS$SNAPSHOT ( SNAP_ID, DBID, INSTANCE_NUMBER , SNAP_TIME, STARTUP _TIME , SESSION_ID, SNAP_LEVEL, UCOMMENT , EXECUTIONS_TH, PARSE_CALLS_TH, DISK_R EADS_TH , BUFFER_GETS_TH, SHARABLE_MEM_TH , VERSION_COUNT_TH, SEG_PHY_READS_TH , SEG_LOG_READS_TH, SEG_BUFF_BUSY_TH, SEG_ROWLOCK_W_TH , SEG_ITL_WAITS_TH, SEG_CR 21 28 0.8 0.0 0.06 0.14 cqgv56fmuj63x select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(proper ty,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj# (+) order by order# ------------------------------------------------------------- SQL ordered by Executions DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total Executions: 4,980 -> Captured SQL account for 76.6% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 723 723 1.0 0.00 0.00 g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysd ate+5/86400)) 723 0 0.0 0.00 0.00 6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n ext_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, j ob 481 481 1.0 0.00 0.00 d0j4tc0b2y7ss Module: rtsf1@BHIMA (TNS V1-V3) select * into :b1,:b2,:b3:i3,:b4:i4,:b5:i5 from F1_MENU where MENU_ITEM=:b6 290 76 0.3 0.00 0.00 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p rivilege#>0 start with grantee#=:1 and privilege#>0 129 290 2.2 0.00 0.00 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege# >0 122 2 0.0 0.00 0.00 cquhfjyvm6340 Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_BCHM where BCHM_E_DATE=:b1 order by BCHM_S_DATE,BCHM_S_TIME 115 115 1.0 0.00 0.00 3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) 111 106 1.0 0.00 0.00 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 109 109 1.0 0.00 0.00 f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual 95 83 0.9 0.00 0.00 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn 95 0 0.0 0.00 0.00 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 94 387 4.1 0.00 0.00 32hbap2vtmf53 select position#,sequence#,level#,argument,type#,charsetid,charsetform,propertie s,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,typ e_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and proc edure#=:2 order by sequence# desc 74 74 1.0 0.00 0.00 2ym6hhaq30r73 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro m seg$ where ts#=:1 and file#=:2 and block#=:3 ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total Parse Calls: 2,621 -> Captured SQL account for 77.7% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 481 481 18.35 d0j4tc0b2y7ss Module: rtsf1@BHIMA (TNS V1-V3) select * into :b1,:b2,:b3:i3,:b4:i4,:b5:i5 from F1_MENU where MENU_ITEM=:b6 290 290 11.06 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p rivilege#>0 start with grantee#=:1 and privilege#>0 129 129 4.92 0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege# >0 122 122 4.65 cquhfjyvm6340 Module: rtsf1@BHIMA (TNS V1-V3) select * from F1_BCHM where BCHM_E_DATE=:b1 order by BCHM_S_DATE,BCHM_S_TIME 115 115 4.39 3m8smr0v7v1m6 INSERT INTO sys.wri$_adv_message_groups (task_id,id,seq,message#,fac,hdr,lm,nl,p 1,p2,p3,p4,p5) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13) 109 109 4.16 f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual 95 95 3.62 g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, del etes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where ob j# = :objn 95 95 3.62 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 74 74 2.82 2ym6hhaq30r73 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis ts,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0),NVL(scanhint,0) fro m seg$ where ts#=:1 and file#=:2 and block#=:3 34 34 1.30 2q817mk1r7sw8 INSERT INTO sys.wri$_adv_rationale (id, task_id, rec_id, obj_id, impact_msg_id, impact_val, msg_id, type, attr1, attr2, attr3, attr4, attr5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, ' ') RETURNING rowid INTO :13 33 33 1.26 d0rymj3uhjgyx Module: rtsf1@BHIMA (TNS V1-V3) select FOTM_TEXT into :b1:i1 from F1_FOTM where ((FOTM_TYPE=:b2 and FOTM_ID=: b3) and FOTM_LANG=:b4) 28 28 1.07 cqgv56fmuj63x select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(proper ty,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj# (+) order by order# 28 28 1.07 8swypbbr0m372 select order#,columns,types from access$ where d_obj#=:1 ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Instance Activity Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- active txn count during cleanout 57 0.0 3.0 application wait time 0 0.0 0.0 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 17,516 4.8 921.9 branch node splits 0 0.0 0.0 buffer is not pinned count 17,355,944 4,781.1 913,470.7 buffer is pinned count 30,187,879 8,315.9 1,588,835.7 bytes received via SQL*Net from 64,337,024 17,723.0 3,386,159.2 bytes sent via SQL*Net to client 1,117,942,674 307,961.0 58,839,088.1 Cached Commit SCN referenced 6,520,317 1,796.2 343,174.6 calls to get snapshot scn: kcmgs 6,548 1.8 344.6 calls to kcmgas 258 0.1 13.6 calls to kcmgcs 70 0.0 3.7 change write time 7 0.0 0.4 cleanout - number of ktugct call 2,091 0.6 110.1 cleanouts and rollbacks - consis 1 0.0 0.1 cleanouts only - consistent read 2,029 0.6 106.8 cluster key scan block gets 10,071 2.8 530.1 cluster key scans 404 0.1 21.3 commit batch/immediate performed 2 0.0 0.1 commit batch/immediate requested 2 0.0 0.1 commit cleanout failures: block 0 0.0 0.0 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callba 0 0.0 0.0 commit cleanout failures: cannot 0 0.0 0.0 commit cleanouts 465 0.1 24.5 commit cleanouts successfully co 465 0.1 24.5 commit immediate performed 2 0.0 0.1 commit immediate requested 2 0.0 0.1 Commit SCN cached 2 0.0 0.1 commit txn count during cleanout 2,056 0.6 108.2 concurrency wait time 38 0.0 2.0 consistent changes 39 0.0 2.1 consistent gets 12,143,242 3,345.1 639,118.0 consistent gets - examination 8,839 2.4 465.2 consistent gets direct 0 0.0 0.0 consistent gets from cache 12,143,242 3,345.1 639,118.0 CPU used by this session 26,507 7.3 1,395.1 CPU used when call started 25,901 7.1 1,363.2 CR blocks created 14 0.0 0.7 cursor authentications 76 0.0 4.0 data blocks consistent reads - u 16 0.0 0.8 db block changes 6,870 1.9 361.6 db block gets 5,993 1.7 315.4 db block gets direct 5 0.0 0.3 db block gets from cache 5,988 1.7 315.2 DB time 173,172 47.7 9,114.3 DBWR checkpoint buffers written 707 0.2 37.2 DBWR checkpoints 0 0.0 0.0 DBWR parallel query checkpoint b 0 0.0 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR transaction table writes 97 0.0 5.1 DBWR undo block writes 194 0.1 10.2 deferred (CURRENT) block cleanou 227 0.1 12.0 DFO trees parallelized 0 0.0 0.0 dirty buffers inspected 1,505 0.4 79.2 enqueue conversions 746 0.2 39.3 enqueue releases 28,647 7.9 1,507.7 enqueue requests 28,648 7.9 1,507.8 Instance Activity Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- enqueue timeouts 1 0.0 0.1 enqueue waits 0 0.0 0.0 execute count 4,980 1.4 262.1 failed probes on index block rec 4 0.0 0.2 free buffer inspected 484,585 133.5 25,504.5 free buffer requested 484,392 133.4 25,494.3 heap block compress 35 0.0 1.8 hot buffers moved to head of LRU 37,175 10.2 1,956.6 immediate (CR) block cleanout ap 2,030 0.6 106.8 immediate (CURRENT) block cleano 116 0.0 6.1 index crx upgrade (positioned) 2,310 0.6 121.6 index fast full scans (full) 0 0.0 0.0 index fetch by key 2,807 0.8 147.7 index scans kdiixs1 3,922 1.1 206.4 leaf node splits 19 0.0 1.0 leaf node 90-10 splits 10 0.0 0.5 lob reads 17 0.0 0.9 lob writes 127 0.0 6.7 lob writes unaligned 127 0.0 6.7 logons cumulative 133 0.0 7.0 messages received 342 0.1 18.0 messages sent 342 0.1 18.0 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 12,128,716 3,341.1 638,353.5 opened cursors cumulative 3,376 0.9 177.7 Parallel operations not downgrad 0 0.0 0.0 parse count (hard) 52 0.0 2.7 parse count (total) 2,621 0.7 138.0 parse time cpu 15 0.0 0.8 parse time elapsed 56 0.0 3.0 physical read bytes 4,124,909,568 1,136,293.7 ############# physical read IO requests 468,497 129.1 24,657.7 physical read total bytes 4,140,064,768 1,140,468.5 ############# physical read total IO requests 470,347 129.6 24,755.1 physical read total multi block 6,491 1.8 341.6 physical reads 503,529 138.7 26,501.5 physical reads cache 484,254 133.4 25,487.1 physical reads cache prefetch 18,951 5.2 997.4 physical reads direct 19,275 5.3 1,014.5 physical reads direct temporary 19,275 5.3 1,014.5 physical reads prefetch warmup 0 0.0 0.0 physical write bytes 180,338,688 49,678.1 9,491,509.9 physical write IO requests 2,235 0.6 117.6 physical write total bytes 212,009,984 58,402.6 11,158,420.2 physical write total IO requests 5,577 1.5 293.5 physical write total multi block 1,160 0.3 61.1 physical writes 22,014 6.1 1,158.6 physical writes direct 19,280 5.3 1,014.7 physical writes direct temporary 19,275 5.3 1,014.5 physical writes from cache 2,734 0.8 143.9 physical writes non checkpoint 21,596 6.0 1,136.6 pinned buffers inspected 0 0.0 0.0 prefetch warmup blocks aged out 3 0.0 0.2 process last non-idle time 1,221,686,392 336,539.4 64,299,283.8 PX local messages recv'd 0 0.0 0.0 PX local messages sent 0 0.0 0.0 queries parallelized 0 0.0 0.0 recursive calls 34,968 9.6 1,840.4 recursive cpu usage 142 0.0 7.5 redo blocks written 1,865 0.5 98.2 Instance Activity Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- redo buffer allocation retries 0 0.0 0.0 redo entries 4,701 1.3 247.4 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo ordering marks 0 0.0 0.0 redo size 1,714,440 472.3 90,233.7 redo synch time 1 0.0 0.1 redo synch writes 835 0.2 44.0 redo wastage 88,224 24.3 4,643.4 redo write time 5 0.0 0.3 redo writer latching time 0 0.0 0.0 redo writes 191 0.1 10.1 rollback changes - undo records 196 0.1 10.3 rollbacks only - consistent read 13 0.0 0.7 rows fetched via callback 1,958 0.5 103.1 session connect time 1,221,686,321 336,539.4 64,299,280.1 session cursor cache hits 2,644 0.7 139.2 session logical reads 12,149,231 3,346.8 639,433.2 session pga memory 4,454,080 1,227.0 234,425.3 session pga memory max 112,195,264 30,906.6 5,905,013.9 session uga memory 4,299,377,728 1,184,354.6 ############# session uga memory max 139,696,624 38,482.4 7,352,453.9 shared hash latch upgrades - no 2,485 0.7 130.8 SMON posted for undo segment shr 0 0.0 0.0 sorts (disk) 1 0.0 0.1 sorts (memory) 2,178 0.6 114.6 sorts (rows) 872,981 240.5 45,946.4 sql area evicted 0 0.0 0.0 sql area purged 0 0.0 0.0 SQL*Net roundtrips to/from clien 5,821,903 1,603.8 306,416.0 summed dirty queue length 1,505 0.4 79.2 switch current to new buffer 4 0.0 0.2 table fetch by rowid 21,074,480 5,805.4 1,109,183.2 table fetch continued row 120 0.0 6.3 table scan blocks gotten 49,183 13.6 2,588.6 table scan rows gotten 3,576,787 985.3 188,252.0 table scans (direct read) 0 0.0 0.0 table scans (long tables) 1 0.0 0.1 table scans (rowid ranges) 0 0.0 0.0 table scans (short tables) 237 0.1 12.5 total number of times SMON poste 2 0.0 0.1 transaction rollbacks 2 0.0 0.1 undo change vector size 488,648 134.6 25,718.3 user calls 5,822,909 1,604.0 306,468.9 user commits 19 0.0 1.0 user I/O wait time 140,680 38.8 7,404.2 workarea executions - onepass 2 0.0 0.1 workarea executions - optimal 623 0.2 32.8 write clones created in backgrou 0 0.0 0.0 write clones created in foregrou 0 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: FONESBH/fonesbh Snaps: 110 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session cursor cache count 5,739 6,555 opened cursors current 25 30 logons current 25 28 ------------------------------------------------------------- Instance Activity Stats - Thread ActivityDB/Inst: FONESBH/fonesbh Snaps: 1103 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ TSDATA_500M 334,803 92 4.0 1.0 544 0 0 0.0 TSIDX_100M 124,243 34 0.5 1.0 434 0 0 0.0 TSDATA_100M 5,562 2 1.1 4.3 2 0 0 0.0 TEMP 3,194 1 11.3 6.0 753 0 0 0.0 SYSAUX 160 0 4.7 1.1 205 0 0 0.0 SYSTEM 300 0 5.4 1.1 38 0 0 0.0 TSUNDO_01 2 0 10.0 1.0 200 0 0 0.0 TOOLS_1M 145 0 4.6 3.6 50 0 0 0.0 TSDATA_10M 11 0 5.5 1.0 6 0 0 0.0 TSIDX_1M 13 0 10.8 1.0 2 0 0 0.0 TSDATA_1M 13 0 5.4 1.0 1 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ SYSAUX /dev/vg_sbh_fone_db/rfonesbh_SYSAUX_001.dbf 160 0 4.7 1.1 205 0 0 0.0 SYSTEM /dev/vg_sbh_fone_db/rfonesbh_SYSTEM_001.dbf 300 0 5.4 1.1 38 0 0 0.0 TEMP /dev/vg_sbh_fone_db/rfonesbh_TEMP_001.dbf 3,194 1 11.3 6.0 753 0 0 N/A TOOLS_1M /dev/vg_sbh_fone_db/rfonesbh_TOOLS_1M_001.dbf 145 0 4.6 3.6 50 0 0 0.0 TSDATA_1M /dev/vg_sbh_fone_db/rfonesbh_TSDATA_1M_001.dbf 13 0 5.4 1.0 1 0 0 0.0 TSDATA_10M /dev/vg_sbh_fone_db/rfonesbh_TSDATA_10M_001.dbf 11 0 5.5 1.0 6 0 0 0.0 TSDATA_100M /dev/vg_sbh_fone_db/rfonesbh_TSDATA_100M_001.dbf 5,562 2 1.1 4.3 2 0 0 0.0 TSDATA_500M /dev/vg_sbh_fone_db/rfonesbh_TSDATA_500M_001.dbf 171,114 47 4.4 1.0 543 0 0 0.0 TSDATA_500M /dev/vg_sbh_fone_db/rfonesbh_TSDATA_500M_002.dbf 163,689 45 3.5 1.0 1 0 0 0.0 TSIDX_1M /dev/vg_sbh_fone_db/rfonesbh_TSIDX_1M_001.dbf 13 0 10.8 1.0 2 0 0 0.0 TSIDX_100M /dev/vg_sbh_fone_db/rfonesbh_TSIDX_100M_001.dbf 124,243 34 0.5 1.0 434 0 0 0.0 TSUNDO_01 /dev/vg_sbh_fone_db/rfonesbh_TSUNDO_01_001.dbf 2 0 10.0 1.0 200 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 63,328 96 12,148,819 484,238 2,734 0 0 0 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 104 10 163 179 1382400 1382400 N/A 199999999 E 105 10 114 0 1382400 1382400 N/A 199999999 ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 No data exists for this section of the report. ------------------------------------------------------------- PGA Aggr Summary DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 --------------- ------------------ -------------------------- 51.4 359 339 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 500 390 144.7 0.0 .0 .0 .0 102,400 E 500 389 148.0 0.0 .0 .0 .0 102,400 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 597 597 0 0 64K 128K 5 5 0 0 512K 1024K 16 16 0 0 1M 2M 5 5 0 0 128M 256M 2 0 2 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 -> 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 ---------- ------- ---------------- ---------------- -------- ---------- 63 0.1 614.6 987.7 38.0 17 125 0.3 614.6 169.4 78.0 0 250 0.5 614.6 169.4 78.0 0 375 0.8 614.6 169.4 78.0 0 500 1.0 614.6 169.4 78.0 0 600 1.2 614.6 169.4 78.0 0 700 1.4 614.6 169.4 78.0 0 800 1.6 614.6 169.4 78.0 0 900 1.8 614.6 169.4 78.0 0 1,000 2.0 614.6 169.4 78.0 0 1,500 3.0 614.6 169.4 78.0 0 2,000 4.0 614.6 169.4 78.0 0 3,000 6.0 614.6 169.4 78.0 0 4,000 8.0 614.6 169.4 78.0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 -> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor -> Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid. Est LC Est LC Est LC Est LC Shared SP Est LC Time Time Load Load Est LC Pool Size Size Est LC Saved Saved Time Time Mem Size(M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 192 .4 37 3,681 14,712 1.0 79 1.0 945,259 256 .5 37 3,681 14,712 1.0 79 1.0 945,259 320 .6 37 3,681 14,712 1.0 79 1.0 945,259 384 .8 37 3,681 14,712 1.0 79 1.0 945,259 448 .9 37 3,681 14,712 1.0 79 1.0 945,259 512 1.0 37 3,681 14,712 1.0 79 1.0 945,259 576 1.1 37 3,681 14,712 1.0 79 1.0 945,259 640 1.3 37 3,681 14,712 1.0 79 1.0 945,259 704 1.4 37 3,681 14,712 1.0 79 1.0 945,259 768 1.5 37 3,681 14,712 1.0 79 1.0 945,259 832 1.6 37 3,681 14,712 1.0 79 1.0 945,259 896 1.8 37 3,681 14,712 1.0 79 1.0 945,259 960 1.9 37 3,681 14,712 1.0 79 1.0 945,259 1,024 2.0 37 3,681 14,712 1.0 79 1.0 945,259 ------------------------------------------------------------- SGA Target Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 No data exists for this section of the report. ------------------------------------------------------------- Streams Pool Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 Size for Size Est Spill Est Spill Est Unspill Est Unspill Est (MB) Factor Count Time (s) Count Time (s) ---------- --------- ----------- ----------- ----------- ----------- 16 0.1 0 0 0 0 32 0.3 0 0 0 0 48 0.4 0 0 0 0 64 0.6 0 0 0 0 80 0.7 0 0 0 0 96 0.9 0 0 0 0 112 1.0 0 0 0 0 128 1.1 0 0 0 0 144 1.3 0 0 0 0 160 1.4 0 0 0 0 176 1.6 0 0 0 0 192 1.7 0 0 0 0 208 1.9 0 0 0 0 224 2.0 0 0 0 0 240 2.1 0 0 0 0 256 2.3 0 0 0 0 272 2.4 0 0 0 0 288 2.6 0 0 0 0 304 2.7 0 0 0 0 320 2.9 0 0 0 0 ------------------------------------------------------------- Java Pool Advisory DB/Inst: FONESBH/fonesbh Snap: 1104 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Enqueue Activity DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Undo Segment Summary DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 .2 312 2,582 3 5069.4166 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 ------------ ----------- ------------ ------- ------- ------- ----- ------------ 18-Sep 03:37 54 104 2,582 3 5,760 0/0 0/0/0/0/0/0 18-Sep 03:27 1 3 1,982 1 5,772 0/0 0/0/0/0/0/0 18-Sep 03:17 1 19 1,382 1 5,631 0/0 0/0/0/0/0/0 18-Sep 03:07 1 4 779 1 5,491 0/0 0/0/0/0/0/0 18-Sep 02:57 20 37 179 3 5,349 0/0 0/0/0/0/0/0 18-Sep 02:47 4 78 0 1 5,210 0/0 0/0/0/0/0/0 18-Sep 02:37 77 67 0 3 5,069 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ active checkpoint queue 6,238 0.0 N/A 0 0 N/A active service list 7,070 0.0 N/A 0 1,221 0.0 archive control 62 0.0 N/A 0 0 N/A archive process latch 1,305 0.0 N/A 0 0 N/A ASM db client latch 2,777 0.0 N/A 0 0 N/A AWR Alerted Metric Eleme 13,677 0.0 N/A 0 0 N/A begin backup scn array 2 0.0 N/A 0 0 N/A cache buffer handles 26 0.0 N/A 0 0 N/A cache buffers chains 24,795,124 0.0 N/A 0 523,820 0.0 cache buffers lru chain 5,896 0.0 N/A 0 529,068 0.0 cache table scan latch 0 N/A N/A 0 3,780 0.0 cas latch 44 0.0 N/A 0 0 N/A channel handle pool latc 265 0.0 N/A 0 0 N/A channel operations paren 19,314 0.0 N/A 0 0 N/A checkpoint queue latch 468,891 0.0 N/A 0 2,694 0.0 client/application info 664 0.0 N/A 0 0 N/A compile environment latc 455 0.0 N/A 0 0 N/A Consistent RBA 191 0.0 N/A 0 0 N/A dml lock allocation 712 0.0 N/A 0 0 N/A dummy allocation 263 0.0 N/A 0 0 N/A enqueue hash chains 58,059 0.0 N/A 0 0 N/A enqueues 56,406 0.0 N/A 0 0 N/A event group latch 132 0.0 N/A 0 0 N/A FAL request queue 96 0.0 N/A 0 0 N/A FAL subheap alocation 96 0.0 N/A 0 0 N/A Fast-Start Failover Stat 242 0.0 N/A 0 0 N/A file cache latch 130 0.0 N/A 0 0 N/A FOB s.o list latch 91 0.0 N/A 0 0 N/A global KZLD latch for me 2 0.0 N/A 0 0 N/A hash table column usage 41 0.0 N/A 0 185 0.0 hash table modification 78 0.0 N/A 0 0 N/A job workq parent latch 0 N/A N/A 0 2 0.0 job_queue_processes free 2 0.0 N/A 0 0 N/A job_queue_processes para 62 0.0 N/A 0 0 N/A JS mem alloc latch 10 0.0 N/A 0 0 N/A JS queue access latch 10 0.0 N/A 0 0 N/A JS queue state obj latch 21,734 0.0 N/A 0 0 N/A JS slv state obj latch 8 0.0 N/A 0 0 N/A kks stats 102 0.0 N/A 0 0 N/A KMG MMAN ready and start 1,210 0.0 N/A 0 0 N/A ksuosstats global area 244 0.0 N/A 0 0 N/A KTF sga latch 6 0.0 N/A 0 1,197 0.0 ktm global data 13 0.0 N/A 0 0 N/A kwqbsn:qsga 132 0.0 N/A 0 0 N/A KWQMN job cache list lat 1 0.0 N/A 0 0 N/A KWQP Prop Status 2 0.0 N/A 0 0 N/A lgwr LWN SCN 1,337 0.0 N/A 0 0 N/A library cache 16,742 0.0 N/A 0 0 N/A library cache load lock 374 0.0 N/A 0 0 N/A library cache lock 9,290 0.0 N/A 0 0 N/A library cache lock alloc 466 0.0 N/A 0 0 N/A library cache pin 6,239 0.0 N/A 0 0 N/A library cache pin alloca 47 0.0 N/A 0 0 N/A list of block allocation 42 0.0 N/A 0 0 N/A loader state object free 4 0.0 N/A 0 0 N/A logminer context allocat 1 0.0 N/A 0 0 N/A longop free list parent 2 0.0 N/A 0 2 0.0 Memory Management Latch 0 N/A N/A 0 1,210 0.0 message pool operations 4 0.0 N/A 0 0 N/A messages 37,311 0.0 0.0 0 0 N/A Latch Activity DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ mostly latch-free SCN 1,602 0.0 N/A 0 0 N/A MQL Tracking Latch 0 N/A N/A 0 72 0.0 multiblock read objects 11,304 0.0 N/A 0 0 N/A Mutex 0 N/A N/A 0 9,665 0.0 ncodef allocation latch 58 0.0 N/A 0 0 N/A object queue header heap 25,275 0.0 N/A 0 91 0.0 object queue header oper 1,002,366 0.0 N/A 0 0 N/A object stats modificatio 40 0.0 N/A 0 0 N/A OS process 405 0.0 N/A 0 0 N/A OS process allocation 1,483 0.0 N/A 0 0 N/A OS process: request allo 261 0.0 N/A 0 0 N/A parallel query alloc buf 460 0.0 N/A 0 0 N/A parameter table allocati 131 0.0 N/A 0 0 N/A PL/SQL warning settings 155 0.0 N/A 0 0 N/A post/wait queue 42 0.0 N/A 0 14 0.0 process allocation 261 0.0 N/A 0 132 0.0 process group creation 261 0.0 N/A 0 0 N/A qmn task queue latch 520 0.4 0.5 0 0 N/A redo allocation 6,284 0.0 0.0 0 0 N/A redo copy 0 N/A N/A 0 4,756 0.1 redo on-disk SCN 3,935 0.0 N/A 0 0 N/A redo writing 9,351 0.0 N/A 0 0 N/A resmgr group change latc 136 0.0 N/A 0 0 N/A resmgr:actses active lis 260 0.0 N/A 0 0 N/A resmgr:actses change gro 130 0.0 N/A 0 0 N/A resmgr:free threads list 259 0.0 N/A 0 0 N/A resmgr:schema config 1 0.0 N/A 0 0 N/A rm cas latch 1,024 0.0 N/A 0 0 N/A row cache objects 26,754 0.0 N/A 0 0 N/A rules engine rule set st 100 0.0 N/A 0 0 N/A sequence cache 753 0.0 N/A 0 0 N/A session allocation 37,217 0.0 N/A 0 0 N/A session idle bit 11,645,195 0.0 N/A 0 0 N/A session state list latch 289 0.0 N/A 0 0 N/A session switching 58 0.0 N/A 0 0 N/A session timer 1,221 0.0 N/A 0 0 N/A SGA IO buffer pool latch 3,945 0.0 N/A 0 3,945 0.0 Shared B-Tree 133 0.0 N/A 0 0 N/A shared pool 19,712 0.0 N/A 0 0 N/A shared pool sim alloc 10 0.0 N/A 0 0 N/A shared pool simulator 1,310 0.0 N/A 0 0 N/A slave class 2 0.0 N/A 0 0 N/A slave class create 8 12.5 1.0 0 0 N/A sort extent pool 252 0.0 N/A 0 0 N/A SQL memory manager latch 1 0.0 N/A 0 1,209 0.0 SQL memory manager worka 81,364 0.0 N/A 0 0 N/A state object free list 2 0.0 N/A 0 0 N/A statistics aggregation 112 0.0 N/A 0 0 N/A temp lob duration state 2 0.0 N/A 0 0 N/A threshold alerts latch 236 0.0 N/A 0 0 N/A transaction allocation 32 0.0 N/A 0 0 N/A transaction branch alloc 58 0.0 N/A 0 0 N/A undo global data 16,462 0.0 N/A 0 0 N/A user lock 257 0.0 N/A 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- qmn task queue latch 520 2 1 1 0 0 0 slave class create 8 1 1 0 0 0 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- event range base latch No latch 0 1 1 slave class create ksvcreate 0 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total Logical Reads: 12,149,231 -> Captured Segments account for 99.9% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- FONESBH TSDATA_500 F1_GDET TABLE 6,562,080 54.01 FONESBH TSIDX_100M AK_1_GDET INDEX 5,499,808 45.27 FONESBH TSDATA_100 F1_GLYR TABLE 41,296 .34 SYS SYSTEM SMON_SCN_TIME TABLE 9,328 .08 FONESBH TSDATA_1M F1_BCHM TABLE 5,936 .05 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Total Physical Reads: 503,529 -> Captured Segments account for 96.1% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- FONESBH TSDATA_500 F1_GDET TABLE 334,799 66.49 FONESBH TSIDX_100M AK_1_GDET INDEX 124,242 24.67 FONESBH TSDATA_100 F1_GLYR TABLE 24,104 4.79 PERFSTAT TOOLS_1M STATS$UNDOSTAT TABLE 429 .09 SYS SYSTEM TAB$ TABLE 43 .01 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- PERFSTAT TOOLS_1M STATS$DATABASE_INSTA INDEX 1 100.00 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> "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 63 0.0 0 N/A 2 1 dc_global_oids 42 11.9 0 N/A 0 28 dc_histogram_defs 235 35.7 0 N/A 0 3,132 dc_object_grants 36 13.9 0 N/A 0 27 dc_object_ids 1,304 5.4 0 N/A 0 846 dc_objects 1,306 8.7 0 N/A 1 799 dc_profiles 129 0.0 0 N/A 0 1 dc_rollback_segments 2,444 0.0 0 N/A 0 75 dc_segments 160 46.9 0 N/A 0 471 dc_sequences 12 8.3 0 N/A 12 9 dc_tablespaces 618 0.0 0 N/A 0 13 dc_usernames 299 0.3 0 N/A 0 10 dc_users 2,912 0.1 0 N/A 0 32 outstanding_alerts 84 0.0 0 N/A 0 13 ------------------------------------------------------------- Library Cache Activity DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 28 14.3 67 6.0 0 0 INDEX 1 0.0 6 0.0 0 0 SQL AREA 193 99.0 3,675 4.2 0 0 TABLE/PROCEDURE 488 40.0 1,443 12.7 0 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 136.9 N/A 5.5 8.6 22 23 25 25 Freeable 7.1 .0 .9 .4 1 N/A 8 8 SQL .6 .4 .1 .1 0 2 10 8 PL/SQL .1 .0 .0 .0 0 0 25 25 E Other 139.1 N/A 5.0 8.2 22 23 28 28 Freeable 8.1 .0 .9 .4 1 N/A 9 9 SQL .7 .4 .1 .1 0 100 13 10 PL/SQL .1 .1 .0 .0 0 0 28 28 ------------------------------------------------------------- SGA Memory Summary DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 536,870,912 Fixed Size 2,304,440 Redo Buffers 10,649,600 Variable Size 1,094,342,216 ------------------- sum 1,644,167,168 ------------------------------------------------------------- SGA breakdown difference DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 208.0 208.0 0.00 large free memory 208.0 208.0 0.00 shared ASH buffers 25.6 25.6 0.00 shared dbwriter coalesce buffer 5.0 5.0 0.00 shared free memory 307.3 303.2 -1.33 shared KGLS heap 5.1 5.9 15.84 shared library cache 6.0 6.6 10.12 shared row cache 7.2 7.2 0.00 shared sql area 18.4 19.5 5.94 stream free memory 112.0 112.0 0.00 buffer_cache 512.0 512.0 0.00 fixed_sga 2.2 2.2 0.00 log_buffer 10.2 10.2 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> 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 Slaves 38,050 0 0 QMON Coordinator 35,662 0 0 ------------------------------------------------------------- Streams Capture DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 -> Rule Sets ordered by Evaluations Fast SQL CPU Elapsed Ruleset Name Evals Evals Execs Time Time ------------------------- -------- -------- -------- -------- -------- SYS.ALERT_QUE_R 0 0 0 0 0 ------------------------------------------------------------- Resource Limit Stats DB/Inst: FONESBH/fonesbh Snap: 1104 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- aq_tm_processes 1 archive_lag_target 0 background_dump_dest /sbh_fone/orabase/fonesbh/bdump compatible 9.2.0.1.0 control_files /dev/vg_sbh_fone_redoctl/rfonesbh core_dump_dest /sbh_fone/orabase/fonesbh/cdump cursor_space_for_time TRUE db_block_size 8192 db_cache_advice OFF db_cache_size 536870912 db_domain sbh_fone db_file_multiblock_read_count 8 db_file_name_convert , db_name fonesbh db_writer_processes 5 dg_broker_start TRUE fast_start_mttr_target 3600 instance_name fonesbh java_pool_size 218103808 job_queue_processes 10 large_pool_size 218103808 local_listener LISTENER_SBH_FONE lock_sga TRUE _log_archive_callout LOCAL_FIRST=TRUE log_archive_dest_state_1 enable log_archive_dest_state_2 ENABLE log_archive_dest_state_3 DEFER log_archive_dest_state_4 DEFER log_archive_dest_1 LOCATION=/sbh_fone/oraarch/fonesb log_archive_dest_2 LOCATION=/sbh_fone_arch_nr/fonesb log_archive_dest_3 service="fonesbh.drsite", ARCH SY log_archive_dest_4 log_archive_format %t_%s.dbf log_archive_max_processes 4 log_archive_min_succeed_dest 1 log_archive_trace 0 log_buffer 10485760 log_checkpoint_interval 199999999 log_checkpoints_to_alert TRUE log_checkpoint_timeout 0 log_file_name_convert , nls_date_format YYYYMMDD nls_language american nls_sort norwegian nls_territory america open_cursors 500 optimizer_mode CHOOSE os_authent_prefix pga_aggregate_target 524288000 processes 300 query_rewrite_enabled FALSE remote_login_passwordfile EXCLUSIVE remote_os_authent TRUE session_cached_cursors 100 session_max_open_files 20 shared_pool_size 536870912 sort_area_size 1048576 spfile /dev/vg_sbh_fone_redoctl/rspfilef standby_archive_dest /sbh_fone/oraarch/fonesbh/standby standby_file_management AUTO init.ora Parameters DB/Inst: FONESBH/fonesbh Snaps: 1103-1104 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- star_transformation_enabled FALSE statistics_level TYPICAL streams_pool_size 117440512 timed_statistics TRUE trace_enabled FALSE transactions 1000 undo_management AUTO undo_retention 1800 undo_tablespace TSUNDO_01 user_dump_dest /sbh_fone/orabase/fonesbh/udump ------------------------------------------------------------- End of Report