| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| CAPGENT | 4127787440 | capgent1 | 1 | 10.2.0.4.0 | YES | rac1.capgent.com |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|---|---|---|---|
| 4 | 3,840M (100%) | 3,184M (82.9%) | 507M (13.2%) | 8.0M (0.2%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 05-Jun-11 15:24:23 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 21351 |
| Analysis End Time: | 07-Jun-11 15:29:23 | DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 21355 + V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 2,885.0 (mins) | |
| Sample Count: | 3,592 | |
| Average Active Sessions: | 0.21 | |
| Avg. Active Session per CPU: | 0.05 | |
| Report Target: | None specified |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| db file sequential read | User I/O | 44.63 | 0.09 |
| CPU + Wait for CPU | CPU | 20.02 | 0.04 |
| db file scattered read | User I/O | 4.06 | 0.01 |
| control file sequential read | System I/O | 2.34 | 0.00 |
| gc current block 2-way | Cluster | 2.31 | 0.00 |
Back to Top Events
Back to Top
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 4.12 | 0.01 |
| control file sequential read | System I/O | 4.04 | 0.01 |
| Streams AQ: qmn coordinator waiting for slave to start | Other | 3.34 | 0.01 |
| reliable message | Other | 2.03 | 0.00 |
| control file parallel write | System I/O | 1.50 | 0.00 |
Back to Top Events
Back to Top
| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|---|---|---|---|
| db file sequential read | 45.96 | "6","287527","1" | 0.06 | file# | block# | blocks |
| control file sequential read | 6.38 | "0","35","1" | 2.20 | file# | block# | blocks |
| db file scattered read | 4.09 | "6","399762","3" | 0.06 | file# | block# | blocks |
| reliable message | 2.03 | "5629965400","5629882976","5630841744" | 0.22 | channel context | channel handle | broadcast message |
| control file parallel write | 1.53 | "3","3","3" | 1.48 | files | block# | requests |
Back to Top Events
Back to Top
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| capgent | JDBC Thin Client | 66.09 | UNNAMED | 66.09 |
| SYS$BACKGROUND | UNNAMED | 17.07 | UNNAMED | 17.07 |
| SYS$USERS | DBMS_SCHEDULER | 9.41 | AUTO_SPACE_ADVISOR_JOB | 4.06 |
| GATHER_STATS_JOB | 3.87 | |||
| AGING_CALCULATIONS | 1.36 | |||
| emagent@rac1.capgent.com (TNS V1-V3) | 2.73 | UNNAMED | 2.73 | |
| SYS$BACKGROUND | MMON_SLAVE | 2.14 | Remote-Flush Slave Action | 0.72 |
Back to Load Profile
Back to Top
No data exists for this section of the report.
Back to Load Profile
Back to Top
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|---|---|---|
| SELECT | 701 | 66.09 | 0.14 |
| INSERT | 36 | 6.24 | 0.01 |
| UPDATE | 18 | 4.54 | 0.01 |
Back to Load Profile
Back to Top
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|---|---|---|---|---|
| bkhf6mdtuuark | 2154183644 | 6.60 | db file sequential read | 4.54 | select * from ( select row_.*,... |
| 237t2j21fva8x | 1756123102 | 5.18 | db file sequential read | 3.67 | /* named native SQL query sear... |
| 39q7fgx59n296 | 1246553133 | 4.45 | db file sequential read | 4.45 | select stslogs0_.IV_ID as IV16... |
| 8szmwam7fysa3 | 2976124318 | 3.42 | db file sequential read | 3.37 | insert into wri$_adv_objspace_... |
| 4gd6b1r53yt88 | 2.59 | reliable message | 1.95 | ** SQL Text Not Available ** |
| Plan Hash | % Activity | # of Sampled SQL Versions | Example SQL 1 | Example SQL TEXT 1 | Example SQL 2 | Example SQL TEXT 2 |
|---|---|---|---|---|---|---|
| 1928032458 | 4.93 | 177 | 00c71dj788y1m | select cmtslog0_.CM_CRTDBY as ... | gzudx733sj1wv | select cmtslog0_.CM_CRTDBY as ... |
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|---|---|---|
| SYS.DBMS_SPACE.AUTO_SPACE_ADVISOR_JOB_PROC | 4.06 | SYS.DBMS_SPACE.OBJECT_SPACE_USAGE | 3.76 |
| SYS.DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC | 3.87 | SQL | 3.81 |
| DNBI.ALL_ENTITY_AGING_CALCULATIONS | 1.11 | SQL | 1.11 |
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 276,54573 | 10.22 | db file sequential read | 5.82 | DNBI | JDBC Thin Client | 209/17K [ 1%] | 2 |
| CPU + Wait for CPU | 2.37 | 85/17K [ 0%] | 0 | ||||
| 267,10792 | 5.99 | CPU + Wait for CPU | 2.53 | DNBI | JDBC Thin Client | 91/17K [ 1%] | 2 |
| db file sequential read | 2.48 | 89/17K [ 1%] | 2 | ||||
| 238,19348 | 4.79 | db file sequential read | 3.20 | DNBI | JDBC Thin Client | 115/17K [ 1%] | 6 |
| 293,24702 | 4.79 | db file sequential read | 3.15 | DNBI | JDBC Thin Client | 113/17K [ 1%] | 8 |
| 332, 1 | 4.45 | control file sequential read | 2.95 | SYS | oracle@rac1.capgent.com (LMON) | 106/17K [ 1%] | 0 |
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
No data exists for this section of the report.
Back to Top Sessions
Back to Top
| Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
|---|---|---|---|---|---|
| 56469 | 18.43 | db file sequential read | 12.39 | DNBI.INV_TXN (TABLE) | CAPGENT_DATA |
| db file scattered read | 2.34 | ||||
| gc current block 2-way | 2.09 | ||||
| 56446 | 5.62 | db file sequential read | 5.51 | DNBI.CMTS_LOG (TABLE) | CAPGENT_DATA |
| 56506 | 5.32 | db file sequential read | 5.29 | DNBI.STS_LOG (TABLE) | CAPGENT_DATA |
| 56429 | 3.84 | db file sequential read | 3.76 | DNBI.ACCR_TXN (TABLE) | CAPGENT_DATA |
| 86115 | 2.23 | db file sequential read | 2.23 | DNBI.STS_LOG_COMP_IDX (INDEX) | CAPGENT_INDEX |
Back to Top Objects/Files/Latches
Back to Top
| File ID | % Activity | Event | % Event | File Name | Tablespace |
|---|---|---|---|---|---|
| 6 | 40.28 | db file sequential read | 33.60 | +DATA/capgent/capgent_data.dbf | CAPGENT_DATA |
| db file scattered read | 2.56 | ||||
| gc current block 2-way | 2.17 | ||||
| 7 | 8.74 | db file sequential read | 8.41 | +DATA/capgent/capgent_index.dbf | CAPGENT_INDEX |
| 3 | 4.09 | db file sequential read | 2.20 | +DATA/capgent/sysaux01.dbf | SYSAUX |
| db file scattered read | 1.53 |
Back to Top Objects/Files/Latches
Back to Top
No data exists for this section of the report.
Back to Top Objects/Files/Latches
Back to Top
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
|---|---|---|---|---|
| 15:24:23 (155.6 min) | 29 | control file sequential read | 9 | 0.25 |
| Streams AQ: qmn coordinator waiting for slave to start | 7 | 0.19 | ||
| CPU + Wait for CPU | 4 | 0.11 | ||
| 18:00:00 (290.0 min) | 83 | db file sequential read | 35 | 0.97 |
| Streams AQ: qmn coordinator waiting for slave to start | 12 | 0.33 | ||
| reliable message | 9 | 0.25 | ||
| 22:50:00 (290.0 min) | 276 | db file sequential read | 125 | 3.48 |
| CPU + Wait for CPU | 58 | 1.61 | ||
| control file sequential read | 15 | 0.42 | ||
| 03:40:00 (290.0 min) | 382 | db file sequential read | 217 | 6.04 |
| CPU + Wait for CPU | 47 | 1.31 | ||
| control file sequential read | 20 | 0.56 | ||
| 08:30:00 (290.0 min) | 672 | db file sequential read | 259 | 7.21 |
| CPU + Wait for CPU | 162 | 4.51 | ||
| cursor: pin S wait on X | 52 | 1.45 | ||
| 13:20:00 (290.0 min) | 366 | CPU + Wait for CPU | 229 | 6.38 |
| db file sequential read | 64 | 1.78 | ||
| control file sequential read | 18 | 0.50 | ||
| 18:10:00 (290.0 min) | 404 | db file sequential read | 228 | 6.35 |
| db file scattered read | 57 | 1.59 | ||
| CPU + Wait for CPU | 52 | 1.45 | ||
| 23:00:00 (290.0 min) | 507 | db file sequential read | 265 | 7.38 |
| CPU + Wait for CPU | 69 | 1.92 | ||
| control file sequential read | 46 | 1.28 | ||
| 03:50:00 (290.0 min) | 337 | db file sequential read | 219 | 6.10 |
| CPU + Wait for CPU | 40 | 1.11 | ||
| control file sequential read | 25 | 0.70 | ||
| 08:40:00 (290.0 min) | 337 | db file sequential read | 147 | 4.09 |
| CPU + Wait for CPU | 125 | 3.48 | ||
| control file sequential read | 22 | 0.61 | ||
| 13:30:00 (119.4 min) | 199 | db file sequential read | 92 | 2.56 |
| CPU + Wait for CPU | 75 | 2.09 | ||
| control file sequential read | 7 | 0.19 |
End of Report