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. |
