WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
PCARD 1840828064 pcard 1 10.2.0.4.0 NO uatdb.nucleu
Snap Id Snap Time Sessions Curs/Sess
--------- ------------------- -------- ---------
Begin Snap: 2834 21-Jun-11 13:00:32 87 9.9
End Snap: 2835 21-Jun-11 14:00:33 85 10.0
Elapsed: 60.03 (mins)
DB Time: 0.10 (mins)
Cache Sizes
~~~~~~~~~~~ Begin End
---------- ----------
Buffer Cache: 1,856M 1,856M Std Block Size: 8K
Shared Pool Size: 800M 800M Log Buffer: 14,344K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 1,290.09 5,972.44
Logical reads: 47.42 219.55
Block changes: 7.39 34.20
Physical reads: 0.00 0.01
Physical writes: 0.75 3.49
User calls: 2.43 11.24
Parses: 1.55 7.16
Hard parses: 0.01 0.03
Sorts: 1.20 5.54
Logons: 0.04 0.17
Executes: 5.49 25.44
Transactions: 0.22
% Blocks changed per Read: 15.58 Recursive Call %: 89.14
Rollback per transaction %: 4.11 Rows per Sort: 14.13
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 100.00 In-memory Sort %: 100.00
Library Hit %: 99.76 Soft Parse %: 99.55
Execute to Parse %: 71.83 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 85.29 % Non-Parse CPU: 94.68
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 88.54 88.70
% SQL with executions>1: 98.24 98.85
% Memory for SQL w/exec>1: 95.47 96.70
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
control file parallel write 1,201 7 6 119.5 System I/O
CPU time 5 88.2
log file parallel write 1,071 2 1 25.4 System I/O
log file sync 341 1 2 13.6 Commit
os thread startup 26 1 20 8.6 Concurrenc
-------------------------------------------------------------
Time Model Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total time in database user-calls (DB Time): 6.2s
-> Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
------------------------------------------ ------------------ ------------
DB CPU 5.5 88.2
sql execute elapsed time 5.2 84.6
PL/SQL execution elapsed time 1.1 17.7
parse time elapsed 0.4 6.3
connection management call elapsed time 0.2 3.3
hard parse elapsed time 0.1 2.4
hard parse (sharing criteria) elapsed time 0.0 .7
PL/SQL compilation elapsed time 0.0 .0
repeated bind elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
DB time 6.2 N/A
background elapsed time 14.7 N/A
background cpu time 7.0 N/A
-------------------------------------------------------------
Wait Class DB/Inst: PCARD/pcard Snaps: 2834-2835
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc
Avg
%Time Total Wait wait Waits
Wait Class Waits -outs Time (s) (ms) /txn
-------------------- ---------------- ------ ---------------- ------- ---------
System I/O 6,004 .0 9 1 7.7
Commit 341 1.2 1 2 0.4
Concurrency 35 2.9 1 15 0.0
Application 304 .0 0 0 0.4
User I/O 321 .0 0 0 0.4
Network 8,242 .0 0 0 10.6
Other 61 .0 0 0 0.1
-------------------------------------------------------------
Wait Events DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
---------------------------- -------------- ------ ----------- ------- ---------
control file parallel write 1,201 .0 7 6 1.5
log file parallel write 1,071 .0 2 1 1.4
log file sync 341 1.2 1 2 0.4
os thread startup 26 .0 1 20 0.0
SQL*Net break/reset to clien 304 .0 0 0 0.4
control file sequential read 3,732 .0 0 0 4.8
db file sequential read 307 .0 0 0 0.4
SQL*Net message to client 7,896 .0 0 0 10.1
latch free 1 .0 0 15 0.0
SQL*Net more data to client 317 .0 0 0 0.4
rdbms ipc reply 9 .0 0 1 0.0
LGWR wait for redo copy 51 .0 0 0 0.1
latch: library cache 8 .0 0 0 0.0
SQL*Net more data from clien 29 .0 0 0 0.0
direct path write 14 .0 0 0 0.0
latch: shared pool 1 100.0 0 0 0.0
SQL*Net message from client 7,873 .0 11,811 1500 10.1
Streams AQ: waiting for time 127 63.0 3,541 27884 0.2
wait for unread message on b 3,603 99.4 3,516 976 4.6
Streams AQ: qmn slave idle w 258 .0 3,515 13624 0.3
Streams AQ: qmn coordinator 391 34.0 3,515 8990 0.5
jobq slave wait 1,200 95.0 3,514 2928 1.5
Streams AQ: waiting for mess 738 97.3 3,513 4760 0.9
virtual circuit status 4,308 .6 2,846 661 5.5
class slave wait 1 .0 0 0 0.0
-------------------------------------------------------------
Background Wait Events DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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,201 .0 7 6 1.5
log file parallel write 1,067 .0 2 1 1.4
os thread startup 26 .0 1 20 0.0
control file sequential read 2,644 .0 0 0 3.4
events in waitclass Other 51 .0 0 0 0.1
latch: shared pool 1 100.0 0 0 0.0
rdbms ipc message 12,398 93.4 38,442 3101 15.9
Streams AQ: waiting for time 127 63.0 3,541 27884 0.2
Streams AQ: qmn slave idle w 258 .0 3,515 13624 0.3
Streams AQ: qmn coordinator 391 34.0 3,515 8990 0.5
pmon timer 1,209 100.0 3,513 2906 1.6
smon timer 20 40.0 3,081 154057 0.0
-------------------------------------------------------------
Operating System Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
Statistic Total
-------------------------------- --------------------
BUSY_TIME 16,592
IDLE_TIME 703,708
IOWAIT_TIME 6,318
NICE_TIME 0
SYS_TIME 5,568
USER_TIME 10,829
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 16,830,660,608
NUM_CPUS 2
-------------------------------------------------------------
Service Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
-> ordered by DB Time
Physical Logical
Service Name DB Time (s) DB CPU (s) Reads Reads
-------------------------------- ------------ ------------ ---------- ----------
pcard 3.8 3.6 0 95,461
SYS$USERS 2.4 1.8 0 53,576
SYS$BACKGROUND 0.0 0.0 7 22,625
-------------------------------------------------------------
Service Wait Class Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
--------- --------- --------- --------- --------- --------- --------- ---------
pcard
0 0 0 0 0 0 6601 3
SYS$USERS
240 0 8 0 0 0 1388 1
SYS$BACKGROUND
81 3 27 53 0 0 0 0
-------------------------------------------------------------
SQL ordered by Elapsed Time DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 60 0.0 11.5 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1 1 1,290 0.0 9.2 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
1 1 1,798 0.0 8.8 8w5st001wrj4q
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;
0 0 119 0.0 7.8 8hk7xvhua40va
Module: OEM.Loader
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
0 0 1 0.4 6.6 bunssq950snhf
insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi
d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS from v$sga_target_advice
0 0 1 0.3 5.1 brmyw35aksw9s
Module: SQLNav5.exe
SELECT /*+FIRST_ROWS*/ USER OWNER, NAME, TYPE, LINE, TEXT T FROM USER_SOURCE W
HERE TYPE IN ('PACKAGE BODY') AND UPPER(TEXT) LIKE '%ERROR RETREIVING SHADOW ACC
OUNT LEVEL%' ESCAPE '!'
0 0 1,711 0.0 4.5 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3
0 0 2 0.1 4.5 cjvkqhca4p2gs
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ SELECT m.tablespace_name, m.used_percent, (m.tab
lespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespac
e_usage_metrics m, dba_tablespaces t WHERE :1 != 'BASIC' AND t.tablespace_na
me = m.tablespace_name
0 0 118 0.0 4.0 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
0 0 1,798 0.0 3.0 80ub3uuhsm7pm
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
ASC) WHERE ROWNUM = 1
0 0 120 0.0 2.9 aykvshm7zsabd
select size_for_estimate, size_factor * 100 f,
estd_physical_read_time, estd_physical_reads
from v$db_cache_advice where id = '3'
0 0 12 0.0 2.4 7j23tu2qk35zj
SQL ordered by Elapsed Time DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
---------- ---------- ------------ ---------- ------- -------------
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ BEGIN IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN
---- -- For a read-write database appropriately configured, try to evalu
ate. ---- dbsnmp.mgmt_response.get_metric_curs(:3); ELSE ----
-- For a read-only database, do not evaluate, but rather return an empty --
0 0 20 0.0 2.3 f787fyhjmkp61
Module: OEM.BoundedPool
INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_
TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVER
ITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :1
0, :11)
0 0 58 0.0 2.3 cydnuss99swtd
Module: OEM.SystemPool
BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
0 0 1 0.1 1.8 5zh8j03jvma9f
Module: SQLNav5.exe
select owner,object_id,created,nvl(last_ddl_time,created) last_ddl_time,decode(s
tatus,'VALID',0,'INVALID',1,2) status,object_name,object_name,decode(object_type
,'TABLE',1,'VIEW',2,'INDEX',3,'SNAPSHOT LOG',4,'PROCEDURE',5,'FUNCTION',6,'PACKA
GE',7,'PACKAGE BODY',8,'TRIGGER',9,'SEQUENCE',10,'SYNONYM',11,'CLUSTER',12,'DATA
0 0 1 0.1 1.6 84qubbrsr0kfn
insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, ge
ts, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, s
leep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number,
hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_ge
0 0 49 0.0 1.4 abtp0uqvdb1d3
CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
0 0 12 0.0 1.3 27v7m7f3zm07w
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
SELECT value FROM v$sysstat WHERE stat_id IN (24469293, 1099569955, 2432034337,
3332107451, 3649082374, 3868577743) ORDER BY stat_id
0 0 1,290 0.0 1.0 6gh8gj9n09vr7
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERA
TE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE ST
EP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND S
TEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=
0 0 10 0.0 1.0 072t81cu41xfj
Module: OEM.BoundedPool
SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND
METRIC_GUID = :B2 AND KEY_VALUE = :B1
0 0 720 0.0 1.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
-------------------------------------------------------------
SQL ordered by CPU Time DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
---------- ---------- ------------ ----------- ------- -------------
1 1 60 0.01 11.5 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1 1 1,290 0.00 9.2 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
1 1 1,798 0.00 8.8 8w5st001wrj4q
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;
0 0 119 0.00 7.8 8hk7xvhua40va
Module: OEM.Loader
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
0 0 1 0.41 6.6 bunssq950snhf
insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZ
E, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbi
d, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_R
EADS from v$sga_target_advice
0 0 1 0.32 5.1 brmyw35aksw9s
Module: SQLNav5.exe
SELECT /*+FIRST_ROWS*/ USER OWNER, NAME, TYPE, LINE, TEXT T FROM USER_SOURCE W
HERE TYPE IN ('PACKAGE BODY') AND UPPER(TEXT) LIKE '%ERROR RETREIVING SHADOW ACC
OUNT LEVEL%' ESCAPE '!'
0 0 1,711 0.00 4.5 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3
0 0 2 0.14 4.5 cjvkqhca4p2gs
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ SELECT m.tablespace_name, m.used_percent, (m.tab
lespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespac
e_usage_metrics m, dba_tablespaces t WHERE :1 != 'BASIC' AND t.tablespace_na
me = m.tablespace_name
0 0 118 0.00 4.0 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
0 0 1,798 0.00 3.0 80ub3uuhsm7pm
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
ASC) WHERE ROWNUM = 1
0 0 120 0.00 2.9 aykvshm7zsabd
select size_for_estimate, size_factor * 100 f,
estd_physical_read_time, estd_physical_reads
from v$db_cache_advice where id = '3'
0 0 12 0.01 2.4 7j23tu2qk35zj
SQL ordered by CPU Time DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
---------- ---------- ------------ ----------- ------- -------------
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ BEGIN IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN
---- -- For a read-write database appropriately configured, try to evalu
ate. ---- dbsnmp.mgmt_response.get_metric_curs(:3); ELSE ----
-- For a read-only database, do not evaluate, but rather return an empty --
0 0 20 0.01 2.3 f787fyhjmkp61
Module: OEM.BoundedPool
INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_
TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVER
ITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :1
0, :11)
0 0 58 0.00 2.3 cydnuss99swtd
Module: OEM.SystemPool
BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
0 0 1 0.11 1.8 5zh8j03jvma9f
Module: SQLNav5.exe
select owner,object_id,created,nvl(last_ddl_time,created) last_ddl_time,decode(s
tatus,'VALID',0,'INVALID',1,2) status,object_name,object_name,decode(object_type
,'TABLE',1,'VIEW',2,'INDEX',3,'SNAPSHOT LOG',4,'PROCEDURE',5,'FUNCTION',6,'PACKA
GE',7,'PACKAGE BODY',8,'TRIGGER',9,'SEQUENCE',10,'SYNONYM',11,'CLUSTER',12,'DATA
0 0 1 0.10 1.6 84qubbrsr0kfn
insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, ge
ts, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, s
leep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number,
hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_ge
0 0 49 0.00 1.4 abtp0uqvdb1d3
CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
0 0 12 0.01 1.3 27v7m7f3zm07w
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
SELECT value FROM v$sysstat WHERE stat_id IN (24469293, 1099569955, 2432034337,
3332107451, 3649082374, 3868577743) ORDER BY stat_id
0 0 1,290 0.00 1.0 6gh8gj9n09vr7
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERA
TE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE ST
EP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND S
TEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=
0 0 10 0.01 1.0 072t81cu41xfj
Module: OEM.BoundedPool
SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND
METRIC_GUID = :B2 AND KEY_VALUE = :B1
0 0 720 0.00 1.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
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 170,810
-> Captured SQL account for 110.8% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
51,785 119 435.2 30.3 0.48 0.48 8hk7xvhua40va
Module: OEM.Loader
INSERT INTO MGMT_METRICS_RAW(COLLECTION_TIMESTAMP, KEY_VALUE, METRIC_GUID, STRIN
G_VALUE, TARGET_GUID, VALUE) VALUES ( :1, NVL(:2, ' '), :3, :4, :5, :6)
47,534 1,711 27.8 27.8 0.28 0.28 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3
26,764 2 13,382.0 15.7 0.28 0.28 cjvkqhca4p2gs
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ SELECT m.tablespace_name, m.used_percent, (m.tab
lespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespac
e_usage_metrics m, dba_tablespaces t WHERE :1 != 'BASIC' AND t.tablespace_na
me = m.tablespace_name
17,531 60 292.2 10.3 0.71 0.71 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
13,392 216 62.0 7.8 0.05 0.05 2njsvt21kvxux
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
select file# from file$ where spare1 is NOT NULL and status$ = 2
10,375 1 10,375.0 6.1 0.32 0.32 brmyw35aksw9s
Module: SQLNav5.exe
SELECT /*+FIRST_ROWS*/ USER OWNER, NAME, TYPE, LINE, TEXT T FROM USER_SOURCE W
HERE TYPE IN ('PACKAGE BODY') AND UPPER(TEXT) LIKE '%ERROR RETREIVING SHADOW ACC
OUNT LEVEL%' ESCAPE '!'
7,192 1,798 4.0 4.2 0.18 0.18 80ub3uuhsm7pm
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
ASC) WHERE ROWNUM = 1
7,192 1,798 4.0 4.2 0.54 0.54 8w5st001wrj4q
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;
5,239 20 262.0 3.1 0.14 0.14 f787fyhjmkp61
Module: OEM.BoundedPool
INSERT INTO MGMT_SEVERITY(ACTION_MESSAGE, ACTION_NLSID, ADVISORY_ID, COLLECTION_
TIMESTAMP, KEY_VALUE, MESSAGE, MESSAGE_NLSID, MESSAGE_PARAMS, METRIC_GUID, SEVER
ITY_CODE, TARGET_GUID) VALUES ( :1, :2, :3, :4, NVL(:5, ' '), :6, :7, :8, :9, :1
0, :11)
5,160 1,290 4.0 3.0 0.57 0.57 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
3,640 10 364.0 2.1 0.06 0.06 072t81cu41xfj
Module: OEM.BoundedPool
SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND
METRIC_GUID = :B2 AND KEY_VALUE = :B1
SQL ordered by Gets DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total Buffer Gets: 170,810
-> Captured SQL account for 110.8% of Total
Gets CPU Elapsed
Buffer Gets Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ------------ ------------ ------ -------- --------- -------------
3,304 118 28.0 1.9 0.24 0.24 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2,996 58 51.7 1.8 0.14 0.14 cydnuss99swtd
Module: OEM.SystemPool
BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
2,161 5 432.2 1.3 0.05 0.05 0njp59jttu2z9
Module: Oracle Enterprise Manager.rollup
DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 A
ND ROWNUM <= :B1
2,160 720 3.0 1.3 0.06 0.06 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
1,913 12 159.4 1.1 0.15 0.15 7j23tu2qk35zj
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
/* OracleOEM */ BEGIN IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN
---- -- For a read-write database appropriately configured, try to evalu
ate. ---- dbsnmp.mgmt_response.get_metric_curs(:3); ELSE ----
-- For a read-only database, do not evaluate, but rather return an empty --
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Disk Reads: 7
-> Captured SQL account for 0.0% of Total
Reads CPU Elapsed
Physical Reads Executions per Exec %Total Time (s) Time (s) SQL Id
-------------- ----------- ------------- ------ -------- --------- -------------
0 10 0.0 0.0 0.06 0.06 072t81cu41xfj
Module: OEM.BoundedPool
SELECT DECODE(COUNT(*), 0, 1, 0) FROM MGMT_SEVERITY WHERE TARGET_GUID = :B3 AND
METRIC_GUID = :B2 AND KEY_VALUE = :B1
0 1,350 0.0 0.0 0.04 0.04 089dbukv1aanh
Module: EM_PING
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
0 60 0.0 0.0 0.00 0.00 08vznc16ycuag
Module: EM_PING
SELECT SYS_GUID() FROM SYS.DUAL
0 20 0.0 0.0 0.00 0.00 0b7dpytkua1uc
Module: OEM.BoundedPool
UPDATE MGMT_LAST_VIOLATION SET COLLECTION_TIMESTAMP = :B4 WHERE TARGET_GUID = :B
3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
0 1 0.0 0.0 0.00 0.00 0cn2wm9d7zq8d
SELECT decode(value,'FATAL',1,'ERROR',2,'WARNING',3,'INFORMATION',4,'INFORMATION
2',5,'INFORMATION3',6,'INFORMATION4',7,'INFORMATION5',8,'INFORMATION6',9,0) FROM
sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0 141 0.0 0.0 0.02 0.02 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
0 130 0.0 0.0 0.04 0.04 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
0 5 0.0 0.0 0.05 0.05 0njp59jttu2z9
Module: Oracle Enterprise Manager.rollup
DELETE MGMT_METRICS_RAW WHERE TARGET_GUID = :B3 AND COLLECTION_TIMESTAMP < :B2 A
ND ROWNUM <= :B1
0 70 0.0 0.0 0.02 0.02 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')
0 2 0.0 0.0 0.00 0.00 10xj8nynmpqtq
SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.start
up_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s
1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS
DATE) as end_time, ROUND((cast( (case when s2.end_interval
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Executions: 19,790
-> Captured SQL account for 67.6% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
1,798 0 0.0 0.00 0.00 80ub3uuhsm7pm
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
SELECT * FROM (SELECT * FROM P7_STORE_AND_FORWARD WHERE DESTINATION_RESOURCE = :
B1 ORDER BY DECODE (MTI, '1420', '9999', MTI) ASC, DATE_CREATE ASC, SEND_COUNTER
ASC) WHERE ROWNUM = 1
1,798 0 0.0 0.00 0.00 8w5st001wrj4q
Module: CIS@uatapp.nucleussoftware.com (TNS V1-V3)
begin :response_code := PCRD_SAF_MANAGE . GET_SAF_DATA ( :T_DEST_RESOURCE , :T_M
ANAGE_TYPE , :T_DECLINE_ADVICE_FLAG , :T_MTI , :T_STAN , :T_SRC_RESOURCE , :T_SE
ND_COUNTER , :T_RESPONSE_CODE , :T_TLV_BUFFER , :T_CARD_NUMBER ) ; END ;
1,711 1,711 1.0 0.00 0.00 91h2x42zqagcm
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VALUE = :B2 , STRIN
G_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC_GUID = :B5 AND KEY_VALUE = :B4
AND COLLECTION_TIMESTAMP < :B3
1,350 1,350 1.0 0.00 0.00 089dbukv1aanh
Module: EM_PING
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
1,290 0 0.0 0.00 0.00 6gh8gj9n09vr7
Module: OEM.SystemPool
SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERA
TE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE ST
EP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND S
TEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <=
1,290 1,290 1.0 0.00 0.00 cb75rw3w1tt0s
Module: OEM.SystemPool
begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
720 60 0.1 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
216 12,960 60.0 0.00 0.00 2njsvt21kvxux
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
select file# from file$ where spare1 is NOT NULL and status$ = 2
212 212 1.0 0.00 0.00 18naypzfmabd6
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
163 163 1.0 0.00 0.00 24dkx03u3rj6k
Module:
SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETE
R_VALUE)='TRUE'
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Parse Calls: 5,574
-> Captured SQL account for 52.2% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
216 216 3.88 2njsvt21kvxux
Module: emagent@uatdb.nucleussoftware.com (TNS V1-V3)
select file# from file$ where spare1 is NOT NULL and status$ = 2
162 162 2.91 6129566gyvx21
Module: OEM.BoundedPool
SELECT INSTANTIABLE, supertype_owner, supertype_name, LOCAL_ATTRIBUTES FROM all_
types WHERE type_name = :1 AND owner = :2
152 152 2.73 350f5yrnnmshs
lock table sys.mon_mods$ in exclusive mode nowait
152 152 2.73 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
141 141 2.53 0h6b2sajwb74n
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p
rivilege#>0 start with grantee#=:1 and privilege#>0
130 130 2.33 0k8522rmdzg4k
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#
>0
118 118 2.12 2b064ybzkwf1y
Module: OEM.SystemPool
BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
105 163 1.88 24dkx03u3rj6k
Module:
SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETE
R_VALUE)='TRUE'
70 70 1.26 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')
70 70 1.26 459f3z9u4fb3u
select value$ from props$ where name = 'GLOBAL_DB_NAME'
70 70 1.26 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
65 65 1.17 9ur12dtztw3rx
Module: OEM.BoundedPool
SELECT TARGET_GUID, DELETE_REQUEST_TIME, DELETE_COMPLETE_TIME FROM MGMT_TARGETS_
DELETE DEL WHERE EMD_URL = :B1 OR EXISTS (SELECT 1 FROM MGMT_TARGET_AGENT_ASSOC
WHERE TARGET_GUID = DEL.TARGET_GUID AND AGENT_GUID = :B2 )
65 65 1.17 d33xszqrpzu17
Module: OEM.BoundedPool
SELECT TARGET_GUID, DETECTION_TIME, RESOLVED_TIME FROM MGMT_DUPLICATE_TARGETS WH
ERE DUPLICATE_EMD_URL = :B1
SQL ordered by Parse Calls DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Parse Calls: 5,574
-> Captured SQL account for 52.2% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
61 61 1.09 bdfrydpbzw07g
Module: OEM.BoundedPool
SELECT BLACKOUT_GUID, START_TIME, END_TIME, STATUS FROM MGMT_BLACKOUT_WINDOWS WH
ERE TARGET_GUID=:B2 AND START_TIME <= :B1
60 1,350 1.08 089dbukv1aanh
Module: EM_PING
SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
60 60 1.08 08vznc16ycuag
Module: EM_PING
SELECT SYS_GUID() FROM SYS.DUAL
60 212 1.08 18naypzfmabd6
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTIO
N, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SU
BSTR(:B7 , 1, 512), SUBSTR(:B6 ,1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,1
28), SUBSTR(:B2 ,1,128), SUBSTR(:B1 ,1,256))
60 60 1.08 19v5guvsgcd1v
SELECT C.TARGET_GUID, C.METRIC_GUID, C.STORE_METRIC, C.SCHEDULE, C.COLL_NAME, M.
METRIC_NAME, M.EVAL_FUNC FROM MGMT_METRIC_COLLECTIONS_REP R, MGMT_METRIC_COLLECT
IONS C, MGMT_METRICS M WHERE C.SUSPENDED = 0 AND C.IS_REPOSITORY = 1 AND (C.LAST
_COLLECTED_TIMESTAMP IS NULL OR C.LAST_COLLECTED_TIMESTAMP + C.SCHEDULE / 1440 <
60 60 1.08 34rks4d5suuxz
Module: EM_PING
SELECT COUNT(FAILOVER_ID) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP
< :B1 /(24*60*60)
60 60 1.08 3z6cvmt9w5292
Module: EM_PING
SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=
J.JOB_ID AND STEP_STATUS IN (:B6 , :B5 , :B4 , :B3 , :B2 ) AND STEP_TYPE=:B1 AND
J.EXECUTION_TIMEOUT > 0 AND (CAST(SYS_EXTRACT_UTC(SYSTIMESTAMP) AS DATE)-E.STAR
T_TIME) > (J.EXECUTION_TIMEOUT/24)
60 60 1.08 47a50dvdgnxc2
update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_dat
e = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date,sysdate)) where j
ob=:4
60 60 1.08 6gvch1xu9ca3g
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date
; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
60 60 1.08 6t7007dkc1abh
Module: EM_PING
DELETE FROM MGMT_JOB_EMD_STATUS_QUEUE
60 60 1.08 7gnakyxnvaadf
Module: SEVERITY EVALUATION
SELECT UNIQUE(TARGET_GUID) FROM MGMT_METRIC_DEPENDENCY WHERE CAN_CALCULATE = 1 A
ND DISABLED = 0
60 60 1.08 a1mbfp580hw3k
select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv,
env, field1 from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where j
ob=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u
SQL ordered by Parse Calls DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Parse Calls: 5,574
-> Captured SQL account for 52.2% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
2.name and cowner = u3.name
60 60 1.08 aq8yqxyyb40nn
update sys.job$ set this_date=:1 where job=:2
60 60 1.08 c8h3jdwaa532q
Module: EM_PING
SELECT TO_NUMBER(PARAMETER_VALUE) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B
1
60 60 1.08 cchx5kcx6tgmz
Module: EM_PING
SELECT COUNT(*) FROM MGMT_FAILOVER_TABLE WHERE SYSDATE-LAST_TIME_STAMP > (HEARTB
EAT_INTERVAL*4)/(24*60*60)
60 60 1.08 d59tgwpksgs94
Module: EM_PING
SELECT EMD_URL, EVENT_TYPE, OCCUR_TIME FROM MGMT_JOB_EMD_STATUS_QUEUE ORDER BY O
CCUR_TIME
60 60 1.08 dwssdqx28tzf5
select sysdate + 1 / (24 * 60) from dual
58 58 1.04 cydnuss99swtd
Module: OEM.SystemPool
BEGIN EM_PING.RECORD_BATCH_HEARTBEAT(:1, :2, :3); END;
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
SQL ordered by Version Count DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Instance Activity Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 660 0.2 0.9
CPU used when call started 491 0.1 0.6
CR blocks created 1,018 0.3 1.3
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 0 0.0 0.0
DB time 1,078,528 299.5 1,386.3
DBWR checkpoint buffers written 2,699 0.8 3.5
DBWR checkpoints 0 0.0 0.0
DBWR object drop buffers written 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 91 0.0 0.1
DBWR undo block writes 335 0.1 0.4
IMU CR rollbacks 375 0.1 0.5
IMU Flushes 990 0.3 1.3
IMU Redo allocation size 1,099,732 305.3 1,413.5
IMU commits 651 0.2 0.8
IMU contention 1 0.0 0.0
IMU ktichg flush 12 0.0 0.0
IMU pool not allocated 0 0.0 0.0
IMU recursive-transaction flush 0 0.0 0.0
IMU undo allocation size 4,313,768 1,197.7 5,544.7
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 11,974 3.3 15.4
active txn count during cleanout 85 0.0 0.1
application wait time 5 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 11,588 3.2 14.9
branch node splits 0 0.0 0.0
buffer is not pinned count 31,430 8.7 40.4
buffer is pinned count 344,846 95.7 443.3
bytes received via SQL*Net from 902,491 250.6 1,160.0
bytes sent via SQL*Net to client 1,696,949 471.2 2,181.2
calls to get snapshot scn: kcmgs 32,740 9.1 42.1
calls to kcmgas 2,939 0.8 3.8
calls to kcmgcs 68 0.0 0.1
change write time 20 0.0 0.0
cleanout - number of ktugct call 80 0.0 0.1
cleanouts and rollbacks - consis 24 0.0 0.0
cleanouts only - consistent read 2 0.0 0.0
cluster key scan block gets 5,600 1.6 7.2
cluster key scans 443 0.1 0.6
commit batch performed 0 0.0 0.0
commit batch requested 0 0.0 0.0
commit batch/immediate performed 33 0.0 0.0
commit batch/immediate requested 33 0.0 0.0
commit cleanout failures: block 12 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callba 5 0.0 0.0
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 4,547 1.3 5.8
commit cleanouts successfully co 4,530 1.3 5.8
commit immediate performed 33 0.0 0.0
commit immediate requested 33 0.0 0.0
commit txn count during cleanout 17 0.0 0.0
concurrency wait time 54 0.0 0.1
consistent changes 1,140 0.3 1.5
consistent gets 135,168 37.5 173.7
Instance Activity Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
consistent gets - examination 39,255 10.9 50.5
consistent gets direct 7 0.0 0.0
consistent gets from cache 135,161 37.5 173.7
cursor authentications 15 0.0 0.0
data blocks consistent reads - u 1,054 0.3 1.4
db block changes 26,606 7.4 34.2
db block gets 35,642 9.9 45.8
db block gets direct 14 0.0 0.0
db block gets from cache 35,628 9.9 45.8
deferred (CURRENT) block cleanou 2,611 0.7 3.4
enqueue conversions 722 0.2 0.9
enqueue releases 34,819 9.7 44.8
enqueue requests 34,819 9.7 44.8
enqueue timeouts 0 0.0 0.0
enqueue waits 0 0.0 0.0
execute count 19,790 5.5 25.4
failed probes on index block rec 0 0.0 0.0
free buffer inspected 0 0.0 0.0
free buffer requested 1,888 0.5 2.4
heap block compress 40 0.0 0.1
immediate (CR) block cleanout ap 26 0.0 0.0
immediate (CURRENT) block cleano 1,442 0.4 1.9
index crx upgrade (found) 0 0.0 0.0
index crx upgrade (positioned) 9,023 2.5 11.6
index fast full scans (full) 81 0.0 0.1
index fetch by key 29,293 8.1 37.7
index scans kdiixs1 14,737 4.1 18.9
leaf node 90-10 splits 8 0.0 0.0
leaf node splits 14 0.0 0.0
lob reads 0 0.0 0.0
lob writes 19 0.0 0.0
lob writes unaligned 19 0.0 0.0
logons cumulative 133 0.0 0.2
messages received 2,287 0.6 2.9
messages sent 2,287 0.6 2.9
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 76,632 21.3 98.5
opened cursors cumulative 5,607 1.6 7.2
parse count (failures) 0 0.0 0.0
parse count (hard) 25 0.0 0.0
parse count (total) 5,574 1.6 7.2
parse time cpu 29 0.0 0.0
parse time elapsed 34 0.0 0.0
physical read IO requests 7 0.0 0.0
physical read bytes 57,344 15.9 73.7
physical read total IO requests 4,039 1.1 5.2
physical read total bytes 63,660,032 17,674.8 81,825.2
physical read total multi block 0 0.0 0.0
physical reads 7 0.0 0.0
physical reads cache 0 0.0 0.0
physical reads cache prefetch 0 0.0 0.0
physical reads direct 7 0.0 0.0
physical reads direct (lob) 0 0.0 0.0
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 1,358 0.4 1.8
physical write bytes 22,224,896 6,170.6 28,566.7
physical write total IO requests 6,029 1.7 7.8
physical write total bytes 86,379,008 23,982.6 111,027.0
physical write total multi block 1,407 0.4 1.8
Instance Activity Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
physical writes 2,713 0.8 3.5
physical writes direct 14 0.0 0.0
physical writes direct (lob) 14 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 2,699 0.8 3.5
physical writes non checkpoint 215 0.1 0.3
pinned buffers inspected 0 0.0 0.0
prefetch warmup blocks flushed o 0 0.0 0.0
process last non-idle time 3,542 1.0 4.6
recursive calls 71,793 19.9 92.3
recursive cpu usage 364 0.1 0.5
redo blocks written 10,005 2.8 12.9
redo buffer allocation retries 0 0.0 0.0
redo entries 11,127 3.1 14.3
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 164 0.1 0.2
redo size 4,646,556 1,290.1 5,972.4
redo subscn max counts 987 0.3 1.3
redo synch time 85 0.0 0.1
redo synch writes 365 0.1 0.5
redo wastage 295,840 82.1 380.3
redo write time 165 0.1 0.2
redo writer latching time 0 0.0 0.0
redo writes 1,067 0.3 1.4
rollback changes - undo records 35 0.0 0.0
rollbacks only - consistent read 994 0.3 1.3
rows fetched via callback 3,958 1.1 5.1
session connect time 0 0.0 0.0
session cursor cache hits 1,334 0.4 1.7
session logical reads 170,810 47.4 219.6
session pga memory 96,716,080 26,852.6 124,313.7
session pga memory max 266,044,048 73,865.4 341,958.9
session uga memory 257,701,228,232 71,549,112.3 #############
session uga memory max 114,379,168 31,756.7 147,016.9
shared hash latch upgrades - no 28,863 8.0 37.1
shared hash latch upgrades - wai 0 0.0 0.0
sorts (memory) 4,313 1.2 5.5
sorts (rows) 60,949 16.9 78.3
sql area evicted 0 0.0 0.0
sql area purged 0 0.0 0.0
switch current to new buffer 671 0.2 0.9
table fetch by rowid 180,021 50.0 231.4
table fetch continued row 6 0.0 0.0
table scan blocks gotten 27,605 7.7 35.5
table scan rows gotten 1,009,332 280.2 1,297.3
table scans (direct read) 0 0.0 0.0
table scans (long tables) 0 0.0 0.0
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 4,142 1.2 5.3
total number of times SMON poste 12 0.0 0.0
transaction rollbacks 33 0.0 0.0
undo change vector size 1,667,584 463.0 2,143.4
user I/O wait time 3 0.0 0.0
user calls 8,744 2.4 11.2
user commits 746 0.2 1.0
user rollbacks 32 0.0 0.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 1,439 0.4 1.9
write clones created in backgrou 0 0.0 0.0
Instance Activity Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
write clones created in foregrou 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats - Absolute ValuesDB/Inst: PCARD/pcard Snaps: 2834-28
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
session cursor cache count 142,657 144,182
opened cursors current 859 852
logons current 87 85
-------------------------------------------------------------
Instance Activity Stats - Thread ActivityDB/Inst: PCARD/pcard Snaps: 2834-283
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
-------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX
7 0 4.3 1.0 1,072 0 0 0.0
UNDOTBS1
0 0 0.0 .0 195 0 1 0.0
SYSTEM
0 0 0.0 .0 91 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 /pcard03/oradata/pcard/pwrcrd_sysaux.dbf
7 0 4.3 1.0 1,072 0 0 0.0
SYSTEM /pcard01/oradata/pcard/system01.dbf
0 0 N/A N/A 91 0 0 0.0
UNDOTBS1 /pcard03/oradata/pcard/undotbs01.dbf
0 0 N/A N/A 195 0 1 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 229,564 100 170,946 0 2,699 0 0 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 11 876 2465 5139 829440 5139 N/A
E 0 11 830 2445 4703 829440 4703 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: PCARD/pcard Snap: 2835
-> 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 176 .1 21,769 2.1 370,183
D 352 .2 43,538 1.8 324,975
D 528 .3 65,307 1.6 281,644
D 704 .4 87,076 1.4 257,279
D 880 .5 108,845 1.3 230,962
D 1,056 .6 130,614 1.1 205,245
D 1,232 .7 152,383 1.1 188,847
D 1,408 .8 174,152 1.0 185,265
D 1,584 .9 195,921 1.0 180,762
D 1,760 .9 217,690 1.0 179,562
D 1,856 1.0 229,564 1.0 179,545
D 1,936 1.0 239,459 1.0 179,528
D 2,112 1.1 261,228 1.0 179,528
D 2,288 1.2 282,997 1.0 179,528
D 2,464 1.3 304,766 1.0 179,528
D 2,640 1.4 326,535 1.0 179,528
D 2,816 1.5 348,304 1.0 179,528
D 2,992 1.6 370,073 1.0 179,528
D 3,168 1.7 391,842 1.0 179,528
D 3,344 1.8 413,611 1.0 179,528
D 3,520 1.9 435,380 1.0 179,528
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 87 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 575 443 167.2 0.0 .0 .0 .0 102,400
E 575 444 164.5 0.0 .0 .0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 1,338 1,338 0 0
64K 128K 5 5 0 0
256K 512K 4 4 0 0
512K 1024K 63 63 0 0
1M 2M 29 29 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: PCARD/pcard Snap: 2835
-> 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
---------- ------- ---------------- ---------------- -------- ----------
72 0.1 16,597.9 505.0 97.0 145
144 0.3 16,597.9 7.4 100.0 4
288 0.5 16,597.9 7.4 100.0 0
431 0.8 16,597.9 7.4 100.0 0
575 1.0 16,597.9 7.4 100.0 0
690 1.2 16,597.9 0.0 100.0 0
805 1.4 16,597.9 0.0 100.0 0
920 1.6 16,597.9 0.0 100.0 0
1,035 1.8 16,597.9 0.0 100.0 0
1,150 2.0 16,597.9 0.0 100.0 0
1,725 3.0 16,597.9 0.0 100.0 0
2,300 4.0 16,597.9 0.0 100.0 0
3,450 6.0 16,597.9 0.0 100.0 0
4,600 8.0 16,597.9 0.0 100.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: PCARD/pcard Snap: 2835
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
320 .4 83 4,613 ####### .8 28,727 106.4 8,966,764
400 .5 159 9,029 ####### .9 19,655 72.8 8,978,639
480 .6 238 10,185 ####### .9 12,659 46.9 8,989,748
560 .7 317 18,880 ####### .9 7,967 29.5 9,000,648
640 .8 396 26,166 ####### 1.0 5,578 20.7 9,011,667
720 .9 475 29,847 ####### 1.0 2,934 10.9 9,023,337
800 1.0 554 33,547 ####### 1.0 270 1.0 9,032,151
880 1.1 633 40,215 ####### 1.1 1 .0 9,037,922
960 1.2 712 44,414 ####### 1.1 1 .0 9,041,965
1,040 1.3 791 55,135 ####### 1.1 1 .0 9,043,422
1,120 1.4 870 65,074 ####### 1.1 1 .0 9,044,626
1,200 1.5 949 71,997 ####### 1.1 1 .0 9,045,429
1,280 1.6 1,028 75,184 ####### 1.1 1 .0 9,045,800
1,360 1.7 1,038 76,542 ####### 1.1 1 .0 9,045,976
1,440 1.8 1,038 76,542 ####### 1.1 1 .0 9,046,011
1,520 1.9 1,038 76,542 ####### 1.1 1 .0 9,046,011
1,600 2.0 1,038 76,542 ####### 1.1 1 .0 9,046,011
-------------------------------------------------------------
SGA Target Advisory DB/Inst: PCARD/pcard Snap: 2835
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
684 0.3 25,738 370,150
1,368 0.5 4,520 324,958
2,052 0.8 4,112 205,220
2,736 1.0 4,024 179,545
3,420 1.3 4,023 179,509
4,104 1.5 4,023 179,509
4,788 1.8 4,023 179,509
5,472 2.0 4,023 179,509
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: PCARD/pcard Snap: 2835
Size for Size Est Spill Est Spill Est Unspill Est Unspill
Est (MB) Factor Count Time (s) Count Time (s)
---------- --------- ----------- ----------- ----------- -----------
16 0.5 0 0 0 0
32 1.0 0 0 0 0
48 1.5 0 0 0 0
64 2.0 0 0 0 0
80 2.5 0 0 0 0
96 3.0 0 0 0 0
112 3.5 0 0 0 0
128 4.0 0 0 0 0
144 4.5 0 0 0 0
160 5.0 0 0 0 0
176 5.5 0 0 0 0
192 6.0 0 0 0 0
208 6.5 0 0 0 0
224 7.0 0 0 0 0
240 7.5 0 0 0 0
256 8.0 0 0 0 0
272 8.5 0 0 0 0
288 9.0 0 0 0 0
304 9.5 0 0 0 0
320 10.0 0 0 0 0
-------------------------------------------------------------
Java Pool Advisory DB/Inst: PCARD/pcard Snap: 2835
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Enqueue Activity DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Undo Segment Summary DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 1,076 0 4 1848.5/18 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
21-Jun 13:55 28 186 0 4 1,894 0/0 0/0/0/0/0/0
21-Jun 13:45 19 127 0 2 1,885 0/0 0/0/0/0/0/0
21-Jun 13:35 21 160 0 2 1,876 0/0 0/0/0/0/0/0
21-Jun 13:25 21 105 0 3 1,867 0/0 0/0/0/0/0/0
21-Jun 13:15 21 256 0 3 1,858 0/0 0/0/0/0/0/0
21-Jun 13:05 132 242 0 4 1,849 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: PCARD/pcard Snaps: 2834-2835
-> "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,394 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 18,799 0.0 N/A 0 0 N/A
Consistent RBA 1,067 0.0 N/A 0 0 N/A
FAL request queue 72 0.0 N/A 0 0 N/A
FAL subheap alocation 72 0.0 N/A 0 0 N/A
FOB s.o list latch 190 0.0 N/A 0 0 N/A
In memory undo latch 14,257 0.0 N/A 0 3,167 0.0
JS queue state obj latch 21,600 0.0 N/A 0 0 N/A
KMG MMAN ready and start 1,200 0.0 N/A 0 0 N/A
KTF sga latch 7 0.0 N/A 0 1,065 0.0
KWQMN job cache list lat 223 0.0 N/A 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 0 N/A N/A 0 1,200 0.0
OS process 453 0.0 N/A 0 0 N/A
OS process allocation 1,499 0.0 N/A 0 0 N/A
OS process: request allo 195 0.0 N/A 0 0 N/A
PL/SQL warning settings 735 0.0 N/A 0 0 N/A
SQL memory manager latch 1 0.0 N/A 0 1,197 0.0
SQL memory manager worka 81,480 0.0 N/A 0 0 N/A
Shared B-Tree 138 0.0 N/A 0 0 N/A
active checkpoint queue 2,544 0.0 N/A 0 0 N/A
active service list 7,083 0.0 N/A 0 1,752 0.0
address list 1 0.0 N/A 0 0 N/A
archive control 126 0.0 N/A 0 0 N/A
archive process latch 1,341 0.0 N/A 0 0 N/A
begin backup scn array 14 0.0 N/A 0 0 N/A
cache buffer handles 52 0.0 N/A 0 0 N/A
cache buffers chains 383,721 0.0 N/A 0 1,093 0.0
cache buffers lru chain 8,000 0.0 N/A 0 1,649 0.0
channel handle pool latc 219 0.0 N/A 0 0 N/A
channel operations paren 21,623 0.0 N/A 0 0 N/A
checkpoint queue latch 31,636 0.0 N/A 0 2,005 0.0
client/application info 2,095 0.0 N/A 0 0 N/A
commit callback allocati 108 0.0 N/A 0 0 N/A
compile environment latc 133 0.0 N/A 0 0 N/A
dml lock allocation 15,936 0.0 0.0 0 0 N/A
dummy allocation 268 0.0 N/A 0 0 N/A
enqueue hash chains 70,380 0.0 0.0 0 0 N/A
enqueues 54,213 0.0 N/A 0 0 N/A
event group latch 96 0.0 N/A 0 0 N/A
file cache latch 811 0.0 N/A 0 0 N/A
global KZLD latch for me 71 0.0 N/A 0 0 N/A
hash table column usage 94 0.0 N/A 0 2,407 0.0
hash table modification 64 0.0 N/A 0 0 N/A
job workq parent latch 0 N/A N/A 0 120 0.0
job_queue_processes para 120 0.0 N/A 0 0 N/A
kks stats 43 0.0 N/A 0 0 N/A
kmcptab latch 6 0.0 N/A 0 0 N/A
kmcpvec latch 0 N/A N/A 0 6 0.0
kokc descriptor allocati 52 0.0 N/A 0 0 N/A
ksuosstats global area 242 0.0 N/A 0 0 N/A
ktm global data 20 0.0 N/A 0 0 N/A
kwqbsn:qsga 137 0.0 N/A 0 0 N/A
lgwr LWN SCN 1,871 0.0 N/A 0 0 N/A
library cache 103,939 0.0 2.0 0 0 N/A
library cache load lock 46 0.0 N/A 0 0 N/A
library cache lock 45,044 0.0 N/A 0 0 N/A
library cache lock alloc 1,968 0.0 N/A 0 0 N/A
library cache pin 54,887 0.0 0.0 0 0 N/A
Latch Activity DB/Inst: PCARD/pcard Snaps: 2834-2835
-> "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
------------------------ -------------- ------ ------ ------ ------------ ------
library cache pin alloca 364 0.0 N/A 0 0 N/A
list of block allocation 286 0.0 N/A 0 0 N/A
loader state object free 42 0.0 N/A 0 0 N/A
logminer context allocat 1 0.0 N/A 0 0 N/A
message pool operations 66 0.0 N/A 0 0 N/A
messages 28,779 0.0 N/A 0 0 N/A
mostly latch-free SCN 1,871 0.0 N/A 0 0 N/A
ncodef allocation latch 58 0.0 N/A 0 0 N/A
object queue header heap 2,557 0.0 N/A 0 12 0.0
object queue header oper 12,714 0.0 0.0 0 0 N/A
object stats modificatio 19 0.0 N/A 0 0 N/A
parallel query alloc buf 476 0.0 N/A 0 0 N/A
parameter list 518 0.0 N/A 0 0 N/A
parameter table allocati 268 0.0 N/A 0 0 N/A
post/wait queue 543 0.0 N/A 0 341 0.0
process allocation 195 0.0 N/A 0 96 0.0
process group creation 195 0.0 N/A 0 0 N/A
qmn task queue latch 903 0.0 N/A 0 0 N/A
redo allocation 11,075 0.0 0.0 0 11,177 0.0
redo copy 0 N/A N/A 0 11,177 0.5
redo writing 8,273 0.0 N/A 0 0 N/A
resmgr group change latc 398 0.0 N/A 0 0 N/A
resmgr:active threads 265 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 264 0.0 N/A 0 0 N/A
resmgr:schema config 1 0.0 N/A 0 0 N/A
row cache objects 102,182 0.0 N/A 0 0 N/A
rules engine aggregate s 21 0.0 N/A 0 0 N/A
rules engine rule set st 142 0.0 N/A 0 0 N/A
sequence cache 475 0.0 N/A 0 0 N/A
session allocation 6,430 0.0 0.0 0 0 N/A
session idle bit 20,160 0.0 N/A 0 0 N/A
session state list latch 361 0.0 N/A 0 0 N/A
session switching 58 0.0 N/A 0 0 N/A
session timer 1,209 0.0 N/A 0 0 N/A
shared pool 10,840 0.1 0.2 0 0 N/A
shared pool sim alloc 2 0.0 N/A 0 0 N/A
shared pool simulator 37,501 0.0 N/A 0 0 N/A
shared server info 24 0.0 N/A 0 0 N/A
simulator hash latch 8,491 0.0 N/A 0 0 N/A
simulator lru latch 2,699 0.0 N/A 0 5,766 0.0
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 168 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
threshold alerts latch 1,459 0.0 N/A 0 0 N/A
transaction allocation 138 0.0 N/A 0 0 N/A
transaction branch alloc 1,209 0.0 N/A 0 0 N/A
undo global data 6,618 0.0 N/A 0 0 N/A
user lock 408 0.0 N/A 0 0 N/A
virtual circuit buffers 41,205 0.1 0.0 0 0 N/A
virtual circuit queues 18,390 0.0 0.0 0 0 N/A
virtual circuits 8,646 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: PCARD/pcard Snaps: 2834-2835
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
shared pool
10,840 6 1 5 0 0 0
library cache
103,939 4 8 3 0 0 0
slave class create
8 1 1 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: PCARD/pcard Snaps: 2834-2835
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
library cache kglScanDependency 0 8 0
object queue header oper kcbo_switch_cq 0 1 0
shared pool kghalo 0 1 0
slave class create ksvcreate 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Total Logical Reads: 170,810
-> Captured Segments account for 77.6% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYSMAN SYSAUX MGMT_CURRENT_METRICS INDEX 44,224 25.89
SYS SYSTEM FILE$ TABLE 13,504 7.91
SYSMAN SYSAUX MGMT_METRICS_RAW_PK INDEX 7,312 4.28
POWERCARD POWERCARD_ P7_STORE_AND_FORWARD TABLE 6,928 4.06
SYS SYSTEM SOURCE$ TABLE 5,392 3.16
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: PCARD/pcard Snaps: 2834-2835
-> "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 1
dc_database_links 144 0.0 0 N/A 0 1
dc_files 12,960 0.0 0 N/A 0 60
dc_global_oids 3,646 0.0 0 N/A 0 308
dc_histogram_data 1,536 0.0 0 N/A 0 9,832
dc_histogram_defs 819 16.0 0 N/A 0 38,587
dc_object_ids 3,956 0.0 0 N/A 0 10,762
dc_objects 326 1.8 0 N/A 0 13,349
dc_profiles 131 0.0 0 N/A 0 1
dc_rollback_segments 324 0.0 0 N/A 0 17
dc_segments 58 0.0 0 N/A 2 11,611
dc_sequences 2 0.0 0 N/A 2 14
dc_tablespaces 1,388 0.0 0 N/A 0 57
dc_usernames 307 0.0 0 N/A 0 236
dc_users 10,230 0.0 0 N/A 1 309
outstanding_alerts 705 1.6 0 N/A 21 113
-------------------------------------------------------------
Library Cache Activity DB/Inst: PCARD/pcard Snaps: 2834-2835
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 831 0.0 6,845 0.0 0 0
CLUSTER 2 0.0 6 0.0 0 0
SQL AREA 1,979 1.5 21,670 0.3 0 0
TABLE/PROCEDURE 266 0.0 9,727 0.2 23 0
TRIGGER 52 0.0 395 0.0 0 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 130.6 N/A 1.5 4.0 22 26 85 85
Freeable 31.2 .0 1.6 1.5 5 N/A 20 20
SQL 3.5 2.2 .0 .1 0 6 75 35
PL/SQL 1.9 1.0 .0 .0 0 8 83 83
E Other 129.4 N/A 1.6 4.0 22 26 82 82
Freeable 29.9 .0 1.6 1.6 5 N/A 19 19
SQL 3.4 2.2 .0 .1 0 6 73 33
PL/SQL 1.9 1.0 .0 .0 0 8 81 81
-------------------------------------------------------------
SGA Memory Summary DB/Inst: PCARD/pcard Snaps: 2834-2835
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 1,946,157,056
Fixed Size 2,086,736
Redo Buffers 14,688,256
Variable Size 905,971,888
-------------------
sum 2,868,903,936
-------------------------------------------------------------
SGA breakdown difference DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 16.0 16.0 0.00
large PX msg pool .9 .9 0.00
large free memory 6.7 6.7 -0.83
large session heap 8.4 8.5 0.66
shared CCursor 69.4 69.5 0.16
shared Heap0: KGL 21.8 21.8 0.01
shared KGLS heap 52.7 52.8 0.12
shared KQR L PO 13.0 13.0 0.04
shared KQR M PO 30.2 30.3 0.21
shared PCursor 37.7 37.7 0.15
shared PL/SQL MPCODE 19.3 19.3 0.00
shared db_block_hash_buckets 22.5 22.5 0.00
shared free memory 91.7 90.4 -1.39
shared library cache 36.1 36.1 0.08
shared sql area 283.1 284.1 0.33
stream free memory 31.9 31.9 0.00
buffer_cache 1,856.0 1,856.0 0.00
fixed_sga 2.0 2.0 0.00
log_buffer 14.0 14.0 0.00
-------------------------------------------------------------
Streams CPU/IO Usage DB/Inst: PCARD/pcard Snaps: 2834-2835
-> 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 72,992 0 0
QMON Coordinator 16,080 0 0
-------------------------------------------------------------
Streams Capture DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: PCARD/pcard Snaps: 2834-2835
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: PCARD/pcard Snaps: 2834-2835
-> Rule Sets ordered by Evaluations
Fast SQL CPU Elapsed
Ruleset Name Evals Evals Execs Time Time
------------------------- -------- -------- -------- -------- --------
SYS.ALERT_QUE_R 21 0 0 0 0
-------------------------------------------------------------
Resource Limit Stats DB/Inst: PCARD/pcard Snap: 2835
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: PCARD/pcard Snaps: 2834-2835
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /pcard18/admin/pcard/adump
background_dump_dest /pcard18/admin/pcard/bdump
compatible 10.2.0.1.0
control_files /pcard02/oradata/pcard/control01.
core_dump_dest /pcard18/admin/pcard/cdump
db_block_size 8192
db_domain
db_file_multiblock_read_count 16
db_name pcard
dispatchers (PROTOCOL=TCP) (SERVICE=pcard)
job_queue_processes 10
log_archive_dest_1 LOCATION=/dbpcardarch/pcard1/PCAR
open_cursors 300
pga_aggregate_target 602931200
processes 500
remote_login_passwordfile EXCLUSIVE
sga_max_size 2868903936
sga_target 2868903936
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest /pcard18/admin/pcard/udump
-------------------------------------------------------------
End of Report