ASH Report For SIEBELDB/siebeldb1

DB NameDB IdInstanceInst numReleaseRACHost
SIEBELDB1705445768siebeldb1111.2.0.2.0YEScrm-db-001

CPUsSGA SizeBuffer CacheShared PoolASH Buffer Size
6494,807M (100%)70,144M (74.0%)20,224M (21.3%)128.0M (0.1%)

Sample TimeData Source
Analysis Begin Time:20-Feb-12 12:19:55V$ACTIVE_SESSION_HISTORY
Analysis End Time:20-Feb-12 12:22:55V$ACTIVE_SESSION_HISTORY
Elapsed Time: 3.0 (mins)  
Sample Count: 45,187 
Average Active Sessions: 251.04 
Avg. Active Session per CPU: 3.92 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
gc buffer busy acquireCluster56.74142.43
gc cr block busyCluster12.3230.93
log file syncCommit9.9324.92
gc buffer busy releaseCluster6.1215.36
gc current block busyCluster5.8314.63

Back to Top Events
Back to Top

Top Background Events

No data exists for this section of the report.

Back to Top Events
Back to Top

Top Cluster Events

Event% EventRemote Instance#% Activity
gc buffer busy acquire56.74 36.93
  219.81
gc cr block busy12.48212.48
gc buffer busy release6.1224.67
   1.45
gc current block busy5.9925.99

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
gc buffer busy acquire56.74"136","3511084","1"7.46 file#block#class#
  "149","1008210","1"5.54    
  "956","325515","1"4.88    
log file sync9.96"36089","1250998218","0"0.08 buffer#sync scnNOT DEFINED
gc buffer busy release6.12"149","1011183","1"2.18 file#block#class#
  "920","939444","1"1.79    
db file sequential read2.32"1130","3395741","1"0.08 file#block#blocks
buffer busy waits2.16"1","227","1"1.50 file#block#class#

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
siebeldbsiebmtshmw.exe92.68UNNAMED92.68
 siebprocmw.exe5.37UNNAMED5.37
SYS$BACKGROUNDUNNAMED1.41UNNAMED1.41

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

SQL Command TypeDistinct SQLIDs% ActivityAvg Active Sessions
SELECT33942.23106.01
UPDATE9821.7754.66
INSERT10219.1948.18

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution88.76222.82

Back to Load Profile
Back to Top

Top Remote Instances

Wait Class% Wait ClassRemote Instance#% Activity
Cluster81.42243.00
   38.42

Back to Load Profile
Back to Top

Top SQL

Back to Top

Top SQL with Top Events

SQL IDPlanhashSampled # of Executions% ActivityEvent% EventTop Row Source% RwSrcSQL Text
fj2b3rrraadjx1000638820715.03 gc buffer busy acquire4.88INDEX - UNIQUE SCAN4.88 SELECT T5.CONFLICT_ID, T5.LAST...
2nhcts7szbzar3698109717263.64 gc buffer busy acquire3.49INDEX - RANGE SCAN3.49 SELECT T1.CONFLICT_ID, T1.LAST...
gptyps8uymuu7960859386623.16 gc buffer busy acquire2.39LOAD TABLE CONVENTIONAL2.39 INSERT INTO SIEBEL.S_AUDIT_IT...
bsksjt0k9hh3g 342.53 gc buffer busy acquire1.46** Row Source Not Available **1.46 INSERT INTO SIEBEL.S_CONTACT_...
arukbn6x207pq2254235305232.43 gc buffer busy acquire2.27INDEX - UNIQUE SCAN2.27 SELECT T8.CONFLICT_ID, T8.LAST...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
fj2b3rrraadjx1000638820715.03 INDEX - UNIQUE SCAN5.03gc buffer busy acquire4.88 SELECT T5.CONFLICT_ID, T5.LAST...
2nhcts7szbzar3698109717263.64 INDEX - RANGE SCAN3.64gc buffer busy acquire3.49 SELECT T1.CONFLICT_ID, T1.LAST...
gptyps8uymuu7960859386623.16 LOAD TABLE CONVENTIONAL3.16gc buffer busy acquire2.39 INSERT INTO SIEBEL.S_AUDIT_IT...
bsksjt0k9hh3g 342.53 ** Row Source Not Available **2.53gc buffer busy acquire1.46 INSERT INTO SIEBEL.S_CONTACT_...
arukbn6x207pq2254235305232.43 INDEX - UNIQUE SCAN2.43gc buffer busy acquire2.27 SELECT T8.CONFLICT_ID, T8.LAST...

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

Top Parsing Module/Action

No data exists for this section of the report.

Back to Top SQL
Back to Top

Complete List of SQL Text

