1460440.1 PXHCDR 11.4.5.8 Report: pxhcdr_orcl_rac1_11.2.0.4.0_20180125_164346_main.html

License   : N
RDBMS     : 11.2.0.4.0
Platform  : LINUX
Instance  : 1
CPU Count : 4
Block Size: 8192
OFE       : 11.2.0.4
DYN_SAMP  : 2
EBS       : ""
SIEBEL    : ""
PSFT      : ""
Date      : 2018-01-25/16:43:46

Observations

Observations below are the outcome of several heath-checks on your system with regard to Parallel Execution (PX).
Review them carefully and take action when appropriate.
Note: Ignore possible errors about dba_rsrc_io_calibrate and gv$io_calibration_status on 10g:
Type Name Observation Details
System Parameter parallel_max_servers A value of 120 for this parameter on instance 1 seems too high. Consider reducing this value to at most cpu_count * 4 * parallel_threads_per_cpu.
Current value for cpu_count is 4 and for parallel_threads_per_cpu is 2.
System Parameter parallel_adaptive_multi_user Parallel adaptive muti-user is enabled on instance 1. Be aware that degree of parallelism (DOP) may be reduced at time of execution.
IO Calibration Results dba_rsrc_io_calibrate There seems to be no I/O Calibration results. Consider using DBMS_RESOURCE_MANAGER.CALIBRATE_IO.
IO Calibration Status gv$io_calibration_status NOT AVAILABLE for instance 1. Time of last calibration: .
Type Name Observation Details

Parallel Degree Limit Method

Collected from GV$PARALLEL_DEGREE_LIMIT_MTH.
# Inst Name
1 1 PARALLEL_DEGREE_LIMIT_ABSOLUTE
# Inst Name

PX Buffer Advice

Collected from GV$PX_BUFFER_ADVICE.
# Inst Statistic Value
1 1 Buffers Current Free 500
2 1 Buffers Current Total 500
3 1 Buffers HWM 0
4 1 Estimated Buffers HWM 0
5 1 Estimated Buffers Max 11160
6 1 Servers Highwater 0
7 1 Servers Max 120
# Inst Statistic Value

PQ System Statistics

Collected from GV$PQ_SYSSTAT.
# Inst Statistic Value
1 1 DDL Initiated 0
2 1 DDL Initiated (IPQ) 0
3 1 DFO Trees 0
4 1 DML Initiated 0
5 1 DML Initiated (IPQ) 0
6 1 Distr Msgs Recv'd 0
7 1 Distr Msgs Sent 0
8 1 Local Msgs Recv'd 0
9 1 Local Msgs Sent 0
10 1 Queries Initiated 0
11 1 Queries Initiated (IPQ) 0
12 1 Queries Queued 0
13 1 Server Sessions 0
14 1 Servers Busy 0
15 1 Servers Cleaned Up 0
16 1 Servers Highwater 0
17 1 Servers Idle 0
18 1 Servers Shutdown 0
19 1 Servers Started 0
20 1 Sessions Active 0
# Inst Statistic Value

PX System Statistics

Collected from GV$PX_PROCESS_SYSSTAT.
# Inst Statistic Value
1 1 Buffers Allocated 0
2 1 Buffers Current 0
3 1 Buffers Freed 0
4 1 Buffers HWM 0
5 1 Memory Chunks Allocated 4
6 1 Memory Chunks Current 4
7 1 Memory Chunks Freed 0
8 1 Memory Chunks HWM 4
9 1 Server Sessions 0
10 1 Servers Available 0
11 1 Servers Cleaned Up 0
12 1 Servers Highwater 0
13 1 Servers In Use 0
14 1 Servers Shutdown 0
15 1 Servers Started 0
# Inst Statistic Value

System Statistics

