<!-- Oracle Remote Diagnostic Agent / Data Collection Results 4.17 -->
<!-- Module:S110PERF Version:1.39 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  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
</verbatim>
