ASH Report For SIEBELDB/siebeldb2

DB NameDB IdInstanceInst numReleaseRACHost
SIEBELDB1705445768siebeldb2211.2.0.2.0YEScrm-db-002

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:22V$ACTIVE_SESSION_HISTORY
Analysis End Time:20-Feb-12 12:22:22V$ACTIVE_SESSION_HISTORY
Elapsed Time: 3.0 (mins)  
Sample Count: 44,274 
Average Active Sessions: 245.97 
Avg. Active Session per CPU: 3.84 
Report Target:None specified 

ASH Report


Back to Top

Top Events

Back to Top

Top User Events

EventEvent Class% EventAvg Active Sessions
log file syncCommit68.94169.57
gc buffer busy releaseCluster19.0246.78
buffer busy waitsConcurrency4.9412.16
db file sequential readUser I/O1.694.16
CPU + Wait for CPUCPU1.202.95

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 release19.18114.66
   4.52

Back to Top Events
Back to Top

Top Event P1/P2/P3 Values

Event% EventP1 Value, P2 Value, P3 Value% ActivityParameter 1Parameter 2Parameter 3
log file sync69.20"27073","1250732067","0"0.24 buffer#sync scnNOT DEFINED
gc buffer busy release19.18"149","1008210","1"7.86 file#block#class#
  "136","3511084","1"3.35    
  "130","2387678","1"1.57    
buffer busy waits5.06"1","143128","1"2.01 file#block#class#
  "1","231","1"1.80    
db file sequential read1.69"898","3442894","1"0.02 file#block#blocks

Back to Top Events
Back to Top

Load Profile

Back to Top

Top Service/Module

ServiceModule% ActivityAction% Action
siebeldbsiebmtshmw.exe89.23UNNAMED89.23
 siebprocmw.exe5.68UNNAMED5.68
SYS$BACKGROUNDUNNAMED1.68UNNAMED1.68
siebeldbsiebmtsh.exe1.52UNNAMED1.52
 JDBC Thin Client1.11UNNAMED1.11

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
UPDATE11914.9836.86
INSERT849.1022.38
DELETE83.217.88
SELECT2441.964.82

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution% ActivityAvg Active Sessions
SQL Execution29.5572.68

Back to Load Profile
Back to Top

Top Remote Instances

Wait Class% Wait ClassRemote Instance#% Activity
Cluster19.70115.06
   4.63

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
ga2zyc4ya1df61332432021381.89 buffer busy waits1.56** Row Source Not Available **1.07 DELETE FROM SIEBEL.S_CM_ITEM_U...
d7twk782dd18r1325953258151.49 gc buffer busy release1.11UPDATE1.11 UPDATE SIEBEL.S_ORDER SET DB_...
gj4tzyqdd0gmd 91.29 gc buffer busy release1.28** Row Source Not Available **1.28 INSERT INTO SIEBEL.CX_INBOUND...
bsksjt0k9hh3g 131.24 gc buffer busy release0.84** Row Source Not Available **0.84 INSERT INTO SIEBEL.S_CONTACT_...
59301wv3dkrt671927763391.20 gc buffer busy release1.18UPDATE1.18 UPDATE SIEBEL.S_ORDER_ITEM SE...

Back to Top SQL
Back to Top

Top SQL with Top Row Sources

