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
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 |
# | Inst | Name |
---|---|---|
1 | 1 | PARALLEL_DEGREE_LIMIT_ABSOLUTE |
# | Inst | Name |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | 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 |
# | Save Time | Name | Value |
---|---|---|---|
# | Save Time | Name | Value |
# | 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 |
# | Inst | Pool | Name | Min Bytes | Max Bytes | Avg Bytes |
---|---|---|---|---|---|---|
# | Inst | Pool | Name | Min Bytes | Max Bytes | Avg Bytes |
# | 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 |
# | 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 |
# | 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) |
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 |
# | 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 |