DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
SIEBELDB | 1705445768 | siebeldb2 | 2 | 11.2.0.2.0 | YES | crm-db-002 |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
64 | 94,807M (100%) | 70,144M (74.0%) | 20,224M (21.3%) | 128.0M (0.1%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 20-Feb-12 12:19:22 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 20-Feb-12 12:22:22 | V$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 |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
log file sync | Commit | 68.94 | 169.57 |
gc buffer busy release | Cluster | 19.02 | 46.78 |
buffer busy waits | Concurrency | 4.94 | 12.16 |
db file sequential read | User I/O | 1.69 | 4.16 |
CPU + Wait for CPU | CPU | 1.20 | 2.95 |
Event | % Event | Remote Instance# | % Activity |
---|---|---|---|
gc buffer busy release | 19.18 | 1 | 14.66 |
4.52 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
log file sync | 69.20 | "27073","1250732067","0" | 0.24 | buffer# | sync scn | NOT DEFINED |
gc buffer busy release | 19.18 | "149","1008210","1" | 7.86 | file# | block# | class# |
"136","3511084","1" | 3.35 | |||||
"130","2387678","1" | 1.57 | |||||
buffer busy waits | 5.06 | "1","143128","1" | 2.01 | file# | block# | class# |
"1","231","1" | 1.80 | |||||
db file sequential read | 1.69 | "898","3442894","1" | 0.02 | file# | block# | blocks |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
siebeldb | siebmtshmw.exe | 89.23 | UNNAMED | 89.23 |
siebprocmw.exe | 5.68 | UNNAMED | 5.68 | |
SYS$BACKGROUND | UNNAMED | 1.68 | UNNAMED | 1.68 |
siebeldb | siebmtsh.exe | 1.52 | UNNAMED | 1.52 |
JDBC Thin Client | 1.11 | UNNAMED | 1.11 |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
UPDATE | 119 | 14.98 | 36.86 |
INSERT | 84 | 9.10 | 22.38 |
DELETE | 8 | 3.21 | 7.88 |
SELECT | 244 | 1.96 | 4.82 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 29.55 | 72.68 |
Wait Class | % Wait Class | Remote Instance# | % Activity |
---|---|---|---|
Cluster | 19.70 | 1 | 15.06 |
4.63 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
ga2zyc4ya1df6 | 1332432021 | 38 | 1.89 | buffer busy waits | 1.56 | ** Row Source Not Available ** | 1.07 | DELETE FROM SIEBEL.S_CM_ITEM_U... |
d7twk782dd18r | 1325953258 | 15 | 1.49 | gc buffer busy release | 1.11 | UPDATE | 1.11 | UPDATE SIEBEL.S_ORDER SET DB_... |
gj4tzyqdd0gmd | 9 | 1.29 | gc buffer busy release | 1.28 | ** Row Source Not Available ** | 1.28 | INSERT INTO SIEBEL.CX_INBOUND... | |
bsksjt0k9hh3g | 13 | 1.24 | gc buffer busy release | 0.84 | ** Row Source Not Available ** | 0.84 | INSERT INTO SIEBEL.S_CONTACT_... | |
59301wv3dkrt6 | 719277633 | 9 | 1.20 | gc buffer busy release | 1.18 | UPDATE | 1.18 | UPDATE SIEBEL.S_ORDER_ITEM SE... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
ga2zyc4ya1df6 | 1332432021 | 38 | 1.89 | ** Row Source Not Available ** | 1.12 | buffer busy waits | 1.07 | DELETE FROM SIEBEL.S_CM_ITEM_U... |
d7twk782dd18r | 1325953258 | 15 | 1.49 | UPDATE | 1.41 | gc buffer busy release | 1.11 | UPDATE SIEBEL.S_ORDER SET DB_... |
gj4tzyqdd0gmd | 9 | 1.29 | ** Row Source Not Available ** | 1.29 | gc buffer busy release | 1.28 | INSERT INTO SIEBEL.CX_INBOUND... | |
bsksjt0k9hh3g | 13 | 1.24 | ** Row Source Not Available ** | 1.24 | gc buffer busy release | 0.84 | INSERT INTO SIEBEL.S_CONTACT_... | |
59301wv3dkrt6 | 719277633 | 9 | 1.20 | UPDATE | 1.20 | gc buffer busy release | 1.18 | UPDATE SIEBEL.S_ORDER_ITEM SE... |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
COMMIT | 29,817 | 67.35 | 165.65 |
V8 Bundled Exec | 12,054 | 27.23 | 66.97 |
EXECUTE | 753 | 1.70 | 4.18 |
Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
6581, 1( 2) | 70.48 | log file sync | 69.20 | SYS | oracle@crm-db-002 (LGWR) | 159/180 [ 88%] | 0 |
14587, 721( 2) | 1.58 | buffer busy waits | 1.58 | SAMPLEUSER | siebmtshmw.exe | 29/180 [ 16%] | 0 |
Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
---|---|---|---|---|---|
1261814 | 8.14 | gc buffer busy release | 7.92 | SIEBEL.S_ORDER_ITEM_CX22_X (INDEX) | NEW_ORDER_ITEM_IND_TBS |
1060341 | 3.44 | gc buffer busy release | 3.41 | SIEBEL.S_ORDER_CX8_X (INDEX) | NEW_ORDER2_IND_TBS |
1049504 | 1.58 | gc buffer busy release | 1.57 | SIEBEL.CX_INBOUND_INFO_CX5 (INDEX) | NEW_OTHERS_IND2_TBS |
1345172 | 1.41 | gc buffer busy release | 1.39 | NIHL1.S_WFA_INSTANCE_CX1 (INDEX) | NEW_OTHERS_IND2_TBS |
1052813 | 1.17 | gc buffer busy release | 1.17 | SIEBEL.S_CONTACT_XM_M1 (INDEX) | NEW_OTHERS_IND2_TBS |
File ID | % Activity | Event | % Event | File Name | Tablespace |
---|---|---|---|---|---|
149 | 8.14 | gc buffer busy release | 7.92 | /oradata/oradata17/siebeldb_tbs_0578.dbf | NEW_ORDER_ITEM_IND_TBS |
130 | 4.70 | gc buffer busy release | 4.63 | /oradata/oradata15/siebeldb_tbs_0549.dbf | NEW_OTHERS_IND2_TBS |
136 | 3.39 | gc buffer busy release | 3.35 | /oradata/oradata14/siebeldb_tbs_0555.dbf | NEW_ORDER2_IND_TBS |
147 | 1.02 | gc buffer busy release | 1.01 | /oradata/oradata15/siebeldb_tbs_0576.dbf | NEW_OTH_BIG_IND_TBS |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
12:19:22 (38 secs) | 9,036 | log file sync | 6,530 | 14.75 |
gc buffer busy release | 2,081 | 4.70 | ||
gcs log flush sync | 147 | 0.33 | ||
12:20:00 (1.0 min) | 27,940 | log file sync | 20,787 | 46.95 |
gc buffer busy release | 5,510 | 12.45 | ||
buffer busy waits | 743 | 1.68 | ||
12:21:00 (1.0 min) | 6,906 | log file sync | 3,281 | 7.41 |
buffer busy waits | 1,496 | 3.38 | ||
gc buffer busy release | 900 | 2.03 | ||
12:22:00 (22 secs) | 392 | db file sequential read | 109 | 0.25 |
CPU + Wait for CPU | 104 | 0.23 | ||
gc buffer busy acquire | 70 | 0.16 |