ASH Report For SKINSTG/SKINSTG1

DB NameDB IdInstanceInst numReleaseRACHost
SKINSTG1860772457SKINSTG1110.2.0.4.0YESstage-rac01

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
41,536M (100%)848M (55.2%)560M (36.5%)8.0M (0.5%)

Sample TimeData Source
Analysis Begin Time:30-Mar-11 07:00:54V$ACTIVE_SESSION_HISTORY
Analysis End Time:30-Mar-11 08:34:54V$ACTIVE_SESSION_HISTORY
Elapsed Time: 94.0 (mins)  
Sample Count: 440 
Average Active Sessions: 0.08 
Avg. Active Session per CPU: 0.02 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% ActivityAvg Active Sessions
CPU + Wait for CPU CPU 9.77 0.01
log file sync Commit 2.95 0.00
gc cr block busy Cluster 1.14 0.00

Back to Top Events
Back to Top

Top Background Events

EventEvent Class% ActivityAvg Active Sessions
control file sequential read System I/O 35.68 0.03
control file parallel write System I/O 25.00 0.02
Streams AQ: qmn coordinator waiting for slave to start Other 6.36 0.00
CPU + Wait for CPU CPU 5.45 0.00
reliable message Other 3.86 0.00

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
control file sequential read 36.36 "0","4","1" 12.05 file# block# blocks
    "0","35","1" 12.05      
    "0","3","1" 3.18      
control file parallel write 25.00 "3","3","3" 25.00 files block# requests
reliable message 3.86 "2264808368","4753080968","2216371320" 1.36 channel context channel handle broadcast message
log file parallel write 3.64 "1","3","1" 0.91 files blocks requests
log file sync 2.95 "575","0","0" 0.23 buffer# NOT DEFINED NOT DEFINED

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
SYS$BACKGROUND UNNAMED 81.14 UNNAMED 81.14
SKINSTG UNNAMED 13.41 UNNAMED 13.41
  OEM.DefaultPool 1.82 /rac/racSitemap 1.59
SYS$USERS emagent@stage-rac01 (TNS V1-V3) 1.59 UNNAMED 1.59
SYS$BACKGROUND MMON_SLAVE 1.14 Auto-Flush Slave Action 1.14

Back to Load Profile
Back to Top

Top Client IDs

