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