SQL IdSQL Text
2nhcts7szbzarSELECT T1.CONFLICT_ID, T1.LAST_UPD, T1.CREATED, T1.LAST_UPD_BY, T1.CREATED_BY, T1.MODIFICATION_NUM, T1.ROW_ID, T1.COMPLETED_FLG, T1.TASK_ID_VAL FROM SIEBEL.S_TU_INST T1 WHERE (T1.TASK_ID_VAL = :1)
arukbn6x207pq SELECT T8.CONFLICT_ID, T8.LAST_UPD, T8.CREATED, T8.LAST_UPD_BY, T8.CREATED_BY, T8.MODIFICATION_NUM, T8.ROW_ID, T6.X_PROMOTION_NAME, T8.ATTRIB_03, T1.CURR_PRI_LST_ID, T8.ATTRIB_34, T8.ATTRIB_07, T5.NAME, T8.ATTRIB_44, T4.NAME, T8.ATTRIB_39, T8.ATTRIB_09, T8.ATTRIB_06, T8.ATTRIB_05, T2.ORDER_NUM, T8.ATTRIB_40, T7.ORDER_SUB_TYPE, T7.ORDER_TYPE, T8.ATTRIB_37, T8.ATTRIB_35, T3.ADDR_NAME, T8.ATTRIB_02, T8.X_SUB_PROC_NAME, T8.ATTRIB_04, T8.ATTRIB_46, T6.X_PROMOTION_NAME, T5.OU_NUM, T5.X_PRICE_TYPE_CD, T5.X_ACCOUNT_TYPE, T8.X_LATEST_CART_REVNUM, T6.X_VIRTUAL_PROD_FLAG, T8.X_VIRTUAL_PROD_NUM, T8.X_ASSET_INFO, T8.X_NEW_PROM_FLG FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_ORDER T2, SIEBEL.S_ADDR_PER T3, SIEBEL.S_PROD_INT T4, SIEBEL.S_ORG_EXT T5, SIEBEL.S_PROD_INT T6, SIEBEL.CX_PROC_ACTCD T7, SIEBEL.S_CONTACT_XM T8 WHERE T8.ATTRIB_03 = T1.PAR_ROW_ID (+) AND T8.X_SUB_PROC_NAME = T7.BIZ_PROC_NAME (+) AND T8.ATTRIB_44 = T5.PAR_ROW_ID (+) AND T8.ATTRIB_39 = T4.ROW_ID (+) AND T8.ATTRIB_05 = T2.ROW_ID (+) AND T8.ATTRIB_02 = T3.ROW_ID (+) AND T8.ATTRIB_46 = T6.ROW_ID (+) AND (((T8.ROW_ID) = NVL (:1, 'NO_ROW_ID') AND T8 .X_STATUS_CD = '新建') AND (T8.TYPE = 'SHCTBusinessLog'))
bsksjt0k9hh3g INSERT INTO SIEBEL.S_CONTACT_XM ( CONFLICT_ID, DB_LAST_UPD_SRC, DB_LAST_UPD, LAST_UPD, CREATED, LAST_UPD_BY, CREATED_BY, MODIFICATION_NUM, ROW_ID, PAR_ROW_ID, ATTRIB_08, NAME, TYPE, X_LATEST_CART_REVNUM, ATTRIB_14, X_STATUS_CD, X_GROUP_FLG, X_NEW_PROM_FLG) VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
fj2b3rrraadjxSELECT T5.CONFLICT_ID, T5.LAST_UPD, T5.CREATED, T5.LAST_UPD_BY, T5.CREATED_BY, T5.MODIFICATION_NUM, T5.ROW_ID, T4.DUNS_NUM, T1.CO_MSTR_ID, T4.PR_CO_MSTR_ID, T2.OWN_INST_ID, T2.INTEGRATION_ID, T3.CO_MSTR_ID, T4.ROW_ID, T4.PAR_ROW_ID, T4.MODIFICATION_NUM, T4.CREATED_BY, T4.LAST_UPD_BY, T4.CREATED, T4.LAST_UPD, T4.CONFLICT_ID, T4.PAR_ROW_ID, T2.ROW_ID, T2.PAR_ROW_ID, T2.MODIFICATION_NUM, T2.CREATED_BY, T2.LAST_UPD_BY, T2.CREATED, T2.LAST_UPD, T2.CONFLICT_ID, T2.PAR_ROW_ID, T3.ROW_ID FROM SIEBEL.S_ACCNT_CO_MSTR T1, SIEBEL.S_ORG_EXT_SS T2, SIEBEL.S_ACCNT_CO_MSTR T3, SIEBEL.S_ORG_EXT T4, SIEBEL.S_PARTY T5 WHERE T4.PR_CO_MSTR_ID = T1.ROW_ID (+) AND T5.ROW_ID = T4.PAR_ROW_ID AND T5.ROW_ID = T2.PAR_ROW_ID (+) AND T1.CO_MSTR_ID = T3.ROW_ID (+) AND ((T5.ROW_ID = :1) AND (T4.INT_ORG_FLG != 'Y'))
gptyps8uymuu7 INSERT INTO SIEBEL.S_AUDIT_ITEM ( CONFLICT_ID, DB_LAST_UPD_SRC, DB_LAST_UPD, LAST_UPD, CREATED, LAST_UPD_BY, CREATED_BY, MODIFICATION_NUM, ROW_ID, AUDIT_LOG, AUDIT_SOURCE_CD, BC_BASE_TBL, BUSCOMP_NAME, OPERATION_DT, SYNC_DT, USER_ID, FIELD_NAME, GROUP_NUM, ITEM_IDEN_NUM, LINK_NAME, NEW_VAL, NODE_NAME, OLD_VAL, OPERATION_CD, RECORD_ID, TBL_NAME, TBL_RECORD_ID, CHILD_BC_BASE_TBL, CHILD_RECORD_ID, CHILD_BC_NAME) VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, SIEBEL.S_AUDIT_ITEM_S.NEXTVAL, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28)

