<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.23 -->
<!-- Module:S110PERF Version:2.05 Report:ash_report OS:linux -->
<verbatim>
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), '|','&#124;'), '<','&lt;'), '>','&gt
;'), 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
</verbatim>