Collected from GV$SYSSTAT.
# Inst Statistic Value
1 1 ADG parselock X get attempts 0
2 1 ADG parselock X get successes 0
3 1 Batched IO (bound) vector count 3
4 1 Batched IO (full) vector count 0
5 1 Batched IO (space) vector count 0
6 1 Batched IO block miss count 41
7 1 Batched IO buffer defrag count 1
8 1 Batched IO double miss count 3
9 1 Batched IO same unit count 18
10 1 Batched IO single block count 3
11 1 Batched IO slow jump count 0
12 1 Batched IO vector block count 20
13 1 Batched IO vector read count 3
14 1 Batched IO zero block count 0
15 1 Block Cleanout Optim referenced 0
16 1 CCursor + sql area evicted 45
17 1 CPU used by this session 4813
18 1 CPU used when call started 1172
19 1 CR blocks created 0
20 1 Cached Commit SCN referenced 0
21 1 Clusterwide global transactions 0
22 1 Clusterwide global transactions spanning RAC nodes 0
23 1 Commit SCN cached 2
24 1 DB time 5699
25 1 DBWR checkpoint buffers written 0
26 1 DBWR checkpoints 12
27 1 DBWR fusion writes 0
28 1 DBWR lru scans 0
29 1 DBWR object drop buffers written 3
30 1 DBWR parallel query checkpoint buffers written 0
31 1 DBWR revisited being-written buffer 0
32 1 DBWR tablespace checkpoint buffers written 0
33 1 DBWR thread checkpoint buffers written 0
34 1 DBWR transaction table writes 0
35 1 DBWR undo block writes 0
36 1 DDL statements parallelized 0
37 1 DFO trees parallelized 0
38 1 DML statements parallelized 0
39 1 DX/BB enqueue lock background get time 0
40 1 DX/BB enqueue lock background gets 0
41 1 DX/BB enqueue lock foreground requests 0
42 1 DX/BB enqueue lock foreground wait time 0
43 1 EHCC Analyze CUs Decompressed 0
44 1 EHCC Analyzer Calls 0
45 1 EHCC Archive CUs Compressed 0
46 1 EHCC Archive CUs Decompressed 0
47 1 EHCC Attempted Block Compressions 0
48 1 EHCC Block Compressions 0
49 1 EHCC CU Row Pieces Compressed 0
50 1 EHCC CUs Compressed 0
51 1 EHCC CUs Decompressed 0
52 1 EHCC Check CUs Decompressed 0
53 1 EHCC Columns Decompressed 0
54 1 EHCC Compressed Length Compressed 0
55 1 EHCC Compressed Length Decompressed 0
56 1 EHCC Conventional DMLs 0
57 1 EHCC DML CUs Decompressed 0
58 1 EHCC Decompressed Length Compressed 0
59 1 EHCC Decompressed Length Decompressed 0
60 1 EHCC Dump CUs Decompressed 0
61 1 EHCC Normal Scan CUs Decompressed 0
62 1 EHCC Pieces Buffered for Decompression 0
63 1 EHCC Query High CUs Compressed 0
64 1 EHCC Query High CUs Decompressed 0
65 1 EHCC Query Low CUs Compressed 0
66 1 EHCC Query Low CUs Decompressed 0
67 1 EHCC Rowid CUs Decompressed 0
68 1 EHCC Rows Compressed 0
69 1 EHCC Rows Not Compressed 0
70 1 EHCC Total Columns for Decompression 0
71 1 EHCC Total Pieces for Decompression 0
72 1 EHCC Total Rows for Decompression 0
73 1 EHCC Turbo Scan CUs Decompressed 0
74 1 EHCC Used on Pillar Tablespace 0
75 1 EHCC Used on ZFS Tablespace 0
76 1 Effective IO time 0
77 1 Forwarded 2PC commands across RAC nodes 0
78 1 GTX processes spawned by autotune 0
79 1 GTX processes stopped by autotune 0
80 1 HSC Compressed Segment Block Changes 0
81 1 HSC Heap Segment Block Changes 0
82 1 HSC IDL Compressed Blocks 0
83 1 HSC OLTP Compressed Blocks 0
84 1 HSC OLTP Compression skipped rows 0
85 1 HSC OLTP Drop Column 0
86 1 HSC OLTP Non Compressible Blocks 0
87 1 HSC OLTP Space Saving 0
88 1 HSC OLTP compression block checked 0
89 1 HSC OLTP inline compression 0
90 1 HSC OLTP negative compression 0
91 1 HSC OLTP positive compression 0
92 1 HSC OLTP recursive compression 0
93 1 Heap Segment Array Inserts 0
94 1 Heap Segment Array Updates 0
95 1 IMU CR rollbacks 0
96 1 IMU Flushes 0
97 1 IMU Redo allocation size 0
98 1 IMU bind flushes 0
99 1 IMU commits 0
100 1 IMU contention 0
101 1 IMU ktichg flush 0
102 1 IMU mbu flush 0
103 1 IMU pool not allocated 0
104 1 IMU recursive-transaction flush 0
105 1 IMU undo allocation size 0
106 1 IMU undo retention flush 0
107 1 IMU- failed to get a private strand 0
108 1 IPC CPU used by this session 0
109 1 LOB table id lookup cache misses 0
110 1 Misses for writing mapping 0
111 1 No. of Decrypt ops 0
112 1 No. of Encrypt ops 0
113 1 No. of Namespaces Created 0
114 1 No. of Principal Cache Misses 0
115 1 No. of Principal Invalidations 0
116 1 No. of Roles Enabled or Disabled 0
117 1 No. of User Callbacks Executed 0
118 1 No. of XS Sessions Attached 0
119 1 No. of XS Sessions Created 0
120 1 Number of FORMAT_PRESERVING redactions 0
121 1 Number of FULL redactions 0
122 1 Number of NONE redactions 0
123 1 Number of PARTIAL redactions 0
124 1 Number of RANDOM redactions 0
125 1 Number of REGEXP redactions 0
126 1 Number of read IOs issued 0
127 1 OS Block input operations 872
128 1 OS Block output operations 8
129 1 OS CPU Qt wait time 0
130 1 OS Integral shared text size 0
131 1 OS Integral unshared data size 0
132 1 OS Integral unshared stack size 0
133 1 OS Involuntary context switches 9
134 1 OS Maximum resident set size 29500
135 1 OS Page faults 6
136 1 OS Page reclaims 7565
137 1 OS Signals received 0
138 1 OS Socket messages received 0
139 1 OS Socket messages sent 0
140 1 OS Swaps 0
141 1 OS System time used 2
142 1 OS User time used 1
143 1 OS Voluntary context switches 33
144 1 OTC commit optimization attempts 0
145 1 OTC commit optimization failure - setup 0
146 1 OTC commit optimization hits 0
147 1 PX local messages recv'd 0
148 1 PX local messages sent 0
149 1 PX remote messages recv'd 0
150 1 PX remote messages sent 0
151 1 Parallel operations downgraded 1 to 25 pct 0
152 1 Parallel operations downgraded 25 to 50 pct 0
153 1 Parallel operations downgraded 50 to 75 pct 0
154 1 Parallel operations downgraded 75 to 99 pct 0
155 1 Parallel operations downgraded to serial 0
156 1 Parallel operations not downgraded 0
157 1 Requests to/from client 2647
158 1 RowCR - resume 0
159 1 RowCR - row contention 0
160 1 RowCR attempts 0
161 1 RowCR hits 0
162 1 SMON posted for dropping temp segment 0
163 1 SMON posted for instance recovery 1
164 1 SMON posted for txn recovery for other instances 0
165 1 SMON posted for undo segment recovery 0
166 1 SMON posted for undo segment shrink 0
167 1 SQL*Net roundtrips to/from client 2647
168 1 SQL*Net roundtrips to/from dblink 0
169 1 TBS Extension: bytes extended 0
170 1 TBS Extension: files extended 0
171 1 TBS Extension: tasks created 0
172 1 TBS Extension: tasks executed 0
173 1 Workload Capture: dbtime 0
174 1 Workload Capture: errors 0
175 1 Workload Capture: size (in bytes) of recording 0
176 1 Workload Capture: unreplayable user calls 0
177 1 Workload Capture: unsupported user calls 0
178 1 Workload Capture: user calls 0
179 1 Workload Capture: user calls flushed 0
180 1 Workload Capture: user logins 0
181 1 Workload Capture: user txns 0
182 1 Workload Replay: dbtime 0
183 1 Workload Replay: deadlocks resolved 0
184 1 Workload Replay: network time 0
185 1 Workload Replay: think time 0
186 1 Workload Replay: time gain 0
187 1 Workload Replay: time loss 0
188 1 Workload Replay: user calls 0
189 1 active txn count during cleanout 0
190 1 application wait time 9
191 1 auto extends on undo tablespace 0
192 1 background checkpoints completed 0
193 1 background checkpoints started 0
194 1 background timeouts 25613
195 1 blocks decrypted 0
196 1 blocks encrypted 0
197 1 branch node splits 0
198 1 buffer is not pinned count 128611
199 1 buffer is pinned count 106325
200 1 bytes received via SQL*Net from client 360068
201 1 bytes received via SQL*Net from dblink 0
202 1 bytes sent via SQL*Net to client 1321837
203 1 bytes sent via SQL*Net to dblink 0
204 1 bytes via SQL*Net vector from client 0
205 1 bytes via SQL*Net vector from dblink 0
206 1 bytes via SQL*Net vector to client 0
207 1 bytes via SQL*Net vector to dblink 0
208 1 calls to get snapshot scn: kcmgss 6035
209 1 calls to kcmgas 0
210 1 calls to kcmgcs 8352
211 1 calls to kcmgrs 0
212 1 cell CUs processed for compressed 0
213 1 cell CUs processed for uncompressed 0
214 1 cell CUs sent compressed 0
215 1 cell CUs sent head piece 0
216 1 cell CUs sent uncompressed 0
217 1 cell IO uncompressed bytes 0
218 1 cell blocks helped by commit cache 0
219 1 cell blocks helped by minscn optimization 0
220 1 cell blocks processed by cache layer 0
221 1 cell blocks processed by data layer 0
222 1 cell blocks processed by index layer 0
223 1 cell blocks processed by txn layer 0
224 1 cell commit cache queries 0
225 1 cell flash cache read hits 0
226 1 cell index scans 0
227 1 cell num block IOs due to a file instant restore in progress 0
228 1 cell num bytes in block IO during predicate offload 0
229 1 cell num bytes in passthru during predicate offload 0
230 1 cell num fast response sessions 0
231 1 cell num fast response sessions continuing to smart scan 0
232 1 cell num smart IO sessions in rdbms block IO due to big payload 0
233 1 cell num smart IO sessions in rdbms block IO due to no cell mem 0
234 1 cell num smart IO sessions in rdbms block IO due to open fail 0
235 1 cell num smart IO sessions in rdbms block IO due to user 0
236 1 cell num smart IO sessions using passthru mode due to cellsrv 0
237 1 cell num smart IO sessions using passthru mode due to timezone 0
238 1 cell num smart IO sessions using passthru mode due to user 0
239 1 cell num smart file creation sessions using rdbms block IO mode 0
240 1 cell num smartio automem buffer allocation attempts 0
241 1 cell num smartio automem buffer allocation failures 0
242 1 cell overwrites in flash cache 0
243 1 cell partial writes in flash cache 0
244 1 cell physical IO bytes eligible for predicate offload 0
245 1 cell physical IO bytes saved by storage index 0
246 1 cell physical IO bytes saved during optimized RMAN file restore 0
247 1 cell physical IO bytes saved during optimized file creation 0
248 1 cell physical IO bytes sent directly to DB node to balance CPU 0
249 1 cell physical IO interconnect bytes 405872640
250 1 cell physical IO interconnect bytes returned by smart scan 0
251 1 cell scans 0
252 1 cell simulated physical IO bytes eligible for predicate offload 0
253 1 cell simulated physical IO bytes returned by predicate offload 0
254 1 cell smart IO session cache hard misses 0
255 1 cell smart IO session cache hits 0
256 1 cell smart IO session cache hwm 0
257 1 cell smart IO session cache lookups 0
258 1 cell smart IO session cache soft misses 0
259 1 cell statistics spare1 0
260 1 cell statistics spare2 0
261 1 cell statistics spare3 0
262 1 cell statistics spare4 0
263 1 cell statistics spare5 0
264 1 cell statistics spare6 0
265 1 cell transactions found in commit cache 0
266 1 cell writes to flash cache 0
267 1 chained rows processed by cell 0
268 1 chained rows rejected by cell 0
269 1 chained rows skipped by cell 0
270 1 change write time 0
271 1 checkpoint clones created for ADG recovery 0
272 1 cleanout - number of ktugct calls 5
273 1 cleanouts and rollbacks - consistent read gets 0
274 1 cleanouts only - consistent read gets 5
275 1 cluster key scan block gets 98178
276 1 cluster key scans 95184
277 1 cluster wait time 2
278 1 cold recycle reads 0
279 1 commit batch performed 0
280 1 commit batch requested 0
281 1 commit batch/immediate performed 0
282 1 commit batch/immediate requested 0
283 1 commit cleanout failures: block lost 0
284 1 commit cleanout failures: buffer being written 0
285 1 commit cleanout failures: callback failure 0
286 1 commit cleanout failures: cannot pin 0
287 1 commit cleanout failures: hot backup in progress 0
288 1 commit cleanout failures: write disabled 0
289 1 commit cleanouts 0
290 1 commit cleanouts successfully completed 0
291 1 commit immediate performed 0
292 1 commit immediate requested 0
293 1 commit nowait performed 0
294 1 commit nowait requested 0
295 1 commit txn count during cleanout 6
296 1 commit wait performed 0
297 1 commit wait requested 0
298 1 commit wait/nowait performed 0
299 1 commit wait/nowait requested 0
300 1 concurrency wait time 346
301 1 consistent changes 34
302 1 consistent gets 234547
303 1 consistent gets - examination 16880
304 1 consistent gets direct 0
305 1 consistent gets from cache 234547
306 1 consistent gets from cache (fastpath) 0
307 1 current blocks converted for CR 0
308 1 cursor authentications 146
309 1 data blocks consistent reads - undo records applied 0
310 1 db block changes 21
311 1 db block gets 36
312 1 db block gets direct 7
313 1 db block gets from cache 29
314 1 db block gets from cache (fastpath) 0
315 1 db corrupt blocks detected 0
316 1 db corrupt blocks recovered 0
317 1 deferred (CURRENT) block cleanout applications 0
318 1 deferred CUR cleanouts (index blocks) 0
319 1 dirty buffers inspected 0
320 1 doubling up with imu segment 0
321 1 drop segment calls in space pressure 0
322 1 enqueue conversions 1375
323 1 enqueue deadlocks 0
324 1 enqueue releases 14661
325 1 enqueue requests 14691
326 1 enqueue timeouts 0
327 1 enqueue waits 5
328 1 exchange deadlocks 0
329 1 execute count 5934
330 1 failed probes on index block reclamation 0
331 1 file io service time 12
332 1 file io wait time 15157144
333 1 flash cache eviction: aged out 0
334 1 flash cache eviction: buffer pinned 0
335 1 flash cache eviction: invalidated 0
336 1 flash cache insert skip: DBWR overloaded 0
337 1 flash cache insert skip: corrupt 0
338 1 flash cache insert skip: exists 0
339 1 flash cache insert skip: modification 0
340 1 flash cache insert skip: not current 0
341 1 flash cache insert skip: not useful 0
342 1 flash cache inserts 0
343 1 flashback cache read optimizations for block new 0
344 1 flashback direct read optimizations for block new 0
345 1 flashback log write bytes 0
346 1 flashback log writes 0
347 1 frame signature mismatch 0
348 1 free buffer inspected 0
349 1 free buffer requested 5010
350 1 gc CPU used by this session 0
351 1 gc blocks compressed 0
352 1 gc blocks corrupt 0
353 1 gc blocks lost 0
354 1 gc claim blocks lost 0
355 1 gc cr block build time 0
356 1 gc cr block flush time 0
357 1 gc cr block receive time 0
358 1 gc cr block send time 0
359 1 gc cr blocks received 0
360 1 gc cr blocks served 0
361 1 gc current block flush time 0
362 1 gc current block pin time 0
363 1 gc current block receive time 0
364 1 gc current block send time 0
365 1 gc current blocks received 0
366 1 gc current blocks served 0
367 1 gc force cr disk read 0
368 1 gc kbytes saved 0
369 1 gc kbytes sent 0
370 1 gc local grants 4992
371 1 gc read wait failures 0
372 1 gc read wait time 0
373 1 gc read wait timeouts 0
374 1 gc read waits 0
375 1 gc reader bypass grants 0
376 1 gc remote grants 0
377 1 gcs messages sent 0
378 1 ges messages sent 0
379 1 global enqueue CPU used by this session 2
380 1 global enqueue get time 67
381 1 global enqueue gets async 1854
382 1 global enqueue gets sync 14865
383 1 global enqueue releases 12809
384 1 global undo segment hints helped 0
385 1 global undo segment hints were stale 0
386 1 heap block compress 0
387 1 hot buffers moved to head of LRU 0
388 1 immediate (CR) block cleanout applications 5
389 1 immediate (CURRENT) block cleanout applications 0
390 1 immediate CR cleanouts (index blocks) 0
391 1 in call idle wait time 15038049
392 1 index crx upgrade (found) 0
393 1 index crx upgrade (positioned) 0
394 1 index crx upgrade (prefetch) 0
395 1 index fast full scans (direct read) 0
396 1 index fast full scans (full) 7
397 1 index fast full scans (rowid ranges) 0
398 1 index fetch by key 63049
399 1 index reclamation/extension switch 0
400 1 index scans kdiixs1 42559
401 1 java call heap collected bytes 0
402 1 java call heap collected count 0
403 1 java call heap gc count 0
404 1 java call heap live object count 0
405 1 java call heap live object count max 0
406 1 java call heap live size 0
407 1 java call heap live size max 0
408 1 java call heap object count 0
409 1 java call heap object count max 0
410 1 java call heap total size 0
411 1 java call heap total size max 0
412 1 java call heap used size 0
413 1 java call heap used size max 0
414 1 java session heap collected bytes 0
415 1 java session heap collected count 0
416 1 java session heap gc count 0
417 1 java session heap live object count 0
418 1 java session heap live object count max 0
419 1 java session heap live size 0
420 1 java session heap live size max 0
421 1 java session heap object count 0
422 1 java session heap object count max 0
423 1 java session heap used size 0
424 1 java session heap used size max 0
425 1 leaf node 90-10 splits 0
426 1 leaf node splits 0
427 1 lob reads 0
428 1 lob writes 0
429 1 lob writes unaligned 0
430 1 local undo segment hints helped 0
431 1 local undo segment hints were stale 0
432 1 logical read bytes from cache 1921646592
433 1 logons cumulative 242
434 1 logons current 40
435 1 max cf enq hold time 770
436 1 messages received 2660
437 1 messages sent 2657
438 1 min active SCN optimization applied on CR 0
439 1 native hash arithmetic execute 0
440 1 native hash arithmetic fail 0
441 1 no buffer to keep pinned count 1
442 1 no work - consistent read gets 214365
443 1 non-idle wait count 166241
444 1 non-idle wait time 414323
445 1 number of map misses 0
446 1 number of map operations 0
447 1 opened cursors cumulative 5201
448 1 opened cursors current 12
449 1 parse count (describe) 0
450 1 parse count (failures) 4
451 1 parse count (hard) 819
452 1 parse count (total) 2974
453 1 parse time cpu 537
454 1 parse time elapsed 1609
455 1 physical read IO requests 1961
456 1 physical read bytes 41189376
457 1 physical read flash cache hits 0
458 1 physical read partial requests 0
459 1 physical read requests optimized 0
460 1 physical read total IO requests 22699
461 1 physical read total bytes 381388800
462 1 physical read total bytes optimized 0
463 1 physical read total multi block requests 49
464 1 physical reads 5028
465 1 physical reads cache 5002
466 1 physical reads cache prefetch 3084
467 1 physical reads direct 26
468 1 physical reads direct (lob) 0
469 1 physical reads direct temporary tablespace 2
470 1 physical reads for flashback new 0
471 1 physical reads prefetch warmup 0
472 1 physical reads retry corrupt 0
473 1 physical write IO requests 16
474 1 physical write bytes 131072
475 1 physical write requests optimized 0
476 1 physical write total IO requests 1548
477 1 physical write total bytes 24483840
478 1 physical write total bytes optimized 0
479 1 physical write total multi block requests 0
480 1 physical writes 16
481 1 physical writes direct 13
482 1 physical writes direct (lob) 0
483 1 physical writes direct temporary tablespace 7
484 1 physical writes from cache 3
485 1 physical writes non checkpoint 16
486 1 pinned buffers inspected 0
487 1 pinned cursors current 7
488 1 prefetch clients - 16k 0
489 1 prefetch clients - 2k 0
490 1 prefetch clients - 32k 0
491 1 prefetch clients - 4k 0
492 1 prefetch clients - 8k 0
493 1 prefetch clients - default 0
494 1 prefetch clients - keep 0
495 1 prefetch clients - recycle 0
496 1 prefetch warmup blocks aged out before use 0
497 1 prefetch warmup blocks flushed out before use 0
498 1 prefetched blocks aged out before use 0
499 1 process last non-idle time 0
500 1 queries parallelized 0
501 1 queue flush 0
502 1 queue ocp pages 0
503 1 queue position update 0
504 1 queue qno pages 0
505 1 queue single row 0
506 1 queue splits 0
507 1 queue update without cp update 0
508 1 read-only violation count 0
509 1 recovery array read time 0
510 1 recovery array reads 0
511 1 recovery block gets from cache 0
512 1 recovery blocks read 0
513 1 recovery blocks read for lost write detection 0
514 1 recovery blocks skipped lost write checks 0
515 1 recursive aborts on index block reclamation 0
516 1 recursive calls 42821
517 1 recursive cpu usage 940
518 1 recursive system API invocations 0
519 1 redo KB read 0
520 1 redo KB read (memory) 0
521 1 redo KB read (memory) for transport 0
522 1 redo KB read for transport 0
523 1 redo blocks checksummed by FG (exclusive) 0
524 1 redo blocks checksummed by LGWR 0
525 1 redo blocks read for recovery 0
526 1 redo blocks written 0
527 1 redo buffer allocation retries 0
528 1 redo entries 0
529 1 redo entries for lost write detection 0
530 1 redo k-bytes read for recovery 0
531 1 redo k-bytes read for terminal recovery 0
532 1 redo log space requests 0
533 1 redo log space wait time 0
534 1 redo ordering marks 0
535 1 redo size 0
536 1 redo size for direct writes 0
537 1 redo size for lost write detection 0
538 1 redo subscn max counts 0
539 1 redo synch long waits 0
540 1 redo synch poll writes 0
541 1 redo synch polls 0
542 1 redo synch time 0
543 1 redo synch time (usec) 0
544 1 redo synch time overhead (usec) 0
545 1 redo synch time overhead count (<128 msec) 0
546 1 redo synch time overhead count (<2 msec) 0
547 1 redo synch time overhead count (<32 msec) 0
548 1 redo synch time overhead count (<8 msec) 0
549 1 redo synch time overhead count (>=128 msec) 0
550 1 redo synch writes 0
551 1 redo wastage 0
552 1 redo write broadcast ack count 0
553 1 redo write broadcast ack time 0
554 1 redo write broadcast lgwr post count 0
555 1 redo write info find 0
556 1 redo write info find fail 0
557 1 redo write time 0
558 1 redo writes 0
559 1 remote Oradebug requests 0
560 1 rollback changes - undo records applied 0
561 1 rollbacks only - consistent read gets 0
562 1 root node splits 0
563 1 rows fetched via callback 830
564 1 scheduler wait time 0
565 1 securefile add dedupd lob to set 0
566 1 securefile allocation bytes 0
567 1 securefile allocation chunks 0
568 1 securefile bytes cleartext 0
569 1 securefile bytes deduplicated 0
570 1 securefile bytes encrypted 0
571 1 securefile bytes non-transformed 0
572 1 securefile compressed bytes 0
573 1 securefile create dedup set 0
574 1 securefile dedup callback oper final 0
575 1 securefile dedup fits inline 0
576 1 securefile dedup flush too low 0
577 1 securefile dedup hash collision 0
578 1 securefile dedup prefix hash match 0
579 1 securefile dedup wapp cache miss 0
580 1 securefile destroy dedup set 0
581 1 securefile direct read bytes 0
582 1 securefile direct read ops 0
583 1 securefile direct write bytes 0
584 1 securefile direct write ops 0
585 1 securefile inode ioreap time 0
586 1 securefile inode read time 0
587 1 securefile inode write time 0
588 1 securefile number of flushes 0
589 1 securefile number of non-transformed flushes 0
590 1 securefile reject deduplication 0
591 1 securefile rmv from dedup set 0
592 1 securefile uncompressed bytes 0
593 1 segment cfs allocations 0
594 1 segment chunks allocation from disepnser 0
595 1 segment dispenser allocations 0
596 1 segment dispenser load empty 0
597 1 segment dispenser load tasks 0
598 1 segment prealloc bytes 0
599 1 segment prealloc ops 0
600 1 segment prealloc tasks 0
601 1 segment prealloc time (ms) 0
602 1 segment prealloc ufs2cfs bytes 0
603 1 segment total chunk allocation 0
604 1 serializable aborts 0
605 1 session connect time 0
606 1 session cursor cache count 1227
607 1 session cursor cache hits 3421
608 1 session logical reads 234583
609 1 session logical reads in local numa group 0
610 1 session logical reads in remote numa group 0
611 1 session pga memory 208538352
612 1 session pga memory max 218172144
613 1 session stored procedure space 0
614 1 session uga memory 18810032
615 1 session uga memory max 165312800
616 1 shared hash latch upgrades - no wait 1522
617 1 shared hash latch upgrades - wait 0
618 1 shared io pool buffer get failure 0
619 1 shared io pool buffer get success 0
620 1 sorts (disk) 0
621 1 sorts (memory) 2006
622 1 sorts (rows) 41090
623 1 space was found by tune down 0
624 1 space was not found by tune down 0
625 1 spare statistic 1 0
626 1 spare statistic 10 0
627 1 spare statistic 11 0
628 1 spare statistic 12 0
629 1 spare statistic 2 0
630 1 spare statistic 3 0
631 1 spare statistic 4 0
632 1 spare statistic 5 0
633 1 spare statistic 6 0
634 1 spare statistic 7 0
635 1 spare statistic 8 0
636 1 spare statistic 9 0
637 1 sql area evicted 247
638 1 sql area purged 34
639 1 steps of tune down ret. in space pressure 0
640 1 summed dirty queue length 0
641 1 switch current to new buffer 0
642 1 table fetch by rowid 51845
643 1 table fetch continued row 80
644 1 table scan blocks gotten 46866
645 1 table scan rows gotten 1568430
646 1 table scans (cache partitions) 0
647 1 table scans (direct read) 0
648 1 table scans (long tables) 2
649 1 table scans (rowid ranges) 0
650 1 table scans (short tables) 457
651 1 temp space allocated (bytes) 0
652 1 total cf enq hold time 2910
653 1 total number of cf enq holders 1650
654 1 total number of slots 0
655 1 total number of times SMON posted 6
656 1 total number of undo segments dropped 0
657 1 transaction lock background get time 0
658 1 transaction lock background gets 0
659 1 transaction lock foreground requests 0
660 1 transaction lock foreground wait time 0
661 1 transaction rollbacks 0
662 1 transaction tables consistent read rollbacks 0
663 1 transaction tables consistent reads - undo records applied 0
664 1 tune down retentions in space pressure 0
665 1 undo change vector size 0
666 1 undo segment header was pinned 0
667 1 user I/O wait time 2055
668 1 user calls 3461
669 1 user commits 0
670 1 user logons cumulative 194
671 1 user logouts cumulative 193
672 1 user rollbacks 0
673 1 workarea executions - multipass 0
674 1 workarea executions - onepass 0
675 1 workarea executions - optimal 1496
676 1 workarea memory allocated 0
677 1 write clones created for recovery 0
678 1 write clones created in background 0
679 1 write clones created in foreground 0
# Inst Statistic Value

