SHOW:
|
|
- or go back to the newest paste.
1 | SQL> select * from v$version; | |
2 | ||
3 | BANNER | |
4 | -------------------------------------------------------------------------------- | |
5 | Oracle Database 11g Release 11.2.0.1.0 - 64bit Production | |
6 | PL/SQL Release 11.2.0.1.0 - Production | |
7 | CORE 11.2.0.1.0 Production | |
8 | TNS for Linux: Version 11.2.0.1.0 - Production | |
9 | NLSRTL Version 11.2.0.1.0 - Production | |
10 | ||
11 | 5 rows selected. | |
12 | ||
13 | SQL> @core_demo_02b.sql | |
14 | ||
15 | PL/SQL procedure successfully completed. | |
16 | ||
17 | ||
18 | ||
19 | ||
20 | ||
21 | Session altered. | |
22 | ||
23 | ||
24 | PL/SQL procedure successfully completed. | |
25 | ||
26 | ||
27 | Table dropped. | |
28 | ||
29 | ||
30 | PL/SQL procedure successfully completed. | |
31 | ||
32 | ||
33 | Table created. | |
34 | ||
35 | ||
36 | Index created. | |
37 | ||
38 | ||
39 | PL/SQL procedure successfully completed. | |
40 | ||
41 | ||
42 | BLOCK_NUMBER ROWS_PER_BLOCK | |
43 | ------------ -------------- | |
44 | 132 60 | |
45 | 133 60 | |
46 | ||
47 | 2 rows selected. | |
48 | ||
49 | ||
50 | System altered. | |
51 | ||
52 | ||
53 | PL/SQL procedure successfully completed. | |
54 | ||
55 | ||
56 | PL/SQL procedure successfully completed. | |
57 | ||
58 | ||
59 | PL/SQL procedure successfully completed. | |
60 | ||
61 | ||
62 | PL/SQL procedure successfully completed. | |
63 | ||
64 | ||
65 | PL/SQL procedure successfully completed. | |
66 | ||
67 | ||
68 | PL/SQL procedure successfully completed. | |
69 | ||
70 | ||
71 | PL/SQL procedure successfully completed. | |
72 | ||
73 | ||
74 | 50 rows updated. | |
75 | ||
76 | --------------------------------- | |
77 | Latch waits:- 22-Apr 20:18:32 | |
78 | Interval:- 0 seconds | |
79 | --------------------------------- | |
80 | Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken Time ms | |
81 | ----- ---- ------ ------ ------ ------- ------- ------- ----- ------- | |
82 | post/wait queue 1 0 0 0 0 0 0 0 .0 | |
83 | test excl. parent l0 1 0 0 0 0 0 0 0 .0 | |
84 | test excl. parent2 l0 1 0 0 0 0 0 0 0 .0 | |
85 | session allocation 5 0 0 0 0 0 0 0 .0 | |
86 | session switching 1 0 0 0 0 0 0 0 .0 | |
87 | session idle bit 52 0 0 0 0 0 0 0 .0 | |
88 | client/application info 1 0 0 0 0 0 0 0 .0 | |
89 | longop free list parent 1 0 0 0 0 0 0 0 .0 | |
90 | object stats modificatio 1 0 0 0 0 0 0 0 .0 | |
91 | kss move lock 1 0 0 0 0 0 0 0 .0 | |
92 | enqueues 2 0 0 0 0 0 0 0 .0 | |
93 | enqueue hash chains 5 0 0 0 0 0 0 0 .0 | |
94 | ksfv messages 1 0 0 0 0 0 0 0 .0 | |
95 | msg queue latch 1 0 0 0 0 0 0 0 .0 | |
96 | done queue latch 1 0 0 0 0 0 0 0 .0 | |
97 | session queue latch 1 0 0 0 0 0 0 0 .0 | |
98 | channel handle pool latc 1 0 0 0 0 0 0 0 .0 | |
99 | channel operations paren 1 0 0 0 0 0 0 0 .0 | |
100 | message pool operations 1 0 0 0 0 0 0 0 .0 | |
101 | ksv class latch 1 0 0 0 0 0 0 0 .0 | |
102 | ksv msg queue latch 1 0 0 0 0 0 0 0 .0 | |
103 | second spare latch 1 0 0 0 0 0 0 0 .0 | |
104 | third spare latch 1 0 0 0 0 0 0 0 .0 | |
105 | fifth spare latch 1 0 0 0 0 0 0 0 .0 | |
106 | IPC stats buffer allocat 1 0 0 0 0 0 0 0 .0 | |
107 | granule operation 1 0 0 0 0 0 0 0 .0 | |
108 | OS process 1 0 0 0 0 0 0 0 .0 | |
109 | ges process parent latch 1 0 0 0 0 0 0 0 .0 | |
110 | ges process hash list 1 0 0 0 0 0 0 0 .0 | |
111 | ges resource table freel 1 0 0 0 0 0 0 0 .0 | |
112 | ges resource hash list 1 0 0 0 0 0 0 0 .0 | |
113 | ges resource scan list 1 0 0 0 0 0 0 0 .0 | |
114 | ges enqueue table freeli 1 0 0 0 0 0 0 0 .0 | |
115 | KJC message pool free li 1 0 0 0 0 0 0 0 .0 | |
116 | KJCT flow control latch 1 0 0 0 0 0 0 0 .0 | |
117 | ges domain table 1 0 0 0 0 0 0 0 .0 | |
118 | ges group table 1 0 0 0 0 0 0 0 .0 | |
119 | gcs resource hash 1 0 0 0 0 0 0 0 .0 | |
120 | gcs resource freelist 1 0 0 0 0 0 0 0 .0 | |
121 | gcs resource scan list 1 0 0 0 0 0 0 0 .0 | |
122 | gcs shadows freelist 1 0 0 0 0 0 0 0 .0 | |
123 | gcs commit scn state 1 0 0 0 0 0 0 0 .0 | |
124 | name-service namespace b 1 0 0 0 0 0 0 0 .0 | |
125 | gcs partitioned table ha 1 0 0 0 0 0 0 0 .0 | |
126 | gcs pcm hashed value buc 1 0 0 0 0 0 0 0 .0 | |
127 | recovery domain hash lis 1 0 0 0 0 0 0 0 .0 | |
128 | ges value block free lis 1 0 0 0 0 0 0 0 .0 | |
129 | Testing 1 0 0 0 0 0 0 0 .0 | |
130 | heartbeat check 1 0 0 0 0 0 0 0 .0 | |
131 | Memory Management Latch 1 0 0 0 0 0 0 0 .0 | |
132 | cache buffers lru chain 1 0 0 0 0 0 0 0 .0 | |
133 | buffer pool 1 0 0 0 0 0 0 0 .0 | |
134 | checkpoint queue latch 1 0 0 0 2 0 0 0 .0 | |
135 | cache buffers chains 267 0 0 0 0 0 0 0 .0 | |
136 | tablespace key chain 1 0 0 0 0 0 0 0 .0 | |
137 | simulator lru latch 1 0 0 0 1 0 0 0 .0 | |
138 | simulator hash latch 2 0 0 0 0 0 0 0 .0 | |
139 | sim partition latch 1 0 0 0 0 0 0 0 .0 | |
140 | object queue header oper 4 0 0 0 0 0 0 0 .0 | |
141 | object queue header heap 1 0 0 0 0 0 0 0 .0 | |
142 | redo copy 1 0 0 0 50 0 0 0 .0 | |
143 | redo allocation 51 0 0 0 0 0 0 0 .0 | |
144 | gc element 1 0 0 0 0 0 0 0 .0 | |
145 | logminer work area 1 0 0 0 0 0 0 0 .0 | |
146 | logminer context allocat 1 0 0 0 0 0 0 0 .0 | |
147 | logical standby cache 1 0 0 0 0 0 0 0 .0 | |
148 | mapped buffers lru chain 1 0 0 0 0 0 0 0 .0 | |
149 | lock DBA buffer during m 1 0 0 0 0 0 0 0 .0 | |
150 | flashback copy 1 0 0 0 0 0 0 0 .0 | |
151 | cvmap freelist lock 1 0 0 0 0 0 0 0 .0 | |
152 | io pool granule metadata 1 0 0 0 0 0 0 0 .0 | |
153 | DML lock allocation 2 0 0 0 0 0 0 0 .0 | |
154 | transaction allocation 1 0 0 0 0 0 0 0 .0 | |
155 | dummy allocation 1 0 0 0 0 0 0 0 .0 | |
156 | undo global data 3 0 0 0 0 0 0 0 .0 | |
157 | intra txn parallel recov 1 0 0 0 0 0 0 0 .0 | |
158 | In memory undo latch 1 0 0 0 0 0 0 0 .0 | |
159 | change notification clie 1 0 0 0 0 0 0 0 .0 | |
160 | lob segment hash table l 1 0 0 0 0 0 0 0 .0 | |
161 | lob segment query latch 1 0 0 0 0 0 0 0 .0 | |
162 | lob segment dispenser la 1 0 0 0 0 0 0 0 .0 | |
163 | File State Object Pool P 1 0 0 0 0 0 0 0 .0 | |
164 | Write State Object Pool 1 0 0 0 0 0 0 0 .0 | |
165 | kdlx hb parent latch 1 0 0 0 0 0 0 0 .0 | |
166 | Locator state objects po 1 0 0 0 0 0 0 0 .0 | |
167 | row cache objects 235 0 0 0 0 0 0 0 .0 | |
168 | kks stats 8 0 0 0 0 0 0 0 .0 | |
169 | global tx hash mapping 1 0 0 0 0 0 0 0 .0 | |
170 | k2q lock allocation 1 0 0 0 0 0 0 0 .0 | |
171 | shared pool 95 0 0 0 0 0 0 0 .0 | |
172 | Token Manager 1 0 0 0 0 0 0 0 .0 | |
173 | cas latch 1 0 0 0 0 0 0 0 .0 | |
174 | rm cas latch 1 0 0 0 0 0 0 0 .0 | |
175 | resmgr:actses change sta 1 0 0 0 0 0 0 0 .0 | |
176 | resmgr:actses change gro 1 0 0 0 0 0 0 0 .0 | |
177 | resmgr:session queuing 1 0 0 0 0 0 0 0 .0 | |
178 | resmgr:plan CPU method 1 0 0 0 0 0 0 0 .0 | |
179 | resmgr:resource group CP 1 0 0 0 0 0 0 0 .0 | |
180 | QMT 1 0 0 0 0 0 0 0 .0 | |
181 | shared pool simulator 5 0 0 0 0 0 0 0 .0 | |
182 | shared pool sim alloc 1 0 0 0 0 0 0 0 .0 | |
183 | Streams Generic 1 0 0 0 0 0 0 0 .0 | |
184 | Shared B-Tree 1 0 0 0 0 0 0 0 .0 | |
185 | Memory Queue 1 0 0 0 0 0 0 0 .0 | |
186 | Memory Queue Subscriber 1 0 0 0 0 0 0 0 .0 | |
187 | Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0 | |
188 | Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0 | |
189 | Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0 | |
190 | Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0 | |
191 | pesom_hash_node 1 0 0 0 0 0 0 0 .0 | |
192 | pesom_free_list 1 0 0 0 0 0 0 0 .0 | |
193 | peshm 1 0 0 0 0 0 0 0 .0 | |
194 | Mutex 1 0 0 0 0 0 0 0 .0 | |
195 | Mutex Stats 1 0 0 0 0 0 0 0 .0 | |
196 | KGNFS-NFS:SHM structure 1 0 0 0 0 0 0 0 .0 | |
197 | KGNFS-NFS:SVR LIST 1 0 0 0 0 0 0 0 .0 | |
198 | SGA heap locks 1 0 0 0 0 0 0 0 .0 | |
199 | SGA pool locks 1 0 0 0 0 0 0 0 .0 | |
200 | SGA bucket locks 1 0 0 0 0 0 0 0 .0 | |
201 | SGA blob parent 1 0 0 0 0 0 0 0 .0 | |
202 | kgb parent 1 0 0 0 0 0 0 0 .0 | |
203 | Event Group Locks 1 0 0 0 0 0 0 0 .0 | |
204 | virtual circuit buffers 1 0 0 0 0 0 0 0 .0 | |
205 | virtual circuit queues 1 0 0 0 0 0 0 0 .0 | |
206 | virtual circuit holder 1 0 0 0 0 0 0 0 .0 | |
207 | cp server hash latch 1 0 0 0 0 0 0 0 .0 | |
208 | cp pool latch 1 0 0 0 0 0 0 0 .0 | |
209 | cp cmon/server latch 1 0 0 0 0 0 0 0 .0 | |
210 | job workq parent latch 1 0 0 0 0 0 0 0 .0 | |
211 | query server freelists 1 0 0 0 0 0 0 0 .0 | |
212 | process queue 1 0 0 0 0 0 0 0 .0 | |
213 | process queue reference 1 0 0 0 0 0 0 0 .0 | |
214 | parallel query stats 1 0 0 0 0 0 0 0 .0 | |
215 | business card 1 0 0 0 0 0 0 0 .0 | |
216 | queuing load statistics 1 0 0 0 0 0 0 0 .0 | |
217 | parallel query alloc buf 1 0 0 0 0 0 0 0 .0 | |
218 | PX hash array latch 1 0 0 0 0 0 0 0 .0 | |
219 | hash table modification 1 0 0 0 0 0 0 0 .0 | |
220 | hash table column usage 0 0 0 0 4 0 0 0 .0 | |
221 | SQL memory manager worka 3 0 0 0 0 0 0 0 .0 | |
222 | AQ deq hash table latch 1 0 0 0 0 0 0 0 .0 | |
223 | XDB unused session pool 1 0 0 0 0 0 0 0 .0 | |
224 | XDB used session pool 1 0 0 0 0 0 0 0 .0 | |
225 | XDB NFS Security Latch 1 0 0 0 0 0 0 0 .0 | |
226 | KFC Hash Latch 1 0 0 0 0 0 0 0 .0 | |
227 | KFC FX Hash Latch 1 0 0 0 0 0 0 0 .0 | |
228 | ASM map operation hash t 1 0 0 0 0 0 0 0 .0 | |
229 | Lsod array latch 1 0 0 0 0 0 0 0 .0 | |
230 | KFCL LE Freelist 1 0 0 0 0 0 0 0 .0 | |
231 | WCR: sync 1 0 0 0 0 0 0 0 .0 | |
232 | JS slv state obj latch 1 0 0 0 0 0 0 0 .0 | |
233 | JS queue access latch 1 0 0 0 0 0 0 0 .0 | |
234 | JS Sh mem access 1 0 0 0 0 0 0 0 .0 | |
235 | PL/SQL warning settings 15 0 0 0 0 0 0 0 .0 | |
236 | ||
237 | PL/SQL procedure successfully completed. | |
238 | ||
239 | --------------------------------- | |
240 | System stats:- 22-Apr 20:18:32 | |
241 | Interval:- 0 seconds | |
242 | --------------------------------- | |
243 | Name Value | |
244 | ---- ----- | |
245 | opened cursors cumulative 32 | |
246 | user calls 37 | |
247 | recursive calls 48 | |
248 | recursive cpu usage 3 | |
249 | session logical reads 57 | |
250 | CPU used when call started 6 | |
251 | CPU used by this session 5 | |
252 | DB time 4 | |
253 | non-idle wait count 34 | |
254 | session uga memory 720,296 | |
255 | session pga memory 131,072 | |
256 | enqueue requests 3 | |
257 | enqueue releases 1 | |
258 | db block gets 53 | |
259 | db block gets from cache 53 | |
260 | consistent gets 4 | |
261 | consistent gets from cache 4 | |
262 | consistent gets from cache (fastpath) 1 | |
263 | consistent gets - examination 1 | |
264 | db block changes 101 | |
265 | shared hash latch upgrades - no wait 2 | |
266 | calls to get snapshot scn: kcmgss 14 | |
267 | redo entries 50 | |
268 | redo size 14,612 | |
269 | undo change vector size 6,036 | |
270 | no work - consistent read gets 1 | |
271 | index scans kdiixs1 3 | |
272 | heap block compress 6 | |
273 | HSC Heap Segment Block Changes 50 | |
274 | session cursor cache hits 17 | |
275 | cursor authentications 2 | |
276 | buffer is not pinned count 3 | |
277 | workarea executions - optimal 14 | |
278 | parse time cpu 1 | |
279 | parse count (total) 25 | |
280 | parse count (hard) 1 | |
281 | execute count 39 | |
282 | bytes sent via SQL*Net to client 27,563 | |
283 | bytes received via SQL*Net from client 7,709 | |
284 | SQL*Net roundtrips to/from client 27 | |
285 | sorts (memory) 13 | |
286 | sorts (rows) 1,188 | |
287 | ||
288 | PL/SQL procedure successfully completed. | |
289 | ||
290 | --------------------------------- | |
291 | Session stats - 22-Apr 20:18:32 | |
292 | Interval:- 0 seconds | |
293 | --------------------------------- | |
294 | Name Value | |
295 | ---- ----- | |
296 | opened cursors cumulative 39 | |
297 | user calls 44 | |
298 | recursive calls 64 | |
299 | recursive cpu usage 7 | |
300 | session logical reads 57 | |
301 | CPU used when call started 10 | |
302 | CPU used by this session 9 | |
303 | DB time 8 | |
304 | non-idle wait count 39 | |
305 | session uga memory 720,296 | |
306 | session pga memory 131,072 | |
307 | enqueue requests 3 | |
308 | enqueue releases 1 | |
309 | db block gets 53 | |
310 | db block gets from cache 53 | |
311 | consistent gets 4 | |
312 | consistent gets from cache 4 | |
313 | consistent gets from cache (fastpath) 1 | |
314 | consistent gets - examination 1 | |
315 | db block changes 101 | |
316 | shared hash latch upgrades - no wait 2 | |
317 | calls to get snapshot scn: kcmgss 17 | |
318 | redo entries 50 | |
319 | redo size 14,612 | |
320 | undo change vector size 6,036 | |
321 | no work - consistent read gets 1 | |
322 | index scans kdiixs1 3 | |
323 | heap block compress 6 | |
324 | HSC Heap Segment Block Changes 50 | |
325 | session cursor cache hits 20 | |
326 | cursor authentications 3 | |
327 | buffer is not pinned count 3 | |
328 | workarea executions - optimal 16 | |
329 | parse time cpu 1 | |
330 | parse count (total) 31 | |
331 | parse count (hard) 1 | |
332 | execute count 47 | |
333 | bytes sent via SQL*Net to client 31,923 | |
334 | bytes received via SQL*Net from client 9,197 | |
335 | SQL*Net roundtrips to/from client 32 | |
336 | sorts (memory) 15 | |
337 | sorts (rows) 1,190 | |
338 | ||
339 | PL/SQL procedure successfully completed. | |
340 | ||
341 | ||
342 | ||
343 | Commit complete. | |
344 | ||
345 | ||
346 | ||
347 | PL/SQL procedure successfully completed. | |
348 | ||
349 | --------------------------------- | |
350 | Latch waits:- 22-Apr 20:18:33 | |
351 | Interval:- 0 seconds | |
352 | --------------------------------- | |
353 | Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken Time ms | |
354 | ----- ---- ------ ------ ------ ------- ------- ------- ----- ------- | |
355 | post/wait queue 3 0 0 0 1 0 0 0 .0 | |
356 | test excl. parent l0 2 0 0 0 0 0 0 0 .0 | |
357 | test excl. parent2 l0 2 0 0 0 0 0 0 0 .0 | |
358 | session allocation 10 0 0 0 0 0 0 0 .0 | |
359 | session switching 2 0 0 0 0 0 0 0 .0 | |
360 | session idle bit 114 0 0 0 0 0 0 0 .0 | |
361 | client/application info 2 0 0 0 0 0 0 0 .0 | |
362 | longop free list parent 2 0 0 0 0 0 0 0 .0 | |
363 | object stats modificatio 1 0 0 0 0 0 0 0 .0 | |
364 | kss move lock 2 0 0 0 0 0 0 0 .0 | |
365 | messages 3 0 0 0 0 0 0 0 .0 | |
366 | enqueues 2 0 0 0 0 0 0 0 .0 | |
367 | enqueue hash chains 8 0 0 0 0 0 0 0 .0 | |
368 | ksfv messages 2 0 0 0 0 0 0 0 .0 | |
369 | msg queue latch 2 0 0 0 0 0 0 0 .0 | |
370 | done queue latch 2 0 0 0 0 0 0 0 .0 | |
371 | session queue latch 2 0 0 0 0 0 0 0 .0 | |
372 | channel handle pool latc 2 0 0 0 0 0 0 0 .0 | |
373 | channel operations paren 2 0 0 0 0 0 0 0 .0 | |
374 | message pool operations 2 0 0 0 0 0 0 0 .0 | |
375 | ksv class latch 2 0 0 0 0 0 0 0 .0 | |
376 | ksv msg queue latch 2 0 0 0 0 0 0 0 .0 | |
377 | second spare latch 2 0 0 0 0 0 0 0 .0 | |
378 | third spare latch 2 0 0 0 0 0 0 0 .0 | |
379 | fifth spare latch 2 0 0 0 0 0 0 0 .0 | |
380 | IPC stats buffer allocat 2 0 0 0 0 0 0 0 .0 | |
381 | granule operation 2 0 0 0 0 0 0 0 .0 | |
382 | OS process 2 0 0 0 0 0 0 0 .0 | |
383 | ges process parent latch 2 0 0 0 0 0 0 0 .0 | |
384 | ges process hash list 2 0 0 0 0 0 0 0 .0 | |
385 | ges resource table freel 2 0 0 0 0 0 0 0 .0 | |
386 | ges resource hash list 2 0 0 0 0 0 0 0 .0 | |
387 | ges resource scan list 2 0 0 0 0 0 0 0 .0 | |
388 | ges enqueue table freeli 2 0 0 0 0 0 0 0 .0 | |
389 | KJC message pool free li 2 0 0 0 0 0 0 0 .0 | |
390 | KJCT flow control latch 2 0 0 0 0 0 0 0 .0 | |
391 | ges domain table 2 0 0 0 0 0 0 0 .0 | |
392 | ges group table 2 0 0 0 0 0 0 0 .0 | |
393 | gcs resource hash 2 0 0 0 0 0 0 0 .0 | |
394 | gcs resource freelist 2 0 0 0 0 0 0 0 .0 | |
395 | gcs resource scan list 2 0 0 0 0 0 0 0 .0 | |
396 | gcs shadows freelist 2 0 0 0 0 0 0 0 .0 | |
397 | gcs commit scn state 2 0 0 0 0 0 0 0 .0 | |
398 | name-service namespace b 2 0 0 0 0 0 0 0 .0 | |
399 | gcs partitioned table ha 2 0 0 0 0 0 0 0 .0 | |
400 | gcs pcm hashed value buc 2 0 0 0 0 0 0 0 .0 | |
401 | recovery domain hash lis 2 0 0 0 0 0 0 0 .0 | |
402 | ges value block free lis 2 0 0 0 0 0 0 0 .0 | |
403 | Testing 2 0 0 0 0 0 0 0 .0 | |
404 | heartbeat check 2 0 0 0 0 0 0 0 .0 | |
405 | Memory Management Latch 2 0 0 0 0 0 0 0 .0 | |
406 | mostly latch-free SCN 1 0 0 0 0 0 0 0 .0 | |
407 | lgwr LWN SCN 1 0 0 0 0 0 0 0 .0 | |
408 | Consistent RBA 1 0 0 0 0 0 0 0 .0 | |
409 | cache buffers lru chain 2 0 0 0 0 0 0 0 .0 | |
410 | buffer pool 2 0 0 0 0 0 0 0 .0 | |
411 | checkpoint queue latch 2 0 0 0 2 0 0 0 .0 | |
412 | cache buffers chains 273 0 0 0 0 0 0 0 .0 | |
413 | tablespace key chain 2 0 0 0 0 0 0 0 .0 | |
414 | simulator lru latch 2 0 0 0 1 0 0 0 .0 | |
415 | simulator hash latch 3 0 0 0 0 0 0 0 .0 | |
416 | sim partition latch 2 0 0 0 0 0 0 0 .0 | |
417 | object queue header oper 5 0 0 0 0 0 0 0 .0 | |
418 | object queue header heap 2 0 0 0 0 0 0 0 .0 | |
419 | redo writing 3 0 0 0 0 0 0 0 .0 | |
420 | redo copy 2 0 0 0 51 0 0 0 .0 | |
421 | redo allocation 55 0 0 0 0 0 0 0 .0 | |
422 | gc element 2 0 0 0 0 0 0 0 .0 | |
423 | logminer work area 2 0 0 0 0 0 0 0 .0 | |
424 | logminer context allocat 2 0 0 0 0 0 0 0 .0 | |
425 | logical standby cache 2 0 0 0 0 0 0 0 .0 | |
426 | mapped buffers lru chain 2 0 0 0 0 0 0 0 .0 | |
427 | lock DBA buffer during m 2 0 0 0 0 0 0 0 .0 | |
428 | flashback copy 2 0 0 0 0 0 0 0 .0 | |
429 | cvmap freelist lock 2 0 0 0 0 0 0 0 .0 | |
430 | io pool granule metadata 2 0 0 0 0 0 0 0 .0 | |
431 | DML lock allocation 4 0 0 0 0 0 0 0 .0 | |
432 | transaction allocation 2 0 0 0 0 0 0 0 .0 | |
433 | dummy allocation 2 0 0 0 0 0 0 0 .0 | |
434 | undo global data 5 0 0 0 0 0 0 0 .0 | |
435 | intra txn parallel recov 2 0 0 0 0 0 0 0 .0 | |
436 | In memory undo latch 2 0 0 0 0 0 0 0 .0 | |
437 | KTF sga latch 0 0 0 0 1 0 0 0 .0 | |
438 | change notification clie 2 0 0 0 0 0 0 0 .0 | |
439 | lob segment hash table l 2 0 0 0 0 0 0 0 .0 | |
440 | lob segment query latch 2 0 0 0 0 0 0 0 .0 | |
441 | lob segment dispenser la 2 0 0 0 0 0 0 0 .0 | |
442 | File State Object Pool P 2 0 0 0 0 0 0 0 .0 | |
443 | Write State Object Pool 2 0 0 0 0 0 0 0 .0 | |
444 | kdlx hb parent latch 2 0 0 0 0 0 0 0 .0 | |
445 | Locator state objects po 2 0 0 0 0 0 0 0 .0 | |
446 | row cache objects 470 0 0 0 0 0 0 0 .0 | |
447 | kks stats 9 0 0 0 0 0 0 0 .0 | |
448 | global tx hash mapping 2 0 0 0 0 0 0 0 .0 | |
449 | k2q lock allocation 2 0 0 0 0 0 0 0 .0 | |
450 | shared pool 112 0 0 0 0 0 0 0 .0 | |
451 | Token Manager 2 0 0 0 0 0 0 0 .0 | |
452 | cas latch 2 0 0 0 0 0 0 0 .0 | |
453 | rm cas latch 2 0 0 0 0 0 0 0 .0 | |
454 | resmgr:actses change sta 2 0 0 0 0 0 0 0 .0 | |
455 | resmgr:actses change gro 2 0 0 0 0 0 0 0 .0 | |
456 | resmgr:session queuing 2 0 0 0 0 0 0 0 .0 | |
457 | resmgr:plan CPU method 2 0 0 0 0 0 0 0 .0 | |
458 | resmgr:resource group CP 2 0 0 0 0 0 0 0 .0 | |
459 | QMT 2 0 0 0 0 0 0 0 .0 | |
460 | shared pool simulator 6 0 0 0 0 0 0 0 .0 | |
461 | shared pool sim alloc 2 0 0 0 0 0 0 0 .0 | |
462 | Streams Generic 2 0 0 0 0 0 0 0 .0 | |
463 | Shared B-Tree 2 0 0 0 0 0 0 0 .0 | |
464 | Memory Queue 2 0 0 0 0 0 0 0 .0 | |
465 | Memory Queue Subscriber 2 0 0 0 0 0 0 0 .0 | |
466 | Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0 | |
467 | Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0 | |
468 | Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0 | |
469 | Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0 | |
470 | pesom_hash_node 2 0 0 0 0 0 0 0 .0 | |
471 | pesom_free_list 2 0 0 0 0 0 0 0 .0 | |
472 | peshm 2 0 0 0 0 0 0 0 .0 | |
473 | Mutex 2 0 0 0 0 0 0 0 .0 | |
474 | Mutex Stats 2 0 0 0 0 0 0 0 .0 | |
475 | KGNFS-NFS:SHM structure 2 0 0 0 0 0 0 0 .0 | |
476 | KGNFS-NFS:SVR LIST 2 0 0 0 0 0 0 0 .0 | |
477 | SGA heap locks 2 0 0 0 0 0 0 0 .0 | |
478 | SGA pool locks 2 0 0 0 0 0 0 0 .0 | |
479 | SGA bucket locks 2 0 0 0 0 0 0 0 .0 | |
480 | SGA blob parent 2 0 0 0 0 0 0 0 .0 | |
481 | kgb parent 2 0 0 0 0 0 0 0 .0 | |
482 | Event Group Locks 2 0 0 0 0 0 0 0 .0 | |
483 | virtual circuit buffers 2 0 0 0 0 0 0 0 .0 | |
484 | virtual circuit queues 2 0 0 0 0 0 0 0 .0 | |
485 | virtual circuit holder 2 0 0 0 0 0 0 0 .0 | |
486 | cp server hash latch 2 0 0 0 0 0 0 0 .0 | |
487 | cp pool latch 2 0 0 0 0 0 0 0 .0 | |
488 | cp cmon/server latch 2 0 0 0 0 0 0 0 .0 | |
489 | job workq parent latch 2 0 0 0 0 0 0 0 .0 | |
490 | query server freelists 2 0 0 0 0 0 0 0 .0 | |
491 | process queue 2 0 0 0 0 0 0 0 .0 | |
492 | process queue reference 2 0 0 0 0 0 0 0 .0 | |
493 | parallel query stats 2 0 0 0 0 0 0 0 .0 | |
494 | business card 2 0 0 0 0 0 0 0 .0 | |
495 | queuing load statistics 2 0 0 0 0 0 0 0 .0 | |
496 | parallel query alloc buf 2 0 0 0 0 0 0 0 .0 | |
497 | PX hash array latch 2 0 0 0 0 0 0 0 .0 | |
498 | hash table modification 1 0 0 0 0 0 0 0 .0 | |
499 | hash table column usage 0 0 0 0 4 0 0 0 .0 | |
500 | SQL memory manager worka 6 0 0 0 0 0 0 0 .0 | |
501 | AQ deq hash table latch 2 0 0 0 0 0 0 0 .0 | |
502 | XDB unused session pool 2 0 0 0 0 0 0 0 .0 | |
503 | XDB used session pool 2 0 0 0 0 0 0 0 .0 | |
504 | XDB NFS Security Latch 2 0 0 0 0 0 0 0 .0 | |
505 | KFC Hash Latch 2 0 0 0 0 0 0 0 .0 | |
506 | KFC FX Hash Latch 2 0 0 0 0 0 0 0 .0 | |
507 | ASM map operation hash t 2 0 0 0 0 0 0 0 .0 | |
508 | Lsod array latch 2 0 0 0 0 0 0 0 .0 | |
509 | KFCL LE Freelist 2 0 0 0 0 0 0 0 .0 | |
510 | WCR: sync 2 0 0 0 0 0 0 0 .0 | |
511 | JS slv state obj latch 2 0 0 0 0 0 0 0 .0 | |
512 | JS queue access latch 2 0 0 0 0 0 0 0 .0 | |
513 | JS Sh mem access 2 0 0 0 0 0 0 0 .0 | |
514 | PL/SQL warning settings 28 0 0 0 0 0 0 0 .0 | |
515 | ||
516 | PL/SQL procedure successfully completed. | |
517 | ||
518 | --------------------------------- | |
519 | System stats:- 22-Apr 20:18:33 | |
520 | Interval:- 0 seconds | |
521 | --------------------------------- | |
522 | Name Value | |
523 | ---- ----- | |
524 | opened cursors cumulative 52 | |
525 | user commits 1 | |
526 | user calls 67 | |
527 | recursive calls 73 | |
528 | recursive cpu usage 8 | |
529 | session logical reads 58 | |
530 | CPU used when call started 11 | |
531 | CPU used by this session 10 | |
532 | DB time 8 | |
533 | non-idle wait count 69 | |
534 | session uga memory 720,296 | |
535 | messages sent 1 | |
536 | messages received 1 | |
537 | background timeouts 1 | |
538 | session pga memory 131,072 | |
539 | enqueue requests 3 | |
540 | enqueue releases 3 | |
541 | physical write total IO requests 1 | |
542 | physical write total bytes 15,360 | |
543 | cell physical IO interconnect bytes 15,360 | |
544 | db block gets 54 | |
545 | db block gets from cache 54 | |
546 | consistent gets 4 | |
547 | consistent gets from cache 4 | |
548 | consistent gets from cache (fastpath) 1 | |
549 | consistent gets - examination 1 | |
550 | db block changes 102 | |
551 | redo synch writes 1 | |
552 | commit cleanouts 2 | |
553 | commit cleanouts successfully completed 2 | |
554 | shared hash latch upgrades - no wait 2 | |
555 | calls to kcmgas 1 | |
556 | calls to get snapshot scn: kcmgss 20 | |
557 | redo entries 51 | |
558 | redo size 14,776 | |
559 | redo wastage 44 | |
560 | redo writes 1 | |
561 | redo blocks written 30 | |
562 | undo change vector size 6,036 | |
563 | no work - consistent read gets 1 | |
564 | index scans kdiixs1 3 | |
565 | heap block compress 6 | |
566 | HSC Heap Segment Block Changes 50 | |
567 | session cursor cache hits 35 | |
568 | cursor authentications 2 | |
569 | buffer is not pinned count 3 | |
570 | workarea executions - optimal 19 | |
571 | parse time cpu 1 | |
572 | parse count (total) 39 | |
573 | parse count (hard) 1 | |
574 | execute count 67 | |
575 | bytes sent via SQL*Net to client 62,486 | |
576 | bytes received via SQL*Net from client 13,186 | |
577 | SQL*Net roundtrips to/from client 50 | |
578 | sorts (memory) 17 | |
579 | sorts (rows) 1,780 | |
580 | ||
581 | PL/SQL procedure successfully completed. | |
582 | ||
583 | --------------------------------- | |
584 | Session stats - 22-Apr 20:18:33 | |
585 | Interval:- 0 seconds | |
586 | --------------------------------- | |
587 | Name Value | |
588 | ---- ----- | |
589 | opened cursors cumulative 59 | |
590 | user commits 1 | |
591 | user calls 75 | |
592 | recursive calls 89 | |
593 | recursive cpu usage 11 | |
594 | session logical reads 58 | |
595 | CPU used when call started 15 | |
596 | CPU used by this session 14 | |
597 | DB time 12 | |
598 | non-idle wait count 74 | |
599 | session uga memory 720,296 | |
600 | messages sent 1 | |
601 | session pga memory 131,072 | |
602 | enqueue requests 3 | |
603 | enqueue releases 3 | |
604 | db block gets 54 | |
605 | db block gets from cache 54 | |
606 | consistent gets 4 | |
607 | consistent gets from cache 4 | |
608 | consistent gets from cache (fastpath) 1 | |
609 | consistent gets - examination 1 | |
610 | db block changes 102 | |
611 | redo synch writes 1 | |
612 | commit cleanouts 2 | |
613 | commit cleanouts successfully completed 2 | |
614 | shared hash latch upgrades - no wait 2 | |
615 | calls to kcmgas 1 | |
616 | calls to get snapshot scn: kcmgss 23 | |
617 | redo entries 51 | |
618 | redo size 14,776 | |
619 | undo change vector size 6,036 | |
620 | no work - consistent read gets 1 | |
621 | index scans kdiixs1 3 | |
622 | heap block compress 6 | |
623 | HSC Heap Segment Block Changes 50 | |
624 | session cursor cache hits 39 | |
625 | cursor authentications 3 | |
626 | buffer is not pinned count 3 | |
627 | workarea executions - optimal 21 | |
628 | parse time cpu 1 | |
629 | parse count (total) 45 | |
630 | parse count (hard) 1 | |
631 | execute count 76 | |
632 | bytes sent via SQL*Net to client 68,109 | |
633 | bytes received via SQL*Net from client 14,717 | |
634 | SQL*Net roundtrips to/from client 56 | |
635 | sorts (memory) 19 | |
636 | sorts (rows) 1,782 | |
637 | ||
638 | PL/SQL procedure successfully completed. |