|
Posted on
2014-12-30 16:50
徐正柱-
阅读( 535)
评论()
编辑
收藏
举报
|
Snap Id |
Snap Time |
Sessions |
Cursors/Session |
Begin Snap: |
35669 |
2012-11-8 13:00 |
1246 |
11.3 |
End Snap: |
35679 |
2012-11-8 18:00 |
834 |
16 |
Elapsed: |
|
300.14 |
|
|
DB Time: |
|
2,841.67 |
|
|
|
|
|
|
|
Operating System Statistics |
Time Model Statistics |
|
|
|
|
|
|
Statistic |
Total |
Statistic Name |
Time (s) |
% of DB Time |
NUM_LCPUS |
0 |
sql execute elapsed time |
87,551.84 |
99.97 |
NUM_VCPUS |
0 |
DB CPU |
248.77 |
0.28 |
AVG_BUSY_TIME |
126,487 |
parse time elapsed |
2.76 |
0 |
AVG_IDLE_TIME |
1,675,188 |
hard parse elapsed time |
1.47 |
0 |
AVG_IOWAIT_TIME |
2,687 |
failed parse elapsed time |
0.45 |
0 |
AVG_SYS_TIME |
11,000 |
PL/SQL execution elapsed time |
0.84 |
0 |
AVG_USER_TIME |
114,879 |
hard parse (sharing criteria) elapsed time |
0.32 |
0 |
BUSY_TIME |
48,496 |
hard parse (bind mismatch) elapsed time |
14.16 |
0.01 |
IDLE_TIME |
8,623,372 |
sequence load elapsed time |
9.8 |
0.01 |
IOWAIT_TIME |
7,728 |
repeated bind elapsed time |
0.01 |
0 |
SYS_TIME |
5,691 |
PL/SQL compilation elapsed time |
2.03 |
0 |
USER_TIME |
42,512 |
connection management call elapsed time |
1.7 |
0 |
LOAD |
0 |
inbound PL/SQL rpc elapsed time |
0.02 |
0 |
OS_CPU_WAIT_TIME |
7,404,200 |
DB time |
87577.44 |
|
RSRC_MGR_CPU_WAIT_TIME |
0 |
background elapsed time |
1585.54 |
|
PHYSICAL_MEMORY_BYTES |
135,319,207,936 |
background cpu time |
206.8 |
|
NUM_CPUS |
48 |
|
|
|
NUM_CPU_CORES |
24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
每个CPU耗时:= |
DB Time/逻辑cpu个数 |
59.20 |
min |
|
DB利用率:= |
DB Time/(NUM_CPUS*Elapsed)*100% |
19.72% |
|
NUM_CPUS是逻辑cpu个数 |
CPU利用率:= |
(DB CPU + background cpu time )/(NUM_CPUS*Elapsed )*100% |
0.08% |
|
NUM_CPUS是实际cpu个数 |
%User = |
USER_TIME/(BUSY_TIME+IDLE_TIME)*100% |
0.49% |
|
|
%Sys = |
SYS_TIME/(BUSY_TIME+IDLE_TIME)*100% |
0.07% |
|
|
%Idle = |
IDLE_TIME/(BUSY_TIME+IDLE_TIME)*100% |
99.44% |
|
|
ELAPSED_TIME= |
(BUSY_TIME+IDLE_TIME)/1000 |
Elapsed*60*60 |
|
|
8671.868 |
1080504.00 |
|
|
|
|
|
|
|
Service Statistics |
|
|
|
|
|
|
ordered by DB Time |
|
|
|
|
|
|
|
|
|
Service Name |
DB Time (s) |
DB CPU (s) |
Physical Reads |
Logical Reads |
SYS$USERS |
87,476.00 |
146.00 |
3,262 |
51,625 |
oradb11 |
101.00 |
102.00 |
0 |
545 |
SYS$BACKGROUND |
0 |
0 |
1 |
26 |
|
|
|
|
|
Total DB Time |
87577.0 |
|
|
|
Total DB Cpu |
248.0 |
|
|
|
% DB Time |
0.28% |
|
|
|
|