PQ Slaves

Collected from GV$PQ_SLAVE.
# Inst Slave
Name
Status Sessions Idle
Time
Total
Busy
Time
Total
CPU
Secs
Total
Msgs
Sent
Total
Msgs
Rcvd
Total
# Inst Slave
Name
Status Sessions Idle
Time
Total
Busy
Time
Total
CPU
Secs
Total
Msgs
Sent
Total
Msgs
Rcvd
Total

PX Sessions

Collected from GV$PX_SESSION.
# Inst QC
SID
Server
Name
SID Serial# PID SPID Server
Group
Server
Set
Server# Degree Req
Degree
Wait Event SQL_ID Child# Resource
Consumer
Group
Module Action
# Inst QC
SID
Server
Name
SID Serial# PID SPID Server
Group
Server
Set
Server# Degree Req
Degree
Wait Event SQL_ID Child# Resource
Consumer
Group
Module Action

Services

Collected from GV$SERVICES.
# Inst Name Network Name Creation Date
1 1 SYS$BACKGROUND 2013-08-24/11:37:40
2 1 SYS$USERS 2013-08-24/11:37:40
3 1 orcl orcl 2015-12-01/23:35:30
4 1 orclXDB orclXDB 2015-12-01/23:35:30
# Inst Name Network Name Creation Date

I/O Calibration Results

Collected from DBA_RSRC_IO_CALIBRATE.
Note: Ignore possible errors about dba_rsrc_io_calibrate on 10g:
# Start Time End Time Max IO
per sec
Max MB
per sec
Max MB
per sec
per proc
Latency Physical
Disks
# Start Time End Time Max IO
per sec
Max MB
per sec
Max MB
per sec
per proc
Latency Physical
Disks

Operating System Statistics

Collected from GV$OSSTAT.

# INST_ID STAT_NAME VALUE OSSTAT_ID COMMENTS CUM
1 1 BUSY_TIME 128628 2 Time (centi-secs) that CPUs have been in the busy state YES
2 1 GLOBAL_RECEIVE_SIZE_MAX 4194304 2007 Global receive size max (net.core.rmem_max) NO
3 1 GLOBAL_SEND_SIZE_MAX 1048576 2006 Global send size max (net.core.wmem_max) NO
4 1 IDLE_TIME 1389215 1 Time (centi-secs) that CPUs have been in the idle state YES
5 1 IOWAIT_TIME 24860 5 Time (centi-secs) spent waiting for IO YES
6 1 LOAD 1.0498046875 15 Number of processes running or waiting on the run queue NO
7 1 NICE_TIME 40 6 Time (centi-secs) spend in low-priority user code YES
8 1 NUM_CPUS 4 0 Number of active CPUs NO
9 1 NUM_CPU_CORES 4 16 Number of CPU cores NO
10 1 NUM_CPU_SOCKETS 2 17 Number of physical CPU sockets NO
11 1 PHYSICAL_MEMORY_BYTES 4002799616 1008 Physical memory size in bytes NO
12 1 RSRC_MGR_CPU_WAIT_TIME 0 14 Time (centi-secs) processes spent in the runnable state waiting YES
13 1 SYS_TIME 46453 4 Time (centi-secs) spent in the kernel YES
14 1 TCP_RECEIVE_SIZE_DEFAULT 87380 2004 TCP Receive Buffer Default Size NO
15 1 TCP_RECEIVE_SIZE_MAX 4194304 2005 TCP Receive Buffer Max Size NO
16 1 TCP_RECEIVE_SIZE_MIN 4096 2003 TCP Receive Buffer Min Size NO
17 1 TCP_SEND_SIZE_DEFAULT 16384 2001 TCP Send Buffer Default Size NO
18 1 TCP_SEND_SIZE_MAX 4194304 2002 TCP Send Buffer Max Size NO
19 1 TCP_SEND_SIZE_MIN 4096 2000 TCP Send Buffer Min Size NO
20 1 USER_TIME 80034 3 Time (centi-secs) spent in user code YES
21 1 VM_IN_BYTES 0 1009 Bytes paged in due to virtual memory swapping YES
22 1 VM_OUT_BYTES 0 1010 Bytes paged out due to virtual memory swapping YES

System Statistics

Collected from SYS.AUX_STATS$.
# Name Value
1 CPUSPEED
2 CPUSPEEDNW 3074.07407407407
3 IOSEEKTIM 10
4 IOTFRSPEED 4096
5 MAXTHR
6 MBRC
7 MREADTIM
8 SLAVETHR
9 SREADTIM
# Name Value

System Statistics History

Collected from SYS.WRI$_OPTSTAT_AUX_HISTORY.
This section includes data captured by AWR.
# Save Time Name Value
# Save Time Name Value

System Global Area (SGA) Statistics