SQL IDPlanHashSampled # of Executions% ActivityRow Source% RwSrcTop Event% EventSQL Text
ga2zyc4ya1df61332432021381.89 ** Row Source Not Available **1.12buffer busy waits1.07 DELETE FROM SIEBEL.S_CM_ITEM_U...
d7twk782dd18r1325953258151.49 UPDATE1.41gc buffer busy release1.11 UPDATE SIEBEL.S_ORDER SET DB_...
gj4tzyqdd0gmd 91.29 ** Row Source Not Available **1.29gc buffer busy release1.28 INSERT INTO SIEBEL.CX_INBOUND...
bsksjt0k9hh3g 131.24 ** Row Source Not Available **1.24gc buffer busy release0.84 INSERT INTO SIEBEL.S_CONTACT_...
59301wv3dkrt671927763391.20 UPDATE1.20gc buffer busy release1.18 UPDATE SIEBEL.S_ORDER_ITEM SE...

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
59301wv3dkrt6 UPDATE SIEBEL.S_ORDER_ITEM SET DB_LAST_UPD_SRC = :1, DB_LAST_UPD = current_date, LAST_UPD = :2, LAST_UPD_BY = :3, MODIFICATION_NUM = :4, EAI_EXPRT_STAT_CD = :5 WHERE ROW_ID = :6 AND MODIFICATION_NUM = :7
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)
d7twk782dd18r UPDATE SIEBEL.S_ORDER SET DB_LAST_UPD_SRC = :1, DB_LAST_UPD = current_date, LAST_UPD = :2, LAST_UPD_BY = :3, MODIFICATION_NUM = :4, ACCNT_ADDR_ID = :5 WHERE ROW_ID = :6 AND MODIFICATION_NUM = :7
ga2zyc4ya1df6DELETE FROM SIEBEL.S_CM_ITEM_USER WHERE ROW_ID = :1
gj4tzyqdd0gmd INSERT INTO SIEBEL.CX_INBOUND_INFO ( CONFLICT_ID, DB_LAST_UPD_SRC, DB_LAST_UPD, LAST_UPD, CREATED, LAST_UPD_BY, CREATED_BY, MODIFICATION_NUM, ROW_ID, COMMENTS, CRM_REC_DT, DATA2, DATA3, EXT_PROC_DT, OPER_TYPE, PROC_STAT, SOURCE) VALUES (:1, :2, current_date, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)

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
COMMIT29,81767.35165.65
V8 Bundled Exec12,05427.2366.97
EXECUTE7531.704.18


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( 2)70.48log file sync69.20 SYSoracle@crm-db-002 (LGWR)159/180 [ 88%]0
14587, 721( 2)1.58buffer busy waits1.58 SAMPLEUSERsiebmtshmw.exe29/180 [ 16%]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
12618148.14gc buffer busy release7.92 SIEBEL.S_ORDER_ITEM_CX22_X (INDEX)NEW_ORDER_ITEM_IND_TBS
10603413.44gc buffer busy release3.41 SIEBEL.S_ORDER_CX8_X (INDEX)NEW_ORDER2_IND_TBS
10495041.58gc buffer busy release1.57 SIEBEL.CX_INBOUND_INFO_CX5 (INDEX)NEW_OTHERS_IND2_TBS
13451721.41gc buffer busy release1.39 NIHL1.S_WFA_INSTANCE_CX1 (INDEX)NEW_OTHERS_IND2_TBS
10528131.17gc buffer busy release1.17 SIEBEL.S_CONTACT_XM_M1 (INDEX)NEW_OTHERS_IND2_TBS

Back to Top Objects/Files/Latches
Back to Top

Top DB Files

File ID% ActivityEvent% EventFile NameTablespace
1498.14gc buffer busy release7.92 /oradata/oradata17/siebeldb_tbs_0578.dbfNEW_ORDER_ITEM_IND_TBS
1304.70gc buffer busy release4.63 /oradata/oradata15/siebeldb_tbs_0549.dbfNEW_OTHERS_IND2_TBS
1363.39gc buffer busy release3.35 /oradata/oradata14/siebeldb_tbs_0555.dbfNEW_ORDER2_IND_TBS
1471.02gc buffer busy release1.01 /oradata/oradata15/siebeldb_tbs_0576.dbfNEW_OTH_BIG_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:22 (38 secs)9,036log file sync6,53014.75
  gc buffer busy release2,0814.70
  gcs log flush sync1470.33
12:20:00 (1.0 min)27,940log file sync20,78746.95
  gc buffer busy release5,51012.45
  buffer busy waits7431.68
12:21:00 (1.0 min)6,906log file sync3,2817.41
  buffer busy waits1,4963.38
  gc buffer busy release9002.03
12:22:00 (22 secs)392db file sequential read1090.25
  CPU + Wait for CPU1040.23
  gc buffer busy acquire700.16


Back to Top

End of Report