| 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,088M (80.4%) | 704M (18.3%) | 8.0M (0.2%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 20-Jan-11 13:09:47 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 20-Jan-11 13:14:47 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 5.0 (mins) | |
| Sample Count: | 322 | |
| Average Active Sessions: | 1.07 | |
| Avg. Active Session per CPU: | 0.27 | |
| Report Target: | None specified |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 96.58 | 1.04 |
Back to Top Events
Back to Top
No data exists for this section of the report.
Back to Top Events
Back to Top
No data exists for this section of the report.
Back to Top Events
Back to Top
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$USERS | SQL*Plus | 93.17 | UNNAMED | 93.17 |
| capgent | Realtime Connection | 3.11 | UNNAMED | 3.11 |
| SYS$BACKGROUND | UNNAMED | 1.24 | UNNAMED | 1.24 |
| SYS$USERS | OEM | 1.24 | UNNAMED | 1.24 |
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 | 11 | 98.14 | 1.05 |
Back to Load Profile
Back to Top
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|---|---|---|---|---|
| gsg9qq19qycas | 93.17 | CPU + Wait for CPU | 93.17 | select invtxn0_.IV_ID as col_0... |
No data exists for this section of the report.
No data exists for this section of the report.
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 294, 13 | 93.17 | CPU + Wait for CPU | 93.17 | SYSTEM | sqlplus@rac1.c...m (TNS V1-V3) | 300/300 [100%] | 0 |
| 275, 532 | 1.24 | db file scattered read | 0.93 | SYSTEM | OMS | 3/300 [ 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
No data exists for this section of the report.
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
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 |
|---|---|---|---|---|
| 13:09:47 (13 secs) | 16 | CPU + Wait for CPU | 14 | 4.35 |
| control file sequential read | 1 | 0.31 | ||
| db file sequential read | 1 | 0.31 | ||
| 13:10:00 (1.0 min) | 64 | CPU + Wait for CPU | 62 | 19.25 |
| db file parallel write | 1 | 0.31 | ||
| db file sequential read | 1 | 0.31 | ||
| 13:11:00 (1.0 min) | 63 | CPU + Wait for CPU | 60 | 18.63 |
| db file scattered read | 3 | 0.93 | ||
| 13:12:00 (1.0 min) | 64 | CPU + Wait for CPU | 62 | 19.25 |
| db file sequential read | 1 | 0.31 | ||
| enq: PS - contention | 1 | 0.31 | ||
| 13:13:00 (1.0 min) | 63 | CPU + Wait for CPU | 62 | 19.25 |
| control file sequential read | 1 | 0.31 | ||
| 13:14:00 (47 secs) | 52 | CPU + Wait for CPU | 52 | 16.15 |
End of Report