Collected from GV$SGASTAT.
# Inst Pool Name Bytes
1 1 java pool free memory 4194304
2 1 large pool ASM map operations hashta 393216
3 1 large pool PX msg pool 8192000
4 1 large pool free memory 8192000
5 1 shared pool 1:kngisga 32152
6 1 shared pool ADR_CONTROL 1504
7 1 shared pool ADR_INVALIDATION 664
8 1 shared pool AQ Propagation Scheduling 16000
9 1 shared pool ASH buffers 8388608
10 1 shared pool ASM KFFD SO 2648
11 1 shared pool ASM extent pointer array 143928
12 1 shared pool ASM generic network state 2584
13 1 shared pool ASM kfk state object 5232
14 1 shared pool ASM map operations 2904
15 1 shared pool ASM rollback operations 2648
16 1 shared pool ASM scan context 3544
17 1 shared pool AW SGA 40
18 1 shared pool AWR Table Info (KEW layer 1216
19 1 shared pool Active Session History - 1528
20 1 shared pool Alert log 520
21 1 shared pool ArchLog Dest Array 22784
22 1 shared pool Array of cached attr 400
23 1 shared pool Auto tune undo info 96
24 1 shared pool BRANCH TABLE SEGMENTED AR 220296
25 1 shared pool Background process state 48
26 1 shared pool Banner Storage 2048
27 1 shared pool CGS system incarn array 24864
28 1 shared pool Checkpoint queue 821248
29 1 shared pool Cleanup state objects 1760
30 1 shared pool Client ID trace setting h 536
31 1 shared pool Client ID trace settings 3928
32 1 shared pool Closed Thread SCN Bitvec 33792
33 1 shared pool Core dump directory 520
34 1 shared pool DBWR array of pointers to 8
35 1 shared pool DBWR event stats array 216
36 1 shared pool DDE_USER_ACTION 1128
37 1 shared pool DDE_USER_ACTION_DEF 1320
38 1 shared pool DDE_USER_ACTION_PARAMETER 2080
39 1 shared pool DDE_USER_INCIDENT_ACTION_ 664
40 1 shared pool DDE_USER_INCIDENT_TYPE 664
41 1 shared pool DFW_CONFIG_CAPTURE 752
42 1 shared pool DFW_CONFIG_ITEM 944
43 1 shared pool DISPATCHER CONFIG ENTRY 88
44 1 shared pool DISPATCHER CONFIG TABLE 2048
45 1 shared pool DISPATCHERS INFO 2496
46 1 shared pool DML lock 410784
47 1 shared pool Detached dump directory 520
48 1 shared pool EM_DIAG_JOB 1320
49 1 shared pool EM_TARGET_INFO 1224
50 1 shared pool EM_USER_ACTIVITY 1224
51 1 shared pool ENQUEUE STATS 23040
52 1 shared pool ENQUQUE FREELISTS 672
53 1 shared pool FAST SPACEUSAGE 312328
54 1 shared pool File Space Usage 11344
55 1 shared pool FileIdentificatonBlock 760896
56 1 shared pool FileOpenBlock 1972416
57 1 shared pool GCR 2776
58 1 shared pool Global Context Heap descr 400
59 1 shared pool HM Hang Stats 1472
60 1 shared pool HM RSLN RC 2112
61 1 shared pool HM SGA context 31392
62 1 shared pool HM SGA kjzs ctx 24
63 1 shared pool HM VFY TRCFIL 520
64 1 shared pool HM Wt Evt Stats Array 164160
65 1 shared pool HM_FDG_SET 848
66 1 shared pool HM_FINDING 2632
67 1 shared pool HM_INFO 944
68 1 shared pool HM_MESSAGE 1416
69 1 shared pool HM_RECOMMENDATION 2072
70 1 shared pool HM_RUN 1976
71 1 shared pool HTTP fixed headers 72
72 1 shared pool I/O stat latches 4960
73 1 shared pool INCCKEY 848
74 1 shared pool INCIDENT 3008
75 1 shared pool INCIDENT_FILE 848
76 1 shared pool INC_METER_CONFIG 1224
77 1 shared pool INC_METER_IMPT_DEF 1040
78 1 shared pool INC_METER_INFO 1320
79 1 shared pool INC_METER_PK_IMPTS 1040
80 1 shared pool INC_METER_SUMMARY 1416
81 1 shared pool IO_SHARES_KGSKCAP 8
82 1 shared pool IPDDB SGA ctx 8
83 1 shared pool IPS_CONFIGURATION 1320
84 1 shared pool IPS_FILE_COPY_LOG 1040
85 1 shared pool IPS_FILE_METADATA 944
86 1 shared pool IPS_PACKAGE 1880
87 1 shared pool IPS_PACKAGE_FILE 848
88 1 shared pool IPS_PACKAGE_HISTORY 1320
89 1 shared pool IPS_PACKAGE_INCIDENT 944
90 1 shared pool IPS_PACKAGE_UNPACK_HISTOR 1040
91 1 shared pool IPS_PROGRESS_LOG 1320
92 1 shared pool IPS_REMOTE_PACKAGE 944
93 1 shared pool JSX SGA 3776
94 1 shared pool K2Q latches 800
95 1 shared pool KCB Table Scan 40
96 1 shared pool KCB Table Scan Bitmap 248
97 1 shared pool KCB Table Scan Buffer 3981120
98 1 shared pool KCB buffer wait statistic 3352
99 1 shared pool KCB incremental ckpt entr 720
100 1 shared pool KCB tablespace encryption 1064
101 1 shared pool KCB undo bitvec 4096
102 1 shared pool KCB where statistics arra 37440
103 1 shared pool KCFIS SGA 8
104 1 shared pool KESTB existence bitvec 262144
105 1 shared pool KESTB existence bitvec se 2048
106 1 shared pool KEWS External IDs 1536
107 1 shared pool KEWS aggregation objs 4032
108 1 shared pool KEWS fixed SGA 5704
109 1 shared pool KEWS sesstat seg tbl 8
110 1 shared pool KEWS sesstat values 160704
111 1 shared pool KEWS statistic maps 3216
112 1 shared pool KEWS statistic metadata 16864
113 1 shared pool KEWS statistic name 2288
114 1 shared pool KEWS sysstat values 256
115 1 shared pool KFD extent enqueue obj 42816
116 1 shared pool KFG SO child 8440
117 1 shared pool KFG state obj 7032
118 1 shared pool KFK SGA 4224
119 1 shared pool KFK idtab_kfksga 64832
120 1 shared pool KFM state obj 2904
121 1 shared pool KGI Session State 1600
122 1 shared pool KGKP randnum 40000
123 1 shared pool KGKP randnum shadow 40000
124 1 shared pool KGKP sga 48
125 1 shared pool KGLA 65400
126 1 shared pool KGLDA 331256
127 1 shared pool KGLH0 6991832
128 1 shared pool KGLHD 1177560
129 1 shared pool KGLNA 1344
130 1 shared pool KGLS 1798184
131 1 shared pool KGLSG 5267216
132 1 shared pool KGNFS scontext 524480
133 1 shared pool KGSK scheduler 63328
134 1 shared pool KGSK sga 8240
135 1 shared pool KGSKI schedule 41384
136 1 shared pool KGSKI scheduler heap 1 de 232
137 1 shared pool KGSKI scheduler heap 2 de 232
138 1 shared pool KGSKI sga 72
139 1 shared pool KGX 133224
140 1 shared pool KGX rowlist 6624
141 1 shared pool KJC receiver 1104
142 1 shared pool KJC snd proxy 4160
143 1 shared pool KJCTS implicit batching s 96
144 1 shared pool KJCTS process batching st 96
145 1 shared pool KJFM heartbea 3392
146 1 shared pool KJFM heartbeat management 136
147 1 shared pool KJGCR global context 360
148 1 shared pool KJXM msg stat table array 32
149 1 shared pool KJXM msg statistics table 27648
150 1 shared pool KKJ SGA 720
151 1 shared pool KKJ SHRD WRQS 240
152 1 shared pool KKJ WRK LAT 480
153 1 shared pool KKKI consumer 5240
154 1 shared pool KKSSP 1590744
155 1 shared pool KKTIN 6688
156 1 shared pool KOKTD 3584
157 1 shared pool KQF optimizer stats table 1904
158 1 shared pool KQF runtime defined table 8928
159 1 shared pool KQFUTTAB COLS 472
160 1 shared pool KQR L PO 785472
161 1 shared pool KQR L SO 48128
162 1 shared pool KQR M SO 166480
163 1 shared pool KQR X PO 538232
164 1 shared pool KRBMROS ANCHOR 96
165 1 shared pool KRSF SGA 40
166 1 shared pool KSFD Cache Hints for IO R 72
167 1 shared pool KSFD SGA I/O b 3977144
168 1 shared pool KSFQ buffer pool 3032
169 1 shared pool KSFV SGA 832
170 1 shared pool KSI ENQUEUES 11760
171 1 shared pool KSI Indexes 288
172 1 shared pool KSI resource types 16224
173 1 shared pool KSIR SGA 144
174 1 shared pool KSK OSS PLAN 3360
175 1 shared pool KSK SGA 168016
176 1 shared pool KSK VT POOL 353600
177 1 shared pool KSKQ SGA 14200
178 1 shared pool KSKQ SGA NODEINFO 1359872
179 1 shared pool KSN WaitID 1560
180 1 shared pool KSQ event description 9208
181 1 shared pool KSRPC I/O Stat array 144
182 1 shared pool KSRPC I/O Stat array ptr 16
183 1 shared pool KSTM SGA 24
184 1 shared pool KSVR SGA 2384
185 1 shared pool KSXP CONN Stats buffer 338880
186 1 shared pool KSXP CTX Stats buffer 313312
187 1 shared pool KSXP OSD MISC Stats buffe 422080
188 1 shared pool KSXP PORT Stats buffer 236480
189 1 shared pool KSXP conn table columns d 4984
190 1 shared pool KSXP ctx table columns de 3296
191 1 shared pool KSXP osd misc table colum 6208
192 1 shared pool KSXP port table columns d 2824
193 1 shared pool KSXP test table columns d 1320
194 1 shared pool KSXR SGA 27856
195 1 shared pool KSXR global channels 3192
196 1 shared pool KSXR large reply queue 168320
197 1 shared pool KSXR pending consumption 21144
198 1 shared pool KSXR pending messages que 862008
199 1 shared pool KSXR pending reply queue 100336
200 1 shared pool KSXR receive buffers 2123776
201 1 shared pool KSZ sga subheap descripto 136
202 1 shared pool KTA latches 2024
203 1 shared pool KTC latch cleanup 480
204 1 shared pool KTC latches 1760
205 1 shared pool KTC txn rsrc cnt 88
206 1 shared pool KTC variable sga 24
207 1 shared pool KTCN global clauses ht 128
208 1 shared pool KTCN global operands ht 128
209 1 shared pool KTCN global operators 64
210 1 shared pool KTCN queries hash table 128
211 1 shared pool KTCN: Hash Table Segmente 5240
212 1 shared pool KTCN: Obj Invalidation Se 24632
213 1 shared pool KTCN: Row Change Segmente 34552
214 1 shared pool KTCN: query inv Segmented 3928
215 1 shared pool KTCNC inv hashtable 128
216 1 shared pool KTCNQROW colname ptrs 344
217 1 shared pool KTCNQROW colnames 1296
218 1 shared pool KTCTSNL freelists 88
219 1 shared pool KTCTSNL subheaps 1496
220 1 shared pool KTF MAPPINGS 12288
221 1 shared pool KTI freelists 88
222 1 shared pool KTPR HIST TB 2808
223 1 shared pool KTPR SUBHEAP 168
224 1 shared pool KTRSGA 8
225 1 shared pool KTSL lat struct 40960
226 1 shared pool KTSL reco struct 24576
227 1 shared pool KTU SGA 32
228 1 shared pool KTU avail cache 4032
229 1 shared pool KTU lat struct 800
230 1 shared pool KTU latch cleanup 624
231 1 shared pool KTU latches 600
232 1 shared pool KTUR HIST INFO 4840
233 1 shared pool KUPP subheap desc 232
234 1 shared pool KWQDL SGA Ddtc gen cleanu 48
235 1 shared pool KWQDL SGA Dtc gen cleanup 48
236 1 shared pool KWQDL child latches 2880
237 1 shared pool KXFR Hash Array latches a 2944
238 1 shared pool KXFR Psuedo Hash Array fo 3072
239 1 shared pool KYWM CROSS INSTANCE 384
240 1 shared pool KYWM RPLY CROSS INSTANCE 53248
241 1 shared pool KYWM SGA 296
242 1 shared pool L2 enabled array 16
243 1 shared pool L2 file global fob 72
244 1 shared pool L2 file map array 4896
245 1 shared pool LGWR debug module memory 8192
246 1 shared pool LGWR post requested array 8
247 1 shared pool LGWR-network Server info 34048
248 1 shared pool LISTEN ADDRESS ENTRY 304
249 1 shared pool LISTEN ADDRESS TABLE 2048
250 1 shared pool LMS post requested array 8
251 1 shared pool LRMPD SGA Table 326480
252 1 shared pool Label Cache Heap descrptr 160
253 1 shared pool Log Archive Config Contex 1096
254 1 shared pool Log Archive Trace PID Lis 40
255 1 shared pool MS alert log 72704
256 1 shared pool MTTR advisory context 1648
257 1 shared pool Managed Standby Proc Arra 34816
258 1 shared pool MinActScn Array 320
259 1 shared pool Monitor Modification Hash 512
260 1 shared pool NETWORK BUFFER 65576
261 1 shared pool Nettimeout Histogram 151280
262 1 shared pool OS file lock 8632
263 1 shared pool OS proc request holder 13816
264 1 shared pool Online Datafile Move sess 2392
265 1 shared pool PARALLEL T RECO LATCH 19200
266 1 shared pool PARAMETER ENTRY 64
267 1 shared pool PARAMETER TABLE 2048
268 1 shared pool PG latch table 640
269 1 shared pool PICKLEERR 1128
270 1 shared pool PLDIA 773512
271 1 shared pool PLMCD 248672
272 1 shared pool PLS SGA hp 46240
273 1 shared pool PLS cca hp desc 352
274 1 shared pool PLS chunk 352
275 1 shared pool PMON blockers 6400
276 1 shared pool PMR sga heap 14249528
277 1 shared pool PQ/BizCard 1536
278 1 shared pool PQ/ResSched 1040
279 1 shared pool PRESENTATION ENTRY 72
280 1 shared pool PRESENTATION TABLE 2048
281 1 shared pool PROBLEM 1600
282 1 shared pool PRTDS 8096
283 1 shared pool PRTMV 15936
284 1 shared pool PX QC deq stats 1696
285 1 shared pool PX QC msg stats 2904
286 1 shared pool PX list of chunk lists 1088
287 1 shared pool PX msg pool struct 56
288 1 shared pool PX server deq stats 1696
289 1 shared pool PX server msg stats 2904
290 1 shared pool PX subheap 239016
291 1 shared pool PX subheap desc 256
292 1 shared pool Parameter Handle 3128
293 1 shared pool Parameter Table 69936
294 1 shared pool Policy Cache Heap descrpt 160
295 1 shared pool Pre-Warm Initialized Seti 512
296 1 shared pool Prefetch client count per 32
297 1 shared pool Prefetch history buffer 11328
298 1 shared pool Prefetch history buffer a 320
299 1 shared pool Processor group descripto 256
300 1 shared pool RTA Boundary Info thread 71808
301 1 shared pool RTA read control file ind 4224
302 1 shared pool RVWR post requested array 8
303 1 shared pool Read Only Database Accoun 160
304 1 shared pool Rec Ping Per Thread Info 21128
305 1 shared pool Result Cache: Bloom Fltr 2048
306 1 shared pool Result Cache: Cache Mgr 208
307 1 shared pool Result Cache: Memory Mgr 200
308 1 shared pool Result Cache: RAC Cbk 5408
309 1 shared pool Result Cache: State Objs 2896
310 1 shared pool Role graph heap 160
311 1 shared pool Role related heap 160
312 1 shared pool SAGE commit cache Allocat 80
313 1 shared pool SAGE commit cache node Al 10240
314 1 shared pool SCHEDULING POLICY TABLE 64
315 1 shared pool SCHEDULING POLICY VECTOR 104
316 1 shared pool SEQ S.O. 57536
317 1 shared pool SERVICE NAME ENTRY 96
318 1 shared pool SERVICE NAMES TABLE 2048
319 1 shared pool SGA - AWR Metric RBSM str 992
320 1 shared pool SGA - SWRF DrvMet Runtime 6368
321 1 shared pool SGA - SWRF Metric CHBs 1001232
322 1 shared pool SGA - SWRF Metric Eidbuf 151696
323 1 shared pool SGA - SWRF Metrics WCTime 2064
324 1 shared pool SGA - SWRF Metrics ksuTim 2064
325 1 shared pool SGA - SWRF RawMet Runtime 4656
326 1 shared pool SGA - SWRF Time Model Bas 120
327 1 shared pool SGA Obsolete Param Source 24
328 1 shared pool SGA Param Source Table 368
329 1 shared pool SGA struct - SWRF Metrics 9120
330 1 shared pool SGA structure for ADR lay 8
331 1 shared pool SGA structure for AWR (KE 256
332 1 shared pool SGA structure for KPON kp 3192
333 1 shared pool SGA structure for KPON ks 400
334 1 shared pool SGA structure for KWQDL h 280
335 1 shared pool SGA structure for KWQDL s 24
336 1 shared pool SGA structure for kelr 2368
337 1 shared pool SGA structure for ktslgt 47200
338 1 shared pool SHARED SERVERS INFO 3672
339 1 shared pool SHRINK STAT 3000
340 1 shared pool SQL Memory Manager Base W 13400
341 1 shared pool SQL Workarea Histogram 1056
342 1 shared pool SQLA 8682488
343 1 shared pool SQLK 16192
344 1 shared pool SQLP 186408
345 1 shared pool SWEEPERR 944
346 1 shared pool SYSTEM PARAMETERS 549936
347 1 shared pool Security Class heap 136
348 1 shared pool Service-level ID trace se 4600
349 1 shared pool Service-level trace setti 536
350 1 shared pool Sort Segment 12288
351 1 shared pool Space Background Task Des 72000
352 1 shared pool State object pools 4608
353 1 shared pool State object subpools 7360
354 1 shared pool Storage for kcrr state ob 104
355 1 shared pool TBS STAT 16000
356 1 shared pool TXN TABLE SEGMENTED ARRAY 241736
357 1 shared pool Temporary Tables State Ob 80688
358 1 shared pool Temporary storage for RTA 72
359 1 shared pool Transportable DB Converte 4720
360 1 shared pool UNDO INFO 16
361 1 shared pool UNDO INFO HASH 8704
362 1 shared pool UNDO INFO SEGMENTED ARRAY 55272
363 1 shared pool UNDO STAT INFO 59904
364 1 shared pool User dump directory 520
365 1 shared pool VIEW 1040
366 1 shared pool VIEWCOL 752
367 1 shared pool VIRTUAL CIRCUITS 856192
368 1 shared pool VM OSD context 96
369 1 shared pool Wait History Array 8
370 1 shared pool Wait History Segment 257920
371 1 shared pool Wait event pointers 384
372 1 shared pool X$KSFQP ANCHOR 80
373 1 shared pool X$KSVII table 512
374 1 shared pool X$KSVIS table 128
375 1 shared pool X$KSVIT table 512
376 1 shared pool X$KSXPCLIENT table 352
377 1 shared pool X$KSXPPING table 20480
378 1 shared pool X$SKGXPIA table 17152
379 1 shared pool active checkp 5040
380 1 shared pool alert threshol 4056
381 1 shared pool alert_ext 3480
382 1 shared pool alter system errs: kspnfy 116736
383 1 shared pool ams_xaction 568
384 1 shared pool analytic workspace 2904
385 1 shared pool archive_lag_target 9632
386 1 shared pool array 1 for shared redo b 192
387 1 shared pool array 2 for shared redo b 192
388 1 shared pool bcast ack latency base ar 72
389 1 shared pool block iostats dynamic seg 9656
390 1 shared pool block media rcv state obj 2520
391 1 shared pool block_sizes_array 48
392 1 shared pool bloom filter 2776
393 1 shared pool branch 105880
394 1 shared pool branch so 360
395 1 shared pool broker globals 232
396 1 shared pool buffer handles 528008
397 1 shared pool buffer_pool_desc_array 3456
398 1 shared pool buffers waiting for write 24
399 1 shared pool call 61024
400 1 shared pool change notification obj m 16416
401 1 shared pool change notification regis 16416
402 1 shared pool change tracking recovery 262144
403 1 shared pool change tracking state cha 2584
404 1 shared pool channel context areas 87480
405 1 shared pool channel handle 105608
406 1 shared pool channel sga anchor 384
407 1 shared pool character set memory 539864
408 1 shared pool character set object 114384
409 1 shared pool cinfo_kfnsg 4104
410 1 shared pool client/application info l 640
411 1 shared pool constraints 79768
412 1 shared pool copy latch aux 64
413 1 shared pool cp cmon array 3632
414 1 shared pool cp connection 2704
415 1 shared pool cp pool array 2608
416 1 shared pool cp srv array 3024
417 1 shared pool cross-platform compliance 2232
418 1 shared pool database NCHAR language h 568
419 1 shared pool database creation languag 568
420 1 shared pool db_block_hash_buckets 1462272
421 1 shared pool db_files 458000
422 1 shared pool dbgdInitEventGrp: eventGr 216
423 1 shared pool dbgefgHtAddSK-1 482048
424 1 shared pool dbgefgHtInit-1 528
425 1 shared pool dbgefgHtInit-2 24
426 1 shared pool dbke_incid_cache_init 12000
427 1 shared pool dbkea msg body 51200
428 1 shared pool dbkea msgq 32
429 1 shared pool dbkea msgs 1200
430 1 shared pool dbkea sga 24
431 1 shared pool dbktb: sga ctx 48
432 1 shared pool dbktb: trace buffer 2457600
433 1 shared pool dbktb: trace pool 13200
434 1 shared pool dbwr actual working sets 64
435 1 shared pool dbwr message active flag 8
436 1 shared pool dbwr outstanding ios per 72
437 1 shared pool dbwr suspend/resume array 16
438 1 shared pool dbwr suspend/resume ptr a 16
439 1 shared pool dbwr working sets kcbdbws 16
440 1 shared pool dbwriter coalesce bitmap 128
441 1 shared pool dbwriter coalesce buffer 2002944
442 1 shared pool dbwriter coalesce struct 48
443 1 shared pool dev2node map 4096
444 1 shared pool dgtab_kfmdsg 25144
445 1 shared pool dia* process descriptor 16
446 1 shared pool diag descriptor 16
447 1 shared pool diag fixed SGA 136
448 1 shared pool diagv_incident 3296
449 1 shared pool dir_ext 1320
450 1 shared pool dirty object counts array 2097152
451 1 shared pool dispatcher rate 1312
452 1 shared pool dispatcher service names 8
453 1 shared pool distributed_transactions- 23048
454 1 shared pool dlo fib struct 12832
455 1 shared pool done Q child latches 448
456 1 shared pool dpslut_kfdsg 512
457 1 shared pool dskm rac entity id 96
458 1 shared pool dsktab_kfgsg 58176
459 1 shared pool dummy 39744
460 1 shared pool enqueue 734584
461 1 shared pool enqueue resources 181456
462 1 shared pool enqueue_hash 25488
463 1 shared pool enqueue_hash_chain_latche 640
464 1 shared pool error message file name 64
465 1 shared pool event classes 1584
466 1 shared pool event descriptor table 65824
467 1 shared pool event list array to post 72
468 1 shared pool event list to post commit 144
469 1 shared pool event statistics per sess 3261696
470 1 shared pool event statistics ptr arra 1984
471 1 shared pool event-class map 5472
472 1 shared pool fencing reid 17976
473 1 shared pool file # to first dba, exte 2416
474 1 shared pool file # translation table 40064
475 1 shared pool file iostats dynamic seg 22936
476 1 shared pool file state object 945600
477 1 shared pool fixed allocation callback 304
478 1 shared pool flashback_marker_cache_si 9200
479 1 shared pool free memory 15820376
480 1 shared pool gc delta push object arra 40
481 1 shared pool gc delta push statistics 1040
482 1 shared pool gc injected bitvec 16
483 1 shared pool gc instance cache transfe 589824
484 1 shared pool gc lock contexts 38424
485 1 shared pool gc lock state 6784
486 1 shared pool gc name table 1572864
487 1 shared pool gc offline scn array 1608
488 1 shared pool gc partition table 2293760
489 1 shared pool gc policy history array 24576
490 1 shared pool gc read wait freelist 218400
491 1 shared pool gc region array 16
492 1 shared pool gcs I/O statistics struct 48
493 1 shared pool gcs commit sga state 106504
494 1 shared pool gcs delta freelist 16
495 1 shared pool gcs mastership buckets 3072
496 1 shared pool gcs process descriptor ar 16
497 1 shared pool gcs procsss descriptor 42832
498 1 shared pool gcs res hash bucket 262144
499 1 shared pool gcs res latch table 25600
500 1 shared pool gcs resource freelist 528
501 1 shared pool gcs resource freelist arr 16
502 1 shared pool gcs resource freelist seg 16
503 1 shared pool gcs resource segmented ar 96
504 1 shared pool gcs resources 5629360
505 1 shared pool gcs scan queue 352
506 1 shared pool gcs scan queue array 16
507 1 shared pool gcs shadows 3897248
508 1 shared pool gcs shadows freelist 560
509 1 shared pool gcs shadows freelist arra 16
510 1 shared pool gcs shadows seg array 16
511 1 shared pool gcs shadows segmented arr 96
512 1 shared pool generic process shared st 464
513 1 shared pool ges big msg buffers 3975248
514 1 shared pool ges deadlock xid freelist 11264
515 1 shared pool ges deadlock xid hash tab 17800
516 1 shared pool ges enqueue cur. usage pe 16
517 1 shared pool ges enqueue max. usage pe 16
518 1 shared pool ges enqueue multiple free 640
519 1 shared pool ges enqueues 4045952
520 1 shared pool ges ipc instance maps 384
521 1 shared pool ges msg pool watchlist 288
522 1 shared pool ges process array 488960
523 1 shared pool ges process descriptor 21416
524 1 shared pool ges process descriptor ar 8
525 1 shared pool ges process hash table 14080
526 1 shared pool ges recovery domain table 176
527 1 shared pool ges regular msg buffers 1277208
528 1 shared pool ges res mastership bucket 3072
529 1 shared pool ges reserved msg buffers 2540448
530 1 shared pool ges resource 2100304
531 1 shared pool ges resource hash seq tab 8192
532 1 shared pool ges resource hash table 360448
533 1 shared pool ges resource pools 992
534 1 shared pool ges scan queue array 176
535 1 shared pool ges shared global area 33944
536 1 shared pool groups_kfgbsg 90624
537 1 shared pool grplut_kfgsg 512
538 1 shared pool grptab_kfgsg 3480
539 1 shared pool hash bucket array allocat 49152
540 1 shared pool heap_kfsg 208
541 1 shared pool hot latch diagnostics 160
542 1 shared pool id:ksu_register_trcid 264
543 1 shared pool incr ckpt write count arr 168
544 1 shared pool init_heap_kfsg 254112
545 1 shared pool instance cnxn information 11904
546 1 shared pool invalid low rba queue 2048
547 1 shared pool iosts_kfmdsg 3600
548 1 shared pool java static objs 34952
549 1 shared pool joxs heap 4192
550 1 shared pool joxs struct 160
551 1 shared pool jsksncb: 2 7840
552 1 shared pool jsksncb: 7 491520
553 1 shared pool jsksncb: 9 555648
554 1 shared pool k2q_lock 299640
555 1 shared pool kcbbl2df L2 disabling fla 8
556 1 shared pool kcbl seq io throughput 12000
557 1 shared pool kcbl state objects 25600
558 1 shared pool kcbl statistics 6144
559 1 shared pool kccsgehtt 360
560 1 shared pool kcfis state object 2392
561 1 shared pool kcrfa structures 656
562 1 shared pool kcrrorlerr.alo 48
563 1 shared pool kdlwl_sga_subheap 232
564 1 shared pool kdlwss 32640
565 1 shared pool kdlxdup swapp 16
566 1 shared pool kdlxdup swappl 2400
567 1 shared pool kea advisor definition ca 480
568 1 shared pool kebm run-once actions 64
569 1 shared pool kebm slave descriptors 7680
570 1 shared pool kebm slave message 304
571 1 shared pool kebm slave reply 888
572 1 shared pool kebm test replies 30720
573 1 shared pool kelr other metrics table 48
574 1 shared pool kelr system metrics table 296
575 1 shared pool kelt translation table 360
576 1 shared pool keswx:batch o 3344
577 1 shared pool keswx:plan en 2080
578 1 shared pool keswxNotify:tabPlans 4096
579 1 shared pool ket (AutoTask) SGA 832
580 1 shared pool kewr MMON Remote Flush Re 30720
581 1 shared pool kfasga 1048
582 1 shared pool kfdsga 144
583 1 shared pool kfgbsg 40
584 1 shared pool kfgsga 104
585 1 shared pool kfiosg 16
586 1 shared pool kfkhsh_kfdsg 4104
587 1 shared pool kfkid hash 4104
588 1 shared pool kfkid hrec 24
589 1 shared pool kfklsod list 15008
590 1 shared pool kfklsodtab 333928
591 1 shared pool kfkrec_kfdsg 24
592 1 shared pool kfmdsg 216
593 1 shared pool kfmsg 3608
594 1 shared pool kfnvsga 24
595 1 shared pool kga sga 8
596 1 shared pool kghx free lists 50624
597 1 shared pool kglsgivl 4096
598 1 shared pool kglsgivl2 28160
599 1 shared pool kglsim Java per-gran bkt 103200
600 1 shared pool kglsim Java timestamps 131072
601 1 shared pool kglsim alloc latch area 2720
602 1 shared pool kglsim alloc latches 136
603 1 shared pool kglsim count of pinned he 12512
604 1 shared pool kglsim count of unpinned 12512
605 1 shared pool kglsim free heap list 408
606 1 shared pool kglsim free obj list 408
607 1 shared pool kglsim hash table 8208
608 1 shared pool kglsim hash table bkts 4194304
609 1 shared pool kglsim heap 297600
610 1 shared pool kglsim latch area 2720
611 1 shared pool kglsim latches 136
612 1 shared pool kglsim object batch 212520
613 1 shared pool kglsim per-gran bkt 103200
614 1 shared pool kglsim recovery area 1632
615 1 shared pool kglsim sga 576
616 1 shared pool kglsim size of pinned mem 24752
617 1 shared pool kglsim size of unpinned m 24752
618 1 shared pool kglsim timestamps 131072
619 1 shared pool kglsim used list arr 2720
620 1 shared pool kgnfs authp 16464
621 1 shared pool kgnfs ctab array 1240
622 1 shared pool kgnfs gid list 104
623 1 shared pool kgnfs htab array 2440
624 1 shared pool kgnfs stats array 18040
625 1 shared pool kgsk subheap descriptor 136
626 1 shared pool kjdrrmreq freelist elemen 1128000
627 1 shared pool kjihap2sav freelist eleme 72000
628 1 shared pool kjip2ackinfo freelist ele 72000
629 1 shared pool kjip2data freelist elemen 64000
630 1 shared pool kjip2owner freelist eleme 40000
631 1 shared pool kjxgrrr SGA 56
632 1 shared pool kjxgrvr SGA 40
633 1 shared pool kkae edition name cache 408
634 1 shared pool kks sga 56
635 1 shared pool kkzias 144
636 1 shared pool kmgsb circular statistics 162304
637 1 shared pool knlsg 144
638 1 shared pool knlu_init_btree:init 96
639 1 shared pool knstoggall_knstsga 192
640 1 shared pool knstsg 56
641 1 shared pool kodosgi kodos 32
642 1 shared pool kodosgi kopfdo 416
643 1 shared pool koh dur heap 424
644 1 shared pool kohsg 16
645 1 shared pool kokcss 24
646 1 shared pool kolbsgi: KOLB's SGA initi 8
647 1 shared pool kolfsgi: KOLF's SGA initi 8
648 1 shared pool kponfy 912
649 1 shared pool kpscad: kpscscon 104
650 1 shared pool kpssnfy: kpsssgct 72
651 1 shared pool kpummst global in the SGA 2576
652 1 shared pool kqf runtime defined table 21120
653 1 shared pool kqlpWrntoStr:string 104
654 1 shared pool kramh message flag 16
655 1 shared pool krbabrAncp 96
656 1 shared pool krbfusg 40
657 1 shared pool krdlrps 7224
658 1 shared pool krdrsb read violation arr 560000
659 1 shared pool krp_sabmr_reqarr 8192
660 1 shared pool krp_sabmr_reqarr2 8192
661 1 shared pool krsv_notifier_cb 33760
662 1 shared pool krvxdka 872
663 1 shared pool krvxdta 1760
664 1 shared pool krvxlctx 248
665 1 shared pool krvxmctx 40
666 1 shared pool ksacm service obj array 768
667 1 shared pool ksacm service root 88
668 1 shared pool ksb action records 4272
669 1 shared pool ksb ci process list (each 880
670 1 shared pool ksb cic process list 912
671 1 shared pool ksb process so list 912
672 1 shared pool ksb rolling migration sta 96
673 1 shared pool ksbsa pointer array 2856
674 1 shared pool ksbtnfy: infrequent actio 2856
675 1 shared pool ksbxic obj 30080
676 1 shared pool ksbxic reques 4000
677 1 shared pool ksbxic sga 40
678 1 shared pool ksbxic subreq 4104
679 1 shared pool kscdnfyglobalflags 8
680 1 shared pool kscdnfyinitflags 8
681 1 shared pool kscdnfyinithead 16
682 1 shared pool kscdnfyinitnext 40
683 1 shared pool kscdnfyinitprev 40
684 1 shared pool ksdhng: blkers cache 7936
685 1 shared pool ksdhng: blkrs cache 3968
686 1 shared pool ksdhng: cache ctx 208
687 1 shared pool ksdhng: cache history 320
688 1 shared pool ksdhng: cbuf 32768
689 1 shared pool ksdhng: cbufs 64
690 1 shared pool ksdhng: el wtr cache 43648
691 1 shared pool ksdhng: els blkrs cache 357120
692 1 shared pool ksdhng: fblkrs cache 11904
693 1 shared pool ksdhng: wtr cache 3968
694 1 shared pool ksfd I/O slave ctx 256
695 1 shared pool ksfd SGA state 96
696 1 shared pool ksfd shared pool recovery 24
697 1 shared pool ksfd: block i/o stats poi 3200
698 1 shared pool ksfd: components i/o stat 188160
699 1 shared pool ksfd: consumer group i/o 13824
700 1 shared pool ksfd: file i/o stats poin 3480
701 1 shared pool ksfdgfib recovery 16
702 1 shared pool ksfdss bitmap array 8704
703 1 shared pool ksfdsscloneinfo allocatio 3200
704 1 shared pool ksfm state object 88
705 1 shared pool ksfv instance 9984
706 1 shared pool ksfv subheap 16536
707 1 shared pool ksfv subheap descriptor 184
708 1 shared pool ksgm sga instance configu 8584
709 1 shared pool ksim cached group entry l 5632
710 1 shared pool ksim cached group entry s 128
711 1 shared pool ksim client list 168
712 1 shared pool ksim group query request 232
713 1 shared pool ksim sga instance group e 1160
714 1 shared pool ksir PrivOp State Object 2392
715 1 shared pool ksir State Object 3032
716 1 shared pool ksleid alloc 176
717 1 shared pool ksmd unit test 1 5296
718 1 shared pool kso req alloc 4056
719 1 shared pool kso req alloc heapds 280
720 1 shared pool kso: sched delay history 28896
721 1 shared pool kspd run-time context 24
722 1 shared pool kspload:comment 64
723 1 shared pool kss unit test 3928
724 1 shared pool kstm drifts table 1048
725 1 shared pool ksu: ksusg_emptypxsta 5488
726 1 shared pool ksu:ksunf_fre 4032
727 1 shared pool ksu:ksusg_emptyinfo 160
728 1 shared pool ksuloi: child latches for 640
729 1 shared pool ksuloi: garbage collectio 16
730 1 shared pool ksuloi: long op free list 64
731 1 shared pool ksuloi: long op statistic 182528
732 1 shared pool ksuloi: long op used list 64
733 1 shared pool ksunfy : SSO free list 3102976
734 1 shared pool ksunfy : array of SSO fre 680
735 1 shared pool ksunfy : array of session 1984
736 1 shared pool ksunfy: Reserved PSO Numa 8
737 1 shared pool ksunfy: in-use PSO Numa A 8
738 1 shared pool ksunfy: is parent statist 8232
739 1 shared pool ksunfy: nodes of hierarch 480
740 1 shared pool ksunfy: system-global sta 5488
741 1 shared pool ksv direct ms 7344
742 1 shared pool ksv reaper 15096
743 1 shared pool ksv slave 15768
744 1 shared pool ksv slave class 197712
745 1 shared pool ksv work msg 2312
746 1 shared pool ksvr msg cache 2392
747 1 shared pool ksws RLB SGA ctx 40
748 1 shared pool ksws msg buffers 2056192
749 1 shared pool ksws service events 52608
750 1 shared pool ksws service object 3168
751 1 shared pool ksxp IPC state object 8856
752 1 shared pool ksxp rm state 136
753 1 shared pool ksxp static shared state 8880
754 1 shared pool ksxp stats bkts 4224
755 1 shared pool ksz parent 9656
756 1 shared pool ktcnc child latches 5888
757 1 shared pool ktcnqrow columns 4328
758 1 shared pool ktfa dynamic SGA allocati 632
759 1 shared pool ktg hash buckets 13576
760 1 shared pool ktgCircBuf:MinActScn Trc 40032
761 1 shared pool ktlbk state objects 293760
762 1 shared pool ktsj_init_sga proc desc 176
763 1 shared pool ktsj_init_sga task stat 24
764 1 shared pool ktud-usd hash table 264
765 1 shared pool kwqicaqe2kc1 11616
766 1 shared pool kwqmncini-slv 18400
767 1 shared pool kwqmncini-stat 120
768 1 shared pool kwqmncini-tbl 4136
769 1 shared pool kxfpSO q freelists 368
770 1 shared pool kxfpSO qref freelists 368
771 1 shared pool kxfpdp pointers 28800
772 1 shared pool kxfpsga snapshots 4096
773 1 shared pool kzekm heap descriptor 304
774 1 shared pool kzsrs filename 536
775 1 shared pool kzxslnfy: 0 304
776 1 shared pool latch classes 352
777 1 shared pool latch hash-value table 2328
778 1 shared pool latch nowait fails or sle 181600
779 1 shared pool latch recovery alignment 80
780 1 shared pool latch recovery structures 3608
781 1 shared pool latch wait-event table 2328
782 1 shared pool latches for protecting fs 960
783 1 shared pool latches for protecting ls 480
784 1 shared pool latches for protecting ws 960
785 1 shared pool latchnum to latch map 4656
786 1 shared pool list 4096
787 1 shared pool listener addresses 16
788 1 shared pool lm heartbeat 4184
789 1 shared pool locator state object 40680
790 1 shared pool lock state hash table 647680
791 1 shared pool log file size history arr 168
792 1 shared pool log_checkpoint_timeout 12360
793 1 shared pool log_simultaneous_copies 1728
794 1 shared pool logout storm management 1200
795 1 shared pool max allowable # log files 506400
796 1 shared pool media recovery state obje 10480
797 1 shared pool memory transfer history 19208
798 1 shared pool message pool context area 22960
799 1 shared pool message pool freequeue 1353408
800 1 shared pool messages 36000
801 1 shared pool modification 86016
802 1 shared pool monitoring co 8320
803 1 shared pool msg Q child latches 448
804 1 shared pool multiblock re 8208
805 1 shared pool name-service 26208
806 1 shared pool name-service entry 3544
807 1 shared pool name-service recovery 3032
808 1 shared pool name-service request 2392
809 1 shared pool name-service table 16144
810 1 shared pool namhsh_kfdsg 4104
811 1 shared pool namhsh_kfgsg 288
812 1 shared pool namrec_kfdsg 24
813 1 shared pool network connections 66640
814 1 shared pool obj hash table pointers 176
815 1 shared pool obj stats allocation chun 2703360
816 1 shared pool obj stats hash table 704
817 1 shared pool object level stat table 1056
818 1 shared pool object queue 66560
819 1 shared pool object queue hash buckets 589824
820 1 shared pool object queue hash table d 16128
821 1 shared pool os statistics 16472
822 1 shared pool osp allocation 28104
823 1 shared pool osp pool handles 8
824 1 shared pool parallel kcbibr 32
825 1 shared pool parallel kcbibr dbwr bitv 8
826 1 shared pool parallel_max_servers 17280
827 1 shared pool param hash values 11656
828 1 shared pool parameter blocks 23312
829 1 shared pool parameter handle 125120
830 1 shared pool parameter string values 209216
831 1 shared pool parameter table block 932480
832 1 shared pool parameter text value 7720
833 1 shared pool parameter value memory 1040
834 1 shared pool partitioned file hash buc 131072
835 1 shared pool partitioned file latches 20480
836 1 shared pool pending bcast scn array 72
837 1 shared pool per_pg_set_descriptor_arr 57344
838 1 shared pool peshm.c: Global_Sub_Heap 232
839 1 shared pool peshm.c:Global 4056
840 1 shared pool peshm.c:latch 160
841 1 shared pool pesldT03_Instance 36920
842 1 shared pool pesom.c: Global_Sub_Heap 232
843 1 shared pool pesom.c: Pesom_Global_Hea 232
844 1 shared pool pesom.c:Global 37336
845 1 shared pool pesom.c:Object 4056
846 1 shared pool pesom.c:latch array 960
847 1 shared pool pesom.c:subheap ds array 920
848 1 shared pool pkey history table 512000
849 1 shared pool plis struct 136
850 1 shared pool plugin datafile array 3616
851 1 shared pool plwppwp:PLW_STR_NEW_LEN_V 16
852 1 shared pool plwppwp:PLW_STR_NEW_VAL_V 32
853 1 shared pool plwppwp:garbage handle 32
854 1 shared pool plwspv:PLW_STR_NEW_VAL 16
855 1 shared pool poisoned memory 32768
856 1 shared pool policy hash table descrpt 280
857 1 shared pool post stats 1560
858 1 shared pool post/wait queues 38016
859 1 shared pool primem_kfmdsg 1032
860 1 shared pool prirec_kfmdsg 24
861 1 shared pool prmtzdini tz region 801416
862 1 shared pool process count for each CI 456
863 1 shared pool process group array 69904
864 1 shared pool processes 1200
865 1 shared pool procs: ksunfy 642000
866 1 shared pool procs_kfgbsg 4048
867 1 shared pool property service SO 4312
868 1 shared pool pso child tracebuf ptrs 1200
869 1 shared pool pso tbs: ksunfy 78000
870 1 shared pool pspool_kfsg 80
871 1 shared pool ptr to sessions under idl 32
872 1 shared pool qesbl old rows 1120
873 1 shared pool qesmmaInitialize: 112
874 1 shared pool qesmmaInitialize: ia_qesm 264
875 1 shared pool qesmmaInitialize: oa_qesm 112
876 1 shared pool qesmmaInitialize: pa_qesm 11088
877 1 shared pool qesmmaInitialize: ta_qesm 264
878 1 shared pool qksbgsg 152
879 1 shared pool qm_init_sga:qmdpsg 1064
880 1 shared pool qmps connections 65280
881 1 shared pool qmtb_init_data 1728
882 1 shared pool qtree_kwqbsgn 48
883 1 shared pool qtree_kwqbspse 48
884 1 shared pool qtree_kwqspqctx 48
885 1 shared pool quiesce system context 440
886 1 shared pool quiescing session 3928
887 1 shared pool recov_kgqbtctx 7320
888 1 shared pool recovery domain 91832
889 1 shared pool redo allocation latch(es) 320
890 1 shared pool relmd_ext 1224
891 1 shared pool replication session stats 1984
892 1 shared pool reservation state object 3056
893 1 shared pool reserved entries for all 5760
894 1 shared pool resize operation history 28808
895 1 shared pool resize request state obje 491200
896 1 shared pool resumable 3672
897 1 shared pool returns from remote ops 51200
898 1 shared pool row cache 8641136
899 1 shared pool row cache child latch 8320
900 1 shared pool rules engine aggregate st 1416
901 1 shared pool rules engine context 200
902 1 shared pool sched job queue 5752
903 1 shared pool sched job slv 14008
904 1 shared pool segmented arrays 19040
905 1 shared pool service names array 16
906 1 shared pool sess Q child latches 448
907 1 shared pool session idle latches 640
908 1 shared pool set_descriptor_array 256
909 1 shared pool sga blobs 32768
910 1 shared pool sga dev dict 56
911 1 shared pool sga listelement 2048
912 1 shared pool sga node map 16
913 1 shared pool sht bkt arr allo 11264
914 1 shared pool sim cache nbufs 640
915 1 shared pool sim cache sizes 640
916 1 shared pool sim kghx free lists 8
917 1 shared pool sim lru segments 5120
918 1 shared pool sim segment hits 5120
919 1 shared pool sim segment num bufs 2560
920 1 shared pool sim state object 96
921 1 shared pool sim trace buf 5144
922 1 shared pool sim trace buf context 200
923 1 shared pool sim_knlasg 1280
924 1 shared pool simulator hash buckets 66560
925 1 shared pool simulator latch/bucket st 29696
926 1 shared pool skgxp ANT slave netstat m 4184
927 1 shared pool slave class sga anchor 360
928 1 shared pool sort segment handle 2640
929 1 shared pool spfile cleanup structure 16760
930 1 shared pool sskgpwcr: Sem set array 8
931 1 shared pool standby event stats 1216
932 1 shared pool starting comp sizes snaps 144
933 1 shared pool stat hash values 2720
934 1 shared pool state objects 10520
935 1 shared pool statement queuing 2904
936 1 shared pool stfxtb stat table array 32
937 1 shared pool stfxtb statistics table 23744
938 1 shared pool sys event stats 656160
939 1 shared pool sys event stats for Other 43744
940 1 shared pool system default language h 568
941 1 shared pool tablespace encryption key 192
942 1 shared pool tablespace encryption mas 16
943 1 shared pool temp lob duration state o 3928
944 1 shared pool temporary foreign ref 3800
945 1 shared pool temporary tabl 4056
946 1 shared pool temporary table lock 2840
947 1 shared pool threshold ale 8064
948 1 shared pool time manager context 40
949 1 shared pool trace buf hdr xtend 208
950 1 shared pool trace buffer header array 208
951 1 shared pool trace events array 72000
952 1 shared pool trace_knlasg 504
953 1 shared pool transaction 685784
954 1 shared pool ts encryption key afn rev 3208
955 1 shared pool txncallback 74536
956 1 shared pool ufgtab_kfmdsg 25144
957 1 shared pool v_actinc 752
958 1 shared pool v_actprob 664
959 1 shared pool v_inc_meter_info_problem 664
960 1 shared pool v_inccount 664
961 1 shared pool v_incfcount 664
962 1 shared pool v_ipsprbcnt 664
963 1 shared pool v_ipsprbcnt1 664
964 1 shared pool v_nfcinc 848
965 1 shared pool v_swperrcount 664
966 1 shared pool value block f 31232
967 1 shared pool vem_user_actlog 664
968 1 shared pool vem_user_actlog1 664
969 1 shared pool vhm_run 2072
970 1 shared pool vinc_meter_info 1696
971 1 shared pool vincident 3296
972 1 shared pool vincident_file 1040
973 1 shared pool vips_file_copy_log 1696
974 1 shared pool vips_file_metadata 944
975 1 shared pool vips_package_file 1320
976 1 shared pool vips_package_history 1416
977 1 shared pool vips_package_incident_det 4992
978 1 shared pool vips_package_main_int 664
979 1 shared pool vips_package_main_problem 752
980 1 shared pool vips_package_size 664
981 1 shared pool vips_pkg_file 1600
982 1 shared pool vips_pkg_incident_candida 3296
983 1 shared pool vnot_exist_incident 3200
984 1 shared pool vproblem 2728
985 1 shared pool vproblem1 2544
986 1 shared pool vproblem2 2632
987 1 shared pool vproblem_bucket 848
988 1 shared pool vproblem_bucket1 848
989 1 shared pool vproblem_bucket_count 944
990 1 shared pool vproblem_int 2448
991 1 shared pool vproblem_lastinc 2352
992 1 shared pool vshowcatview 848
993 1 shared pool vshowincb 752
994 1 shared pool vshowincb_i 752
995 1 shared pool vtest_exists 1040
996 1 shared pool where to latch num map 11352
997 1 shared pool work area tab 264248
998 1 shared pool write info array 65536
999 1 shared pool write state object 1695840
1000 1 shared pool writes stopped lock conte 32
1001 1 shared pool writes stopped lock state 24
1002 1 shared pool x$ksmfs table 32
1003 1 shared pool x$ksxpif 2048
1004 1 shared pool x$ksxpif:ent 760
1005 1 shared pool x$rule_set 17608
1006 1 shared pool xscalc 4056
1007 1 shared pool xslongops 14776
1008 1 shared pool xssinfo 6008
1009 1 shared pool zafwctx 40608
1010 1 shared pool zasasga 8
1011 1 buffer_cache 260046848
1012 1 fixed_sga 2257272
1013 1 log_buffer 6828032
# Inst Pool Name Bytes

System Global Area (SGA) Statistics History

Collected from DBA_HIST_SGASTAT.
This section includes data captured by AWR.
# Inst Pool Name Min Bytes Max Bytes Avg Bytes
# Inst Pool Name Min Bytes Max Bytes Avg Bytes

System Parameters with Non-Default or Modified Values

Collected from GV$SYSTEM_PARAMETER2 where isdefault = 'FALSE' OR ismodified != 'FALSE'.
"Is Default" = FALSE means the parameter was set in the spfile.
# Name Inst Ord Is
Default
Is
Modified
Value Display
Value
Description
1 audit_file_dest 1 1 FALSE FALSE /oracle/app/oracle/admin/orcl/adump Directory in which auditing files are to reside
2 audit_trail 1 1 FALSE FALSE OS enable system auditing
3 cluster_database 1 1 FALSE FALSE TRUE if TRUE startup in cluster database mode
4 compatible 1 1 FALSE FALSE 11.2.0.4.0 Database will be completely compatible with this software version
5 control_files 1 1 FALSE FALSE +DATA/orcl/controlfile/current.260.897348927 control file names list
6 db_block_size 1 1 FALSE FALSE 8192 Size of database block in bytes
7 db_create_file_dest 1 1 FALSE FALSE +DATA default database location
8 db_domain 1 1 FALSE FALSE directory part of global database name stored with CREATE DATABASE
9 db_name 1 1 FALSE FALSE orcl database name specified in CREATE DATABASE
10 diagnostic_dest 1 1 FALSE FALSE /oracle/app/oracle diagnostic base directory
11 dispatchers 1 1 FALSE FALSE (PROTOCOL=TCP) (SERVICE=orclXDB) specifications of dispatchers
12 fal_client 1 1 FALSE FALSE pridb FAL client
13 fal_server 1 1 FALSE FALSE stydb FAL server list
14 instance_number 1 1 FALSE FALSE 1 instance number
15 local_listener 1 1 TRUE MODIFIED (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.130)(PORT=1521)) local listener
16 log_archive_config 1 1 FALSE FALSE dg_config=(orcl,standby) log archive config parameter
17 log_archive_dest_1 1 1 FALSE FALSE location=+data valid_for=(all_logfiles,all_roles) db_unique_name=orcl archival destination #1 text string
18 log_archive_dest_2 1 1 FALSE FALSE service=stydb valid_for=(online_logfiles,primary_role) db_unique_name=standby archival destination #2 text string
19 memory_target 1 1 FALSE FALSE 780140544 744M Target size of Oracle SGA and PGA memory
20 open_cursors 1 1 FALSE FALSE 300 max # cursors per session
21 processes 1 1 FALSE FALSE 150 user processes
22 remote_listener 1 1 FALSE FALSE scan-ip:1521 remote listener
23 remote_login_passwordfile 1 1 FALSE FALSE EXCLUSIVE password file usage parameter
24 spfile 1 1 FALSE FALSE +DATA/orcl/spfileorcl.ora server parameter file
25 thread 1 1 FALSE FALSE 1 Redo thread to mount
26 undo_tablespace 1 1 FALSE FALSE UNDOTBS1 use/switch undo tablespace
# Name Inst Ord Is
Default
Is
Modified
Value Display
Value
Description

Instance Parameters

System Parameters collected from V$SYSTEM_PARAMETER2 for Instance number 1.
# Name Ord Is
Default
Is
Modified
Value Display
Value
Description
1 O7_DICTIONARY_ACCESSIBILITY 1 TRUE FALSE FALSE Version 7 Dictionary Accessibility Support
2 active_instance_count 0 TRUE FALSE number of active instances in the cluster database
3 aq_tm_processes 1 TRUE FALSE 1 number of AQ Time Managers to start
4 archive_lag_target 1 TRUE FALSE 0 Maximum number of seconds of redos the standby could lose
5 asm_diskgroups 0 TRUE FALSE disk groups to mount automatically
6 asm_diskstring 0 TRUE FALSE disk set locations for discovery
7 asm_power_limit 1 TRUE FALSE 1 number of parallel relocations for disk rebalancing
8 asm_preferred_read_failure_groups 0 TRUE FALSE preferred read failure groups
9 audit_file_dest 1 FALSE FALSE /oracle/app/oracle/admin/orcl/adump Directory in which auditing files are to reside
10 audit_sys_operations 1 TRUE FALSE FALSE enable sys auditing
11 audit_syslog_level 0 TRUE FALSE Syslog facility and level
12 audit_trail 1 FALSE FALSE OS enable system auditing
13 awr_snapshot_time_offset 1 TRUE FALSE 0 Setting for AWR Snapshot Time Offset
14 background_core_dump 1 TRUE FALSE partial Core Size for Background Processes
15 background_dump_dest 1 TRUE FALSE /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace Detached process dump directory
16 backup_tape_io_slaves 1 TRUE FALSE FALSE BACKUP Tape I/O slaves
17 bitmap_merge_area_size 1 TRUE FALSE 1048576 maximum memory allow for BITMAP MERGE
18 blank_trimming 1 TRUE FALSE FALSE blank trimming semantics parameter
19 buffer_pool_keep 1 TRUE FALSE Number of database blocks/latches in keep buffer pool
20 buffer_pool_recycle 1 TRUE FALSE Number of database blocks/latches in recycle buffer pool
21 cell_offload_compaction 1 TRUE FALSE ADAPTIVE Cell packet compaction strategy
22 cell_offload_decryption 1 TRUE FALSE TRUE enable SQL processing offload of encrypted data to cells
23 cell_offload_parameters 1 TRUE FALSE Additional cell offload parameters
24 cell_offload_plan_display 1 TRUE FALSE AUTO Cell offload explain plan display
25 cell_offload_processing 1 TRUE FALSE TRUE enable SQL processing offload to cells
26 cell_offloadgroup_name 0 TRUE FALSE Set the offload group name
27 circuits 0 TRUE FALSE max number of circuits
28 client_result_cache_lag 1 TRUE FALSE 3000 client result cache maximum lag in milliseconds
29 client_result_cache_size 1 TRUE FALSE 0 client result cache max size in bytes
30 clonedb 1 TRUE FALSE FALSE clone database
31 cluster_database 1 FALSE FALSE TRUE if TRUE startup in cluster database mode
32 cluster_database_instances 1 TRUE FALSE 2 number of instances to use for sizing cluster db SGA structures
33 cluster_interconnects 0 TRUE FALSE interconnects for RAC use
34 commit_logging 0 TRUE FALSE transaction commit log write behaviour
35 commit_point_strength 1 TRUE FALSE 1 Bias this node has toward not preparing in a two-phase commit
36 commit_wait 0 TRUE FALSE transaction commit log wait behaviour
37 commit_write 0 TRUE FALSE transaction commit log write behaviour
38 compatible 1 FALSE FALSE 11.2.0.4.0 Database will be completely compatible with this software version
39 control_file_record_keep_time 1 TRUE FALSE 7 control file record keep time in days
40 control_files 1 FALSE FALSE +DATA/orcl/controlfile/current.260.897348927 control file names list
41 control_management_pack_access 1 TRUE FALSE DIAGNOSTIC+TUNING declares which manageability packs are enabled
42 core_dump_dest 1 TRUE FALSE /oracle/app/oracle/diag/rdbms/orcl/orcl1/cdump Core dump directory
43 cpu_count 1 TRUE FALSE 4 number of CPUs for this instance
44 create_bitmap_area_size 1 TRUE FALSE 8388608 size of create bitmap buffer for bitmap index
45 create_stored_outlines 0 TRUE FALSE create stored outlines for DML statements
46 cursor_bind_capture_destination 1 TRUE FALSE memory+disk Allowed destination for captured bind variables
47 cursor_sharing 1 TRUE FALSE EXACT cursor sharing mode
48 cursor_space_for_time 1 TRUE FALSE FALSE use more memory in order to get faster execution
49 db_16k_cache_size 1 TRUE FALSE 0 Size of cache for 16K buffers
50 db_2k_cache_size 1 TRUE FALSE 0 Size of cache for 2K buffers
51 db_32k_cache_size 1 TRUE FALSE 0 Size of cache for 32K buffers
52 db_4k_cache_size 1 TRUE FALSE 0 Size of cache for 4K buffers
53 db_8k_cache_size 1 TRUE FALSE 0 Size of cache for 8K buffers
54 db_block_buffers 1 TRUE FALSE 0 Number of database blocks cached in memory
55 db_block_checking 1 TRUE FALSE FALSE header checking and data and index block checking
56 db_block_checksum 1 TRUE FALSE TYPICAL store checksum in db blocks and check during reads
57 db_block_size 1 FALSE FALSE 8192 Size of database block in bytes
58 db_cache_advice 1 TRUE FALSE ON Buffer cache sizing advisory
59 db_cache_size 1 TRUE FALSE 0 Size of DEFAULT buffer pool for standard block size buffers
60 db_create_file_dest 1 FALSE FALSE +DATA default database location
61 db_create_online_log_dest_1 1 TRUE FALSE online log/controlfile destination #1
62 db_create_online_log_dest_2 1 TRUE FALSE online log/controlfile destination #2
63 db_create_online_log_dest_3 1 TRUE FALSE online log/controlfile destination #3
64 db_create_online_log_dest_4 1 TRUE FALSE online log/controlfile destination #4
65 db_create_online_log_dest_5 1 TRUE FALSE online log/controlfile destination #5
66 db_domain 1 FALSE FALSE directory part of global database name stored with CREATE DATABASE
67 db_file_multiblock_read_count 1 TRUE FALSE 90 db block to be read each IO
68 db_file_name_convert 0 TRUE FALSE datafile name convert patterns and strings for standby/clone db
69 db_files 1 TRUE FALSE 200 max allowable # db files
70 db_flash_cache_file 1 TRUE FALSE flash cache file for default block size
71 db_flash_cache_size 1 TRUE FALSE 0 flash cache size for db_flash_cache_file
72 db_flashback_retention_target 1 TRUE FALSE 1440 Maximum Flashback Database log retention time in minutes.
73 db_keep_cache_size 1 TRUE FALSE 0 Size of KEEP buffer pool for standard block size buffers
74 db_lost_write_protect 1 TRUE FALSE NONE enable lost write detection
75 db_name 1 FALSE FALSE orcl database name specified in CREATE DATABASE
76 db_recovery_file_dest 1 TRUE FALSE default database recovery file location
77 db_recovery_file_dest_size 1 TRUE FALSE 0 database recovery files size limit
78 db_recycle_cache_size 1 TRUE FALSE 0 Size of RECYCLE buffer pool for standard block size buffers
79 db_securefile 1 TRUE FALSE PERMITTED permit securefile storage during lob creation
80 db_ultra_safe 1 TRUE FALSE OFF Sets defaults for other parameters that control protection levels
81 db_unique_name 1 TRUE FALSE orcl Database Unique Name
82 db_unrecoverable_scn_tracking 1 TRUE FALSE TRUE Track nologging SCN in controlfile
83 db_writer_processes 1 TRUE FALSE 1 number of background database writer processes to start
84 dbwr_io_slaves 1 TRUE FALSE 0 DBWR I/O slaves
85 ddl_lock_timeout 1 TRUE FALSE 0 timeout to restrict the time that ddls wait for dml lock
86 deferred_segment_creation 1 TRUE FALSE TRUE defer segment creation to first insert
87 dg_broker_config_file1 1 TRUE FALSE /oracle/app/oracle/product/11.2.0/db/dbs/dr1orcl.dat data guard broker configuration file #1
88 dg_broker_config_file2 1 TRUE FALSE /oracle/app/oracle/product/11.2.0/db/dbs/dr2orcl.dat data guard broker configuration file #2
89 dg_broker_start 1 TRUE FALSE FALSE start Data Guard broker (DMON process)
90 diagnostic_dest 1 FALSE FALSE /oracle/app/oracle diagnostic base directory
91 disk_asynch_io 1 TRUE FALSE TRUE Use asynch I/O for random access devices
92 dispatchers 1 FALSE FALSE (PROTOCOL=TCP) (SERVICE=orclXDB) specifications of dispatchers
93 distributed_lock_timeout 1 TRUE FALSE 60 number of seconds a distributed transaction waits for a lock
94 dml_locks 1 TRUE FALSE 1088 dml locks - one for each table modified in a transaction
95 dnfs_batch_size 1 TRUE FALSE 4096 Max number of dNFS asynch I/O requests queued per session
96 dst_upgrade_insert_conv 1 TRUE FALSE TRUE Enables/Disables internal conversions during DST upgrade
97 enable_ddl_logging 1 TRUE FALSE FALSE enable ddl logging
98 enable_goldengate_replication 1 TRUE FALSE FALSE goldengate replication enabled
99 event 1 TRUE FALSE debug event control - default null string
100 fal_client 1 FALSE FALSE pridb FAL client
101 fal_server 1 FALSE FALSE stydb FAL server list
102 fast_start_io_target 1 TRUE FALSE 0 Upper bound on recovery reads
103 fast_start_mttr_target 1 TRUE FALSE 0 MTTR target in seconds
104 fast_start_parallel_rollback 1 TRUE FALSE LOW max number of parallel recovery slaves that may be used
105 file_mapping 1 TRUE FALSE FALSE enable file mapping
106 fileio_network_adapters 0 TRUE FALSE Network Adapters for File I/O
107 filesystemio_options 1 TRUE FALSE none IO operations on filesystem files
108 fixed_date 1 TRUE FALSE fixed SYSDATE value
109 gcs_server_processes 1 TRUE FALSE 2 number of background gcs server processes to start
110 global_context_pool_size 1 TRUE FALSE Global Application Context Pool Size in Bytes
111 global_names 1 TRUE FALSE FALSE enforce that database links have same name as remote database
112 global_txn_processes 1 TRUE FALSE 1 number of background global transaction processes to start
113 hash_area_size 1 TRUE FALSE 131072 size of in-memory hash work area
114 hi_shared_memory_address 1 TRUE FALSE 0 SGA starting address (high order 32-bits on 64-bit platforms)
115 hs_autoregister 1 TRUE FALSE TRUE enable automatic server DD updates in HS agent self-registration
116 ifile 0 TRUE FALSE include file in init.ora
117 instance_groups 0 TRUE FALSE list of instance group names
118 instance_name 1 TRUE FALSE orcl1 instance name supported by the instance
119 instance_number 1 FALSE FALSE 1 instance number
120 instance_type 1 TRUE FALSE RDBMS type of instance to be executed
121 instant_restore 1 TRUE FALSE FALSE instant repopulation of datafiles
122 java_jit_enabled 1 TRUE FALSE TRUE Java VM JIT enabled
123 java_max_sessionspace_size 1 TRUE FALSE 0 max allowed size in bytes of a Java sessionspace
124 java_pool_size 1 TRUE FALSE 0 size in bytes of java pool
125 java_restrict 1 TRUE FALSE none Restrict Java VM Access
126 java_soft_sessionspace_limit 1 TRUE FALSE 0 warning limit on size in bytes of a Java sessionspace
127 job_queue_processes 1 TRUE FALSE 1000 maximum number of job queue slave processes
128 large_pool_size 1 TRUE FALSE 0 size in bytes of large pool
129 ldap_directory_access 1 TRUE FALSE NONE RDBMS's LDAP access option
130 ldap_directory_sysauth 1 TRUE FALSE no OID usage parameter
131 license_max_sessions 1 TRUE FALSE 0 maximum number of non-system user sessions allowed
132 license_max_users 1 TRUE FALSE 0 maximum number of named users that can be created in the database
133 license_sessions_warning 1 TRUE FALSE 0 warning level for number of non-system user sessions
134 listener_networks 0 TRUE FALSE listener registration networks
135 local_listener 1 TRUE MODIFIED (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.133.130)(PORT=1521)) local listener
136 lock_name_space 0 TRUE FALSE lock name space used for generating lock names for standby/clone database
137 lock_sga 1 TRUE FALSE FALSE Lock entire SGA in physical memory
138 log_archive_config 1 FALSE FALSE dg_config=(orcl,standby) log archive config parameter
139 log_archive_dest 1 TRUE FALSE archival destination text string
140 log_archive_dest_1 1 FALSE FALSE location=+data valid_for=(all_logfiles,all_roles) db_unique_name=orcl archival destination #1 text string
141 log_archive_dest_10 1 TRUE FALSE archival destination #10 text string
142 log_archive_dest_11 1 TRUE FALSE archival destination #11 text string
143 log_archive_dest_12 1 TRUE FALSE archival destination #12 text string
144 log_archive_dest_13 1 TRUE FALSE archival destination #13 text string
145 log_archive_dest_14 1 TRUE FALSE archival destination #14 text string
146 log_archive_dest_15 1 TRUE FALSE archival destination #15 text string
147 log_archive_dest_16 1 TRUE FALSE archival destination #16 text string
148 log_archive_dest_17 1 TRUE FALSE archival destination #17 text string
149 log_archive_dest_18 1 TRUE FALSE archival destination #18 text string
150 log_archive_dest_19 1 TRUE FALSE archival destination #19 text string
151 log_archive_dest_2 1 FALSE FALSE service=stydb valid_for=(online_logfiles,primary_role) db_unique_name=standby archival destination #2 text string
152 log_archive_dest_20 1 TRUE FALSE archival destination #20 text string
153 log_archive_dest_21 1 TRUE FALSE archival destination #21 text string
154 log_archive_dest_22 1 TRUE FALSE archival destination #22 text string
155 log_archive_dest_23 1 TRUE FALSE archival destination #23 text string
156 log_archive_dest_24 1 TRUE FALSE archival destination #24 text string
157 log_archive_dest_25 1 TRUE FALSE archival destination #25 text string
158 log_archive_dest_26 1 TRUE FALSE archival destination #26 text string
159 log_archive_dest_27 1 TRUE FALSE archival destination #27 text string
160 log_archive_dest_28 1 TRUE FALSE archival destination #28 text string
161 log_archive_dest_29 1 TRUE FALSE archival destination #29 text string
162 log_archive_dest_3 1 TRUE FALSE archival destination #3 text string
163 log_archive_dest_30 1 TRUE FALSE archival destination #30 text string
164 log_archive_dest_31 1 TRUE FALSE archival destination #31 text string
165 log_archive_dest_4 1 TRUE FALSE archival destination #4 text string
166 log_archive_dest_5 1 TRUE FALSE archival destination #5 text string
167 log_archive_dest_6 1 TRUE FALSE archival destination #6 text string
168 log_archive_dest_7 1 TRUE FALSE archival destination #7 text string
169 log_archive_dest_8 1 TRUE FALSE archival destination #8 text string
170 log_archive_dest_9 1 TRUE FALSE archival destination #9 text string
171 log_archive_dest_state_1 1 TRUE FALSE enable archival destination #1 state text string
172 log_archive_dest_state_10 1 TRUE FALSE enable archival destination #10 state text string
173 log_archive_dest_state_11 1 TRUE FALSE enable archival destination #11 state text string
174 log_archive_dest_state_12 1 TRUE FALSE enable archival destination #12 state text string
175 log_archive_dest_state_13 1 TRUE FALSE enable archival destination #13 state text string
176 log_archive_dest_state_14 1 TRUE FALSE enable archival destination #14 state text string
177 log_archive_dest_state_15 1 TRUE FALSE enable archival destination #15 state text string
178 log_archive_dest_state_16 1 TRUE FALSE enable archival destination #16 state text string
179 log_archive_dest_state_17 1 TRUE FALSE enable archival destination #17 state text string
180 log_archive_dest_state_18 1 TRUE FALSE enable archival destination #18 state text string
181 log_archive_dest_state_19 1 TRUE FALSE enable archival destination #19 state text string
182 log_archive_dest_state_2 1 TRUE FALSE enable archival destination #2 state text string
183 log_archive_dest_state_20 1 TRUE FALSE enable archival destination #20 state text string
184 log_archive_dest_state_21 1 TRUE FALSE enable archival destination #21 state text string
185 log_archive_dest_state_22 1 TRUE FALSE enable archival destination #22 state text string
186 log_archive_dest_state_23 1 TRUE FALSE enable archival destination #23 state text string
187 log_archive_dest_state_24 1 TRUE FALSE enable archival destination #24 state text string
188 log_archive_dest_state_25 1 TRUE FALSE enable archival destination #25 state text string
189 log_archive_dest_state_26 1 TRUE FALSE enable archival destination #26 state text string
190 log_archive_dest_state_27 1 TRUE FALSE enable archival destination #27 state text string
191 log_archive_dest_state_28 1 TRUE FALSE enable archival destination #28 state text string
192 log_archive_dest_state_29 1 TRUE FALSE enable archival destination #29 state text string
193 log_archive_dest_state_3 1 TRUE FALSE enable archival destination #3 state text string
194 log_archive_dest_state_30 1 TRUE FALSE enable archival destination #30 state text string
195 log_archive_dest_state_31 1 TRUE FALSE enable archival destination #31 state text string
196 log_archive_dest_state_4 1 TRUE FALSE enable archival destination #4 state text string
197 log_archive_dest_state_5 1 TRUE FALSE enable archival destination #5 state text string
198 log_archive_dest_state_6 1 TRUE FALSE enable archival destination #6 state text string
199 log_archive_dest_state_7 1 TRUE FALSE enable archival destination #7 state text string
200 log_archive_dest_state_8 1 TRUE FALSE enable archival destination #8 state text string
201 log_archive_dest_state_9 1 TRUE FALSE enable archival destination #9 state text string
202 log_archive_duplex_dest 1 TRUE FALSE duplex archival destination text string
203 log_archive_format 1 TRUE FALSE %t_%s_%r.dbf archival destination format
204 log_archive_local_first 1 TRUE FALSE TRUE Establish EXPEDITE attribute default value
205 log_archive_max_processes 1 TRUE FALSE 4 maximum number of active ARCH processes
206 log_archive_min_succeed_dest 1 TRUE FALSE 1 minimum number of archive destinations that must succeed
207 log_archive_start 1 TRUE FALSE FALSE start archival process on SGA initialization
208 log_archive_trace 1 TRUE FALSE 0 Establish archivelog operation tracing level
209 log_buffer 1 TRUE FALSE 6520832 redo circular buffer size
210 log_checkpoint_interval 1 TRUE FALSE 0 # redo blocks checkpoint threshold
211 log_checkpoint_timeout 1 TRUE FALSE 1800 Maximum time interval between checkpoints in seconds
212 log_checkpoints_to_alert 1 TRUE FALSE FALSE log checkpoint begin/end to alert file
213 log_file_name_convert 0 TRUE FALSE logfile name convert patterns and strings for standby/clone db
214 max_dispatchers 0 TRUE FALSE max number of dispatchers
215 max_dump_file_size 1 TRUE FALSE unlimited Maximum size (in bytes) of dump file
216 max_enabled_roles 1 TRUE FALSE 150 max number of roles a user can have enabled
217 max_shared_servers 0 TRUE FALSE max number of shared servers
218 memory_max_target 1 TRUE FALSE 780140544 744M Max size for Memory Target
219 memory_target 1 FALSE FALSE 780140544 744M Target size of Oracle SGA and PGA memory
220 nls_calendar 1 TRUE FALSE NLS calendar system name
221 nls_comp 1 TRUE FALSE BINARY NLS comparison
222 nls_currency 1 TRUE FALSE NLS local currency symbol
223 nls_date_format 1 TRUE FALSE NLS Oracle date format
224 nls_date_language 1 TRUE FALSE NLS date language name
225 nls_dual_currency 1 TRUE FALSE Dual currency symbol
226 nls_iso_currency 1 TRUE FALSE NLS ISO currency territory name
227 nls_language 1 TRUE FALSE AMERICAN NLS language name
228 nls_length_semantics 1 TRUE FALSE BYTE create columns using byte or char semantics by default
229 nls_nchar_conv_excp 1 TRUE FALSE FALSE NLS raise an exception instead of allowing implicit conversion
230 nls_numeric_characters 1 TRUE FALSE NLS numeric characters
231 nls_sort 1 TRUE FALSE NLS linguistic definition name
232 nls_territory 1 TRUE FALSE AMERICA NLS territory name
233 nls_time_format 1 TRUE FALSE time format
234 nls_time_tz_format 1 TRUE FALSE time with timezone format
235 nls_timestamp_format 1 TRUE FALSE time stamp format
236 nls_timestamp_tz_format 1 TRUE FALSE timestamp with timezone format
237 object_cache_max_size_percent 1 TRUE FALSE 10 percentage of maximum size over optimal of the user session's object cache
238 object_cache_optimal_size 1 TRUE FALSE 102400 optimal size of the user session's object cache in bytes
239 olap_page_pool_size 1 TRUE FALSE 0 size of the olap page pool in bytes
240 open_cursors 1 FALSE FALSE 300 max # cursors per session
241 open_links 1 TRUE FALSE 4 max # open links per session
242 open_links_per_instance 1 TRUE FALSE 4 max # open links per instance
243 optimizer_capture_sql_plan_baselines 1 TRUE FALSE FALSE automatic capture of SQL plan baselines for repeatable statements
244 optimizer_dynamic_sampling 1 TRUE FALSE 2 optimizer dynamic sampling
245 optimizer_features_enable 1 TRUE FALSE 11.2.0.4 optimizer plan compatibility parameter
246 optimizer_index_caching 1 TRUE FALSE 0 optimizer percent index caching
247 optimizer_index_cost_adj 1 TRUE FALSE 100 optimizer index cost adjustment
248 optimizer_mode 1 TRUE FALSE ALL_ROWS optimizer mode
249 optimizer_secure_view_merging 1 TRUE FALSE TRUE optimizer secure view merging and predicate pushdown/movearound
250 optimizer_use_invisible_indexes 1 TRUE FALSE FALSE Usage of invisible indexes (TRUE/FALSE)
251 optimizer_use_pending_statistics 1 TRUE FALSE FALSE Control whether to use optimizer pending statistics
252 optimizer_use_sql_plan_baselines 1 TRUE FALSE TRUE use of SQL plan baselines for captured sql statements
253 os_authent_prefix 1 TRUE FALSE ops$ prefix for auto-logon accounts
254 os_roles 1 TRUE FALSE FALSE retrieve roles from the operating system
255 parallel_adaptive_multi_user 1 TRUE FALSE TRUE enable adaptive setting of degree for multiple user streams
256 parallel_automatic_tuning 1 TRUE FALSE FALSE enable intelligent defaults for parallel execution parameters
257 parallel_degree_limit 1 TRUE FALSE CPU limit placed on degree of parallelism
258 parallel_degree_policy 1 TRUE FALSE MANUAL policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)
259 parallel_execution_message_size 1 TRUE FALSE 16384 message buffer size for parallel execution
260 parallel_force_local 1 TRUE FALSE FALSE force single instance execution
261 parallel_instance_group 1 TRUE FALSE instance group to use for all parallel operations
262 parallel_io_cap_enabled 1 TRUE FALSE FALSE enable capping DOP by IO bandwidth
263 parallel_max_servers 1 TRUE FALSE 120 maximum parallel query servers per instance
264 parallel_min_percent 1 TRUE FALSE 0 minimum percent of threads required for parallel query
265 parallel_min_servers 1 TRUE FALSE 0 minimum parallel query servers per instance
266 parallel_min_time_threshold 1 TRUE FALSE AUTO threshold above which a plan is a candidate for parallelization (in seconds)
267 parallel_server 1 TRUE FALSE TRUE if TRUE startup in parallel server mode
268 parallel_server_instances 1 TRUE FALSE 2 number of instances to use for sizing OPS SGA structures
269 parallel_servers_target 1 TRUE FALSE 64 instance target in terms of number of parallel servers
270 parallel_threads_per_cpu 1 TRUE FALSE 2 number of parallel execution threads per CPU
271 permit_92_wrap_format 1 TRUE FALSE TRUE allow 9.2 or older wrap format in PL/SQL
272 pga_aggregate_target 1 TRUE FALSE 0 Target size for the aggregate PGA memory consumed by the instance
273 plscope_settings 1 TRUE FALSE IDENTIFIERS:NONE plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data
274 plsql_ccflags 1 TRUE FALSE PL/SQL ccflags
275 plsql_code_type 1 TRUE FALSE INTERPRETED PL/SQL code-type
276 plsql_debug 1 TRUE FALSE FALSE PL/SQL debug
277 plsql_optimize_level 1 TRUE FALSE 2 PL/SQL optimize level
278 plsql_v2_compatibility 1 TRUE FALSE FALSE PL/SQL version 2.x compatibility flag
279 plsql_warnings 1 TRUE FALSE DISABLE:ALL PL/SQL compiler warnings settings
280 pre_page_sga 1 TRUE FALSE FALSE pre-page sga for process
281 processes 1 FALSE FALSE 150 user processes
282 processor_group_name 0 TRUE FALSE Name of the processor group that this instance should run in.
283 query_rewrite_enabled 1 TRUE FALSE TRUE allow rewrite of queries using materialized views if enabled
284 query_rewrite_integrity 1 TRUE FALSE enforced perform rewrite using materialized views with desired integrity
285 rdbms_server_dn 1 TRUE FALSE RDBMS's Distinguished Name
286 read_only_open_delayed 1 TRUE FALSE FALSE if TRUE delay opening of read only files until first access
287 recovery_parallelism 1 TRUE FALSE 0 number of server processes to use for parallel recovery
288 recyclebin 1 TRUE FALSE on recyclebin processing
289 redo_transport_user 1 TRUE FALSE Data Guard transport user when using password file
290 remote_dependencies_mode 1 TRUE FALSE TIMESTAMP remote-procedure-call dependencies mode parameter
291 remote_listener 1 FALSE FALSE scan-ip:1521 remote listener
292 remote_login_passwordfile 1 FALSE FALSE EXCLUSIVE password file usage parameter
293 remote_os_authent 1 TRUE FALSE FALSE allow non-secure remote clients to use auto-logon accounts
294 remote_os_roles 1 TRUE FALSE FALSE allow non-secure remote clients to use os roles
295 replication_dependency_tracking 1 TRUE FALSE TRUE tracking dependency for Replication parallel propagation
296 resource_limit 1 TRUE FALSE FALSE master switch for resource limit
297 resource_manager_cpu_allocation 1 TRUE FALSE 4 Resource Manager CPU allocation
298 resource_manager_plan 0 TRUE FALSE resource mgr top plan
299 result_cache_max_result 1 TRUE FALSE 5 maximum result size as percent of cache size
300 result_cache_max_size 1 TRUE FALSE 1966080 1920K maximum amount of memory to be used by the cache
301 result_cache_mode 1 TRUE FALSE MANUAL result cache operator usage mode
302 result_cache_remote_expiration 1 TRUE FALSE 0 maximum life time (min) for any result using a remote object
303 resumable_timeout 1 TRUE FALSE 0 set resumable_timeout
304 rollback_segments 0 TRUE FALSE undo segment list
305 sec_case_sensitive_logon 1 TRUE FALSE TRUE case sensitive password enabled for logon
306 sec_max_failed_login_attempts 1 TRUE FALSE 10 maximum number of failed login attempts on a connection
307 sec_protocol_error_further_action 1 TRUE FALSE CONTINUE TTC protocol error continue action
308 sec_protocol_error_trace_action 1 TRUE FALSE TRACE TTC protocol error action
309 sec_return_server_release_banner 1 TRUE FALSE FALSE whether the server retruns the complete version information
310 serial_reuse 1 TRUE FALSE disable reuse the frame segments
311 service_names 1 TRUE FALSE orcl service names supported by the instance
312 session_cached_cursors 1 TRUE FALSE 50 Number of cursors to cache in a session.
313 session_max_open_files 1 TRUE FALSE 10 maximum number of open files allowed per session
314 sessions 1 TRUE FALSE 248 user and system sessions
315 sga_max_size 1 TRUE FALSE 780140544 744M max total SGA size
316 sga_target 1 TRUE FALSE 0 Target size of SGA
317 shadow_core_dump 1 TRUE FALSE partial Core Size for Shadow Processes
318 shared_memory_address 1 TRUE FALSE 0 SGA starting address (low order 32-bits on 64-bit platforms)
319 shared_pool_reserved_size 1 TRUE FALSE 9017753 size in bytes of reserved area of shared pool
320 shared_pool_size 1 TRUE FALSE 0 size in bytes of shared pool
321 shared_server_sessions 0 TRUE FALSE max number of shared server sessions
322 shared_servers 1 TRUE FALSE 1 number of shared servers to start up
323 skip_unusable_indexes 1 TRUE FALSE TRUE skip unusable indexes if set to TRUE
324 smtp_out_server 0 TRUE FALSE utl_smtp server and port configuration parameter
325 sort_area_retained_size 1 TRUE FALSE 0 size of in-memory sort work area retained between fetch calls
326 sort_area_size 1 TRUE FALSE 65536 size of in-memory sort work area
327 spfile 1 FALSE FALSE +DATA/orcl/spfileorcl.ora server parameter file
328 sql92_security 1 TRUE FALSE FALSE require select privilege for searched update/delete
329 sql_trace 1 TRUE FALSE FALSE enable SQL trace
330 sqltune_category 1 TRUE FALSE DEFAULT Category qualifier for applying hintsets
331 standby_archive_dest 1 TRUE FALSE ?/dbs/arch standby database archivelog destination text string
332 standby_file_management 1 TRUE FALSE MANUAL if auto then files are created/dropped automatically on standby
333 star_transformation_enabled 1 TRUE FALSE FALSE enable the use of star transformation
334 statistics_level 1 TRUE FALSE TYPICAL statistics level
335 streams_pool_size 1 TRUE FALSE 0 size in bytes of the streams pool
336 tape_asynch_io 1 TRUE FALSE TRUE Use asynch I/O requests for tape devices
337 thread 1 FALSE FALSE 1 Redo thread to mount
338 timed_os_statistics 1 TRUE FALSE 0 internal os statistic gathering interval in seconds
339 timed_statistics 1 TRUE FALSE TRUE maintain internal timing statistics
340 trace_enabled 1 TRUE FALSE TRUE enable in memory tracing
341 tracefile_identifier 0 TRUE FALSE trace file custom identifier
342 transactions 1 TRUE FALSE 272 max. number of concurrent active transactions
343 transactions_per_rollback_segment 1 TRUE FALSE 5 number of active transactions per rollback segment
344 undo_management 1 TRUE FALSE AUTO instance runs in SMU mode if TRUE, else in RBU mode
345 undo_retention 1 TRUE FALSE 900 undo retention in seconds
346 undo_tablespace 1 FALSE FALSE UNDOTBS1 use/switch undo tablespace
347 use_indirect_data_buffers 1 TRUE FALSE FALSE Enable indirect data buffers (very large SGA on 32-bit platforms)
348 use_large_pages 1 TRUE FALSE TRUE Use large pages if available (TRUE/FALSE/ONLY)
349 user_dump_dest 1 TRUE FALSE /oracle/app/oracle/diag/rdbms/orcl/orcl1/trace User process dump directory
350 utl_file_dir 0 TRUE FALSE utl_file accessible directories list
351 workarea_size_policy 1 TRUE FALSE AUTO policy used to size SQL working areas (MANUAL/AUTO)
352 xml_db_events 1 TRUE FALSE enable are XML DB events enabled
# Name Ord Is
Default
Is
Modified
Value Display
Value
Description

