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 uatdb.nucleu
CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size
---- ------------------ ------------------ ------------------ ------------------
2 2,736M (100%) 1,824M (66.7%) 832M (30.4%) 4.0M (0.1%)
Analysis Begin Time: 21-Jun-11 14:20:40
Analysis End Time: 21-Jun-11 14:35:40
Elapsed Time: 15.0 (mins)
Sample Count: 49
Average Active Sessions: 0.05
Avg. Active Session per CPU: 0.03
Report Target: None specified
Top User Events DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
db file sequential read User I/O 53.06 0.03
CPU + Wait for CPU CPU 32.65 0.02
db file scattered read User I/O 2.04 0.00
-------------------------------------------------------------
Top Background Events DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
Avg Active
Event Event Class % Activity Sessions
----------------------------------- --------------- ---------- ----------
CPU + Wait for CPU CPU 6.12 0.00
control file parallel write System I/O 4.08 0.00
log file parallel write System I/O 2.04 0.00
-------------------------------------------------------------
Top Event P1/P2/P3 Values DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
Event % Event P1 Value, P2 Value, P3 Value % Activity
------------------------------ ------- ----------------------------- ----------
Parameter 1 Parameter 2 Parameter 3
-------------------------- -------------------------- --------------------------
db file sequential read 53.06 "1","2681","1" 2.04
file# block# blocks
"1","5457","1" 2.04
"1","9809","1" 2.04
control file parallel write 4.08 "3","3","3" 4.08
files block# requests
db file scattered read 2.04 "1","586","7" 2.04
file# block# blocks
log file parallel write 2.04 "1","2","1" 2.04
files blocks requests
-------------------------------------------------------------
Top Service/Module DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
Service Module % Activity Action % Action
-------------- ------------------------ ---------- ------------------ ----------
SYS$USERS SQL*Plus 81.63 UNNAMED 81.63
SYS$BACKGROUND UNNAMED 12.24 UNNAMED 12.24
pcard OEM.BoundedPool 2.04 UNNAMED 2.04
SYS$USERS perl@uatdb.nucleussoftwa 2.04 UNNAMED 2.04
sqlplus@uatdb.nucleussof 2.04 UNNAMED 2.04
-------------------------------------------------------------
Top Client IDs DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
No data exists for this section of the report.
-------------------------------------------------------------
Top SQL Command Types DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> '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 81.63 0.04
INSERT 1 2.04 0.00
PL/SQL EXECUTE 1 2.04 0.00
-------------------------------------------------------------
Top SQL Statements DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
SQL ID Planhash % Activity Event % Event
------------- ----------- ---------- ------------------------------ ----------
gk5ktyxs4agyw 3790912635 48.98 db file sequential read 44.90
SELECT '|' || v.status || '|' || d.file_name || '|' || d.ta
blespace_name || '| ' || d.file_id || '| ' || d.relative_fno || '|
' || TO_CHAR((d.bytes / 1048576), '99999990D000') || '| '
|| TO_CHAR(NVL((d.bytes - NVL(s.bytes, 0)) / 1048576, 0),
CPU + Wait for CPU 4.08
9tjq6dfrwgzfr 4238420532 10.20 CPU + Wait for CPU 8.16
select output from table(dbms_workload_repository.ash_report_text( :dbid,
:inst_num, to_date(:btime, '
DD-Mon-YY HH24:MI:SS'), to_date(:etime, 'DD-Mon-YY
HH24:MI:SS'), 0, to_nu
db file sequential read 2.04
gtxzycka2u5fy 851311265 4.08 CPU + Wait for CPU 4.08
select output from table(dbms_workload_repository.awr_report_text( :dbid,
:inst_num,
:bid, :eid,
:rpt_options ))
2f0rj4at6g3ju 2992066943 2.04 db file scattered read 2.04
SELECT '|' || e.owner || '|' || e.name || '|' || TO_CHAR(e.
line) || '/' || TO_CHAR(e.position) || '|' || REPLACE(REPLACE(REPLACE(REP
LACE(LTRIM(e.text), '|','|'), '<','<'), '>','>
;'), CHR(10),'%BR%') || '|' FROM dba_errors e ORDER BY e.owner, e.name
3z9ucawhdg5g7 56213068 2.04 CPU + Wait for CPU 2.04
SELECT '|' || owner || '|' || table_name || '|' || partitio
ning_type || '|' || subpartitioning_type || '| ' || partition_coun
t || '| ' || partitioning_key_count || '| ' || subpartitioning_key
_count || '|' || NVL(def_tablespace_name,'%NULL%') || '|' || def_l
-------------------------------------------------------------
Top SQL using literals DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
No data exists for this section of the report.
-------------------------------------------------------------
Top PL/SQL Procedures DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> '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_WORKLOAD_REPOSITORY.ASH_REPORT_TEXT 10.20
SQL 10.20
SYS.DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_TEXT 4.08
SYS.DBMS_SWRF_REPORT_INTERNAL.#package_initialization 2.04
SQL 2.04
SYS.DBMS_OUTPUT.DISABLE 2.04
SYS.DBMS_OUTPUT.DISABLE 2.04
SYS.DBMS_PRVTAQIS.ADD_ADDRESS 2.04
SQL 2.04
SYSMAN.METRICS_SEVERITY_DUPLICATES 2.04
SQL 2.04
-------------------------------------------------------------
Top Sessions DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> '# 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
-------------------- ------------------------------ ------------------ --------
530, 6468 42.86 db file sequential read 40.82
SYSTEM sqlplus@uatdb....m (TNS V1-V3) 20/900 [ 2%] 0
CPU + Wait for CPU 2.04
1/900 [ 0%] 0
530, 6525 10.20 CPU + Wait for CPU 8.16
SYSTEM sqlplus@uatdb....m (TNS V1-V3) 4/900 [ 0%] 0
db file sequential read 2.04
1/900 [ 0%] 0
530, 6814 6.12 db file sequential read 4.08
SYSTEM sqlplus@uatdb....m (TNS V1-V3) 2/900 [ 0%] 0
CPU + Wait for CPU 2.04
1/900 [ 0%] 0
553, 1 6.12 CPU + Wait for CPU 6.12
SYS oracle@uatdb.n...re.com (MMAN) 3/900 [ 0%] 0
530, 6523 4.08 CPU + Wait for CPU 4.08
SYSTEM sqlplus@uatdb....m (TNS V1-V3) 2/900 [ 0%] 0
-------------------------------------------------------------
Top Blocking Sessions DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
No data exists for this section of the report.
-------------------------------------------------------------
Top Sessions running PQs DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
No data exists for this section of the report.
-------------------------------------------------------------
Top DB Objects DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> With respect to Application, Cluster, User I/O and buffer busy waits only.
Object ID % Activity Event % Event
--------------- ---------- ------------------------------ ----------
Object Name (Type) Tablespace
----------------------------------------------------- -------------------------
69 2.04 db file sequential read 2.04
SYS.PROCEDURE$ (TABLE) SYSTEM
79 2.04 db file scattered read 2.04
SYS.ERROR$ (TABLE) SYSTEM
4614 2.04 db file sequential read 2.04
SYSTEM.AQ$_SCHEDULES (TABLE) SYSTEM
54377 2.04 db file sequential read 2.04
SYSMAN.SEVERITY_PRIMARY_KEY (INDEX) SYSAUX
-------------------------------------------------------------
Top DB Files DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> With respect to Cluster and User I/O events only.
File ID % Activity Event % Event
--------------- ---------- ------------------------------ ----------
File Name Tablespace
----------------------------------------------------- -------------------------
1 16.33 db file sequential read 14.29
/pcard01/oradata/pcard/system01.dbf SYSTEM
db file scattered read 2.04
6 10.20 db file sequential read 10.20
/pcard08/oradata/pcard/pwrcrd_usr01.dbf POWERCARD_USERS
3 8.16 db file sequential read 8.16
/pcard03/oradata/pcard/pwrcrd_sysaux.dbf SYSAUX
8 4.08 db file sequential read 4.08
/pcard12/oradata/pcard/pwrcrd_ndx_par01.dbf POWERCARD_INDEX_PAR
11 2.04 db file sequential read 2.04
/pcard09/oradata/pcard/pwrcrd_ndx_bo_part01_01.dbf POWERCARD_INDEX_BO_PART01
-------------------------------------------------------------
Top Latches DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
No data exists for this section of the report.
-------------------------------------------------------------
Activity Over Time DB/Inst: PCARD/pcard (Jun 21 14:20 to 14:35)
-> 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:26:00 (2.0 min) 39 db file sequential read 23 46.94
CPU + Wait for CPU 15 30.61
log file parallel write 1 2.04
14:28:00 (2.0 min) 2 CPU + Wait for CPU 1 2.04
control file parallel write 1 2.04
14:30:00 (2.0 min) 1 control file parallel write 1 2.04
14:34:00 (1.7 min) 7 CPU + Wait for CPU 3 6.12
db file sequential read 3 6.12
db file scattered read 1 2.04
-------------------------------------------------------------
End of Report