Back to Top SQL
Back to Top

Top PL/SQL Procedures

No data exists for this section of the report.


Back to Top

Top Java Workload

No data exists for this section of the report.


Back to Top

Top Call Types

Call TypeCount% ActivityAvg Active Sessions
V8 Bundled Exec30,00866.41166.71
EXEC & FCH4,62910.2425.72
COMMIT4,2899.4923.83
FETCH2,8156.2315.64
EXECUTE2,7506.0915.28


Back to Top

Top Sessions

Back to Top

Top Sessions

No data exists for this section of the report.

Back to Top Sessions
Back to Top

Top Blocking Sessions

Blocking Sid (Inst)% ActivityEvent Caused% EventUserProgram# Samples ActiveXIDs
6581, 1( 1)10.29log file sync9.96 SYSoracle@crm-db-001 (LGWR)58/180 [ 32%]0
9186, 8429( 1)7.46gc buffer busy acquire7.46 SAMPLEUSERsiebmtshmw.exe76/180 [ 42%]2
949,31805( 1)5.54gc buffer busy acquire5.54 SAMPLEUSERsiebmtshmw.exe72/180 [ 40%]1
6349, 2065( 1)4.88gc buffer busy acquire4.88 SAMPLEUSERsiebmtshmw.exe71/180 [ 39%]0
14811, 6537( 1)3.65gc buffer busy acquire3.65 SAMPLEUSERsiebmtshmw.exe101/180 [ 56%]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
106034110.10gc buffer busy acquire7.69 SIEBEL.S_ORDER_CX8_X (INDEX)NEW_ORDER2_IND_TBS
  gc buffer busy release1.83   
10520748.46gc buffer busy acquire6.38 SIEBEL.S_USER (TABLE)NEW_OTHERS_DATA2_TBS
  gc cr block busy2.08   
12618148.28gc buffer busy acquire5.57 SIEBEL.S_ORDER_ITEM_CX22_X (INDEX)NEW_ORDER_ITEM_IND_TBS
  gc buffer busy release2.21   
10528155.42gc buffer busy acquire4.66 SIEBEL.S_CONTACT_XM_P1 (INDEX)NEW_OTHERS_IND2_TBS
10598025.04gc buffer busy acquire4.88 SIEBEL.S_PARTY_P1 (INDEX)NEW_ACCT_IND_TBS

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
1308.42gc buffer busy acquire6.47 /oradata/oradata15/siebeldb_tbs_0549.dbfNEW_OTHERS_IND2_TBS
1498.27gc buffer busy acquire5.55 /oradata/oradata17/siebeldb_tbs_0578.dbfNEW_ORDER_ITEM_IND_TBS
  gc buffer busy release2.21   
1367.85gc buffer busy acquire7.46 /oradata/oradata14/siebeldb_tbs_0555.dbfNEW_ORDER2_IND_TBS
9565.04gc buffer busy acquire4.88 /oradata/oradata08/NEW_ACCT_IND_TBS_0008.DBFNEW_ACCT_IND_TBS
1404.78gc buffer busy acquire3.97 /oradata/oradata14/siebeldb_tbs_0559.DBFUPG_NEW_OBJ_IND_TBS

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
12:19:55 (5 secs)1,168gc buffer busy acquire8161.81
  gc cr block busy2190.48
  gc current block busy1040.23
12:20:00 (1.0 min)28,795gc buffer busy acquire20,83646.11
  gc cr block busy4,58010.14
  gc current block busy2,2224.92
12:21:00 (1.0 min)7,240gc buffer busy acquire3,9868.82
  gc cr block busy8381.85
  buffer busy waits6731.49
12:22:00 (55 secs)7,984log file sync4,3269.57
  gc buffer busy release2,6855.94
  db file sequential read4571.01


Back to Top

End of Report