SQL Monitor

Collected from GV$SQL_MONITOR where process_name = 'ora' and px_servers_requested > 1.
This section includes data from the Oracle Tuning pack.
Note: Ignore possible errors about gv$sql_monitor on 10g:
# Inst Status First Refresh Last Refresh SQL_ID Plan
Hash
Value
PX
Max
DOP
PX
Max
DOP
Inst
PX
Servers
Requested
PX
Servers
Allocated
Elapsed
Time
(secs)
Queuing
Time
(secs)
# Inst Status First Refresh Last Refresh SQL_ID Plan
Hash
Value
PX
Max
DOP
PX
Max
DOP
Inst
PX
Servers
Requested
PX
Servers
Allocated
Elapsed
Time
(secs)
Queuing
Time
(secs)

Version Count as per Cursor Sharing

Collected from GV$SQL_SHARED_CURSOR.
Inst Between
1 and 4
Between
5 and 8
Between
9 and 16
Between
17 and 32
Between
33 and 64
Between
65 and 128
Between
129 and 256
Between
257 and 512
Between
513 and 1024
Between
1025 and 2048
More Than
2048
1 277 0 0 0 0 0 0 0 0 0 0
Inst Between
1 and 4
Between
5 and 8
Between
9 and 16
Between
17 and 32
Between
33 and 64
Between
65 and 128
Between
129 and 256
Between
257 and 512
Between
513 and 1024
Between
1025 and 2048
More Than
2048

Cursor Sharing and Reason

Collected from GV$SQL_SHARED_CURSOR.
# Reason Inst Cursors
1 BIND_MISMATCH 1 1
2 OPTIMIZER_MISMATCH 1 34
3 SQL_TYPE_MISMATCH 1 2
4 STATS_ROW_MISMATCH 1 2
5 USE_FEEDBACK_STATS 1 7
# Reason Inst Cursors

1460440.1 PXHCDR 11.4.5.8 2018-01-25/16:43:46