| 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: | 30-Mar-11 07:00:54 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 30-Mar-11 08:34:54 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 94.0 (mins) | |
| Sample Count: | 440 | |
| Average Active Sessions: | 0.08 | |
| Avg. Active Session per CPU: | 0.02 | |
| Report Target: | None specified |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 9.77 | 0.01 |
| log file sync | Commit | 2.95 | 0.00 |
| gc cr block busy | Cluster | 1.14 | 0.00 |
Back to Top Events
Back to Top
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| control file sequential read | System I/O | 35.68 | 0.03 |
| control file parallel write | System I/O | 25.00 | 0.02 |
| Streams AQ: qmn coordinator waiting for slave to start | Other | 6.36 | 0.00 |
| CPU + Wait for CPU | CPU | 5.45 | 0.00 |
| reliable message | Other | 3.86 | 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 | 36.36 | "0","4","1" | 12.05 | file# | block# | blocks |
| "0","35","1" | 12.05 | |||||
| "0","3","1" | 3.18 | |||||
| control file parallel write | 25.00 | "3","3","3" | 25.00 | files | block# | requests |
| reliable message | 3.86 | "2264808368","4753080968","2216371320" | 1.36 | channel context | channel handle | broadcast message |
| log file parallel write | 3.64 | "1","3","1" | 0.91 | files | blocks | requests |
| log file sync | 2.95 | "575","0","0" | 0.23 | buffer# | NOT DEFINED | NOT DEFINED |
Back to Top Events
Back to Top
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$BACKGROUND | UNNAMED | 81.14 | UNNAMED | 81.14 |
| SKINSTG | UNNAMED | 13.41 | UNNAMED | 13.41 |
| OEM.DefaultPool | 1.82 | /rac/racSitemap | 1.59 | |
| SYS$USERS | emagent@stage-rac01 (TNS V1-V3) | 1.59 | UNNAMED | 1.59 |
| SYS$BACKGROUND | MMON_SLAVE | 1.14 | Auto-Flush Slave Action | 1.14 |
Back to Load Profile
Back to Top
| Client ID | % Activity | Avg Active Sessions | User | Program | Service |
|---|---|---|---|---|---|
| SYSTEM@su-nat.int.smq.datapipe.net@Mozilla/4.0 (compatible; MSI | 1.36 | 0.00 | SYSMAN | OMS | SKINSTG |
Back to Load Profile
Back to Top
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|---|---|---|
| SELECT | 12 | 9.77 | 0.01 |
| INSERT | 3 | 1.14 | 0.00 |
Back to Load Profile
Back to Top
| SQL ID | Planhash | % Activity | Event | % Event | SQL Text |
|---|---|---|---|---|---|
| 60hnnv7bb12wh | 857639778 | 6.36 | CPU + Wait for CPU | 5.23 | select user0_.USER_ID as USER1... |
| 4gd6b1r53yt88 | 5.45 | reliable message | 3.64 | ** SQL Text Not Available ** |
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 |
|---|---|---|---|---|---|---|---|
| 544, 1 | 28.41 | control file parallel write | 25.00 | SYS | oracle@stage-rac01 (CKPT) | 110/5,640 [ 2%] | 0 |
| control file sequential read | 3.18 | 14/5,640 [ 0%] | 0 | ||||
| 550, 1 | 24.77 | control file sequential read | 24.09 | SYS | oracle@stage-rac01 (LMON) | 106/5,640 [ 2%] | 0 |
| 1084,42356 | 7.73 | CPU + Wait for CPU | 4.55 | SKINIDC | 20/5,640 [ 0%] | 0 | |
| log file sync | 1.36 | 6/5,640 [ 0%] | 0 | ||||
| 1098, 5 | 7.05 | control file sequential read | 7.05 | SYS | oracle@stage-rac01 (ARC1) | 31/5,640 [ 1%] | 0 |
| 532, 9 | 6.36 | Streams AQ: qmn coordinator waiting for slave to start | 6.36 | SYS | oracle@stage-rac01 (QMNC) | 28/5,640 [ 0%] | 0 |
Back to Top Sessions
Back to Top
| Blocking Sid | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 1102, 1 | 3.86 | log file sync | 2.95 | SYS | oracle@stage-rac01 (LGWR) | 16/5,640 [ 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
| Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
|---|---|---|---|---|---|
| 92812 | 1.14 | gc cr block 2-way | 0.45 | SKINIDC.SKINID_USERS (TABLE) | SKIN_DATA |
Back to Top Objects/Files/Latches
Back to Top
| File ID | % Activity | Event | % Event | File Name | Tablespace |
|---|---|---|---|---|---|
| 6 | 3.18 | db file scattered read | 0.91 | +DATA/skinstg/skin_data.dbf | SKIN_DATA |
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 |
|---|---|---|---|---|
| 07:00:54 (2.1 min) | 13 | CPU + Wait for CPU | 7 | 1.59 |
| control file sequential read | 5 | 1.14 | ||
| reliable message | 1 | 0.23 | ||
| 07:03:00 (9.0 min) | 38 | control file sequential read | 11 | 2.50 |
| CPU + Wait for CPU | 8 | 1.82 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 5 | 1.14 | ||
| 07:12:00 (9.0 min) | 40 | CPU + Wait for CPU | 9 | 2.05 |
| control file sequential read | 7 | 1.59 | ||
| log file parallel write | 6 | 1.36 | ||
| 07:21:00 (9.0 min) | 39 | CPU + Wait for CPU | 17 | 3.86 |
| control file sequential read | 8 | 1.82 | ||
| control file parallel write | 5 | 1.14 | ||
| 07:30:00 (9.0 min) | 27 | control file parallel write | 8 | 1.82 |
| control file sequential read | 8 | 1.82 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 7 | 1.59 | ||
| 07:39:00 (9.0 min) | 85 | control file sequential read | 45 | 10.23 |
| control file parallel write | 28 | 6.36 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 6 | 1.36 | ||
| 07:48:00 (9.0 min) | 64 | control file parallel write | 30 | 6.82 |
| control file sequential read | 23 | 5.23 | ||
| CPU + Wait for CPU | 2 | 0.45 | ||
| 07:57:00 (9.0 min) | 28 | control file sequential read | 15 | 3.41 |
| control file parallel write | 8 | 1.82 | ||
| CPU + Wait for CPU | 3 | 0.68 | ||
| 08:06:00 (9.0 min) | 32 | control file sequential read | 15 | 3.41 |
| control file parallel write | 9 | 2.05 | ||
| Streams AQ: qmn coordinator waiting for slave to start | 5 | 1.14 | ||
| 08:15:00 (9.0 min) | 38 | CPU + Wait for CPU | 13 | 2.95 |
| control file sequential read | 9 | 2.05 | ||
| control file parallel write | 8 | 1.82 | ||
| 08:24:00 (9.0 min) | 26 | control file sequential read | 8 | 1.82 |
| CPU + Wait for CPU | 7 | 1.59 | ||
| control file parallel write | 7 | 1.59 | ||
| 08:33:00 (1.9 min) | 10 | control file sequential read | 6 | 1.36 |
| control file parallel write | 2 | 0.45 | ||
| CPU + Wait for CPU | 1 | 0.23 |
End of Report