DB Name
|
DB Id
|
Instance
|
Inst num
|
Startup Time
|
Release
|
RAC
|
MDB
|
2154954810
|
MDB
|
1
|
02-Jul-15
10:07
|
11.2.0.3.0
|
NO
|
Host Name
|
Platform
|
CPUs
|
Cores
|
Sockets
|
Memory (GB)
|
Mylocalhhost
|
Linux
x86 64-bit
|
6
|
6
|
6
|
23.46
|
Snap Id
|
Snap Time
|
Sessions
|
Cursors/Session
|
||
Begin
Snap:
|
9275
|
06-Jul-15 10:00:34
|
350
|
5.4
|
|
End
Snap:
|
9276
|
06-Jul-15 11:00:44
|
280
|
6.7
|
|
Elapsed:
|
60.16 (mins)
|
||||
DB
Time:
|
37.65 (mins)
|
||||
Cache
Sizes
Begin
|
End
|
|||
Buffer
Cache:
|
2,064M
|
2,064M
|
Std
Block Size:
|
8K
|
Shared
Pool Size:
|
4,848M
|
4,848M
|
Log
Buffer:
|
13,964K
|
Load
Profile
Per Second
|
Per Transaction
|
Per Exec
|
Per Call
|
|
DB
Time(s):
|
0.6
|
0.0
|
0.00
|
0.00
|
DB
CPU(s):
|
0.3
|
0.0
|
0.00
|
0.00
|
Redo
size:
|
135,529.4
|
8,717.8
|
||
Logical
reads:
|
5,165.1
|
332.2
|
||
Block
changes:
|
768.0
|
49.4
|
||
Physical
reads:
|
165.8
|
10.7
|
||
Physical
writes:
|
14.2
|
0.9
|
||
User
calls:
|
2,196.5
|
141.3
|
||
Parses:
|
160.6
|
10.3
|
||
Hard
parses:
|
1.8
|
0.1
|
||
W/A
MB processed:
|
2.1
|
0.1
|
||
Logons:
|
3.0
|
0.2
|
||
Executes:
|
1,334.9
|
85.9
|
||
Rollbacks:
|
0.1
|
0.0
|
||
Transactions:
|
15.6
|
Instance
Efficiency Percentages (Target 100%)
Buffer
Nowait %:
|
99.86
|
Redo
NoWait %:
|
100.00
|
Buffer
Hit %:
|
99.98
|
In-memory
Sort %:
|
100.00
|
Library
Hit %:
|
99.77
|
Soft
Parse %:
|
98.86
|
Execute
to Parse %:
|
87.97
|
Latch
Hit %:
|
99.85
|
Parse
CPU to Parse Elapsd %:
|
18.79
|
%
Non-Parse CPU:
|
95.81
|
Shared
Pool Statistics
Begin
|
End
|
|
Memory
Usage %:
|
47.51
|
47.69
|
%
SQL with executions>1:
|
98.42
|
97.77
|
%
Memory for SQL w/exec>1:
|
93.32
|
93.80
|
Top
5 Timed Foreground Events
Event
|
Waits
|
Time(s)
|
Avg wait (ms)
|
% DB time
|
Wait Class
|
DB
CPU
|
1,169
|
51.74
|
|||
buffer
busy waits
|
17,020
|
142
|
8
|
6.30
|
Concurrency
|
library
cache: mutex X
|
10,218
|
131
|
13
|
5.78
|
Concurrency
|
enq:
MS - contention
|
2,207
|
65
|
30
|
2.89
|
Other
|
enq:
TX - row lock contention
|
5,139
|
63
|
12
|
2.80
|
Application
|
Host
CPU (CPUs: 6 Cores: 6 Sockets: 6)
Load
Average Begin
|
Load Average End
|
%User
|
%System
|
%WIO
|
%Idle
|
0.18
|
0.18
|
4.7
|
1.9
|
0.3
|
93.2
|
Instance
CPU
%Total CPU
|
%Busy CPU
|
%DB time waiting for CPU (Resource
Manager)
|
5.6
|
83.0
|
0.0
|
Memory
Statistics
Begin
|
End
|
|
Host
Mem (MB):
|
24,023.5
|
24,023.5
|
SGA
use (MB):
|
7,216.0
|
7,216.0
|
PGA
use (MB):
|
845.4
|
771.0
|
%
Host Mem used for SGA+PGA:
|
33.56
|
33.25
|
No comments:
Post a Comment