ASH Report For PCARD/pcard
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ------------
PCARD 1840828064 pcard 1 10.2.0.4.0 NO rac01.nucleu
CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size
---- ------------------ ------------------ ------------------ ------------------
16 9,008M (100%) 7,424M (82.4%) 1,504M (16.7%) 29.0M (0.3%)
Analysis Begin Time: 21-Jun-11 14:52:12
Analysis End Time: 21-Jun-11 15:07:12
Elapsed Time: 15.0 (mins)
Sample Count: 61
Average Active Sessions: 0.07
Avg. Active Session per CPU: 0.00
Report Target: None specified
Top User Events DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
control file sequential read System I/O 26.23 0.02
CPU + Wait for CPU CPU 24.59 0.02
switch logfile command Administrative 3.28 0.00
RMAN backup & recovery I/O System I/O 1.64 0.00
control file parallel write System I/O 1.64 0.00
-------------------------------------------------------------
Top Background Events DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
CPU + Wait for CPU CPU 9.84 0.01
control file sequential read System I/O 9.84 0.01
ARCH wait on SENDREQ Network 4.92 0.00
db file sequential read User I/O 4.92 0.00
log file parallel write System I/O 4.92 0.00
-------------------------------------------------------------
Top Event P1/P2/P3 Values DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
Event % Event P1 Value, P2 Value, P3 Value % Activity
------------------------------ ------- ----------------------------- ----------
Parameter 1 Parameter 2 Parameter 3
-------------------------- -------------------------- --------------------------
control file sequential read 36.07 "0","17","1" 4.92
file# block# blocks
"0","1","1" 3.28
"0","11","1" 3.28
db file sequential read 6.56 "1","8243","1" 1.64
file# block# blocks
"11","1","1" 1.64
"31","1","1" 1.64
log file parallel write 4.92 "2","2","2" 1.64
files blocks requests
"2","4","2" 1.64
"2","20","2" 1.64
control file parallel write 3.28 "3","3","3" 1.64
files block# requests
"3","418","3" 1.64
RMAN backup & recovery I/O 1.64 "3","256","4294967295" 1.64
count intr timeout
-------------------------------------------------------------
Top Service/Module DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
Service Module % Activity Action % Action
-------------- ------------------------ ---------- ------------------ ----------
SYS$BACKGROUND UNNAMED 29.51 UNNAMED 29.51
SYS$USERS rman@rac01.nucleussoftwa 29.51 0000011 FINISHED12 14.75
0000001 FINISHED70 4.92
0000003 STARTED114 3.28
SYS$BACKGROUND MMON_SLAVE 8.20 Auto-Flush Slave A 8.20
pcard easyagent@rac01.nucleuss 8.20 UNNAMED 8.20
frmweb@app02.nucleussoft 8.20 UNNAMED 8.20
-------------------------------------------------------------
Top Client IDs DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Top SQL Command Types DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
-> 'Distinct SQLIDs' is the count of the distinct number of SQLIDs
with the given SQL Command Type found over all the ASH samples
in the analysis period
Distinct Avg Active
SQL Command Type SQLIDs % Activity Sessions
---------------------------------------- ---------- ---------- ----------
SELECT 12 36.07 0.02
PL/SQL EXECUTE 3 4.92 0.00
-------------------------------------------------------------
Top SQL Statements DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
SQL ID Planhash % Activity Event % Event
------------- ----------- ---------- ------------------------------ ----------
b9yn7yyr5pmxz 1329430332 8.20 CPU + Wait for CPU 8.20
SELECT PROCESSING_CODE,REFERENCE_NUMBER,EXTERNAL_STAN,MESSAGE_TYPE,CARD_NUMBER,C
ARD_ACCEPTOR_ID,INTERNAL_TRANSMISSION_TIME,TRANSACTION_AMOUNT,action_code,AUTHOR
IZATION_CODE,CAPTURE_CODE,ROUTING_CODE,CURRENT_TABLE_INDICATOR,TRANSACTION_CURRE
NCY,SERVICES_SETUP_CODE,FUNCTION_CODE,SOURCE_ACCOUNT_CODE,DESTINATION_ACCOUNT_CO
c8gw6zzr9n9qn 821583789 8.20 control file sequential read 8.20
SELECT /*+ordered*/ FE.FENUM DFNUMBER, FE.FECRC_SCN DFCREATIONSCN, TO_DATE(FE.FE
CRC_TIM,'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNA
M FILENAME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, FE.FESTA STATUS, FH.FHFSZ BLOCKS
, FE.FEBSZ BLOCKSIZE, FH.FHFSZ*FE.FEBSZ/1024 KBYTES, FE.FEURS UNRECOVSCN, DECODE
24vb3s3db0p28 157323055 4.92 control file sequential read 4.92
select count(*) from sys.v_$archived_log where standby_dest = :t and applied = :
s
3a69upryc89m2 3988613580 1.64 CPU + Wait for CPU 1.64
SELECT NVL(MAX(NEXT_CHANGE#),0) FROM V$ARCHIVED_LOG L, V$ARCHIVE_DEST D, V$DATAB
ASE_INCARNATION I WHERE D.TARGET = 'STANDBY' AND (D.VALID_NOW = 'YES' OR D.VALID
_NOW = 'UNKNOWN' OR D.VALID_NOW = 'INACTIVE') AND D.STATUS != 'DEFERRED' AND D.S
TATUS != 'ALTERNATE' AND D.DEPENDENCY = 'NONE' AND D.DEST_ID = L.DEST_ID AND L.S
3dcdrhnkran7p 4006194250 1.64 control file sequential read 1.64
select /*+ rule +*/ round(sum(MBYTES_PROCESSED)) ,round(sum(INPUT_BYTES)) ,ro
und(sum(OUTPUT_BYTES)) from V$RMAN_STATUS start with (RECID=:b1 and STAMP=:b2)
connect by prior RECID=parent_recid
-------------------------------------------------------------
Top SQL using literals DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Top PL/SQL Procedures DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
-> 'PL/SQL entry subprogram' represents the application's top-level
entry-point(procedure, function, trigger, package initialization
or RPC call) into PL/SQL.
-> 'PL/SQL current subprogram' is the pl/sql subprogram being executed
at the point of sampling . If the value is 'SQL', it represents
the percentage of time spent executing SQL for the particular
plsql entry subprogram
PLSQL Entry Subprogram % Activity
----------------------------------------------------------------- ----------
PLSQL Current Subprogram % Current
----------------------------------------------------------------- ----------
SYS.DBMS_RCVMAN.LISTBACKUP 11.48
SQL 11.48
SYS.DBMS_BACKUP_RESTORE.REFRESHAGEDFILES 6.56
SYS.DBMS_BACKUP_RESTORE.REFRESHAGEDFILES 3.28
SYS.DBMS_RCVMAN.LISTBACKUP 1.64
SQL 1.64
DP_ADM.DP_MONITOR.QUERY_ROW_COUNT 4.92
SQL 4.92
SYS.DBMS_BACKUP_RESTORE.DOAUTOBACKUP#2 3.28
SYS.DBMS_BACKUP_RESTORE.DOAUTOBACKUP#2 3.28
POWERCARD.PCRD_GET_PARAM_GENERAL_ROWS.GET_RESOURCES 3.28
SQL 3.28
-------------------------------------------------------------
Top Sessions DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
-> '# Samples Active' shows the number of ASH samples in which the session
was found waiting for that particular event. The percentage shown
in this column is calculated with respect to wall clock time
and not total database activity.
-> 'XIDs' shows the number of distinct transaction IDs sampled in ASH
when the session was waiting for that particular event
-> For sessions running Parallel Queries, this section will NOT aggregate
the PQ slave activity into the session issuing the PQ. Refer to
the 'Top Sessions running PQs' section for such statistics.
Sid, Serial# % Activity Event % Event
--------------- ---------- ------------------------------ ----------
User Program # Samples Active XIDs
-------------------- ------------------------------ ------------------ --------
401, 4494 29.51 control file sequential read 19.67
SYS rman@rac01.nuc...m (TNS V1-V3) 12/900 [ 1%] 0
CPU + Wait for CPU 4.92
3/900 [ 0%] 0
switch logfile command 3.28
2/900 [ 0%] 0
537, 1 11.48 ARCH wait on SENDREQ 4.92
SYS oracle@rac01.n...re.com (ARC0) 3/900 [ 0%] 0
CPU + Wait for CPU 3.28
2/900 [ 0%] 0
control file sequential read 3.28
2/900 [ 0%] 0
459, 626 8.20 CPU + Wait for CPU 8.20
POWERCARD frmweb@app02.n...m (TNS V1-V3) 5/900 [ 1%] 1
470, 47 8.20 db file sequential read 4.92
SYS oracle@rac01.n...re.com (m000) 3/900 [ 0%] 0
CPU + Wait for CPU 1.64
1/900 [ 0%] 0
control file sequential read 1.64
1/900 [ 0%] 0
546, 1 6.56 CPU + Wait for CPU 3.28
SYS oracle@rac01.n...re.com (CKPT) 2/900 [ 0%] 0
control file parallel write 1.64
1/900 [ 0%] 0
control file sequential read 1.64
1/900 [ 0%] 0
-------------------------------------------------------------
Top Blocking Sessions DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
-> Blocking session activity percentages are calculated with respect to
waits on enqueues, latches and "buffer busy" only
-> '% Activity' represents the load on the database caused by
a particular blocking session
-> '# Samples Active' shows the number of ASH samples in which the
blocking session was found active.
-> 'XIDs' shows the number of distinct transaction IDs sampled in ASH
when the blocking session was found active.
Blocking Sid % Activity Event Caused % Event
--------------- ---------- ------------------------------ ----------
User Program # Samples Active XIDs
-------------------- ------------------------------ ------------------ --------
401, 4494 1.64 enq: CF - contention 1.64
SYS rman@rac01.nuc...m (TNS V1-V3) 18/900 [ 2%] 0
547, 1 1.64 log file sync 1.64
SYS oracle@rac01.n...re.com (LGWR) 3/900 [ 0%] 0
-------------------------------------------------------------
Top Sessions running PQs DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Top DB Objects DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Top DB Files DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Top Latches DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
No data exists for this section of the report.
-------------------------------------------------------------
Activity Over Time DB/Inst: PCARD/pcard (Jun 21 14:52 to 15:07)
-> Analysis period is divided into smaller time slots
-> Top 3 events are reported in each of those slots
-> 'Slot Count' shows the number of ASH samples in that slot
-> 'Event Count' shows the number of ASH samples waiting for
that event in that slot
-> '% Event' is 'Event Count' over all ASH samples in the analysis period
Slot Event
Slot Time (Duration) Count Event Count % Event
-------------------- -------- ------------------------------ -------- -------
14:52:12 (1.8 min) 3 CPU + Wait for CPU 2 3.28
control file sequential read 1 1.64
14:54:00 (2.0 min) 1 control file sequential read 1 1.64
14:56:00 (2.0 min) 1 CPU + Wait for CPU 1 1.64
14:58:00 (2.0 min) 4 CPU + Wait for CPU 3 4.92
log file parallel write 1 1.64
15:00:00 (2.0 min) 34 control file sequential read 15 24.59
CPU + Wait for CPU 7 11.48
ARCH wait on SENDREQ 3 4.92
15:02:00 (2.0 min) 7 CPU + Wait for CPU 2 3.28
control file sequential read 2 3.28
control file parallel write 1 1.64
15:04:00 (2.0 min) 4 CPU + Wait for CPU 3 4.92
control file sequential read 1 1.64
15:06:00 (1.2 min) 7 CPU + Wait for CPU 3 4.92
control file sequential read 2 3.28
db file sequential read 1 1.64
-------------------------------------------------------------
End of Report