| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| SUSASTG | 2407826999 | SUSASTG2 | 2 | 11.1.0.7.0 | YES | stage-rac02 |
| CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
|---|---|---|---|---|
| 4 | 2,039M (100%) | 672M (33.0%) | 656M (32.2%) | 8.0M (0.4%) |
| Sample Time | Data Source | |
|---|---|---|
| Analysis Begin Time: | 07-Dec-10 12:30:28 | V$ACTIVE_SESSION_HISTORY |
| Analysis End Time: | 07-Dec-10 14:30:28 | V$ACTIVE_SESSION_HISTORY |
| Elapsed Time: | 120.0 (mins) | |
| Sample Count: | 632 | |
| 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 | 20.89 | 0.02 |
| reliable message | Other | 15.19 | 0.01 |
| CPU + Wait for CPU | CPU | 7.75 | 0.01 |
| log file sync | Commit | 4.11 | 0.00 |
| control file sequential read | System I/O | 1.58 | 0.00 |
| Event | Event Class | % Activity | Avg Active Sessions |
|---|---|---|---|
| CPU + Wait for CPU | CPU | 23.10 | 0.02 |
| control file sequential read | System I/O | 12.18 | 0.01 |
| control file parallel write | System I/O | 3.32 | 0.00 |
| ASM file metadata operation | Other | 2.69 | 0.00 |
| log file parallel write | System I/O | 2.69 | 0.00 |
| Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
|---|---|---|---|---|---|---|
| PX Deq: Slave Session Stats | 20.89 | "268632063","1","0" | 12.18 | sleeptime/senderid | passes | NOT DEFINED |
| reliable message | 15.98 | "2760167032","3717508896","2761025992" | 2.69 | channel context | channel handle | broadcast message |
| "2760167032","3717508896","2761027528" | 2.22 | |||||
| "2760167032","3717508896","2761027144" | 1.74 | |||||
| control file sequential read | 13.77 | "0","35","1" | 8.07 | file# | block# | blocks |
| "0","1","1" | 2.37 | |||||
| "0","3","1" | 2.06 | |||||
| log file sync | 4.11 | "3410","0","0" | 1.74 | buffer# | NOT DEFINED | NOT DEFINED |
| control file parallel write | 3.32 | "3","4","3" | 3.32 | files | block# | requests |
| Service | Module | % Activity | Action | % Action |
|---|---|---|---|---|
| SYS$BACKGROUND | UNNAMED | 45.41 | UNNAMED | 45.41 |
| SYS$USERS | racgimon@stage-rac02 (TNS V1-V3) | 28.96 | UNNAMED | 28.96 |
| racgimon@stage-rac01 (TNS V1-V3) | 6.80 | UNNAMED | 6.80 | |
| UNNAMED | 5.54 | UNNAMED | 5.54 | |
| SUSASTG | UNNAMED | 4.43 | UNNAMED | 4.43 |
| SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
|---|---|---|---|
| SELECT | 19 | 9.18 | 0.01 |
| PL/SQL EXECUTE | 4 | 2.06 | 0.00 |
| INSERT | 3 | 1.11 | 0.00 |
| Phase of Execution | % Activity | Avg Active Sessions |
|---|---|---|
| SQL Execution | 23.73 | 0.02 |
| PLSQL Execution | 1.58 | 0.00 |
| SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 7frqszzdu8sgg | 4109302118 | 23 | 4.91 | reliable message | 3.01 | PX COORDINATOR | 3.01 | select DECODE(UPPER(d.OPEN_MOD... |
| control file sequential read | 1.58 | FIXED TABLE - FULL | 1.42 |
| SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 7frqszzdu8sgg | 4109302118 | 23 | 4.91 | PX COORDINATOR | 3.16 | reliable message | 3.01 | select DECODE(UPPER(d.OPEN_MOD... |
| FIXED TABLE - FULL | 1.42 | control file sequential read | 1.42 |
| PLSQL Entry Subprogram | % Activity | PLSQL Current Subprogram | % Current |
|---|---|---|---|
| SYSMAN.EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS | 3.32 | SQL | 1.90 |
| Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 537, 3 | 16.61 | reliable message | 14.56 | SYS | racgimon@stage...2 (TNS V1-V3) | 92/7,200 [ 1%] | 0 |
| control file sequential read | 1.58 | 10/7,200 [ 0%] | 0 | ||||
| 1086, 1 | 12.82 | CPU + Wait for CPU | 10.13 | SYS | oracle@stage-rac02 (ASMB) | 64/7,200 [ 1%] | 0 |
| ASM file metadata operation | 2.69 | 17/7,200 [ 0%] | 0 | ||||
| 1096, 1 | 10.44 | control file sequential read | 10.13 | SYS | oracle@stage-rac02 (LMON) | 64/7,200 [ 1%] | 0 |
| 1097, 1 | 5.38 | CPU + Wait for CPU | 5.38 | SYS | oracle@stage-rac02 (DIA0) | 34/7,200 [ 0%] | 0 |
| 1090, 1 | 4.27 | control file parallel write | 3.32 | SYS | oracle@stage-rac02 (CKPT) | 21/7,200 [ 0%] | 0 |
| Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
|---|---|---|---|---|---|---|---|
| 1091, 1( 2) | 4.75 | log file sync | 4.11 | SYS | oracle@stage-rac02 (LGWR) | 17/7,200 [ 0%] | 0 |
| Sid,Srl# (Inst) | % Activity | SQL ID | Event | % Event | User | Program | SQL Text |
|---|---|---|---|---|---|---|---|
| 537, 3(2) | 27.06 | PX Deq: Slave Session Stats | 11.55 | SYS | racgimon@stage...2 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | |
| reliable message | 11.55 | SYS | racgimon@stage...2 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | |||
| 7frqszzdu8sgg | reliable message | 3.01 | SYS | racgimon@stage...2 (TNS V1-V3) | select DECODE(UPPER(d.OPEN_MOD... | ||
| 1094, 8(1) | 6.96 | PX Deq: Slave Session Stats | 6.49 | UserID: |
| Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
|---|---|---|---|---|
| 12:30:28 (5.5 min) | 36 | CPU + Wait for CPU | 20 | 3.16 |
| reliable message | 6 | 0.95 | ||
| control file sequential read | 3 | 0.47 | ||
| 12:36:00 (12.0 min) | 69 | CPU + Wait for CPU | 21 | 3.32 |
| PX Deq: Slave Session Stats | 15 | 2.37 | ||
| control file sequential read | 10 | 1.58 | ||
| 12:48:00 (12.0 min) | 43 | CPU + Wait for CPU | 15 | 2.37 |
| PX Deq: Slave Session Stats | 10 | 1.58 | ||
| control file sequential read | 10 | 1.58 | ||
| 13:00:00 (12.0 min) | 71 | CPU + Wait for CPU | 27 | 4.27 |
| PX Deq: Slave Session Stats | 12 | 1.90 | ||
| reliable message | 11 | 1.74 | ||
| 13:12:00 (12.0 min) | 91 | control file sequential read | 19 | 3.01 |
| log file sync | 16 | 2.53 | ||
| CPU + Wait for CPU | 14 | 2.22 | ||
| 13:24:00 (12.0 min) | 62 | CPU + Wait for CPU | 14 | 2.22 |
| PX Deq: Slave Session Stats | 11 | 1.74 | ||
| control file sequential read | 10 | 1.58 | ||
| 13:36:00 (12.0 min) | 59 | CPU + Wait for CPU | 22 | 3.48 |
| PX Deq: Slave Session Stats | 12 | 1.90 | ||
| reliable message | 11 | 1.74 | ||
| 13:48:00 (12.0 min) | 71 | PX Deq: Slave Session Stats | 25 | 3.96 |
| reliable message | 20 | 3.16 | ||
| CPU + Wait for CPU | 17 | 2.69 | ||
| 14:00:00 (12.0 min) | 52 | CPU + Wait for CPU | 13 | 2.06 |
| PX Deq: Slave Session Stats | 13 | 2.06 | ||
| reliable message | 12 | 1.90 | ||
| 14:12:00 (12.0 min) | 49 | CPU + Wait for CPU | 20 | 3.16 |
| PX Deq: Slave Session Stats | 10 | 1.58 | ||
| control file sequential read | 8 | 1.27 | ||
| 14:24:00 (6.5 min) | 29 | CPU + Wait for CPU | 12 | 1.90 |
| PX Deq: Slave Session Stats | 8 | 1.27 | ||
| control file sequential read | 4 | 0.63 |