| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| SKINSTG | 1860772457 | SKINSTG1 | 1 | 10.2.0.4.0 | YES | stage-rac01 |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|---|---|---|---|
| 4 | 1,536M (100%) | 848M (55.2%) | 560M (36.5%) | 8.0M (0.5%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 26-Mar-11 00:01:59 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 27-Mar-11 23:59:59 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 2,878.0 (mins) | |
| Sample Count: | 6,767 | |
| Average Active Sessions: | 0.04 | |
| Avg. Active Session per CPU: | 0.01 | |
| Report Target: | None specified |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 4.97 | 0.00 |
Back to Top Events
Back to Top
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| control file sequential read | System I/O | 27.50 | 0.01 |
| control file parallel write | System I/O | 18.94 | 0.01 |
| Streams AQ: qmn coordinator waiting for slave to start | Other | 13.74 | 0.01 |
| CPU + Wait for CPU | CPU | 13.70 | 0.01 |
| reliable message | Other | 10.17 | 0.00 |
Back to Top Events
Back to Top
| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|---|---|---|---|
| control file sequential read | 27.87 | "0","35","1" | 13.65 | file# | block# | blocks |
| "0","4","1" | 6.80 | |||||
| "1","1","1" | 1.92 | |||||
| control file parallel write | 19.00 | "3","3","3" | 18.94 | files | block# | requests |
| reliable message | 10.20 | "2264808368","4753080968","2216368696" | 1.15 | channel context | channel handle | broadcast message |
| "2264808368","4753080968","2216369680" | 1.11 | |||||
| "2264808368","4753080968","2216370992" | 1.11 | |||||
| log file parallel write | 1.54 | "1","2","1" | 0.52 | files | blocks | requests |
| db file parallel write | 1.43 | "1","0","2147483647" | 1.43 | requests | interrupt | timeout |
Back to Top Events
Back to Top
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$BACKGROUND | UNNAMED | 87.51 | UNNAMED | 87.51 |
| MMON_SLAVE | 2.60 | Auto-Flush Slave Action | 1.37 | |
| Remote-Flush Slave Action | 1.17 | |||
| SYS$USERS | emagent@stage-rac01 (TNS V1-V3) | 2.23 | UNNAMED | 2.23 |
| backup incr datafile | 1.46 | 0000045 STARTED16 | 1.42 | |
| DBMS_SCHEDULER | 1.37 | GATHER_STATS_JOB | 0.86 |
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 | 58 | 1.54 | 0.00 |
Back to Load Profile
Back to Top
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|---|---|---|---|---|
| 4gd6b1r53yt88 | 11.50 | reliable message | 9.93 | ** SQL Text Not Available ** |
No data exists for this section of the report.
| SQL Id | SQL Text |
|---|---|
| 4gd6b1r53yt88 | ** SQL Text Not Available ** |
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|---|---|---|
| SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#10 | 2.07 | SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#10 | 2.07 |
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 550, 1 | 22.96 | control file sequential read | 20.45 | SYS | oracle@stage-rac01 (LMON) | 1,384/173K [ 1%] | 0 |
| CPU + Wait for CPU | 2.29 | 155/173K [ 0%] | 0 | ||||
| 544, 1 | 21.55 | control file parallel write | 18.94 | SYS | oracle@stage-rac01 (CKPT) | 1,282/173K [ 1%] | 0 |
| CPU + Wait for CPU | 1.30 | 88/173K [ 0%] | 0 | ||||
| control file sequential read | 1.27 | 86/173K [ 0%] | 0 | ||||
| 532, 9 | 13.95 | Streams AQ: qmn coordinator waiting for slave to start | 13.74 | SYS | oracle@stage-rac01 (QMNC) | 930/173K [ 1%] | 0 |
| 540, 1 | 11.50 | reliable message | 9.93 | SYS | oracle@stage-rac01 (MMON) | 672/173K [ 0%] | 0 |
| 1098, 5 | 4.06 | control file sequential read | 3.96 | SYS | oracle@stage-rac01 (ARC1) | 268/173K [ 0%] | 0 |
Back to Top Sessions
Back to Top
| Blocking Sid | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 1102, 1 | 1.61 | gcs log flush sync | 0.84 | SYS | oracle@stage-rac01 (LGWR) | 123/173K [ 0%] | 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 Objects/Files/Latches
Back to Top
| File ID | % Activity | Event | % Event | File Name | Tablespace |
|---|---|---|---|---|---|
| 3 | 1.36 | gc cr block busy | 0.50 | +DATA/skinstg/sysaux01.dbf | SYSAUX |
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 |
|---|---|---|---|---|
| 00:01:59 (286.0 min) | 801 | control file sequential read | 225 | 3.32 |
| CPU + Wait for CPU | 166 | 2.45 | ||
| control file parallel write | 101 | 1.49 | ||
| 04:48:00 (288.0 min) | 843 | control file sequential read | 249 | 3.68 |
| control file parallel write | 187 | 2.76 | ||
| CPU + Wait for CPU | 118 | 1.74 | ||
| 09:36:00 (288.0 min) | 629 | control file sequential read | 164 | 2.42 |
| control file parallel write | 141 | 2.08 | ||
| CPU + Wait for CPU | 121 | 1.79 | ||
| 14:24:00 (288.0 min) | 622 | control file sequential read | 171 | 2.53 |
| control file parallel write | 111 | 1.64 | ||
| reliable message | 102 | 1.51 | ||
| 19:12:00 (288.0 min) | 616 | control file sequential read | 153 | 2.26 |
| CPU + Wait for CPU | 124 | 1.83 | ||
| control file parallel write | 101 | 1.49 | ||
| 00:00:00 (288.0 min) | 817 | CPU + Wait for CPU | 212 | 3.13 |
| control file sequential read | 208 | 3.07 | ||
| control file parallel write | 125 | 1.85 | ||
| 04:48:00 (288.0 min) | 720 | control file sequential read | 232 | 3.43 |
| control file parallel write | 187 | 2.76 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 92 | 1.36 | ||
| 09:36:00 (288.0 min) | 569 | control file sequential read | 155 | 2.29 |
| control file parallel write | 105 | 1.55 | ||
| CPU + Wait for CPU | 104 | 1.54 | ||
| 14:24:00 (288.0 min) | 523 | control file sequential read | 160 | 2.36 |
| control file parallel write | 107 | 1.58 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 85 | 1.26 | ||
| 19:12:00 (288.0 min) | 627 | control file sequential read | 169 | 2.50 |
| CPU + Wait for CPU | 157 | 2.32 | ||
| control file parallel write | 121 | 1.79 |
End of Report