DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
UPRR | 1058789863 | uprr | 1 | 11.2.0.3.0 | NO | cnuctdb130 |
CPUs | SGA Size | Buffer Cache | Shared Pool | ASH Buffer Size |
---|---|---|---|---|
16 | 16,311M (100%) | 5,600M (34.3%) | 1,024M (6.3%) | 32.0M (0.2%) |
Sample Time | Data Source | |
---|---|---|
Analysis Begin Time: | 24-Apr-13 15:29:41 | V$ACTIVE_SESSION_HISTORY |
Analysis End Time: | 24-Apr-13 15:59:41 | V$ACTIVE_SESSION_HISTORY |
Elapsed Time: | 30.0 (mins) | |
Sample Count: | 3,900 | |
Average Active Sessions: | 2.17 | |
Avg. Active Session per CPU: | 0.14 | |
Report Target: | None specified |
Event | Event Class | % Event | Avg Active Sessions |
---|---|---|---|
CPU + Wait for CPU | CPU | 35.56 | 0.77 |
log file sequential read | System I/O | 16.18 | 0.35 |
Disk file operations I/O | User I/O | 1.67 | 0.04 |
Event | Event Class | % Activity | Avg Active Sessions |
---|---|---|---|
row cache lock | Concurrency | 45.97 | 1.00 |
Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
row cache lock | 45.97 | "2","0","3" | 45.97 | cache id | mode | request |
log file sequential read | 16.18 | "0","391168","2048" | 0.18 | log# | block# | blocks |
Disk file operations I/O | 1.69 | "2","0","3" | 1.49 | FileOperation | fileno | filetype |
Service | Module | % Activity | Action | % Action |
---|---|---|---|---|
SYS$USERS | JDBC Thin Client | 50.03 | UNNAMED | 50.03 |
SYS$BACKGROUND | UNNAMED | 46.51 | UNNAMED | 46.51 |
uprr | PL/SQL Developer | 3.44 | SQL 窗口 - 新建 | 3.38 |
SQL Command Type | Distinct SQLIDs | % Activity | Avg Active Sessions |
---|---|---|---|
INSERT | 3 | 46.95 | 1.02 |
SELECT | 75 | 6.41 | 0.14 |
Phase of Execution | % Activity | Avg Active Sessions |
---|---|---|
SQL Execution | 53.10 | 1.15 |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
3g3k82x8rr54f | 1397102654 | 166 | 45.67 | CPU + Wait for CPU | 27.95 | ** Row Source Not Available ** | 27.95 | insert into DF2_GL_BALANCE_QUE... |
3g3k82x8rr54f | 1397102654 | 166 | 45.66666666666666666666666666666666666667 |
log file sequential read | 16.05 | ** Row Source Not Available ** | 16.05 | |
3g3k82x8rr54f | 1397102654 | 166 | 45.66666666666666666666666666666666666667 |
Disk file operations I/O | 1.64 | ** Row Source Not Available ** | 1.64 | |
gb3kwkhf2yrhp | 3618362180 | 1 | 1.74 | CPU + Wait for CPU | 1.74 | FIXED TABLE - FIXED INDEX | 1.69 | select * from v$access t where... |
SQL ID | PlanHash | Sampled # of Executions | % Activity | Row Source | % RwSrc | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
3g3k82x8rr54f | 1397102654 | 166 | 45.67 | ** Row Source Not Available ** | 45.67 | CPU + Wait for CPU | 27.95 | insert into DF2_GL_BALANCE_QUE... |
gb3kwkhf2yrhp | 3618362180 | 1 | 1.74 | FIXED TABLE - FIXED INDEX | 1.69 | CPU + Wait for CPU | 1.69 | select * from v$access t where... |
Call Type | Count | % Activity | Avg Active Sessions |
---|---|---|---|
V8 Bundled Exec | 1,947 | 49.92 | 1.08 |
FETCH | 136 | 3.49 | 0.08 |
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
926, 1 | 45.97 | row cache lock | 45.97 | SYS | oracle@cnuctdb130 (SMON) | 1,793/1,800 [100%] | 0 |
1168,23869 | 40.00 | CPU + Wait for CPU | 24.26 | DATACORE | JDBC Thin Client | 946/1,800 [ 53%] | 0 |
1168,23869 | 40 | log file sequential read | 14.28 | DATACORE | JDBC Thin Client | 557/1,800 [ 31%] | 0 |
1168,23869 | 40 | Disk file operations I/O | 1.44 | DATACORE | JDBC Thin Client | 56/1,800 [ 3%] | 0 |
1009, 283 | 5.97 | CPU + Wait for CPU | 3.85 | DATACORE | JDBC Thin Client | 150/1,800 [ 8%] | 0 |
1009, 283 | 5.97435897435897435897435897435897435897 | log file sequential read | 1.90 | DATACORE | JDBC Thin Client | 74/1,800 [ 4%] | 0 |
315,54271 | 3.31 | CPU + Wait for CPU | 3.31 | DATACORE | plsqldev.exe | 129/1,800 [ 7%] | 0 |
1009, 287 | 1.21 | CPU + Wait for CPU | 1.18 | DATACORE | JDBC Thin Client | 46/1,800 [ 3%] | 1 |
Blocking Sid (Inst) | % Activity | Event Caused | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
1168,23869( 1) | 40.00 | row cache lock | 40.00 | DATACORE | JDBC Thin Client | 1,560/1,800 [ 87%] | 0 |
1009, 283( 1) | 5.97 | row cache lock | 5.97 | DATACORE | JDBC Thin Client | 233/1,800 [ 13%] | 0 |
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
15:29:41 (19 secs) | 43 | row cache lock | 20 | 0.51 |
15:29:41 (19 secs) | 43 | CPU + Wait for CPU | 18 | 0.46 |
15:29:41 (19 secs) | 43 | log file sequential read | 4 | 0.10 |
15:30:00 (3.0 min) | 381 | row cache lock | 178 | 4.56 |
15:30:00 (3.0 min) | 381 | CPU + Wait for CPU | 133 | 3.41 |
15:30:00 (3.0 min) | 381 | log file sequential read | 63 | 1.62 |
15:33:00 (3.0 min) | 374 | row cache lock | 177 | 4.54 |
15:33:00 (3.0 min) | 374 | CPU + Wait for CPU | 131 | 3.36 |
15:33:00 (3.0 min) | 374 | log file sequential read | 56 | 1.44 |
15:36:00 (3.0 min) | 367 | row cache lock | 181 | 4.64 |
15:36:00 (3.0 min) | 367 | CPU + Wait for CPU | 116 | 2.97 |
15:36:00 (3.0 min) | 367 | log file sequential read | 65 | 1.67 |
15:39:00 (3.0 min) | 449 | CPU + Wait for CPU | 197 | 5.05 |
15:39:00 (3.0 min) | 449 | row cache lock | 179 | 4.59 |
15:39:00 (3.0 min) | 449 | log file sequential read | 64 | 1.64 |
15:42:00 (3.0 min) | 428 | row cache lock | 180 | 4.62 |
15:42:00 (3.0 min) | 428 | CPU + Wait for CPU | 178 | 4.56 |
15:42:00 (3.0 min) | 428 | log file sequential read | 61 | 1.56 |
15:45:00 (3.0 min) | 371 | row cache lock | 180 | 4.62 |
15:45:00 (3.0 min) | 371 | CPU + Wait for CPU | 120 | 3.08 |
15:45:00 (3.0 min) | 371 | log file sequential read | 64 | 1.64 |
15:48:00 (3.0 min) | 411 | row cache lock | 179 | 4.59 |
15:48:00 (3.0 min) | 411 | CPU + Wait for CPU | 162 | 4.15 |
15:48:00 (3.0 min) | 411 | log file sequential read | 62 | 1.59 |
15:51:00 (3.0 min) | 365 | row cache lock | 180 | 4.62 |
15:51:00 (3.0 min) | 365 | CPU + Wait for CPU | 114 | 2.92 |
15:51:00 (3.0 min) | 365 | log file sequential read | 62 | 1.59 |
15:54:00 (3.0 min) | 383 | row cache lock | 181 | 4.64 |
15:54:00 (3.0 min) | 383 | CPU + Wait for CPU | 135 | 3.46 |
15:54:00 (3.0 min) | 383 | log file sequential read | 60 | 1.54 |
15:57:00 (2.7 min) | 328 | row cache lock | 158 | 4.05 |
15:57:00 (2.7 min) | 328 | CPU + Wait for CPU | 95 | 2.44 |
15:57:00 (2.7 min) | 328 | log file sequential read | 70 | 1.79 |