WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst Num Release RAC Host ------------ ----------- ------------ -------- ----------- --- ------------ ORAMARSP 3575707997 ORAMARSP 1 10.2.0.4.0 NO z1s10immarsp Snap Id Snap Time Sessions Curs/Sess --------- ------------------- -------- --------- Begin Snap: 38819 12-Jul-12 11:00:15 37 13.4 End Snap: 38820 12-Jul-12 12:00:27 37 15.0 Elapsed: 60.21 (mins) DB Time: 1.93 (mins) Cache Sizes ~~~~~~~~~~~ Begin End ---------- ---------- Buffer Cache: 1,056M 1,024M Std Block Size: 8K Shared Pool Size: 704M 736M Log Buffer: 14,384K Load Profile ~~~~~~~~~~~~ Per Second Per Transaction --------------- --------------- Redo size: 7,212.51 34,925.47 Logical reads: 343.97 1,665.62 Block changes: 46.10 223.25 Physical reads: 14.65 70.96 Physical writes: 1.50 7.24 User calls: 7.28 35.26 Parses: 3.09 14.98 Hard parses: 0.03 0.16 Sorts: 8.28 40.10 Logons: 0.09 0.44 Executes: 9.88 47.86 Transactions: 0.21 % Blocks changed per Read: 13.40 Recursive Call %: 81.93 Rollback per transaction %: 1.74 Rows per Sort: 15.22 Instance Efficiency Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Buffer Nowait %: 100.00 Redo NoWait %: 100.00 Buffer Hit %: 95.74 In-memory Sort %: 100.00 Library Hit %: 99.22 Soft Parse %: 98.93 Execute to Parse %: 68.70 Latch Hit %: 100.00 Parse CPU to Parse Elapsd %: 98.73 % Non-Parse CPU: 97.79 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 67.03 64.69 % SQL with executions>1: 94.10 93.57 % Memory for SQL w/exec>1: 88.38 88.74 Top 5 Timed Events Avg %Total ~~~~~~~~~~~~~~~~~~ wait Call Event Waits Time (s) (ms) Time Wait Class ------------------------------ ------------ ----------- ------ ------ ---------- CPU time 35 30.5 db file sequential read 9,515 27 3 23.3 User I/O db file scattered read 4,721 16 3 14.2 User I/O os thread startup 44 3 67 2.5 Concurrenc log file parallel write 960 3 3 2.4 System I/O ------------------------------------------------------------- Time Model Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total time in database user-calls (DB Time): 115.7s -> 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 114.2 98.7 PL/SQL execution elapsed time 43.6 37.7 DB CPU 35.3 30.5 parse time elapsed 1.7 1.5 hard parse elapsed time 1.3 1.2 connection management call elapsed time 0.8 .7 hard parse (sharing criteria) elapsed time 0.7 .6 PL/SQL compilation elapsed time 0.2 .2 repeated bind elapsed time 0.0 .0 hard parse (bind mismatch) elapsed time 0.0 .0 sequence load elapsed time 0.0 .0 DB time 115.7 N/A background elapsed time 77.4 N/A background cpu time 66.9 N/A ------------------------------------------------------------- Wait Class DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 14,301 .0 43 3 19.2 System I/O 9,223 .0 9 1 12.4 Concurrency 44 .0 3 67 0.1 Commit 213 .0 1 3 0.3 Network 29,723 .0 0 0 39.8 Other 44 .0 0 1 0.1 Application 10 .0 0 1 0.0 ------------------------------------------------------------- Wait Events DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 9,515 .0 27 3 12.8 db file scattered read 4,721 .0 16 3 6.3 os thread startup 44 .0 3 67 0.1 log file parallel write 960 .0 3 3 1.3 control file parallel write 1,240 .0 3 2 1.7 db file parallel write 1,844 .0 2 1 2.5 control file sequential read 5,179 .0 1 0 6.9 log file sync 213 .0 1 3 0.3 SQL*Net more data to client 4,206 .0 0 0 5.6 SQL*Net more data from clien 215 .0 0 0 0.3 latch free 6 .0 0 4 0.0 SQL*Net message to client 25,302 .0 0 0 33.9 local write wait 7 .0 0 2 0.0 direct path write temp 45 .0 0 0 0.1 enq: RO - fast object reuse 2 .0 0 3 0.0 direct path write 13 .0 0 0 0.0 LGWR wait for redo copy 36 .0 0 0 0.0 SQL*Net break/reset to clien 8 .0 0 0 0.0 reliable message 2 .0 0 0 0.0 SQL*Net message from client 25,301 .0 24,146 954 33.9 Streams AQ: waiting for time 25 100.0 16,150 645983 0.0 jobq slave wait 1,215 98.3 3,516 2894 1.6 Streams AQ: qmn coordinator 384 33.9 3,513 9148 0.5 Streams AQ: qmn slave idle w 144 .0 3,513 24394 0.2 class slave wait 4 .0 0 0 0.0 ------------------------------------------------------------- Background Wait Events DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> ordered by wait time desc, waits desc (idle events last) Avg %Time Total Wait wait Waits Event Waits -outs Time (s) (ms) /txn ---------------------------- -------------- ------ ----------- ------- --------- os thread startup 44 .0 3 67 0.1 log file parallel write 961 .0 3 3 1.3 control file parallel write 1,240 .0 3 2 1.7 db file parallel write 1,844 .0 2 1 2.5 control file sequential read 2,654 .0 0 0 3.6 db file sequential read 15 .0 0 8 0.0 events in waitclass Other 41 .0 0 0 0.1 rdbms ipc message 15,983 94.7 48,123 3011 21.4 Streams AQ: waiting for time 25 100.0 16,150 645983 0.0 pmon timer 1,235 100.0 3,520 2850 1.7 Streams AQ: qmn coordinator 384 33.9 3,513 9148 0.5 Streams AQ: qmn slave idle w 144 .0 3,513 24394 0.2 smon timer 37 24.3 3,231 87313 0.0 ------------------------------------------------------------- Operating System Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 Statistic Total -------------------------------- -------------------- AVG_BUSY_TIME 22,645 AVG_IDLE_TIME 338,374 AVG_IOWAIT_TIME 0 AVG_SYS_TIME 13,284 AVG_USER_TIME 9,240 BUSY_TIME 728,435 IDLE_TIME 10,831,639 IOWAIT_TIME 0 SYS_TIME 428,949 USER_TIME 299,486 LOAD 1 OS_CPU_WAIT_TIME 5,800 RSRC_MGR_CPU_WAIT_TIME 0 VM_IN_BYTES 2,070,585,344 VM_OUT_BYTES 0 PHYSICAL_MEMORY_BYTES 67,467,059,200 NUM_CPUS 32 ------------------------------------------------------------- Service Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> ordered by DB Time Physical Logical Service Name DB Time (s) DB CPU (s) Reads Reads -------------------------------- ------------ ------------ ---------- ---------- SYS$USERS 84.0 21.6 8,391 576,268 ORAMARSP.IM.AWM.JPMC.NET 31.7 13.7 44,388 645,779 SYS$BACKGROUND 0.0 0.0 138 19,873 ------------------------------------------------------------- Service Wait Class Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 7044 1982 0 0 0 0 2759 1 ORAMARSP.IM.AWM.JPMC.NET 7083 2257 0 0 0 0 25975 11 SYS$BACKGROUND 172 104 44 293 0 0 0 0 ------------------------------------------------------------- SQL ordered by Elapsed Time DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 ---------- ---------- ------------ ---------- ------- ------------- 40 1 4 10.0 34.7 5wtd81k0hzgr2 Module: Foglight for Oracle <5.5.4.559> select greatest(count(*) - :1,0) "number_of_rows_to_skip" from Q_ALERT_LOG_ORAMA RSP 13 6 1 12.9 11.2 cvj1zjwg3n3w5 Module: WIReportServer.bin@ct5lp003 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_LONG_NM, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURIT Y_ID, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURITY_TYPE_NM, SMART.VW_FUND_HIE 11 1 1 10.7 9.2 cbhaqfhstf2x3 Module: Foglight for Oracle <5.5.4.559> SELECT * FROM (SELECT t.name tablespace_name, t.blocksize blo ck_size, fs.fully_usable, fs.unusable, fs.partly_usa ble, CASE WHEN DECODE (t.contents$,0,(DECODE (BITAND (t.fla gs, 16), 16, 'UNDO', 'PERMANENT')),1, 'TEMPORARY') = 'TEMPORARY' AND DECODE (t.b 9 2 1 9.2 8.0 bb5yx09ku4nqw Module: pmdtm@z1s40iminfmp (TNS V1-V3) SELECT MAX(AMP_UPDATED_ON) FROM SRC_AMP_ACCOUNT_MASTER 4 1 2 1.9 3.4 5rgtwvm0w5g81 Module: Foglight for Oracle <5.5.4.559> SELECT file_name as datafile_name, tablespace_name as tablespace_name, d.file_id , autoextensible as auto_extensible, status, maxbytes/1024/1024 max_size, dec ode(substr(file_name,1,1),'+','YES','NO') is_asm_file, nvl(BYTES,0) / 10 24/1024 + 0 size_megabytes, (nvl(BYTES,0) - nvl(freebytes,0))/1024/1024 3 3 20,427 0.0 3.0 9mnxkqw7rhy94 Module: pmdtm@z1s40iminfmp (TNS V1-V3) UPDATE MARSODS.SRC_AMP_ACCOUNT_MASTER SET SHORT_NM = :1, LONG_NM = :2, AMP_UPDAT ED_ON = :3, UPDATE_TS = :4 WHERE SOURCE_SYSTEM_CD = :5 AND ACCOUNT_NO = :6 AND F UND_CD = :7 AND SHARE_CLASS = :8 AND ALT_PRODUCT_CD = :9 AND INSIDE_HOLDING_FUND _CD = :10 AND RECORD_TYPE_CD = :11 3 1 1 3.4 2.9 9pda1bu5svhk3 BEGIN MARSODS.GUI_GRD_GENERAL.GET_GEN_EDITOR_TREE(:1,:2); END; 3 0 1 2.7 2.3 gugr82fp3vdw7 SELECT COUNT(*) FROM GEI_ACCOUNT_PROFILE_AUDIT WHERE ROW_IMG_CD = :1 AND STATUS_ CD IN(:2,:3,:4) 2 2 67 0.0 2.0 9kgsxkyxfaazm Module: EventManger1.1 CALL MARSODS.EVENT_MGR.ADMIN_DEQUEUE_SP(:1) 2 2 2 1.1 1.8 fmvx1zmndbr7k WITH ENTITY_CLASSES AS ( SELECT ENTITY_CLASS FROM MARSODS.HRCHY_ENTITY_REL_DEF W HERE HRCHY_CD = :B1 ), ENTITY_INST AS ( SELECT /*+ materialize */ EI.ENTITY_CLAS S , EI.ENTITY_CD , EI.SRC_ENTITY_CD , EI.ALT_ENTITY_CD , EI.ENTITY_NM , EI.LGCL_ DEL_FL FROM MARSODS.HRCHY_ENTITY_INST EI WHERE EI.ENTITY_CLASS IN ( SELECT ENTIT 2 1 1 1.8 1.5 0kgwbsvyuvmfy Module: WIReportServer.bin@ct5lp006 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.VW_DAILY_FLOWS_FACT.RECORD_TYPE, SMART.VW_DAI LY_FLOWS_FACT.AS_OF_DT, SMART.VW_DAILY_FLOWS_FACT.TRANSACTION_DT, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_LONG_NM, SQL ordered by Elapsed Time DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 1 4 0.3 1.2 b5wtbu053m5na BEGIN MARSODS.GUI_GRD_SCREEN_DETAILS.EDITOR(:1,:2,:3,NULL,NULL,:4); END; 1 1 12 0.1 1.1 ar09fmjrvr9pv Module: Foglight for Oracle <5.5.4.559> select e.event# as event_id,s.event wait_type,s.time_waited/100 + 0 as wait_time ,'' as main_category,'' as sub_category from sys.v_$system_event s, sys.v_$event _name e where e.name = s.event ------------------------------------------------------------- SQL ordered by CPU Time DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 ---------- ---------- ------------ ----------- ------- ------------- 6 13 1 6.06 11.2 cvj1zjwg3n3w5 Module: WIReportServer.bin@ct5lp003 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_LONG_NM, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURIT Y_ID, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURITY_TYPE_NM, SMART.VW_FUND_HIE 3 3 20,427 0.00 3.0 9mnxkqw7rhy94 Module: pmdtm@z1s40iminfmp (TNS V1-V3) UPDATE MARSODS.SRC_AMP_ACCOUNT_MASTER SET SHORT_NM = :1, LONG_NM = :2, AMP_UPDAT ED_ON = :3, UPDATE_TS = :4 WHERE SOURCE_SYSTEM_CD = :5 AND ACCOUNT_NO = :6 AND F UND_CD = :7 AND SHARE_CLASS = :8 AND ALT_PRODUCT_CD = :9 AND INSIDE_HOLDING_FUND _CD = :10 AND RECORD_TYPE_CD = :11 2 2 2 1.05 1.8 fmvx1zmndbr7k WITH ENTITY_CLASSES AS ( SELECT ENTITY_CLASS FROM MARSODS.HRCHY_ENTITY_REL_DEF W HERE HRCHY_CD = :B1 ), ENTITY_INST AS ( SELECT /*+ materialize */ EI.ENTITY_CLAS S , EI.ENTITY_CD , EI.SRC_ENTITY_CD , EI.ALT_ENTITY_CD , EI.ENTITY_NM , EI.LGCL_ DEL_FL FROM MARSODS.HRCHY_ENTITY_INST EI WHERE EI.ENTITY_CLASS IN ( SELECT ENTIT 2 2 67 0.03 2.0 9kgsxkyxfaazm Module: EventManger1.1 CALL MARSODS.EVENT_MGR.ADMIN_DEQUEUE_SP(:1) 2 9 1 1.96 8.0 bb5yx09ku4nqw Module: pmdtm@z1s40iminfmp (TNS V1-V3) SELECT MAX(AMP_UPDATED_ON) FROM SRC_AMP_ACCOUNT_MASTER 1 1 12 0.10 1.1 ar09fmjrvr9pv Module: Foglight for Oracle <5.5.4.559> select e.event# as event_id,s.event wait_type,s.time_waited/100 + 0 as wait_time ,'' as main_category,'' as sub_category from sys.v_$system_event s, sys.v_$event _name e where e.name = s.event 1 11 1 1.20 9.2 cbhaqfhstf2x3 Module: Foglight for Oracle <5.5.4.559> SELECT * FROM (SELECT t.name tablespace_name, t.blocksize blo ck_size, fs.fully_usable, fs.unusable, fs.partly_usa ble, CASE WHEN DECODE (t.contents$,0,(DECODE (BITAND (t.fla gs, 16), 16, 'UNDO', 'PERMANENT')),1, 'TEMPORARY') = 'TEMPORARY' AND DECODE (t.b 1 1 2 0.55 1.0 cn89b46m3guqu BEGIN MARSODS.GUI_HRCHY_MAINT.PR_SEARCH_REFERENCE_DETAILS(:1,:2,:3,:4,:5,:6,:7,: 8,:9,NULL,:10); END; 1 1 4 0.23 0.8 2w7jf05bx6guf Module: Foglight for Oracle <5.5.4.559> SELECT /*+RULE*/ HASH_VALUE, CHILD_NUMBER, TO_DATE(FIRST_LOAD_TIME,'YYYY-MM-DD/H H24:MI:SS') FIRST_LOAD_TIME, SORTS, FETCHES, EXECUTIONS, LOADS, PX_SERVE RS_EXECUTIONS, ROWS_PROCESSED, PARSE_CALLS, DISK_READS, DIRECT_WRITES, BUFFER_GETS, CPU_TIME/1000000 CPU_TIME, (APPLICATION_WAIT_TIME+C 1 1 4 0.22 1.2 b5wtbu053m5na BEGIN MARSODS.GUI_GRD_SCREEN_DETAILS.EDITOR(:1,:2,:3,NULL,NULL,:4); END; 1 2 1 0.72 1.5 0kgwbsvyuvmfy Module: WIReportServer.bin@ct5lp006 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.VW_DAILY_FLOWS_FACT.RECORD_TYPE, SMART.VW_DAI LY_FLOWS_FACT.AS_OF_DT, SMART.VW_DAILY_FLOWS_FACT.TRANSACTION_DT, SMART.ACCO SQL ordered by CPU Time DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 ---------- ---------- ------------ ----------- ------- ------------- UNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_LONG_NM, 1 3 1 0.65 2.9 9pda1bu5svhk3 BEGIN MARSODS.GUI_GRD_GENERAL.GET_GEN_EDITOR_TREE(:1,:2); END; 1 40 4 0.16 34.7 5wtd81k0hzgr2 Module: Foglight for Oracle <5.5.4.559> select greatest(count(*) - :1,0) "number_of_rows_to_skip" from Q_ALERT_LOG_ORAMA RSP 1 4 2 0.26 3.4 5rgtwvm0w5g81 Module: Foglight for Oracle <5.5.4.559> SELECT file_name as datafile_name, tablespace_name as tablespace_name, d.file_id , autoextensible as auto_extensible, status, maxbytes/1024/1024 max_size, dec ode(substr(file_name,1,1),'+','YES','NO') is_asm_file, nvl(BYTES,0) / 10 24/1024 + 0 size_megabytes, (nvl(BYTES,0) - nvl(freebytes,0))/1024/1024 0 3 1 0.17 2.3 gugr82fp3vdw7 SELECT COUNT(*) FROM GEI_ACCOUNT_PROFILE_AUDIT WHERE ROW_IMG_CD = :1 AND STATUS_ CD IN(:2,:3,:4) ------------------------------------------------------------- SQL ordered by Gets DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 1,242,555 -> Captured SQL account for 91.5% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 301,355 1 301,355.0 24.3 6.06 12.93 cvj1zjwg3n3w5 Module: WIReportServer.bin@ct5lp003 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_LONG_NM, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURIT Y_ID, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURITY_TYPE_NM, SMART.VW_FUND_HIE 209,271 20,427 10.2 16.8 2.55 3.47 9mnxkqw7rhy94 Module: pmdtm@z1s40iminfmp (TNS V1-V3) UPDATE MARSODS.SRC_AMP_ACCOUNT_MASTER SET SHORT_NM = :1, LONG_NM = :2, AMP_UPDAT ED_ON = :3, UPDATE_TS = :4 WHERE SOURCE_SYSTEM_CD = :5 AND ACCOUNT_NO = :6 AND F UND_CD = :7 AND SHARE_CLASS = :8 AND ALT_PRODUCT_CD = :9 AND INSIDE_HOLDING_FUND _CD = :10 AND RECORD_TYPE_CD = :11 113,703 67 1,697.1 9.2 2.10 2.35 9kgsxkyxfaazm Module: EventManger1.1 CALL MARSODS.EVENT_MGR.ADMIN_DEQUEUE_SP(:1) 75,898 1 75,898.0 6.1 0.65 3.41 9pda1bu5svhk3 BEGIN MARSODS.GUI_GRD_GENERAL.GET_GEN_EDITOR_TREE(:1,:2); END; 59,735 1 59,735.0 4.8 0.72 1.76 0kgwbsvyuvmfy Module: WIReportServer.bin@ct5lp006 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.VW_DAILY_FLOWS_FACT.RECORD_TYPE, SMART.VW_DAI LY_FLOWS_FACT.AS_OF_DT, SMART.VW_DAILY_FLOWS_FACT.TRANSACTION_DT, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_LONG_NM, 56,972 2 28,486.0 4.6 0.73 0.91 dt1254rccxkvj BEGIN MARSODS.GUI_FLEX_REPORTS.GET_REPORT_TREE(:1,:2); END; 39,746 2 19,873.0 3.2 0.51 3.88 5rgtwvm0w5g81 Module: Foglight for Oracle <5.5.4.559> SELECT file_name as datafile_name, tablespace_name as tablespace_name, d.file_id , autoextensible as auto_extensible, status, maxbytes/1024/1024 max_size, dec ode(substr(file_name,1,1),'+','YES','NO') is_asm_file, nvl(BYTES,0) / 10 24/1024 + 0 size_megabytes, (nvl(BYTES,0) - nvl(freebytes,0))/1024/1024 37,842 6 6,307.0 3.0 0.70 0.72 2nqq64nmafmy4 SELECT M.MOD_CD , M.MOD_NM , M.MOD_DESC , M.TABLE_NM , RD.SRCH_NM , RD.SRCH_DESC , RD.DB AS SRCH_DB , RD.DELETE_FL , RD.REPL_MOD_CD , RD.REPL_MOD_CD , RI.CTRL_C LASS , RI.CTRL_CD , RI.CTRL_PROP_CD , RI.CTRL_PROP_VALUE , CD.PROP_REQ_FL , CD.P ROP_DESC , CD.UI_IGNORE_FL , MI.ATTR_VALUE AS MODULE_ICON , COALESCE(SB.ATTR_VAL 37,446 67 558.9 3.0 0.68 0.69 f8gvcrw0cm64z Module: EventManger1.1 SELECT COUNT(*) FROM VW_EVENT_INST A WHERE LOWER(RTRIM(A.STATUS)) = 'new' AND LO WER(RTRIM(A.FREQ_TYPE)) IN ('auto', 'once') AND NVL(A.START_TS, SYSDATE) <= SYSD ATE AND (NVL(RTRIM(A.DEPENDS), ' ') = ' ' OR A.DEPENDS IN ( SELECT EVENT_ID FROM EVENT_INST B WHERE B.STATUS IN ('completed', 'complete', 'success') ) ) AND ( L 33,500 67 500.0 2.7 0.51 0.55 7t8uydg30vrmv Module: EventManger1.1 UPDATE EVENT_INST SET STATUS = 'removed' WHERE LOWER(RTRIM(STATUS)) IN ('complet ed', 'cancelled', 'failed') AND END_TS IS NOT NULL AND END_TS < :B1 33,500 67 500.0 2.7 0.52 0.52 bzgd6xbk0nqzq Module: EventManger1.1 SELECT COUNT(*) FROM EVENT_INST WHERE RTRIM(LOWER(STATUS)) = 'active' SQL ordered by Gets DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. -> Total Buffer Gets: 1,242,555 -> Captured SQL account for 91.5% of Total Gets CPU Elapsed Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ------------ ------------ ------ -------- --------- ------------- 26,956 2 13,478.0 2.2 0.38 0.56 6avdpmx9zsuvf INSERT INTO MARSODS.TMP_GRD_RPT_TREE ( HRCHY_CD , HRCHY_NM , ENTITY_CLASS , ENTI TY_CLASS_NM , ALT_ENTITY_CD , ENTITY_CD , ENTITY_NM , PARENT_ENTITY_CLASS , PARE NT_ENTITY_CD , CHILD_CLASS , REPORT_DESC , HIDE_FL , SEARCH_FL , ISLEAF ) WITH R ECENT_RPTS AS ( SELECT DISTINCT CASE WHEN EL.LOG_NAME = 'GUI_GRD_SCREEN_DETAILS' 26,035 8 3,254.4 2.1 0.53 0.53 db06n2f7wg75p SELECT M.MOD_CD , M.MOD_NM , M.MOD_DESC , M.TABLE_NM , ED.EDIT_NM , ED.EDIT_DESC , ED.DB AS EDIT_DB , ED.APPROVE_FL , ED.DELETE_FL , ES.SEC_CD , ES.SEC_NM , ES. SEC_DESC , ES.SORT_ORDER AS SEC_SORT_ORDER , ES.IS_COLLAPSED , EI.CTRL_CLASS , E I.CTRL_CD , EI.CTRL_PROP_CD , EI.CTRL_PROP_VALUE , CD.PROP_REQ_FL , CD.PROP_DESC 23,730 1 23,730.0 1.9 1.96 9.23 bb5yx09ku4nqw Module: pmdtm@z1s40iminfmp (TNS V1-V3) SELECT MAX(AMP_UPDATED_ON) FROM SRC_AMP_ACCOUNT_MASTER 20,321 1 20,321.0 1.6 0.44 0.73 daaabsyuh1149 WITH UI_TREE AS ( SELECT LEVEL AS LVL , HRCHY_CD , HRCHY_NM , ENTITY_CLASS , ENT ITY_CLASS_NM , ENTITY_CD , ENTITY_NM , PARENT_ENTITY_CLASS , PARENT_ENTITY_CD , CHILD_CLASS , HIDE_FL , CREATE_NEW_FL , SEARCH_FL , WORKQ_FL , AUDIT_FL , TABLE_ NM , PENDING_ROWS FROM TMP_GRD_TREE START WITH PARENT_ENTITY_CD IS NULL CONNECT 18,907 4 4,726.8 1.5 0.89 1.39 b5wtbu053m5na BEGIN MARSODS.GUI_GRD_SCREEN_DETAILS.EDITOR(:1,:2,:3,NULL,NULL,:4); END; 17,134 2 8,567.0 1.4 0.14 0.14 axxuy07k0fny3 UPDATE MARSODS.TMP_GRD_RPT_TREE SET SEARCH_FL = (SELECT NVL(MAX(VIEW_FL),'N') FR OM MARSODS.VW_USER_PRIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_ CD = TMP_GRD_RPT_TREE.ALT_ENTITY_CD ) WHERE 1=1 AND EXISTS (SELECT VIEW_FL FROM MARSODS.VW_USER_PRIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD 16,374 1 16,374.0 1.3 1.20 10.66 cbhaqfhstf2x3 Module: Foglight for Oracle <5.5.4.559> SELECT * FROM (SELECT t.name tablespace_name, t.blocksize blo ck_size, fs.fully_usable, fs.unusable, fs.partly_usa ble, CASE WHEN DECODE (t.contents$,0,(DECODE (BITAND (t.fla gs, 16), 16, 'UNDO', 'PERMANENT')),1, 'TEMPORARY') = 'TEMPORARY' AND DECODE (t.b 15,386 2 7,693.0 1.2 0.40 0.75 fdv6qxz00rcdf Module: SQL*Plus select 'ORAMARSP' ||'~'|| df.tablespace_name ||'~'|| df.Total_Meg ||'~'|| nvl(fs.Free_Meg,0) ||'~'|| trunc(100 - (nvl(fs.Free_Meg,0)/df.Total_Meg)*100, 0) ||'~'|| to_char(sysdate,'DD-MON-YYYY:HH24:MI' )||'*' tbs_report from ( select tablespace_name, trunc(sum(bytes)/(1024*1024),0) Free_Meg 14,945 1 14,945.0 1.2 0.10 0.10 4anbgy8g8gp3c UPDATE TMP_GRD_TREE SET SEARCH_FL = (SELECT NVL(MAX(VIEW_FL),'N') FROM VW_USER_P RIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_TREE.EN TITY_CD ) WHERE TMP_GRD_TREE.SEARCH_FL = 'Y' AND EXISTS (SELECT VIEW_FL FROM VW_ USER_PRIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_T 14,294 11 1,299.5 1.2 0.42 0.50 ggdu1fgg5jkmu WITH NEW_INSTANCE AS ( SELECT 'NEW' AS "Extract ID" , :B1 AS "Report Name " , MARSODS.GET_GRD_MODULE_LINK ('Create New Instance' , 'Click here to schedule a new intance of data extract for ' || :B1 , 'etlx_common' , 'hidExtractCD=' || :B2 || ';' || 'rptTitle=Create New Instance of ' || :B1 || ';' || 'rptDesc=Clic ------------------------------------------------------------- SQL ordered by Reads DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total Disk Reads: 52,933 -> Captured SQL account for 98.5% of Total Reads CPU Elapsed Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id -------------- ----------- ------------- ------ -------- --------- ------------- 28,373 1 28,373.0 53.6 6.06 12.93 cvj1zjwg3n3w5 Module: WIReportServer.bin@ct5lp003 (TNS V1-V3) SELECT SMART.VW_SOURCE_SYSTEM_DIMENSION2.SOURCE_SYSTEM_CD, WEEK_DIMENSION2.R EPORTING_WEEK_ENDING_DT, SMART.ACCOUNT_FUND_DIMENSION.ACCOUNT_CD, SMART.ACCO UNT_FUND_DIMENSION.ACCOUNT_LONG_NM, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURIT Y_ID, SMART.VW_FUND_HIERARCHY_DIMENSION2.SECURITY_TYPE_NM, SMART.VW_FUND_HIE 13,755 1 13,755.0 26.0 1.96 9.23 bb5yx09ku4nqw Module: pmdtm@z1s40iminfmp (TNS V1-V3) SELECT MAX(AMP_UPDATED_ON) FROM SRC_AMP_ACCOUNT_MASTER 5,134 1 5,134.0 9.7 1.20 10.66 cbhaqfhstf2x3 Module: Foglight for Oracle <5.5.4.559> SELECT * FROM (SELECT t.name tablespace_name, t.blocksize blo ck_size, fs.fully_usable, fs.unusable, fs.partly_usa ble, CASE WHEN DECODE (t.contents$,0,(DECODE (BITAND (t.fla gs, 16), 16, 'UNDO', 'PERMANENT')),1, 'TEMPORARY') = 'TEMPORARY' AND DECODE (t.b 1,563 2 781.5 3.0 2.11 2.11 fmvx1zmndbr7k WITH ENTITY_CLASSES AS ( SELECT ENTITY_CLASS FROM MARSODS.HRCHY_ENTITY_REL_DEF W HERE HRCHY_CD = :B1 ), ENTITY_INST AS ( SELECT /*+ materialize */ EI.ENTITY_CLAS S , EI.ENTITY_CD , EI.SRC_ENTITY_CD , EI.ALT_ENTITY_CD , EI.ENTITY_NM , EI.LGCL_ DEL_FL FROM MARSODS.HRCHY_ENTITY_INST EI WHERE EI.ENTITY_CLASS IN ( SELECT ENTIT 1,221 3 407.0 2.3 0.14 0.81 cc9yxwn282qn4 Module: pmdtm@z1s40iminfmp (TNS V1-V3) SELECT COUNT(*) AS TRANS_ID FROM MARSODS.HRCHY_AUDIT HRCHY_AUDIT 533 2 266.5 1.0 0.40 0.75 fdv6qxz00rcdf Module: SQL*Plus select 'ORAMARSP' ||'~'|| df.tablespace_name ||'~'|| df.Total_Meg ||'~'|| nvl(fs.Free_Meg,0) ||'~'|| trunc(100 - (nvl(fs.Free_Meg,0)/df.Total_Meg)*100, 0) ||'~'|| to_char(sysdate,'DD-MON-YYYY:HH24:MI' )||'*' tbs_report from ( select tablespace_name, trunc(sum(bytes)/(1024*1024),0) Free_Meg 490 2 245.0 0.9 0.51 3.88 5rgtwvm0w5g81 Module: Foglight for Oracle <5.5.4.559> SELECT file_name as datafile_name, tablespace_name as tablespace_name, d.file_id , autoextensible as auto_extensible, status, maxbytes/1024/1024 max_size, dec ode(substr(file_name,1,1),'+','YES','NO') is_asm_file, nvl(BYTES,0) / 10 24/1024 + 0 size_megabytes, (nvl(BYTES,0) - nvl(freebytes,0))/1024/1024 484 1 484.0 0.9 0.65 3.41 9pda1bu5svhk3 BEGIN MARSODS.GUI_GRD_GENERAL.GET_GEN_EDITOR_TREE(:1,:2); END; 445 1 445.0 0.8 0.17 2.72 gugr82fp3vdw7 SELECT COUNT(*) FROM GEI_ACCOUNT_PROFILE_AUDIT WHERE ROW_IMG_CD = :1 AND STATUS_ CD IN(:2,:3,:4) 271 2 135.5 0.5 1.10 1.11 cn89b46m3guqu BEGIN MARSODS.GUI_HRCHY_MAINT.PR_SEARCH_REFERENCE_DETAILS(:1,:2,:3,:4,:5,:6,:7,: 8,:9,NULL,:10); END; ------------------------------------------------------------- SQL ordered by Executions DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total Executions: 35,701 -> Captured SQL account for 80.8% of Total CPU per Elap per Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id ------------ --------------- -------------- ---------- ----------- ------------- 20,427 20,427 1.0 0.00 0.00 9mnxkqw7rhy94 Module: pmdtm@z1s40iminfmp (TNS V1-V3) UPDATE MARSODS.SRC_AMP_ACCOUNT_MASTER SET SHORT_NM = :1, LONG_NM = :2, AMP_UPDAT ED_ON = :3, UPDATE_TS = :4 WHERE SOURCE_SYSTEM_CD = :5 AND ACCOUNT_NO = :6 AND F UND_CD = :7 AND SHARE_CLASS = :8 AND ALT_PRODUCT_CD = :9 AND INSIDE_HOLDING_FUND _CD = :10 AND RECORD_TYPE_CD = :11 2,291 3,124 1.4 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 1,538 1,538 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 395 395 1.0 0.00 0.00 17aqmh9ygytt5 SELECT COUNT(*) FROM MARSODS.MARS_SETTINGS WHERE UPPER(SID) = UPPER(:B2 ) AND UP PER(SETTING_NM) = UPPER(:B1 ) 395 395 1.0 0.00 0.00 7jy6k3wyd28su SELECT MAX(SETTING_VALUE) FROM MARS_SETTINGS WHERE UPPER(SID) = UPPER(:B2 ) AND UPPER(SETTING_NM) = UPPER(:B1 ) 287 287 1.0 0.00 0.00 47mnjvqncaf79 SELECT COUNT (*) FROM MARSODS.NEXT_ITEM WHERE ITEM_NM = :B1 287 287 1.0 0.00 0.00 7jtxm8bz4xm19 UPDATE MARSODS.NEXT_ITEM NI SET NI.ITEM_ID = ITEM_ID + 1 , NI.LAST_USED_TS = SYS DATE WHERE ITEM_NM = :B1 287 287 1.0 0.00 0.00 b57ks6uuvxxy1 SELECT ITEM_ID FROM MARSODS.NEXT_ITEM WHERE ITEM_NM = :B1 246 246 1.0 0.00 0.00 15bh2uyydw634 INSERT INTO MARSODS.EVENT_LOG ( SID, LOG_NAME, LOG_DESC, LOG_COL1, LOG_COL2, LOG _COL3, LOG_COL4, LOG_COL5, LOG_COL6, LOG_COL7, LOG_UI_ID ) SELECT :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL 218 218 1.0 0.00 0.00 0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE _NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') ------------------------------------------------------------- SQL ordered by Parse Calls DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total Parse Calls: 11,174 -> Captured SQL account for 60.8% of Total % Total Parse Calls Executions Parses SQL Id ------------ ------------ --------- ------------- 2,291 2,291 20.50 0h6b2sajwb74n select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p rivilege#>0 start with grantee#=:1 and privilege#>0 1,538 1,538 13.76 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 218 218 1.95 0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_ NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE _NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') 218 218 1.95 459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME' 218 218 1.95 5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE ', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 209 209 1.87 05uqdabhzncdc select role# from defrole$ d,user$ u where d.user#=:1 and u.user#=d.user# and u. defrole=2 union select privilege# from sysauth$ s,user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where use r#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 165 165 1.48 350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait 165 165 1.48 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 89 89 0.80 ardtrztqc3q9c SELECT DBTIMEZONE FROM DUAL 88 88 0.79 bsa0wjtftg3uw select file# from file$ where ts#=:1 ------------------------------------------------------------- SQL ordered by Sharable Memory DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id ---------------- ------------ -------- ------------- 1,666,006 1 0.22 fh1daqqkjfm0k UPDATE TMP_GRD_TREE SET AUDIT_FL = (SELECT NVL(MAX(VIEW_FL),'N') FROM VW_USER_PR IVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_TREE.ENT ITY_CD ) WHERE TMP_GRD_TREE.AUDIT_FL = 'Y' AND EXISTS (SELECT VIEW_FL FROM VW_US ER_PRIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_TRE 1,290,529 1 0.17 31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as tim e_secs, operation FROM ( SELECT 1 as source, trunc((s ysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 1,249,496 1 0.16 4anbgy8g8gp3c UPDATE TMP_GRD_TREE SET SEARCH_FL = (SELECT NVL(MAX(VIEW_FL),'N') FROM VW_USER_P RIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_TREE.EN TITY_CD ) WHERE TMP_GRD_TREE.SEARCH_FL = 'Y' AND EXISTS (SELECT VIEW_FL FROM VW_ USER_PRIVS WHERE VW_USER_PRIVS.SID = :B1 AND VW_USER_PRIVS.ACCESS_CD = TMP_GRD_T 1,247,620 18 0.16 78m9ryygp65v5 Module: RSQL.exe SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 A ND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$x d_%') AND V.FUNCTION = :B1 1,120,488 2 0.15 fdv6qxz00rcdf Module: SQL*Plus select 'ORAMARSP' ||'~'|| df.tablespace_name ||'~'|| df.Total_Meg ||'~'|| nvl(fs.Free_Meg,0) ||'~'|| trunc(100 - (nvl(fs.Free_Meg,0)/df.Total_Meg)*100, 0) ||'~'|| to_char(sysdate,'DD-MON-YYYY:HH24:MI' )||'*' tbs_report from ( select tablespace_name, trunc(sum(bytes)/(1024*1024),0) Free_Meg ------------------------------------------------------------- SQL ordered by Version Count DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Only Statements with Version Count greater than 20 are displayed Version Count Executions SQL Id -------- ------------ ------------- 747 246 15bh2uyydw634 INSERT INTO MARSODS.EVENT_LOG ( SID, LOG_NAME, LOG_DESC, LOG_COL1, LOG_COL2, LOG _COL3, LOG_COL4, LOG_COL5, LOG_COL6, LOG_COL7, LOG_UI_ID ) SELECT :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL 189 287 47mnjvqncaf79 SELECT COUNT (*) FROM MARSODS.NEXT_ITEM WHERE ITEM_NM = :B1 149 287 7jtxm8bz4xm19 UPDATE MARSODS.NEXT_ITEM NI SET NI.ITEM_ID = ITEM_ID + 1 , NI.LAST_USED_TS = SYS DATE WHERE ITEM_NM = :B1 139 287 b57ks6uuvxxy1 SELECT ITEM_ID FROM MARSODS.NEXT_ITEM WHERE ITEM_NM = :B1 27 1 akh9zqqkx3wj7 select 1, max(id) from sys.wri$_adv_objects where task_id = :1 union all select 2, max(id) from sys.wri$_adv_recommendations where task_id = :1 union all sele ct 3, max(id) from sys.wri$_adv_actions where task_id = :1 union all select 4, max(id) from sys.wri$_adv_findings where task_id = :1 union all select 5, max(i 24 1 bhvyz9bgyrhb2 SELECT name,datatype,value,flags, nvl(description,'NULL') FROM sys.wri$_adv_para meters WHERE task_id = :1 ORDER BY 1 22 1 298ppdduqr7wm SELECT status FROM sys.wri$_adv_tasks WHERE id = :1 21 1 gdn3ysuyssf82 SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 ------------------------------------------------------------- Instance Activity Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- CPU used by this session 9,114 2.5 12.2 CPU used when call started 3,566 1.0 4.8 CR blocks created 20 0.0 0.0 Cached Commit SCN referenced 0 0.0 0.0 Commit SCN cached 0 0.0 0.0 DB time 375,529 104.0 503.4 DBWR checkpoint buffers written 3,231 0.9 4.3 DBWR checkpoints 2 0.0 0.0 DBWR object drop buffers written 6 0.0 0.0 DBWR revisited being-written buf 0 0.0 0.0 DBWR tablespace checkpoint buffe 0 0.0 0.0 DBWR thread checkpoint buffers w 0 0.0 0.0 DBWR transaction table writes 78 0.0 0.1 DBWR undo block writes 1,512 0.4 2.0 IMU CR rollbacks 0 0.0 0.0 IMU Flushes 169 0.1 0.2 IMU Redo allocation size 743,532 205.8 996.7 IMU commits 563 0.2 0.8 IMU contention 1 0.0 0.0 IMU ktichg flush 10 0.0 0.0 IMU pool not allocated 0 0.0 0.0 IMU recursive-transaction flush 1 0.0 0.0 IMU undo allocation size 2,990,816 827.9 4,009.1 IMU- failed to get a private str 0 0.0 0.0 SMON posted for undo segment shr 0 0.0 0.0 SQL*Net roundtrips to/from clien 24,567 6.8 32.9 active txn count during cleanout 780 0.2 1.1 application wait time 1 0.0 0.0 background checkpoints completed 0 0.0 0.0 background checkpoints started 0 0.0 0.0 background timeouts 15,140 4.2 20.3 branch node splits 1 0.0 0.0 buffer is not pinned count 458,082 126.8 614.1 buffer is pinned count 506,499 140.2 679.0 bytes received via SQL*Net from 5,693,797 1,576.2 7,632.4 bytes sent via SQL*Net to client 12,562,377 3,477.6 16,839.7 calls to get snapshot scn: kcmgs 88,155 24.4 118.2 calls to kcmgas 9,398 2.6 12.6 calls to kcmgcs 573 0.2 0.8 change write time 41 0.0 0.1 cleanout - number of ktugct call 978 0.3 1.3 cleanouts and rollbacks - consis 0 0.0 0.0 cleanouts only - consistent read 102 0.0 0.1 cluster key scan block gets 11,224 3.1 15.1 cluster key scans 4,535 1.3 6.1 commit batch/immediate performed 0 0.0 0.0 commit batch/immediate requested 0 0.0 0.0 commit cleanout failures: block 204 0.1 0.3 commit cleanout failures: buffer 0 0.0 0.0 commit cleanout failures: callba 158 0.0 0.2 commit cleanout failures: cannot 0 0.0 0.0 commit cleanouts 4,877 1.4 6.5 commit cleanouts successfully co 4,515 1.3 6.1 commit immediate performed 0 0.0 0.0 commit immediate requested 0 0.0 0.0 commit txn count during cleanout 704 0.2 0.9 concurrency wait time 293 0.1 0.4 consistent changes 7,574 2.1 10.2 consistent gets 1,052,907 291.5 1,411.4 consistent gets - examination 460,039 127.4 616.7 Instance Activity Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- consistent gets direct 10 0.0 0.0 consistent gets from cache 1,052,897 291.5 1,411.4 current blocks converted for CR 0 0.0 0.0 cursor authentications 47 0.0 0.1 data blocks consistent reads - u 14 0.0 0.0 db block changes 166,548 46.1 223.3 db block gets 189,648 52.5 254.2 db block gets direct 1,639 0.5 2.2 db block gets from cache 188,009 52.1 252.0 deferred (CURRENT) block cleanou 2,524 0.7 3.4 dirty buffers inspected 347 0.1 0.5 drop segment calls in space pres 0 0.0 0.0 enqueue conversions 732 0.2 1.0 enqueue releases 31,576 8.7 42.3 enqueue requests 31,583 8.7 42.3 enqueue timeouts 0 0.0 0.0 enqueue waits 2 0.0 0.0 exchange deadlocks 0 0.0 0.0 execute count 35,701 9.9 47.9 failed probes on index block rec 16 0.0 0.0 frame signature mismatch 0 0.0 0.0 free buffer inspected 51,587 14.3 69.2 free buffer requested 54,722 15.2 73.4 heap block compress 143 0.0 0.2 hot buffers moved to head of LRU 13,856 3.8 18.6 immediate (CR) block cleanout ap 102 0.0 0.1 immediate (CURRENT) block cleano 1,222 0.3 1.6 index crx upgrade (found) 0 0.0 0.0 index crx upgrade (positioned) 2,549 0.7 3.4 index fast full scans (full) 25 0.0 0.0 index fetch by key 303,925 84.1 407.4 index scans kdiixs1 31,515 8.7 42.3 leaf node 90-10 splits 14 0.0 0.0 leaf node splits 130 0.0 0.2 lob reads 0 0.0 0.0 lob writes 19 0.0 0.0 lob writes unaligned 19 0.0 0.0 local undo segment hints helped 0 0.0 0.0 logons cumulative 325 0.1 0.4 messages received 3,220 0.9 4.3 messages sent 3,221 0.9 4.3 no buffer to keep pinned count 0 0.0 0.0 no work - consistent read gets 526,205 145.7 705.4 opened cursors cumulative 11,567 3.2 15.5 parse count (failures) 0 0.0 0.0 parse count (hard) 120 0.0 0.2 parse count (total) 11,174 3.1 15.0 parse time cpu 78 0.0 0.1 parse time elapsed 79 0.0 0.1 physical read IO requests 14,075 3.9 18.9 physical read bytes 433,627,136 120,038.9 581,269.6 physical read total IO requests 19,435 5.4 26.1 physical read total bytes 545,545,216 151,020.6 731,293.9 physical read total multi block 4,761 1.3 6.4 physical reads 52,933 14.7 71.0 physical reads cache 52,923 14.7 70.9 physical reads cache prefetch 38,858 10.8 52.1 physical reads direct 10 0.0 0.0 physical reads direct (lob) 0 0.0 0.0 physical reads direct temporary 0 0.0 0.0 Instance Activity Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- physical reads prefetch warmup 0 0.0 0.0 physical write IO requests 2,048 0.6 2.8 physical write bytes 44,244,992 12,248.1 59,309.6 physical write total IO requests 7,734 2.1 10.4 physical write total bytes 160,018,432 44,297.1 214,501.9 physical write total multi block 2,237 0.6 3.0 physical writes 5,401 1.5 7.2 physical writes direct 1,639 0.5 2.2 physical writes direct (lob) 16 0.0 0.0 physical writes direct temporary 1,623 0.5 2.2 physical writes from cache 3,762 1.0 5.0 physical writes non checkpoint 4,141 1.2 5.6 pinned buffers inspected 0 0.0 0.0 prefetch clients - default 0 0.0 0.0 prefetch warmup blocks aged out 0 0.0 0.0 prefetched blocks aged out befor 0 0.0 0.0 process last non-idle time 4,198 1.2 5.6 recursive aborts on index block 0 0.0 0.0 recursive calls 119,220 33.0 159.8 recursive cpu usage 1,131 0.3 1.5 redo blocks written 53,522 14.8 71.8 redo buffer allocation retries 0 0.0 0.0 redo entries 82,344 22.8 110.4 redo log space requests 0 0.0 0.0 redo log space wait time 0 0.0 0.0 redo ordering marks 1,429 0.4 1.9 redo size 26,054,404 7,212.5 34,925.5 redo subscn max counts 1,934 0.5 2.6 redo synch time 58 0.0 0.1 redo synch writes 282 0.1 0.4 redo wastage 261,616 72.4 350.7 redo write time 250 0.1 0.3 redo writer latching time 0 0.0 0.0 redo writes 962 0.3 1.3 rollback changes - undo records 0 0.0 0.0 rollbacks only - consistent read 14 0.0 0.0 rows fetched via callback 193,617 53.6 259.5 session connect time 0 0.0 0.0 session cursor cache hits 4,813 1.3 6.5 session logical reads 1,242,555 344.0 1,665.6 session pga memory 91,607,552 25,359.3 122,798.3 session uga memory 266,299,043,640 73,718,263.4 ############# session uga memory max 320,756,968 88,793.6 429,969.1 shared hash latch upgrades - no 8,468 2.3 11.4 shared hash latch upgrades - wai 0 0.0 0.0 sorts (disk) 0 0.0 0.0 sorts (memory) 29,916 8.3 40.1 sorts (rows) 455,368 126.1 610.4 space was found by tune down 0 0.0 0.0 sql area evicted 4 0.0 0.0 sql area purged 6 0.0 0.0 steps of tune down ret. in space 0 0.0 0.0 summed dirty queue length 2,518 0.7 3.4 switch current to new buffer 185 0.1 0.3 table fetch by rowid 256,989 71.1 344.5 table fetch continued row 5,737 1.6 7.7 table scan blocks gotten 434,289 120.2 582.2 table scan rows gotten 22,543,443 6,240.6 30,219.1 table scans (direct read) 0 0.0 0.0 table scans (long tables) 2 0.0 0.0 Instance Activity Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- table scans (rowid ranges) 0 0.0 0.0 table scans (short tables) 23,095 6.4 31.0 total number of times SMON poste 28 0.0 0.0 transaction rollbacks 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 transaction tables consistent re 0 0.0 0.0 tune down retentions in space pr 0 0.0 0.0 undo change vector size 10,557,152 2,922.5 14,151.7 user I/O wait time 4,355 1.2 5.8 user calls 26,301 7.3 35.3 user commits 733 0.2 1.0 user rollbacks 13 0.0 0.0 workarea executions - onepass 0 0.0 0.0 workarea executions - optimal 26,715 7.4 35.8 write clones created in backgrou 7 0.0 0.0 write clones created in foregrou 0 0.0 0.0 ------------------------------------------------------------- Instance Activity Stats - Absolute ValuesDB/Inst: ORAMARSP/ORAMARSP Snaps: 3 -> Statistics with absolute values (should not be diffed) Statistic Begin Value End Value -------------------------------- --------------- --------------- session cursor cache count 7,333,606 7,336,504 opened cursors current 495 555 logons current 37 37 ------------------------------------------------------------- Instance Activity Stats - Thread ActivityDB/Inst: ORAMARSP/ORAMARSP Snaps: 38 -> Statistics identified by '(derived)' come from sources other than SYSSTAT Statistic Total per Hour -------------------------------- ------------------ --------- log switches (derived) 0 .00 ------------------------------------------------------------- Tablespace IO Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ MARSODS_DAT 4,671 1 3.3 3.4 743 0 0 0.0 SMART_DAT 4,076 1 3.5 7.4 4 0 0 0.0 SYSAUX 3,033 1 2.0 1.0 422 0 0 0.0 SYSTEM 1,398 0 3.1 1.0 169 0 0 0.0 MARSODS_IDX 472 0 5.9 1.0 343 0 0 0.0 UNDOTBS1 2 0 5.0 1.0 258 0 0 0.0 TEMP 135 0 0.3 12.0 109 0 0 0.0 AXIOM_DAT 160 0 3.3 1.0 0 0 0 0.0 SMART_IDX 63 0 2.4 1.0 0 0 0 0.0 USERS 45 0 5.8 1.0 0 0 0 0.0 ------------------------------------------------------------- File IO Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ AXIOM_DAT /cfs/dblinks/oramarsp/fs/usrdata1/axiom_dat_01.dbf 17 0 5.3 1.0 0 0 0 0.0 AXIOM_DAT /cfs/dblinks/oramarsp/fs/usrdata1/axiom_dat_02.dbf 120 0 2.8 1.0 0 0 0 0.0 AXIOM_DAT /cfs/dblinks/oramarsp/fs/usrdata1/axiom_dat_03.dbf 23 0 3.9 1.0 0 0 0 0.0 MARSODS_DAT /cfs/dblinks/oramarsp/fs/usrdata1/marsods_dat.dbf 2,360 1 3.3 3.4 421 0 0 0.0 MARSODS_DAT /cfs/dblinks/oramarsp/fs/usrdata1/marsods_dat02.dbf 2,311 1 3.3 3.4 322 0 0 0.0 MARSODS_IDX /cfs/dblinks/oramarsp/fs/usrindex1/marsods_idx.dbf 472 0 5.9 1.0 343 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_01.dbf 305 0 4.9 12.9 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_02.dbf 394 0 4.3 9.5 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_03.dbf 343 0 4.0 10.0 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_04.dbf 302 0 4.8 9.9 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_05.dbf 1,774 0 2.5 2.9 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_06.dbf 330 0 4.5 11.6 4 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_07.dbf 290 0 3.8 11.2 0 0 0 0.0 SMART_DAT /cfs/dblinks/oramarsp/fs/usrdata1/smart_dat_08.dbf 338 0 4.1 11.3 0 0 0 0.0 SMART_IDX /cfs/dblinks/oramarsp/fs/usrindex1/smart_idx_02.dbf 63 0 2.4 1.0 0 0 0 0.0 SYSAUX /cfs/dblinks/oramarsp/fs/sysdata1/sysaux01.dbf 3,033 1 2.0 1.0 422 0 0 0.0 SYSTEM /cfs/dblinks/oramarsp/fs/sysdata1/system01.dbf 1,398 0 3.1 1.0 169 0 0 0.0 TEMP /cfs/dblinks/oramarsp/fs/temp/temp01.dbf 18 0 0.0 2.1 28 0 0 N/A TEMP /cfs/dblinks/oramarsp/fs/temp/temp02.dbf 117 0 0.3 13.6 81 0 0 N/A UNDOTBS1 /cfs/dblinks/oramarsp/fs/undo/undotbs01.dbf 2 0 5.0 1.0 258 0 0 0.0 USERS /cfs/dblinks/oramarsp/fs/usrdata1/users01.dbf 45 0 5.8 1.0 0 0 0 0.0 ------------------------------------------------------------- Buffer Pool Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Standard block size Pools D: default, K: keep, R: recycle -> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k Free Writ Buffer Number of Pool Buffer Physical Physical Buff Comp Busy P Buffers Hit% Gets Reads Writes Wait Wait Waits --- ---------- ---- -------------- ------------ ----------- ---- ---- ---------- D 124,896 96 1,240,624 52,920 3,762 0 0 0 ------------------------------------------------------------- Instance Recovery Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> B: Begin snapshot, E: End snapshot Targt Estd Log File Log Ckpt Log Ckpt MTTR MTTR Recovery Actual Target Size Timeout Interval (s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks - ----- ----- ---------- --------- --------- ---------- --------- ------------ B 0 13 210 449 1220 368640 1220 N/A E 0 13 290 1812 7688 368640 7688 N/A ------------------------------------------------------------- Buffer Pool Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 -> Only rows with estimated physical reads >0 are displayed -> ordered by Block Size, Buffers For Estimate Est Phys Size for Size Buffers for Read Estimated P Est (M) Factor Estimate Factor Physical Reads --- -------- ------ ---------------- ------ ------------------ D 96 .1 11,874 1.1 4,257,276,673 D 192 .2 23,748 1.1 4,192,783,767 D 288 .3 35,622 1.0 4,135,944,173 D 384 .4 47,496 1.0 4,087,907,244 D 480 .5 59,370 1.0 4,048,666,739 D 576 .6 71,244 1.0 4,018,523,302 D 672 .7 83,118 1.0 3,997,055,257 D 768 .8 94,992 1.0 3,986,856,272 D 864 .8 106,866 1.0 3,979,182,510 D 960 .9 118,740 1.0 3,972,499,343 D 1,024 1.0 126,656 1.0 3,968,404,818 D 1,056 1.0 130,614 1.0 3,966,357,439 D 1,152 1.1 142,488 1.0 3,960,659,404 D 1,248 1.2 154,362 1.0 3,955,278,464 D 1,344 1.3 166,236 1.0 3,950,146,562 D 1,440 1.4 178,110 1.0 3,945,263,588 D 1,536 1.5 189,984 1.0 3,940,366,266 D 1,632 1.6 201,858 1.0 3,935,436,650 D 1,728 1.7 213,732 1.0 3,930,493,713 D 1,824 1.8 225,606 1.0 3,925,548,939 D 1,920 1.9 237,480 1.0 3,920,542,349 ------------------------------------------------------------- PGA Aggr Summary DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written --------------- ------------------ -------------------------- 100.0 1,032 0 ------------------------------------------------------------- PGA Aggr Target Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 866 146.2 0.0 .0 .0 .0 104,850 E 1,024 865 147.1 0.0 .0 .0 .0 104,850 ------------------------------------------------------------- PGA Aggr Target Histogram DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Optimal Executions are purely in-memory operations Low High Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs ------- ------- -------------- -------------- ------------ ------------ 2K 4K 25,619 25,619 0 0 64K 128K 35 35 0 0 128K 256K 56 56 0 0 256K 512K 82 82 0 0 512K 1024K 637 637 0 0 1M 2M 210 210 0 0 2M 4M 33 33 0 0 4M 8M 2 2 0 0 16M 32M 5 5 0 0 ------------------------------------------------------------- PGA Memory Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 -> 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 2,912,026.9 315,297.8 90.0 3,100 256 0.3 2,912,026.9 128,102.1 96.0 101 512 0.5 2,912,026.9 77,542.6 97.0 0 768 0.8 2,912,026.9 77,287.3 97.0 0 1,024 1.0 2,912,026.9 69,918.5 98.0 0 1,229 1.2 2,912,026.9 52,277.9 98.0 0 1,434 1.4 2,912,026.9 52,277.9 98.0 0 1,638 1.6 2,912,026.9 52,277.9 98.0 0 1,843 1.8 2,912,026.9 52,277.9 98.0 0 2,048 2.0 2,912,026.9 52,277.9 98.0 0 3,072 3.0 2,912,026.9 52,277.9 98.0 0 4,096 4.0 2,912,026.9 52,277.9 98.0 0 6,144 6.0 2,912,026.9 52,277.9 98.0 0 8,192 8.0 2,912,026.9 52,277.9 98.0 0 ------------------------------------------------------------- Shared Pool Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 -> 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 ---------- ----- -------- ------------ ------- ------ ------- ------ ----------- 256 .3 86 3,359 ####### .8 ####### 37.9 ########### 336 .5 161 5,968 ####### .8 ####### 31.6 ########### 416 .6 239 7,534 ####### .9 ####### 25.3 ########### 496 .7 317 9,369 ####### .9 ####### 19.1 ########### 576 .8 396 13,432 ####### .9 ####### 12.9 ########### 656 .9 475 16,018 ####### 1.0 ####### 6.9 ########### 736 1.0 554 19,166 ####### 1.0 30,101 1.0 ########### 816 1.1 633 22,666 ####### 1.0 1 .0 ########### 896 1.2 656 23,417 ####### 1.1 1 .0 ########### 976 1.3 656 23,417 ####### 1.1 1 .0 ########### 1,056 1.4 735 25,958 ####### 1.1 1 .0 ########### 1,136 1.5 815 28,622 ####### 1.2 1 .0 ########### 1,216 1.7 896 31,079 ####### 1.2 1 .0 ########### 1,296 1.8 964 35,264 ####### 1.2 1 .0 ########### 1,376 1.9 964 35,264 ####### 1.3 1 .0 ########### 1,456 2.0 1,043 38,666 ####### 1.3 1 .0 ########### 1,536 2.1 1,276 50,912 ####### 1.3 1 .0 ########### ------------------------------------------------------------- SGA Target Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 SGA Target SGA Size Est DB Est Physical Size (M) Factor Time (s) Reads ---------- ---------- ------------ ---------------- 512 0.3 2,579,811 4,265,638,302 1,024 0.5 1,274,846 4,200,953,304 1,536 0.8 889,899 4,004,914,108 2,048 1.0 786,408 3,968,404,784 2,560 1.3 738,988 3,938,244,908 3,072 1.5 738,988 3,928,323,896 3,584 1.8 738,988 3,928,323,896 4,096 2.0 738,988 3,928,323,896 ------------------------------------------------------------- Streams Pool Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 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 128 2.7 0 0 0 0 144 3.0 0 0 0 0 160 3.3 0 0 0 0 176 3.7 0 0 0 0 192 4.0 0 0 0 0 208 4.3 0 0 0 0 224 4.7 0 0 0 0 240 5.0 0 0 0 0 256 5.3 0 0 0 0 272 5.7 0 0 0 0 288 6.0 0 0 0 0 304 6.3 0 0 0 0 320 6.7 0 0 0 0 ------------------------------------------------------------- Java Pool Advisory DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 No data exists for this section of the report. ------------------------------------------------------------- Buffer Wait Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Enqueue Activity DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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) ------------ ------------ ----------- ----------- ------------ -------------- RO-Multiple Object Reuse (fast object reuse) 18 18 0 2 0 2.50 ------------------------------------------------------------- Undo Segment Summary DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 1.5 1,422 0 3 2207.1833 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Undo Segment Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 ------------ ----------- ------------ ------- ------- ------- ----- ------------ 12-Jul 12:01 103 364 0 3 2,255 0/0 0/0/0/0/0/0 12-Jul 11:51 100 144 0 3 2,246 0/0 0/0/0/0/0/0 12-Jul 11:41 55 158 0 3 2,237 0/0 0/0/0/0/0/0 12-Jul 11:31 1,116 218 0 3 2,229 0/0 0/0/0/0/0/0 12-Jul 11:21 14 134 0 2 2,226 0/0 0/0/0/0/0/0 12-Jul 11:11 18 165 0 2 2,216 0/0 0/0/0/0/0/0 12-Jul 11:01 84 239 0 3 2,207 0/0 0/0/0/0/0/0 ------------------------------------------------------------- Latch Activity DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests -> "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests -> "Pct Misses" for both should be very close to 0.0 Pct Avg Wait Pct Get Get Slps Time NoWait NoWait Latch Name Requests Miss /Miss (s) Requests Miss ------------------------ -------------- ------ ------ ------ ------------ ------ ASM db client latch 2,404 0.0 N/A 0 0 N/A ASM network background l 2 0.0 N/A 0 0 N/A AWR Alerted Metric Eleme 14,628 0.0 N/A 0 0 N/A Consistent RBA 961 0.0 N/A 0 0 N/A FAL request queue 72 0.0 N/A 0 0 N/A FAL subheap alocation 72 0.0 N/A 0 0 N/A FIB s.o chain latch 4 0.0 N/A 0 0 N/A FOB s.o list latch 313 0.0 N/A 0 0 N/A In memory undo latch 7,249 0.0 N/A 0 1,778 0.0 JS mem alloc latch 4 0.0 N/A 0 0 N/A JS queue access latch 4 0.0 N/A 0 0 N/A JS queue state obj latch 21,600 0.0 N/A 0 0 N/A JS slv state obj latch 133 0.0 N/A 0 0 N/A KMG MMAN ready and start 1,201 0.0 N/A 0 0 N/A KMG resize request state 2 0.0 N/A 0 0 N/A KTF sga latch 8 0.0 N/A 0 1,066 0.0 KWQMN job cache list lat 27 33.3 0.6 0 0 N/A KWQP Prop Status 2 0.0 N/A 0 0 N/A MQL Tracking Latch 0 N/A N/A 0 72 0.0 Memory Management Latch 20 0.0 N/A 0 1,201 0.0 OS process 1,050 0.0 N/A 0 0 N/A OS process allocation 1,901 0.0 N/A 0 0 N/A OS process: request allo 525 0.0 N/A 0 0 N/A PL/SQL warning settings 739 0.0 N/A 0 0 N/A SQL memory manager latch 1 0.0 N/A 0 1,200 0.0 SQL memory manager worka 83,179 0.0 N/A 0 0 N/A Shared B-Tree 132 0.0 N/A 0 0 N/A active checkpoint queue 7,159 0.1 0.0 0 0 N/A active service list 7,941 0.0 N/A 0 1,235 0.0 archive control 110 0.0 N/A 0 0 N/A archive process latch 1,344 0.0 N/A 0 0 N/A begin backup scn array 16 0.0 N/A 0 0 N/A buffer pool 3 0.0 N/A 0 0 N/A cache buffer handles 1,058 0.0 N/A 0 0 N/A cache buffers chains 2,449,011 0.0 0.0 0 162,149 0.0 cache buffers lru chain 19,780 0.0 0.0 0 175,449 0.0 cache table scan latch 0 N/A N/A 0 4,721 0.0 channel handle pool latc 611 0.0 N/A 0 0 N/A channel operations paren 18,090 0.0 0.0 0 0 N/A checkpoint queue latch 422,550 0.0 0.0 0 7,717 0.0 client/application info 3,208 0.0 N/A 0 0 N/A commit callback allocati 4 0.0 N/A 0 0 N/A compile environment latc 325 0.0 N/A 0 0 N/A dictionary lookup 6 0.0 N/A 0 0 N/A dml lock allocation 3,887 0.0 N/A 0 0 N/A dummy allocation 649 0.0 N/A 0 0 N/A enqueue hash chains 63,726 0.0 0.0 0 122 0.0 enqueues 57,829 0.0 0.0 0 0 N/A event group latch 263 0.0 N/A 0 0 N/A file cache latch 132 0.0 N/A 0 0 N/A global KZLD latch for me 219 0.0 N/A 0 0 N/A hash table column usage 132 0.0 N/A 0 12,798 0.0 hash table modification 91 0.0 N/A 0 0 N/A internal temp table obje 5 0.0 N/A 0 0 N/A job workq parent latch 0 N/A N/A 0 124 0.0 job_queue_processes para 122 0.0 N/A 0 0 N/A kks stats 387 0.0 N/A 0 0 N/A kokc descriptor allocati 86 0.0 N/A 0 0 N/A ksuosstats global area 243 0.0 N/A 0 0 N/A ktm global data 37 0.0 N/A 0 0 N/A Latch Activity DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> "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 ------------------------ -------------- ------ ------ ------ ------------ ------ kwqbsn:qsga 131 0.0 N/A 0 0 N/A lgwr LWN SCN 1,807 0.0 N/A 0 0 N/A library cache 157,043 0.0 0.0 0 5 0.0 library cache load lock 102 0.0 N/A 0 0 N/A library cache lock 37,489 0.0 N/A 0 0 N/A library cache lock alloc 2,800 0.0 N/A 0 0 N/A library cache pin 14,604 0.0 N/A 0 0 N/A library cache pin alloca 498 0.0 N/A 0 0 N/A list of block allocation 495 0.0 N/A 0 0 N/A loader state object free 132 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 message pool operations 98 0.0 N/A 0 0 N/A messages 37,958 0.1 0.0 0 0 N/A mostly latch-free SCN 1,809 0.1 0.0 0 0 N/A multiblock read objects 13,972 0.0 N/A 0 0 N/A ncodef allocation latch 59 0.0 N/A 0 0 N/A object queue header heap 6,321 0.0 N/A 0 1,708 0.0 object queue header oper 135,427 0.0 N/A 0 3,948 0.0 object stats modificatio 1,661 0.0 N/A 0 0 N/A parallel query alloc buf 480 0.0 N/A 0 0 N/A parameter list 793 0.0 N/A 0 0 N/A parameter table allocati 328 0.0 N/A 0 0 N/A post/wait queue 385 0.0 N/A 0 213 0.0 process allocation 525 0.0 N/A 0 263 0.0 process group creation 525 0.0 N/A 0 0 N/A qmn task queue latch 789 0.0 N/A 0 0 N/A redo allocation 8,131 0.0 0.0 0 82,276 0.0 redo copy 0 N/A N/A 0 82,277 0.0 redo writing 12,559 0.1 0.0 0 0 N/A resmgr group change latc 673 0.0 N/A 0 0 N/A resmgr:active threads 644 0.0 N/A 0 0 N/A resmgr:actses change gro 281 0.0 N/A 0 0 N/A resmgr:free threads list 643 0.0 N/A 0 0 N/A resmgr:schema config 1 0.0 N/A 0 0 N/A row cache objects 96,246 0.0 N/A 0 0 N/A rules engine aggregate s 2 0.0 N/A 0 0 N/A rules engine rule set st 104 0.0 N/A 0 0 N/A sequence cache 866 0.0 N/A 0 0 N/A session allocation 13,176 0.1 0.0 0 0 N/A session idle bit 54,196 0.0 N/A 0 0 N/A session state list latch 808 0.0 N/A 0 0 N/A session switching 59 0.0 N/A 0 0 N/A session timer 1,235 0.0 N/A 0 0 N/A shared pool 18,843 0.0 0.0 0 0 N/A shared pool simulator 40,961 0.0 N/A 0 0 N/A simulator hash latch 92,591 0.0 N/A 0 0 N/A simulator lru latch 4,179 0.0 N/A 0 81,277 0.0 slave class 3 0.0 N/A 0 0 N/A slave class create 12 8.3 1.0 0 0 N/A sort extent pool 1,010 0.0 N/A 0 0 N/A state object free list 2 0.0 N/A 0 0 N/A statistics aggregation 336 0.0 N/A 0 0 N/A temporary table state ob 4 0.0 N/A 0 0 N/A threshold alerts latch 386 0.0 N/A 0 0 N/A transaction allocation 188,787 0.0 N/A 0 0 N/A transaction branch alloc 1,235 0.0 N/A 0 0 N/A undo global data 14,392 0.0 N/A 0 0 N/A user lock 1,000 0.0 N/A 0 0 N/A ------------------------------------------------------------- Latch Sleep Breakdown DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> ordered by misses desc Latch Name ---------------------------------------- Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3 -------------- ----------- ----------- ---------- -------- -------- -------- KWQMN job cache list latch 27 9 5 4 0 0 0 slave class create 12 1 1 0 0 0 0 ------------------------------------------------------------- Latch Miss Sources DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- -------- KWQMN job cache list lat kwqmndej: dequeue 0 7 7 slave class create ksvcreate 0 1 0 ------------------------------------------------------------- Parent Latch Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Child Latch Statistics DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Segments by Logical Reads DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total Logical Reads: 1,242,555 -> Captured Segments account for 90.3% of Total Tablespace Subobject Obj. Logical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SMART SMART_DAT PK_ACCOUNT_FUND_DIM INDEX 149,664 12.04 SMART SMART_DAT ACCOUNT_FUND_DIMENSI TABLE 147,344 11.86 MARSODS MARSODS_DA EVENT_INST TABLE 129,936 10.46 MARSODS MARSODS_ID IX2SRC_AMP_ACCT_MAST INDEX 124,432 10.01 MARSODS MARSODS_DA HRCHY_ENTITY_ATTR_IN TABLE 85,312 6.87 ------------------------------------------------------------- Segments by Physical Reads DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Total Physical Reads: 52,933 -> Captured Segments account for 81.9% of Total Tablespace Subobject Obj. Physical Owner Name Object Name Name Type Reads %Total ---------- ---------- -------------------- ---------- ----- ------------ ------- SMART SMART_DAT WEEKLY_ACCTFUND_FLOW TABLE 28,326 53.51 MARSODS MARSODS_DA SRC_AMP_ACCOUNT_MAST TABLE 13,823 26.11 MARSODS MARSODS_DA GEI_ACCOUNT_PROFILE_ TABLE 445 .84 SMART SMART_DAT DAILY_FLOWS_FACT TABLE 143 .27 MARSODS MARSODS_DA HRCHY_AUDIT TABLE 77 .15 ------------------------------------------------------------- Segments by Row Lock Waits DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- MARSODS MARSODS_ID IX2SRC_AMP_ACCT_MAST INDEX 16 44.44 SYS SYSAUX WRH$_LATCH_PK 7997_38809 INDEX 4 11.11 SYS SYSAUX WRH$_SQLSTAT_PK 7997_38809 INDEX 4 11.11 SYS SYSAUX WRH$_SYSSTAT_PK 7997_38809 INDEX 4 11.11 SYS SYSAUX WRH$_LATCH_MISSES_SU 7997_38809 INDEX 2 5.56 ------------------------------------------------------------- Segments by ITL Waits DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> % 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 ---------- ---------- -------------------- ---------- ----- ------------ ------- SYS SYSAUX WRH$_SQLSTAT_PK 7997_38809 INDEX 1 100.00 ------------------------------------------------------------- Segments by Buffer Busy Waits DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Dictionary Cache Stats DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> "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 66 0.0 0 N/A 2 2 dc_database_links 440 0.0 0 N/A 0 1 dc_files 300 0.0 0 N/A 0 25 dc_global_oids 212 0.0 0 N/A 0 52 dc_histogram_data 6,806 0.3 0 N/A 0 6,136 dc_histogram_defs 1,573 2.4 0 N/A 0 8,922 dc_object_grants 14 0.0 0 N/A 0 74 dc_object_ids 1,952 0.5 0 N/A 4 1,220 dc_objects 1,173 1.2 0 N/A 16 2,010 dc_profiles 283 0.0 0 N/A 0 2 dc_rollback_segments 1,524 0.0 0 N/A 0 67 dc_segments 789 0.4 0 N/A 5 1,147 dc_sequences 1 100.0 0 N/A 1 22 dc_table_scns 4 100.0 0 N/A 0 0 dc_tablespaces 5,752 0.0 0 N/A 0 13 dc_usernames 3,021 0.0 0 N/A 0 70 dc_users 14,479 0.0 0 N/A 0 166 outstanding_alerts 158 0.6 0 N/A 2 24 ------------------------------------------------------------- Library Cache Activity DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> "Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- BODY 782 0.1 1,549 0.3 1 0 INDEX 1 0.0 2 0.0 0 0 SQL AREA 3,706 2.1 42,187 0.8 100 36 TABLE/PROCEDURE 356 2.0 4,463 1.3 26 0 TRIGGER 116 0.9 218 0.5 0 0 ------------------------------------------------------------- Process Memory Summary DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 109.8 N/A 3.0 5.8 22 147 37 37 Freeable 34.1 .0 1.4 1.2 6 N/A 24 24 SQL 1.8 .9 .1 .1 0 64 27 26 PL/SQL .6 .4 .0 .0 0 0 37 37 E Other 108.4 N/A 2.9 5.7 22 26 38 38 Freeable 36.3 .0 1.5 1.1 6 N/A 25 25 SQL 1.8 .9 .1 .1 0 42 28 27 PL/SQL .7 .5 .0 .0 0 1 38 38 ------------------------------------------------------------- SGA Memory Summary DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 End Size (Bytes) SGA regions Begin Size (Bytes) (if different) ------------------------------ ------------------- ------------------- Database Buffers 1,107,296,256 1,073,741,824 Fixed Size 2,041,976 Redo Buffers 14,729,216 Variable Size 1,023,416,200 1,056,970,632 ------------------- sum 2,147,483,648 ------------------------------------------------------------- SGA breakdown difference DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 PX msg pool 1.0 1.0 0.00 large free memory 15.0 15.0 0.00 shared ASH buffers 41.0 41.0 0.00 shared CCursor 44.2 44.5 0.69 shared KGH: NO ACCESS 962.8 962.8 0.00 shared PCursor 25.4 25.5 0.59 shared free memory 232.1 259.9 11.99 shared library cache 40.0 40.0 0.00 shared sql area 177.7 180.7 1.69 stream free memory 48.0 48.0 0.00 buffer_cache 1,056.0 1,024.0 -3.03 fixed_sga 1.9 1.9 0.00 log_buffer 14.0 14.0 0.00 ------------------------------------------------------------- Streams CPU/IO Usage DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> 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 30,974 0 0 QMON Coordinator 30,762 0 0 ------------------------------------------------------------- Streams Capture DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Streams Apply DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Buffered Queues DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Buffered Subscribers DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 No data exists for this section of the report. ------------------------------------------------------------- Rule Set DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 -> Rule Sets ordered by Evaluations Fast SQL CPU Elapsed Ruleset Name Evals Evals Execs Time Time ------------------------- -------- -------- -------- -------- -------- SYS.ALERT_QUE_R 2 0 0 0 0 ------------------------------------------------------------- Resource Limit Stats DB/Inst: ORAMARSP/ORAMARSP Snap: 38820 No data exists for this section of the report. ------------------------------------------------------------- init.ora Parameters DB/Inst: ORAMARSP/ORAMARSP Snaps: 38819-38820 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- aq_tm_processes 5 audit_file_dest /cfs/dblinks/oramarsp/fs/admin/ad audit_sys_operations TRUE audit_trail DB background_dump_dest /cfs/dblinks/oramarsp/fs/admin/bd compatible 10.2.0.4.0 control_file_record_keep_time 365 control_files /cfs/dblinks/oramarsp/fs/cntl1/co core_dump_dest /cfs/dblinks/oramarsp/fs/admin/cd db_block_size 8192 db_domain IM.AWM.JPMC.NET db_file_multiblock_read_count 16 db_name ORAMARSP db_recovery_file_dest /cfs/dblinks/oramarsp/fs/flash_re db_recovery_file_dest_size 30064771072 dispatchers java_pool_size 218103808 job_queue_processes 10 local_listener LSNR_ORAMARSP open_cursors 2000 os_authent_prefix OPS$ pga_aggregate_target 1073741824 processes 300 remote_login_passwordfile EXCLUSIVE sga_target 2147483648 shared_pool_size 318767104 shared_servers 0 spfile /apps/oracle/product/ora10204/dbs streams_pool_size 50331648 undo_management AUTO undo_tablespace UNDOTBS1 user_dump_dest /cfs/dblinks/oramarsp/fs/admin/ud ------------------------------------------------------------- End of Report