| |
 |
|
STATSPACK report showing library cache load lock bottleneck
Oracle Tips by Burleson Consulting
December 10, 2007
|
Sample from:
Oracle dynamic memory management tips
STATSPACK report for
DB Name DB Id
Instance Inst Num Release Cluster Host
------------ -----------
------------ -------- ----------- ------- ------------
123456 xxxx
123456 1 9.2.0.4.0 NO abcdefg
.
. .
Elapsed: 9.98 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer
Cache: 11,504M Std Block Size: 8K
Shared Pool
Size: 400M Log Buffer: 1,280K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo
size: 196,617.69 632.75
Logical
reads: 36,311.98 116.86
Block
changes: 1,114.83 3.59
Physical
reads: 2,164.71 6.97
Physical
writes: 958.11 3.08
User
calls: 2,103.44 6.77
Parses: 441.53 1.42
Hard
parses: 37.52 0.12
Sorts: 362.25 1.17
Logons: 0.25 0.00
Executes: 1,790.94 5.76
Transactions: 310.73
% Blocks changed per
Read: 3.07 Recursive Call %: 65.64
Rollback per transaction
%: 92.05 Rows per Sort: 885.61
Instance Efficiency
Percentages (Target 100%) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait
%: 99.99 Redo NoWait %: 100.00
Buffer Hit
%: 96.56 In-memory Sort %: 99.97
Library Hit
%: 96.51 Soft Parse %: 91.50
Execute to Parse
%: 75.35 Latch Hit %: 99.17
Parse CPU to Parse Elapsd
%: 0.64 % Non-Parse CPU: 96.07
Shared Pool
Statistics Begin
End ------ ------
Memory Usage
%: 85.55 89.99
% SQL with
executions>1: 57.79 53.57
% Memory for SQL
w/exec>1: 72.61 68.39
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ %
Total
Event Waits Time (s) Ela
Time
-------------------------------------------- ------------ -----------
--------
library cache load
lock 9,708 13,194 49.20
library cache
pin 8,084 9,425 35.14
CPU
time 1,538 5.73
kksfbc child
completion 152,610 1,495 5.57
db file sequential
read 190,283 738 2.75
-------------------------------------------------------------
Wait Events for DB: 123456
Instance: 123456 Snaps: 7103 -7113
-> s - second
-> cs - centisecond -
100th of a second
-> ms - millisecond -
1000th of a second
-> us - microsecond -
1000000th of a second
-> ordered by wait time
desc, waits desc (idle events last)
Avg
Total Wait
wait Waits
Event Waits Timeouts Time (s)
(ms) /txn
---------------------------- ------------ ---------- --------------
---------- --------
library cache load
lock 9,708 2,438 13,194 1,359 0.1
library cache pin
8,084 1,796 9,425 1,166 0.0
kksfbc child
completion 152,610 152,595 1,495 10 0.8
db file sequential
read 190,283 0 738 4 1.0
row cache
lock 605 5 232 383
0.0
log file
sync 14,785 0 60 4
0.1
latch
free 13,785 399 45
3 0.1
db file scattered
read 45,780 0 31 1 0.2
SQL*Net message from dblink
69 0 30 437 0.0
direct path
read 10,805 0 13 1 0.1
db file parallel
write 809 0 6 7 0.0
db file parallel
read 216 0 3 15 0.0
log file sequential
read 157 0 2 13 0.0
buffer busy
waits 1,631 0 2 1 0.0
resmgr:waiting in
check2 120 0 1 10 0.0
enqueue 344 0 1
3 0.0
control file parallel
write 251 0 1 3 0.0
LGWR wait for redo
copy 322 20 0 1 0.0
SQL*Net break/reset to
clien 524 0 0 1 0.0
direct path
write 546 0 0 0 0.0
async disk
IO 524 0 0 0 0.0
SQL*Net more data to client
9,360 0 0 0 0.1
log file parallel
write 14,026 13,960 0 0 0.1
control file sequential
read 1,187 0 0 0 0.0
direct path read
(lob) 72 0 0 0 0.0
SQL*Net message to dblink
69 0 0 0 0.0
SQL*Net more data from
dblin 9 0 0 0 0.0
resmgr:waiting in
check 2 0 0 0 0.0
buffer
deadlock 38 37 0 0
0.0
SQL*Net message from
client 1,272,239 0 201,810 159 6.8
PX Idle
Wait 1,168 1,168 2,336 2,000
0.0
pipe
get 180 179 709
3,939 0.0
virtual circuit
status 20 20 586 29,297 0.0
wakeup time
manager 19 19 559 29,421 0.0
SQL*Net more data from
clien 9,700 0 7 1 0.1
SQL*Net message to
client 1,272,231 0 1 0 6.8
-------------------------------------------------------------
Background Wait Events for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> ordered by wait time
desc, waits desc (idle events last)
Avg
Total Wait
wait Waits
Event Waits Timeouts Time (s)
(ms) /txn
---------------------------- ------------ ---------- --------------
---------- --------
db file parallel
write 810 0 6 7 0.0
log file sequential
read 114 0 1 12 0.0
control file parallel
write 251 0 1 3 0.0
LGWR wait for redo
copy 322 20 0 1 0.0
async disk
IO 341 0 0 0 0.0
direct path
read 860 0 0 0 0.0
log file parallel
write 14,027 13,961 0 0 0.1
direct path
write 206 0 0 0 0.0
latch
free 1 0 0
12 0.0
control file sequential
read 231 0 0 0 0.0
db file scattered
read 4 0 0 0 0.0
db file sequential
read 7 0 0 0 0.0
rdbms ipc
reply 2 0 0 0
0.0
rdbms ipc message
41,115 26,482 4,495 109 0.2
smon
timer 3 2 681
227,146 0.0
pmon
timer 201 201 583
2,901 0.0
-------------------------------------------------------------
. . .
Instance Activity Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
Statistic Total per Second per
Trans
--------------------------------- ------------------ --------------
------------
CPU used by this
session 153,800 256.8 0.8
CPU used when call
started 153,887 256.9 0.8
CR blocks
created 3,663 6.1 0.0
DBWR buffers
scanned 126,011 210.4 0.7
DBWR checkpoint buffers
written 17,892 29.9 0.1
DBWR
checkpoints 0 0.0 0.0
DBWR free buffers
found 114,888 191.8 0.6
DBWR lru
scans 266 0.4 0.0
DBWR make free
requests 300 0.5 0.0
DBWR revisited
being-written buff 0 0.0 0.0
DBWR summed scan
depth 126,011 210.4 0.7
DBWR transaction table
writes 17 0.0 0.0
DBWR undo block writes
8,948 14.9 0.1
Parallel operations
downgraded to 0 0.0 0.0
SQL*Net roundtrips to/from
client 1,257,948 2,100.1 6.8
SQL*Net roundtrips to/from
dblink 69 0.1 0.0
active txn count during
cleanout 9,813 16.4 0.1
background checkpoints
completed 0 0.0 0.0
background checkpoints
started 0 0.0 0.0
background
timeouts 1,297 2.2 0.0
branch node
splits 4 0.0 0.0
buffer is not pinned
count 12,842,702 21,440.2 69.0
buffer is pinned
count 17,944,327 29,957.1 96.4
bytes received via SQL*Net
from c 188,200,100 314,190.5 1,011.1
bytes received via SQL*Net
from d 35,159 58.7 0.2
bytes sent via SQL*Net to
client 207,282,409 346,047.4 1,113.6
bytes sent via SQL*Net to
dblink 16,184 27.0 0.1
calls to get snapshot scn:
kcmgss 1,323,226 2,209.1 7.1
calls to kcmgas
23,304 38.9 0.1
calls to kcmgcs
3,064 5.1 0.0
change write
time 347 0.6 0.0
cleanout - number of ktugct
calls 7,282 12.2 0.0
cluster key scan block
gets 76,574 127.8 0.4
cluster key
scans 23,416 39.1 0.1
commit cleanout failures:
block l 0 0.0 0.0
commit cleanout failures:
buffer 1 0.0 0.0
commit cleanout failures:
callbac 99 0.2 0.0
commit cleanout failures:
cannot 149 0.3 0.0
commit cleanout failures:
hot bac 0 0.0 0.0
commit
cleanouts 93,172 155.6 0.5
commit cleanouts
successfully com 92,923 155.1 0.5
commit txn count during
cleanout 19,109 31.9 0.1
consistent
changes 7,664 12.8 0.0
consistent
gets 20,724,603 34,598.7 111.3
consistent gets -
examination 7,000,932 11,687.7 37.6
current blocks converted
for CR 3 0.0 0.0
cursor
authentications 3,070 5.1 0.0
data blocks consistent
reads - un 7,589 12.7 0.0
db block
changes 667,784 1,114.8 3.6
db block
gets 1,026,500 1,713.7 5.5
deferred (CURRENT) block
cleanout 12,339 20.6 0.1
Instance Activity Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
Statistic Total per Second per
Trans
--------------------------------- ------------------ --------------
------------
dirty buffers
inspected 989 1.7 0.0
enqueue
conversions 2,552 4.3 0.0
enqueue
releases 392,540 655.3 2.1
enqueue
requests 392,522 655.3 2.1
enqueue
timeouts 0 0.0 0.0
enqueue waits
340 0.6 0.0
exchange
deadlocks 38 0.1 0.0
execute
count 1,072,775 1,790.9 5.8
free buffer inspected
1,016 1.7 0.0
free buffer
requested 764,876 1,276.9 4.1
hot buffers moved to head
of LRU 98,480 164.4 0.5
immediate (CR) block
cleanout app 3,599 6.0 0.0
immediate (CURRENT) block
cleanou 6,584 11.0 0.0
index fast full scans
(full) 629 1.1 0.0
index fetch by
key 1,988,571 3,319.8 10.7
index scans
kdiixs1 1,748,585 2,919.2 9.4
leaf node 90-10
splits 234 0.4 0.0
leaf node
splits 1,441 2.4 0.0
logons
cumulative 148 0.3 0.0
messages
received 15,037 25.1 0.1
messages
sent 15,037 25.1 0.1
no buffer to keep pinned
count 0 0.0 0.0
no work - consistent read
gets 11,805,774 19,709.1 63.4
opened cursors
cumulative 124,207 207.4 0.7
parse count
(failures) 539 0.9 0.0
parse count
(hard) 22,475 37.5 0.1
parse count
(total) 264,478 441.5 1.4
parse time cpu
6,048 10.1 0.0
parse time
elapsed 937,998 1,565.9 5.0
physical
reads 1,296,660 2,164.7 7.0
physical reads
direct 547,346 913.8 2.9
physical reads direct
(lob) 72 0.1 0.0
physical
writes 573,910 958.1 3.1
physical writes direct
543,910 908.0 2.9
physical writes non
checkpoint 571,493 954.1 3.1
pinned buffers
inspected 2 0.0 0.0
prefetched
blocks 517,096 863.3 2.8
prefetched blocks aged out
before 12 0.0 0.0
process last non-idle
time 160,370,062,707 267,729,653.9 861,602.4
recursive
calls 2,406,633 4,017.8 12.9
recursive cpu
usage 108,358 180.9 0.6
redo blocks
written 245,757 410.3 1.3
redo buffer allocation
retries 0 0.0 0.0
redo
entries 341,942 570.9 1.8
redo log space
requests 0 0.0 0.0
redo log space wait
time 0 0.0 0.0
redo ordering
marks 0 0.0 0.0
redo
size 117,773,996 196,617.7 632.8
redo synch
time 5,880 9.8 0.0
redo synch
writes 14,852 24.8 0.1
redo
wastage 4,084,012 6,818.1 21.9
Instance Activity Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
Statistic Total per Second per
Trans
--------------------------------- ------------------ --------------
------------
redo write
time 2,806 4.7 0.0
redo writer latching
time 46 0.1 0.0
redo
writes 13,915 23.2 0.1
rollback changes - undo
records a 4,032 6.7 0.0
rows fetched via
callback 1,785,454 2,980.7 9.6
session connect
time 160,370,062,707 267,729,653.9 861,602.4
session logical
reads 21,750,874 36,312.0 116.9
session pga memory
max 78,421,104 130,920.0 421.3
session uga memory
max 9,144,734,176 15,266,668.1 49,130.9
shared hash latch upgrades
- no w 1,692,604 2,825.7 9.1
shared hash latch upgrades
- wait 2,030 3.4 0.0
sorts
(disk) 67 0.1 0.0
sorts
(memory) 216,921 362.1 1.2
sorts
(rows) 192,166,563 320,812.3 1,032.4
summed dirty queue
length 12,117 20.2 0.1
switch current to new
buffer 1,498 2.5 0.0
table fetch by rowid
11,182,579 18,668.8 60.1
table fetch continued
row 80,654 134.7 0.4
table scan blocks
gotten 5,454,987 9,106.8 29.3
table scan rows
gotten 271,796,367 453,750.2 1,460.3
table scans (cache
partitions) 3 0.0 0.0
table scans (long
tables) 4 0.0 0.0
table scans (short
tables) 59,965 100.1 0.3
transaction
rollbacks 80 0.1 0.0
transaction tables
consistent rea 0 0.0 0.0
transaction tables
consistent rea 0 0.0 0.0
user
calls 1,259,958 2,103.4 6.8
user
commits 14,799 24.7 0.1
user
rollbacks 171,331 286.0 0.9
workarea executions -
onepass 136 0.2 0.0
workarea executions -
optimal 164,095 274.0 0.9
write clones created in
backgroun 0 0.0 0.0
write clones created in
foregroun 5 0.0 0.0
-------------------------------------------------------------
. . .
Buffer Pool Statistics for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> Standard block size
Pools D: default, K: keep, R: recycle
-> Default Pools for other
block sizes: 2k, 4k, 8k, 16k, 32k
Free Write
Buffer
Number of
Cache Buffer Physical Physical Buffer Complete Busy
P Buffers Hit
% Gets Reads Writes Waits Waits Waits
--- ---------- -----
----------- ----------- ---------- ------- -------- ------
D 1,427,215 96.6
22,272,387 754,370 30,478 0 0 1,842
-------------------------------------------------------------
Instance Recovery Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> B: Begin
snapshot, E: End snapshot
Targt
Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual
Target Size Timeout Interval
(s) (s) Estd IOs
Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ----------
---------- ---------- ---------- ---------- ----------
B 300 27
43146 447895 442368 442368 990588
E 300 27
42038 442652 442368 442368 1235937
-------------------------------------------------------------
Buffer Pool Advisory for
DB: 123456 Instance: 123456 End Snap: 7113
-> Only rows with estimated
physical reads >0 are displayed
-> ordered by Block Size,
Buffers For Estimate
Size for Size
Buffers for Est Physical Estimated
P Estimate (M) Factr
Estimate Read Factor Physical Reads
--- ------------ -----
---------------- ------------- ------------------
D 1,152
.1 142,920 2.98 338,300,731
D 2,304
.2 285,840 2.33 264,487,712
D 3,456
.3 428,760 1.86 211,440,467
D 4,608
.4 571,680 1.57 178,291,585
D 5,760
.5 714,600 1.37 155,799,666
D 6,912
.6 857,520 1.24 140,324,634
D 8,064
.7 1,000,440 1.14 129,571,197
D 9,216
.8 1,143,360 1.08 122,259,078
D 10,368
.9 1,286,280 1.03 117,249,885
D 11,504
1.0 1,427,215 1.00 113,474,858
D 11,520
1.0 1,429,200 1.00 113,423,137
D 12,672
1.1 1,572,120 0.97 109,708,462
D 13,824
1.2 1,715,040 0.94 106,795,972
D 14,976
1.3 1,857,960 0.92 104,036,040
D 16,128
1.4 2,000,880 0.90 102,165,676
D 17,280
1.5 2,143,800 0.89 100,654,657
D 18,432
1.6 2,286,720 0.88 99,373,249
D 19,584
1.7 2,429,640 0.87 98,218,564
D 20,736
1.8 2,572,560 0.86 97,205,464
D 21,888
1.9 2,715,480 0.85 96,379,712
D 23,040
2.0 2,858,400 0.84 95,626,728
-------------------------------------------------------------
Buffer wait Statistics for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> ordered by wait time
desc, waits desc
Tot Wait Avg
Class
Waits Time (s) Time (ms)
------------------
----------- ---------- ---------
data block
1,766 2 1
undo block
31 0 1
undo header
26 0 0
1st level bmb
1 0 0
-------------------------------------------------------------
PGA Aggr Target Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> B: Begin snap E: End
snap (rows dentified with B or E contain data
which is absolute i.e.
not diffed over the interval)
-> PGA cache hit % -
percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual
workarea memory target
-> W/A PGA Used - amount
of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem -
percentage of PGA memory allocated to workareas
-> %Auto W/A Mem -
percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem -
percentage of workarea memory under manual control
PGA Cache Hit % W/A MB
Processed Extra W/A MB Read/Written
---------------
---------------- -------------------------
76.6
15,895 4,851
%PGA %Auto %Man
PGA Aggr Auto PGA PGA
Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M)
Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- ---------
---------- ---------- ------ ------ ------ ----------
B 2,500 1,758
1,383.5 139.8 10.1 100.0 .0 102,400
E 2,500 1,751
1,202.5 25.8 2.1 100.0 .0 102,400
-------------------------------------------------------------
PGA Aggr Target Histogram
for DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> Optimal Executions are
purely in-memory operations
Low High
Optimal Optimal Total
Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- -------
-------------- ------------- ------------ ------------
8K
16K 162,803 162,803 0 0
16K
32K 632 632 0 0
32K
64K 362 362 0 0
64K 128K
121 121 0 0
128K
256K 21 21 0 0
256K
512K 3 3 0 0
512K
1024K 4 4 0 0
1M
2M 7 7 0 0
2M
4M 2 2 0 0
4M
8M 2 2 0 0
8M 16M 4
4 0 0
32M 64M
136 0 136 0
64M 128M
140 140 0 0
-------------------------------------------------------------
PGA Memory Advisory for DB:
123456 Instance: 123456 End Snap: 7113
-> When using Auto Memory
Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc
Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target
Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr
Processed Written to Disk Hit % Count
---------- -------
---------------- ---------------- -------- ----------
313 0.1
20,576,033.4 28,251,393.2 42.0 89,807
625 0.3
20,576,033.4 19,032,700.8 52.0 30,704
1,250 0.5
20,576,033.4 9,294,023.4 69.0 0
1,875 0.8
20,576,033.4 3,163,596.5 87.0 0
2,500 1.0
20,576,033.4 3,154,650.9 87.0 0
3,000 1.2
20,576,033.4 390,593.6 98.0 0
3,500 1.4
20,576,033.4 390,593.6 98.0 0
4,000 1.6
20,576,033.4 390,593.6 98.0 0
4,500 1.8
20,576,033.4 390,593.6 98.0 0
5,000 2.0
20,576,033.4 390,593.6 98.0 0
7,500 3.0
20,576,033.4 390,593.6 98.0 0
10,000 4.0
20,576,033.4 390,593.6 98.0 0
15,000 6.0
20,576,033.4 390,593.6 98.0 0
20,000 8.0
20,576,033.4 390,593.6 98.0 0
-------------------------------------------------------------
Enqueue activity for DB:
123456 Instance: 123456 Snaps: 7103 -7113
-> Enqueue stats gathered
prior to 9i should not be compared with 9i data
-> ordered by Wait Time
desc, Waits desc
Avg Wt Wait
Eq Requests Succ
Gets Failed Gets Waits Time (ms) Time (s)
-- ------------
------------ ----------- ----------- ------------- ------------
TX 18,321
18,327 0 141 7.89 1
SQ 1,391
1,391 0 171 .48 0
CU 5,469
5,469 0 28 .57 0
-------------------------------------------------------------
Rollback Segment Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
->A high value for "Pct
Waits" suggests more rollback segments may be required
->RBS stats may not be
accurate between begin and end snaps when using Auto Undo,
managment, as RBS may be
dynamically created and dropped as needed
Trans Table
Pct Undo Bytes
RBS No Gets
Waits Written Wraps Shrinks Extends
------ --------------
------- --------------- -------- -------- --------
0 18.0
0.00 0 0 0 0
1 2,835.0
0.00 2,855,722 3 0 3
2 1,370.0
0.00 1,169,460 1 0 1
3 23.0
0.00 0 0 0 0
4 2,531.0
0.04 2,501,660 3 0 3
5 1,845.0
0.05 1,719,574 0 0 0
6 1,915.0
0.00 2,403,960 3 0 3
7 61.0
0.00 1,076 0 0 0
8 2,343.0
0.00 2,782,674 0 0 0
9 1,857.0
0.00 1,725,788 2 0 1
10 885.0
0.00 1,048,368 1 0 1
11 1,695.0
0.00 1,668,372 1 0 0
12 1,410.0
0.00 1,773,072 2 0 1
13 54.0
0.00 77,860 0 0 0
14 6.0
0.00 0 0 0 0
15 1,934.0
0.00 1,630,046 0 0 0
16 1,658.0
0.00 1,484,418 1 1 0
17 25.0
0.00 1,824 0 0 0
18 12.0
0.00 0 0 0 0
19 2,969.0
0.00 2,916,724 3 0 3
20 1,196.0
0.00 1,282,160 1 0 1
21 18.0
0.00 0 0 0 0
22 1,941.0
0.00 2,030,982 2 0 2
23 2,435.0
0.00 2,363,328 3 0 2
24 6.0
0.00 0 0 0 0
25 834.0
0.00 803,482 1 0 1
26 1,191.0
0.00 1,414,074 0 0 0
27 1,032.0
0.00 1,235,972 2 0 2
28 14.0
0.00 0 0 0 0
29 10.0
0.00 0 0 0 0
30 1,207.0
0.00 1,369,426 1 0 1
31 11.0
0.00 0 0 0 0
32 26.0
0.00 0 0 0 0
33 23.0
0.00 0 0 0 0
34 26.0
0.00 410 0 0 0
35 1,971.0
0.00 1,803,244 2 0 2
36 10.0
0.00 0 0 0 0
37 1,998.0
0.00 1,953,712 2 0 2
38 1,425.0
0.00 1,562,604 2 0 2
39 16.0
0.00 0 0 0 0
40 329.0
0.00 251,960 0 0 0
41 1,998.0
0.00 1,716,500 2 0 2
42 1,943.0
0.00 1,882,810 2 0 2
-------------------------------------------------------------
Rollback Segment Storage
for DB: 123456 Instance: 123456 Snaps: 7103 -7113
->Optimal Size should be
larger than Avg Active
RBS No Segment Size
Avg Active Optimal Size Maximum Size
------ ---------------
--------------- --------------- ---------------
0
385,024 30,222 385,024
1
32,628,736 1,303,496 1,610,735,616
2 25,288,704
3,794,109 4,227,981,312
3
31,580,160 1,467,428 1,979,834,368
4
23,191,552 1,162,536 700,571,648
5 44,163,072
222,127,802 4,227,981,312
6
60,940,288 4,657,998 788,652,032
7
37,871,616 1,600,874 861,003,776
8 77,717,504
343,101,031 805,429,248
9
25,288,704 1,199,937 1,543,626,752
10 47,308,800
362,694,289 4,227,981,312
11
25,288,704 1,001,174 56,745,984
12
55,697,408 1,147,522 55,697,408
13 124,903,424
38,937,889 218,226,688
14
16,900,096 990,490 31,580,160
15 203,546,624
90,357,982 268,558,336
16 865,198,080
334,973,318 868,343,808
17
15,851,520 944,904 26,337,280
18
5,365,760 199,228 5,365,760
19
37,871,616 1,060,858 37,871,616
20
48,357,376 1,102,192 48,357,376
21
31,580,160 2,013,934 31,580,160
22
24,240,128 934,781 24,240,128
23
23,191,552 928,476 23,191,552
24
8,511,488 0 8,511,488
25
20,045,824 892,945 20,045,824
26
59,891,712 1,460,931 159,506,432
27
16,900,096 830,802 16,900,096
28
11,657,216 646,871 11,657,216
29
13,754,368 199,228 13,754,368
30
15,917,056 798,250 15,917,056
31
7,462,912 460,498 7,462,912
32
16,900,096 830,802 16,900,096
33
10,477,568 620,105 10,477,568
34 12,574,720
701,514 12,574,720
35
12,574,720 701,514 12,574,720
36
6,283,264 395,521 6,283,264
37
16,769,024 821,751 16,769,024
38
20,963,328 899,174 20,963,328
39
8,380,416 519,601 8,380,416
40
20,963,328 2,430,913 20,963,328
41
17,817,600 843,637 17,817,600
42
16,769,024 820,867 16,769,024
-------------------------------------------------------------
Undo Segment Summary for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> Undo segment block
stats:
-> uS - unexpired Stolen,
uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen,
eR - expired Released, eU - expired reUsed
Undo
Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS#
Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- --------------
-------------- -------- ---------- -------- ------ -------------
1 29,113
40,035,106 4,173 25 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB:
123456 Instance: 123456 Snaps: 7103 -7113
-> ordered by Time desc
Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/
End Time
Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------
-------- ------- -------- ------- ------ -------------
04-Dec 10:14 6,604
######## 4,173 25 0 0 0/0/0/0/0/0
04-Dec 10:04 22,509
######## 3,574 23 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB:
123456 Instance: 123456 Snaps: 7103 -7113
->"Get Requests", "Pct Get
Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get
requests
->"NoWait Requests", "Pct
NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both
should be very close to 0.0
Pct Avg Wait
Pct
Get Get Slps Time NoWait
NoWait
Latch
Requests Miss /Miss (s) Requests Miss
------------------------
-------------- ------ ------ ------ ------------ ------
Consistent RBA
13,917 0.0 0 0
FIB s.o chain
latch 2 0.0 0 0
FOB s.o list
latch 5,628 0.1 0.0 0 0
SQL memory manager
latch 1 0.0 0 194 0.0
SQL memory manager worka
206,085 0.0 0.0 0 0
active checkpoint
queue 1,902 0.0 0 0
archive
control 431 0.0 0 0
archive process
latch 12 0.0 0 0
cache buffer
handles 9,830 0.0 0 0
cache buffers
chains 39,560,533 0.5 0.0 0 1,334,587 0.0
cache buffers lru
chain 44,176 0.1 0.0 0 1,122,946 0.2
channel handle pool latc
282 0.0 0 0
channel operations paren
820 0.0 0 0
checkpoint queue
latch 169,290 0.0 0.0 0 28,900 0.0
child cursor hash
table 238,715 0.6 0.0 0 0
dml lock allocation
122,873 0.4 0.0 0 0
dummy
allocation 288 0.0 0 0
enqueue hash
chains 788,011 0.4 0.0 0 0
enqueues 829,863 0.7 0.0 0 0
event group
latch 145 0.0 0 0
global tx hash
mapping 1,691 0.0 0 0
hash table column
usage 0 0 284,957 0.0
internal temp table obje
9 0.0 0 0
job_queue_processes
para 10 0.0 0 0
ktm global
data 5 0.0 0 0
kwqit: protect wakeup ti
19 0.0 0 0
lgwr LWN
SCN 13,943 0.0 0.0 0 0
library
cache 6,864,052 2.8 0.0 33 60,456 17.3
library cache load
lock 97,089 1.2 0.0 0 0
library cache
pin 4,278,801 0.2 0.0 0 0
library cache pin alloca
1,649,019 0.1 0.0 0 0
list of block
allocation 2,437 0.0 0 0
loader state object
free 860 0.0 0 0
longop free list
parent 8 0.0 0 5 0.0
messages 98,114 0.0 0.1 0 0
mostly latch-free
SCN 14,139 0.6 0.0 0 0
multiblock read
objects 124,060 0.0 0.0 0 0
ncodef allocation
latch 10 0.0 0 0
post/wait
queue 20,862 0.0 0 14,623 0.1
process
allocation 145 0.0 0 145 0.0
process group
creation 282 0.0 0 0
redo
allocation 369,800 0.4 0.0 0 0
redo copy
0 0 342,176 0.1
redo
writing 44,061 0.0 0 0
resmgr group change latc
300,140 0.1 0.0 0 0
Latch Activity for DB:
123456 Instance: 123456 Snaps: 7103 -7113
->"Get Requests", "Pct Get
Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get
requests
->"NoWait Requests", "Pct
NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both
should be very close to 0.0
Pct Avg Wait
Pct
Get Get Slps Time NoWait
NoWait
Latch
Requests Miss /Miss (s) Requests Miss
------------------------
-------------- ------ ------ ------ ------------ ------
resmgr:actses active lis
288 0.0 0 0
resmgr:actses change gro
142 0.0 0 0
resmgr:actses change sta
3,228 0.0 0 0
resmgr:plan CPU
method 3,333 0.0 0 0
resmgr:resource group
CP 26,148 1.7 0.0 0 0
resmgr:schema config
300,011 0.0 0 201 0.0
resumable state
object 2 0.0 0 0
row cache enqueue
latch 1,864,548 1.6 0.0 0 0
row cache
objects 1,904,225 2.3 0.0 1 10,503 1.3
sequence
cache 75,913 0.2 0.0 0 0
session
allocation 530,678 0.1 0.1 0 0
session idle
bit 2,728,123 0.0 0.0 0 0
session switching
40 0.0 0 0
session
timer 201 0.0 0 0
shared
pool 3,514,793 2.7 0.0 8 0
sim partition
latch 0 0 184 0.0
simulator hash
latch 1,410,542 0.0 0.0 0 0
simulator lru
latch 61,529 0.0 0.0 0 6,537 1.4
sort extent
pool 561 0.0 0 0
spilled msgs queues
list 19 0.0 0 0
temp lob duration
state 2 0.0 0 0
transaction
allocation 263,070 0.0 0 0
transaction branch alloc
1,529 0.0 0 0
undo global
data 80,874 0.0 0.0 0 3 0.0
user
lock 25,240 0.8 0.1 0 0
-------------------------------------------------------------
Latch Sleep breakdown for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
-> ordered by misses desc
Get Spin &
Latch Name
Requests Misses Sleeps Sleeps 1->4
--------------------------
-------------- ----------- ----------- ------------
library
cache 6,864,052 194,937 8,417 186804/7858/
266/9/0
cache buffers
chains 39,560,533 178,124 421 0/0/0/0/0
shared
pool 3,514,793 96,558 4,506 92155/4304/9
5/4/0
row cache
objects 1,904,225 43,735 113 43624/109/2/
0/0
row cache enqueue
latch 1,864,548 29,241 21 29220/21/0/0
/0
library cache
pin 4,278,801 8,811 32 8779/32/0/0/
0
enqueues 829,863 5,665 12
5653/12/0/0/
0
enqueue hash
chains 788,011 3,059 3 3056/3/0/0/0
library cache pin allocati
1,649,019 1,756 26 1730/26/0/0/
0
redo
allocation 369,800 1,498 2 1496/2/0/0/0
child cursor hash
table 238,715 1,404 34 1370/34/0/0/
0
library cache load
lock 97,089 1,141 5 1136/5/0/0/0
session
allocation 530,678 559 62 498/60/1/0/0
dml lock
allocation 122,873 489 5 484/5/0/0/0
session idle
bit 2,728,123 416 6 0/0/0/0/0
resmgr group change
latch 300,140 383 5 378/5/0/0/0
user
lock 25,240 205 20 185/20/0/0/0
sequence
cache 75,913 172 1 171/1/0/0/0
cache buffers lru
chain 44,176 61 1 60/1/0/0/0
messages 98,114 34 2 32/2/0/0/0
-------------------------------------------------------------
Latch Miss Sources for DB:
123456 Instance: 123456 Snaps: 7103 -7113
-> only latches with sleeps
are shown
-> ordered by name, sleeps
desc
NoWait Waiter
Latch Name
Where Misses Sleeps Sleeps
------------------------
-------------------------------- ---------- ---------- --------
cache buffers chains
kcbgtcr: kslbegin excl 0 294 277
cache buffers chains
kcbrls: kslbegin 0 54 76
cache buffers chains
kcbgtcr: fast path 0 46 41
cache buffers chains
kcbget: pin buffer 0 11 8
cache buffers chains
kcbget: exchange rls 0 8 0
cache buffers chains
kcbchg: kslbegin: bufs not pinne 0 4 3
cache buffers chains
kcbgcur: kslbegin 0 2 3
cache buffers lru chain
kcbzgb: multiple sets nowait 285 1 0
child cursor hash table
kksheqd: delete enqueue 0 9 0
child cursor hash table
kkslod: mark kksb state 0 9 1
child cursor hash table
kksfbc: broken child 0 7 2
child cursor hash table
kkshbsf: mark cursor state 0 5 16
child cursor hash table
opiaba: bitset. 0 2 2
child cursor hash table
kkslod: set parent info. 0 1 0
child cursor hash table
kkssbt: allocate enqueue 0 1 0
cost function
kzulrl 0 13 15
cost function
kzulgt: find user res 0 7 5
dml lock allocation
ktaiam 0 5 5
enqueue hash chains
ksqrcl 0 3 0
enqueues
ksqdel 0 6 1
enqueues
ksqgel: create enqueue 0 3 7
enqueues
ksqies 0 3 4
library cache
kgllkdl: child: cleanup 0 1,289 684
library cache
kglupc: child 0 1,159 743
library cache
kglpndl: child: before processin 0 913 959
library cache
kglhdgc: child: 0 857 292
library cache
kglpnc: child 0 773 1,230
library cache
kglobpn: child: 0 737 315
library cache
kgldti: 2child 0 388 347
library cache
kglhdgn: child: 0 310 1,758
library cache
kglpin: child: heap processing 0 310 409
library cache
kglpndl: child: after processing 0 227 24
library cache
kgldte: child 0 0 192 216
library cache
kglpin 0 190 187
library cache kglobld
0 150 399
library cache
kgldtld: 2child 0 125 140
library cache
kglpnp: child 0 108 218
library cache
kglini: child 0 93 87
library cache
kglrtl 0 59 51
library cache
kglget: child: KGLDSBRD 0 8 59
library cache
kglget: child: KGLDSBYD 0 5 26
library cache
kglnti 0 5 5
library cache
kglati 0 4 2
library cache
kglhfr: child 0 2 1
library cache
kglhdgh: child: 0 1 0
library cache
kglic 0 1 0
library cache load lock
kglllal: llatch 0 3 3
library cache load lock
kgllldl: llatch 0 2 1
Latch Miss Sources for DB:
123456 Instance: 123456 Snaps: 7103 -7113
-> only latches with sleeps
are shown
-> ordered by name, sleeps
desc
NoWait
Waiter
Latch Name
Where Misses Sleeps Sleeps
------------------------
-------------------------------- ---------- ---------- --------
library cache pin
kglpndl 0 13 7
library cache pin
kglupc 0 8 4
library cache pin
kglpnal: child: alloc space 0 7 10
library cache pin
kglpnc: child 0 2 7
library cache pin
kglpnp: child 0 2 4
library cache pin alloca
kgllkdl 0 15 7
library cache pin alloca
kglpnal 0 11 19
messages ksaamb:
after wakeup 0 1 2
messages
ksarcv 0 1 1
redo allocation
kcrfwr 0 2 2
resmgr group change latc
kskincrstat1 0 5 4
row cache enqueue latch
kqreqd 0 11 1
row cache enqueue latch
kqreqa 0 10 20
row cache objects
kqrpfl: not dirty 0 77 5
row cache objects
kqrpre: find obj 0 31 98
row cache objects
kqrget 0 3 2
sequence cache
kdnssd 0 1 0
session allocation
ksuxds: not user session 0 29 31
session allocation
ksucri 0 18 26
session allocation
ksufap: active sessions 0 13 4
session allocation
ksuprc 0 1 1
session allocation
ksuxds: KSUSFCLC not set 0 1 0
session idle bit
ksupuc: set busy 0 6 2
shared pool
kghalo 0 1,184 2,034
shared pool
kghupr1 0 1,178 1,563
shared pool
kghalp 0 693 603
shared pool
kghfen: not perm alloc class 0 549 89
shared pool
kghfrunp: alloc: wait 0 501 21
shared pool
kghfre 0 338 103
shared pool
kghfrunp: clatch: nowait 0 269 0
shared pool
kghfrunp: clatch: wait 0 244 267
shared pool
kghfru 0 63 93
-------------------------------------------------------------
Dictionary Cache Stats for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
->"Pct Misses" should be
very low (< 2% in most cases)
->"Cache Usage" is the
number of cache entries being used
->"Pct SGA" is the
ratio of usage to allocated size for that cache
Get Pct Scan Pct Mod
Final
Cache Requests Miss Reqs Miss Reqs
Usage
-------------------------
------------ ------ ------- ----- -------- ----------
dc_database_links
33 3.0 0 0 4
dc_global_oids
31 0.0 0 0 11
dc_histogram_defs
191,735 0.1 0 0 4,016
dc_object_ids
405,222 0.0 0 0 815
dc_objects
96,664 1.9 0 0 6,268
dc_profiles
142 0.0 0 0 3
dc_rollback_segments
1,014 0.0 0 0 314
dc_segments
110,757 0.1 0 0 779
dc_sequences 1,246 0.2 0 1,246
20
dc_tablespaces
4,091 0.0 0 0 47
dc_user_grants
1,807 0.8 0 0 108
dc_usernames
40,710 19.9 0 0 31
dc_users
118,065 0.0 0 5 303
-------------------------------------------------------------
Library Cache Activity for
DB: 123456 Instance: 123456 Snaps: 7103 -7113
->"Pct Misses" should be
very low
Get
Pct Pin Pct Invali-
Namespace
Requests Miss Requests Miss Reloads dations
---------------
------------ ------ -------------- ------ ---------- --------
BODY
12,345 5.4 14,499 21.8 1,620 0
CLUSTER
4,111 0.0 5,299 0.0 0 0
INDEX
76 25.0 76 25.0 0 0
PIPE
63 0.0 64 0.0 0 0
SQL AREA
279,180 3.4 1,735,722 1.7 16,790 0
TABLE/PROCEDURE
361,177 2.7 471,521 9.4 16,278 0
TRIGGER
18,613 0.5 18,683 3.6 536 0
-------------------------------------------------------------
Shared Pool Advisory for
DB: 123456 Instance: 123456 End Snap: 7113
-> Note there is often a
1:Many correlation between a single logical object
in the Library Cache,
and the physical number of memory objects associated
with it. Therefore
comparing the number of Lib Cache objects (e.g. in
v$librarycache), with
the number of Lib Cache Memory Objects is invalid
Estd
Shared Pool SP
Estd Estd Estd Lib LC Time
Size for Size Lib
Cache Lib Cache Cache Time Saved Estd Lib Cache
Estim (M) Factr Size
(M) Mem Obj Saved (s) Factr Mem Obj Hits
----------- -----
---------- ------------ ------------ ------- ---------------
224 .5
202 30,245 33,926,805 1.0 430,628,957
272 .7
250 39,855 33,926,835 1.0 430,650,063
320 .8
298 47,426 33,926,852 1.0 430,663,948
368 .9
346 54,300 33,927,353 1.0 430,675,723
416 1.0
394 62,074 33,927,364 1.0 430,685,572
464 1.1
442 68,925 33,927,375 1.0 430,693,923
512 1.2
490 75,972 33,927,385 1.0 430,701,060
560 1.3
538 82,565 33,927,392 1.0 430,707,310
608 1.5
586 88,598 33,927,399 1.0 430,714,095
656 1.6
634 94,117 33,927,403 1.0 430,718,870
704 1.7
682 99,562 33,927,407 1.0 430,723,107
752 1.8
729 104,780 33,927,410 1.0 430,727,266
800 1.9
777 109,914 33,927,413 1.0 430,730,657
848 2.0
808 112,822 33,927,417 1.0 430,733,668
-------------------------------------------------------------
SGA Memory Summary for DB:
123456 Instance: 123456 Snaps: 7103 -7113
SGA
regions Size in Bytes
------------------------------ ----------------
Database Buffers
12,062,818,304
Fixed
Size 764,208
Redo
Buffers 1,585,152
Variable
Size 3,154,116,608
----------------
sum 15,219,284,272
-------------------------------------------------------------
SGA breakdown difference
for DB: 123456 Instance: 123456 Snaps: 7103 -7113
Pool
Name Begin value End value % Diff
------
------------------------------ ---------------- ---------------- ----------
java free
memory 79,433,728 79,433,728 0.00
java memory in
use 4,452,352 4,452,352 0.00
large PX msg
pool 983,040 983,040 0.00
large free
memory 49,348,608 49,348,608 0.00
shared Checkpoint
queue 10,246,400 10,246,400 0.00
shared DML
lock 7,260,072 7,260,072 0.00
shared
FileIdentificatonBlock 899,080 899,080 0.00
shared FileOpenBlock
16,270,720 16,270,720 0.00
shared KGK
heap 26,200 26,200 0.00
shared KGLS
heap 3,868,096 4,543,480 17.46
shared KGSK
scheduler 623,000 623,000 0.00
shared KGSKI
schedule 43,512 43,512 0.00
shared KQR L
PO 10,249,728 8,411,920 -17.93
shared KQR M
PO 3,080,712 3,151,432 2.30
shared KQR M
SO 62,672 62,672 0.00
shared KQR S
SO 37,288 37,288 0.00
shared KQR X
PO 561,696 564,272 0.46
shared KSXR receive
buffers 1,034,000 1,034,000 0.00
shared MTTR
advisory 4,517,632 4,517,632 0.00
shared PL/SQL
DIANA 2,770,864 3,266,672 17.89
shared PL/SQL MPCODE
3,624,272 4,327,952 19.42
shared PLS non-lib
hp 2,944 2,944 0.00
shared PX subheap
73,496 73,496 0.00
shared Temporary Tables
State Ob 1,992,664 1,992,664 0.00
shared UNDO INFO SEGMENTED
ARRAY 1,667,000 1,667,000 0.00
shared VIRTUAL
CIRCUITS 17,275,680 17,275,680 0.00
shared XDB Schema Cac
7,318,136 7,318,136 0.00
shared
branch 3,031,632 3,031,632 0.00
shared
constraints 2,116,280 2,116,280 0.00
shared
db_block_hash_buckets 50,520,304 50,520,304 0.00
shared db_handles
928,000 928,000 0.00
shared dictionary
cache 3,229,952 3,229,952 0.00
shared dummy
690,024 690,024 0.00
shared
enqueue 12,075,416 12,075,416 0.00
shared enqueue
resources 4,972,088 4,972,088 0.00
shared enqueue_hash
817,680 817,680 0.00
shared
errors 135,120 135,120 0.00
shared event statistics per
sess 95,472,000 95,472,000 0.00
shared fixed allocation
callback 960 960 0.00
shared free
memory 106,638,904 73,876,864 -30.72
shared joxlod: in ehe
272,384 272,384 0.00
shared joxs heap
init 480 480 0.00
shared ktlbk state
objects 5,011,600 5,011,600 0.00
shared library
cache 148,295,232 156,592,120 5.59
shared
miscellaneous 61,800,512 62,022,120 0.36
shared
parameters 53,816 99,664 85.19
shared qmps
connections 3,604,000 3,604,000 0.00
shared replication session
stats 2,584,000 2,584,000 0.00
shared
sessions 22,984,000 22,984,000 0.00
SGA breakdown difference
for DB: 123456 Instance: 123456 Snaps: 7103 -7113
Pool
Name Begin value End value % Diff
------
------------------------------ ---------------- ---------------- ----------
shared sim memory hea
11,957,424 11,957,424 0.00
shared sql
area 91,932,392 116,006,416 26.19
shared subheap
102,312 102,312 0.00
shared table definiti
21,904 26,040 18.88
shared
transaction 15,358,928 15,358,928 0.00
shared trigger
defini 78,120 84,680 8.40
shared trigger
inform 3,600 4,344 20.67
shared trigger
source 88 1,208 1,272.73
shared type object
de 3,240 3,240 0.00
buffer_cache 12,062,818,304 12,062,818,304 0.00
fixed_sga 764,208 764,208 0.00
log_buffer 1,573,888 1,573,888 0.00
-------------------------------------------------------------
init.ora Parameters for DB:
123456 Instance: 123456 Snaps: 7103 -7113
End value
Parameter
Name Begin value (if different)
----------------------------- ---------------------------------
--------------
aq_tm_processes 1
audit_file_dest xxx
audit_sys_operations TRUE
audit_trail TRUE
background_dump_dest xxx
blank_trimming TRUE
compatible 9.2.0.0.0
control_file_record_keep_time 280
control_files xxx
core_dump_dest xxx
db_block_size
8192
db_cache_size 12062818304
db_domain world
db_file_multiblock_read_count 32
db_files 800
db_name 123456
db_writer_processes 4
disk_asynch_io
TRUE
dispatchers (PROTOCOL=TCP) (SERVICE=xxx)
fast_start_mttr_target 300
fast_start_parallel_rollback FALSE
hash_join_enabled FALSE
ifile xxx
instance_name 123456
java_pool_size 83886080
job_queue_processes 10
large_pool_size 50331648
log_archive_dest_1 LOCATION=/xxx
log_archive_dest_2 LOCATION=/xxx
log_archive_dest_3 LOCATION=/xxx
log_archive_dest_state_1 ENABLE
log_archive_dest_state_2 ENABLE
log_archive_dest_state_3 DEFER
log_archive_format arch_%t_%s.arc
log_archive_start TRUE
log_archive_trace 0
max_enabled_roles 80
nls_date_format DD-MON-YYYY
open_cursors 500
open_links 120
optimizer_features_enable 9.2.0
os_authent_prefix
parallel_adaptive_multi_user TRUE
parallel_automatic_tuning TRUE
parallel_max_servers 16
parallel_min_percent 0
parallel_min_servers 4
parallel_threads_per_cpu 2
pga_aggregate_target 2621440000
processes 800
init.ora Parameters for DB:
123456 Instance: 123456 Snaps: 7103 -7113
End value
Parameter
Name Begin value (if different)
----------------------------- ---------------------------------
--------------
query_rewrite_enabled TRUE
remote_dependencies_mode TIMESTAMP
remote_login_passwordfile EXCLUSIVE
resource_manager_plan xxx
session_max_open_files 100
sessions 8500
sga_max_size 15219284272
shared_pool_size 419430400
sort_area_size 2621440
star_transformation_enabled TRUE
timed_statistics
TRUE
transactions_per_rollback_seg 4
undo_management
AUTO
undo_retention 10800
undo_tablespace SYS_UND_UNDO_TS01
use_indirect_data_buffers
FALSE
user_dump_dest xxx
utl_file_dir
xxx
-------------------------------------------------------------
End of Report
 |
If you like Oracle tuning, you
might enjoy my book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get instant
access to the code depot of Oracle tuning scripts. |
|