Client ID% ActivityAvg Active SessionsUserProgramService
SYSTEM@su-nat.int.smq.datapipe.net@Mozilla/4.0 (compatible; MSI 1.36 0.00 SYSMAN OMS SKINSTG

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT 12 9.77 0.01
INSERT 3 1.14 0.00

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL Statements

SQL IDPlanhash% ActivityEvent% EventSQL Text
60hnnv7bb12wh 857639778 6.36 CPU + Wait for CPU 5.23 select user0_.USER_ID as USER1...
4gd6b1r53yt88   5.45 reliable message 3.64 ** SQL Text Not Available **

Back to Top SQL
Back to Top

Top SQL using literals

No data exists for this section of the report.

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
4gd6b1r53yt88** SQL Text Not Available **
60hnnv7bb12whselect user0_.USER_ID as USER1_7_, user0_.PREF_LOCALE_CD as PREF2_7_, user0_.LAST_REGIMEN_ID as LAST3_7_, user0_.PREV_REGIMEN_ID as PREV4_7_, user0_.EMAIL_ADDR as EMAIL5_7_, user0_.PSWD_HASH as PSWD6_7_, user0_.GIVEN_NAME as GIVEN7_7_, user0_.FAMILY_NAME as FAMILY8_7_, user0_.DOB as DOB7_, user0_.AGE as AGE7_, user0_.GENDER as GENDER7_, user0_.POSTAL_CODE as POSTAL12_7_, user0_.SKINID_OPTIN as SKINID13_7_, user0_.NEUTROGENA_OPTIN as NEUTROGENA14_7_, user0_.JNJ_OPTIN as JNJ15_7_, user0_.PURCHASE_FLAG as PURCHASE16_7_, user0_.CREATED_AT as CREATED17_7_, user0_.MODIFIED_AT as MODIFIED18_7_, user0_.CREATED_BY as CREATED19_7_, user0_.MODIFIED_BY as MODIFIED20_7_, user0_.MEMBER_STATUS as MEMBER21_7_, user0_.CELL_CODE as CELL22_7_, user0_.CAMPAIGN_ID as CAMPAIGN23_7_, user0_.POINTS as POINTS7_ from SKINID_USERS user0_ where lower(user0_.EMAIL_ADDR)=:1

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Sessions

Back to Top

Top Sessions

Sid, Serial#% ActivityEvent% EventUserProgram# Samples ActiveXIDs
544, 1 28.41 control file parallel write 25.00 SYS oracle@stage-rac01 (CKPT) 110/5,640 [ 2%] 0
    control file sequential read 3.18     14/5,640 [ 0%] 0
550, 1 24.77 control file sequential read 24.09 SYS oracle@stage-rac01 (LMON) 106/5,640 [ 2%] 0
1084,42356 7.73 CPU + Wait for CPU 4.55 SKINIDC   20/5,640 [ 0%] 0
    log file sync 1.36     6/5,640 [ 0%] 0
1098, 5 7.05 control file sequential read 7.05 SYS oracle@stage-rac01 (ARC1) 31/5,640 [ 1%] 0
532, 9 6.36 Streams AQ: qmn coordinator waiting for slave to start 6.36 SYS oracle@stage-rac01 (QMNC) 28/5,640 [ 0%] 0

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
1102, 1 3.86 log file sync 2.95 SYS oracle@stage-rac01 (LGWR) 16/5,640 [ 0%] 0

Back to Top Sessions
Back to Top

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Objects/Files/Latches

Back to Top

Top DB Objects

Object ID% ActivityEvent% EventObject Name (Type)Tablespace
92812 1.14 gc cr block 2-way 0.45 SKINIDC.SKINID_USERS (TABLE) SKIN_DATA

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
6 3.18 db file scattered read 0.91 +DATA/skinstg/skin_data.dbf SKIN_DATA

Back to Top Objects/Files/Latches
Back to Top

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches
Back to Top

Activity Over Time

Slot Time (Duration)Slot CountEventEvent Count% Event
07:00:54 (2.1 min) 13 CPU + Wait for CPU 7 1.59
    control file sequential read 5 1.14
    reliable message 1 0.23
07:03:00 (9.0 min) 38 control file sequential read 11 2.50
    CPU + Wait for CPU 8 1.82
    Streams AQ: qmn coordinator waiting for slave to start 5 1.14
07:12:00 (9.0 min) 40 CPU + Wait for CPU 9 2.05
    control file sequential read 7 1.59
    log file parallel write 6 1.36
07:21:00 (9.0 min) 39 CPU + Wait for CPU 17 3.86
    control file sequential read 8 1.82
    control file parallel write 5 1.14
07:30:00 (9.0 min) 27 control file parallel write 8 1.82
    control file sequential read 8 1.82
    Streams AQ: qmn coordinator waiting for slave to start 7 1.59
07:39:00 (9.0 min) 85 control file sequential read 45 10.23
    control file parallel write 28 6.36
    Streams AQ: qmn coordinator waiting for slave to start 6 1.36
07:48:00 (9.0 min) 64 control file parallel write 30 6.82
    control file sequential read 23 5.23
    CPU + Wait for CPU 2 0.45
07:57:00 (9.0 min) 28 control file sequential read 15 3.41
    control file parallel write 8 1.82
    CPU + Wait for CPU 3 0.68
08:06:00 (9.0 min) 32 control file sequential read 15 3.41
    control file parallel write 9 2.05
    Streams AQ: qmn coordinator waiting for slave to start 5 1.14
08:15:00 (9.0 min) 38 CPU + Wait for CPU 13 2.95
    control file sequential read 9 2.05
    control file parallel write 8 1.82
08:24:00 (9.0 min) 26 control file sequential read 8 1.82
    CPU + Wait for CPU 7 1.59
    control file parallel write 7 1.59
08:33:00 (1.9 min) 10 control file sequential read 6 1.36
    control file parallel write 2 0.45
    CPU + Wait for CPU 1 0.23


Back to Top

End of Report