| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| SUSASTG | 2407826999 | SUSASTG1 | 1 | 11.1.0.7.0 | YES | stage-rac01 |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|---|---|---|---|
| 4 | 2,039M (100%) | 432M (21.2%) | 784M (38.5%) | 8.0M (0.4%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 03-Dec-10 05:00:32 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 03-Dec-10 07:00:32 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 120.0 (mins) | |
| Sample Count: | 669 | |
| Average Active Sessions: | 0.09 | |
| Avg. Active Session per CPU: | 0.02 | |
| Report Target: | None specified |
| Event | Event Class | % Event | Avg Active Sessions |
|---|---|---|---|
| PX Deq: Slave Session Stats | Other | 14.95 | 0.01 |
| reliable message | Other | 9.12 | 0.01 |
| CPU + Wait for CPU | CPU | 3.59 | 0.00 |
| control file sequential read | System I/O | 2.69 | 0.00 |
| log file sync | Commit | 2.39 | 0.00 |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 31.24 | 0.03 |
| control file sequential read | System I/O | 14.20 | 0.01 |
| control file parallel write | System I/O | 9.87 | 0.01 |
| RMAN backup & recovery I/O | System I/O | 2.39 | 0.00 |
| log file parallel write | System I/O | 2.39 | 0.00 |
| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|---|---|---|---|
| control file sequential read | 16.89 | "0","35","1" | 6.58 | file# | block# | blocks |
| "0","4","1" | 3.89 | |||||
| "0","1","1" | 2.09 | |||||
| PX Deq: Slave Session Stats | 14.95 | "268566527","1","0" | 6.73 | sleeptime/senderid | passes | NOT DEFINED |
| control file parallel write | 9.87 | "3","3","3" | 9.87 | files | block# | requests |
| reliable message | 9.72 | "2961493624","3348354712","2962353352" | 2.09 | channel context | channel handle | broadcast message |
| "2961493624","3348354712","2962352968" | 1.49 | |||||
| "2961493624","3348354712","2962351432" | 1.05 | |||||
| RMAN backup & recovery I/O | 2.39 | "1","32","2147483647" | 2.24 | count | intr | timeout |
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$BACKGROUND | UNNAMED | 56.95 | UNNAMED | 56.95 |
| SYS$USERS | racgimon@stage-rac01 (TNS V1-V3) | 20.48 | UNNAMED | 20.48 |
| racgimon@stage-rac02 (TNS V1-V3) | 8.07 | UNNAMED | 8.07 | |
| backup archivelog | 5.53 | 0000058 STARTED16 | 5.23 | |
| SUSASTG | UNNAMED | 3.14 | UNNAMED | 3.14 |
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|---|---|---|
| SELECT | 9 | 6.43 | 0.01 |
| Phase of Execution | % Activity | Avg Active Sessions |
|---|---|---|
| SQL Execution | 15.25 | 0.01 |
| SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 7frqszzdu8sgg | 4109302118 | 24 | 4.93 | control file sequential read | 2.39 | FIXED TABLE - FULL | 1.64 | select DECODE(UPPER(d.OPEN_MOD... |
| reliable message | 2.24 | PX COORDINATOR | 2.24 | |||||
| 9jmd3y1tnxy9n | 0 | 1.49 | CPU + Wait for CPU | 1.35 | ** Row Source Not Available ** | 1.35 | ** SQL Text Not Available ** |
| SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 7frqszzdu8sgg | 4109302118 | 24 | 4.93 | PX COORDINATOR | 2.24 | reliable message | 2.24 | select DECODE(UPPER(d.OPEN_MOD... |
| FIXED TABLE - FULL | 1.79 | control file sequential read | 1.64 | |||||
| 9jmd3y1tnxy9n | 0 | 1.49 | ** Row Source Not Available ** | 1.49 | CPU + Wait for CPU | 1.35 | ** SQL Text Not Available ** |
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|---|---|---|
| SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#12 | 5.23 | SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE#12 | 5.23 |
| SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS | 1.05 | SQL | 0.75 |
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 1094, 8 | 11.96 | reliable message | 9.12 | SYS | racgimon@stage...1 (TNS V1-V3) | 61/7,200 [ 1%] | 0 |
| control file sequential read | 2.39 | 16/7,200 [ 0%] | 0 | ||||
| 544, 1 | 11.81 | control file sequential read | 10.46 | SYS | oracle@stage-rac01 (LMON) | 70/7,200 [ 1%] | 0 |
| CPU + Wait for CPU | 1.35 | 9/7,200 [ 0%] | 0 | ||||
| 537, 1 | 11.66 | control file parallel write | 9.87 | SYS | oracle@stage-rac01 (CKPT) | 66/7,200 [ 1%] | 0 |
| 533, 1 | 10.16 | CPU + Wait for CPU | 9.27 | SYS | oracle@stage-rac01 (ASMB) | 62/7,200 [ 1%] | 0 |
| 545, 1 | 6.73 | CPU + Wait for CPU | 6.73 | SYS | oracle@stage-rac01 (DIA0) | 45/7,200 [ 1%] | 0 |
| Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 1102, 1( 1) | 2.84 | log file sync | 2.39 | SYS | oracle@stage-rac01 (LGWR) | 18/7,200 [ 0%] | 0 |
| Sid,Srl# (Inst) | % Activity | SQL ID | Event | % Event | User | Program | SQL Text |
|---|---|---|---|---|---|---|---|
| 1094, 8(1) | 17.19 | PX Deq: Slave Session Stats | 7.03 | SYS | racgimon@stage...1 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | |
| reliable message | 6.88 | SYS | racgimon@stage...1 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | |||
| 7frqszzdu8sgg | reliable message | 2.24 | SYS | racgimon@stage...1 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | ||
| 537, 3(2) | 8.22 | PX Deq: Slave Session Stats | 7.62 | UserID: |
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
|---|---|---|---|---|
| 05:00:32 (11.5 min) | 82 | CPU + Wait for CPU | 32 | 4.78 |
| RMAN backup & recovery I/O | 16 | 2.39 | ||
| control file sequential read | 14 | 2.09 | ||
| 05:12:00 (12.0 min) | 66 | CPU + Wait for CPU | 19 | 2.84 |
| PX Deq: Slave Session Stats | 18 | 2.69 | ||
| reliable message | 12 | 1.79 | ||
| 05:24:00 (12.0 min) | 48 | CPU + Wait for CPU | 22 | 3.29 |
| PX Deq: Slave Session Stats | 8 | 1.20 | ||
| control file sequential read | 7 | 1.05 | ||
| 05:36:00 (12.0 min) | 58 | CPU + Wait for CPU | 18 | 2.69 |
| control file sequential read | 10 | 1.49 | ||
| reliable message | 9 | 1.35 | ||
| 05:48:00 (12.0 min) | 72 | CPU + Wait for CPU | 28 | 4.19 |
| PX Deq: Slave Session Stats | 11 | 1.64 | ||
| log file parallel write | 6 | 0.90 | ||
| 06:00:00 (12.0 min) | 87 | CPU + Wait for CPU | 23 | 3.44 |
| control file parallel write | 21 | 3.14 | ||
| control file sequential read | 17 | 2.54 | ||
| 06:12:00 (12.0 min) | 70 | CPU + Wait for CPU | 25 | 3.74 |
| control file parallel write | 15 | 2.24 | ||
| control file sequential read | 13 | 1.94 | ||
| 06:24:00 (12.0 min) | 55 | CPU + Wait for CPU | 17 | 2.54 |
| PX Deq: Slave Session Stats | 14 | 2.09 | ||
| control file sequential read | 8 | 1.20 | ||
| 06:36:00 (12.0 min) | 57 | CPU + Wait for CPU | 18 | 2.69 |
| PX Deq: Slave Session Stats | 12 | 1.79 | ||
| control file sequential read | 11 | 1.64 | ||
| 06:48:00 (12.0 min) | 64 | CPU + Wait for CPU | 27 | 4.04 |
| control file sequential read | 15 | 2.24 | ||
| PX Deq: Slave Session Stats | 9 | 1.35 | ||
| 07:00:00 (32 secs) | 10 | CPU + Wait for CPU | 4 | 0.60 |
| control file sequential read | 2 | 0.30 | ||
| ASM file metadata operation | 1 | 0.15 |