|
Search Forums |
Tag Search |
Advanced Search |
Quick Links |
Contact Us |
Forum Rules |
Today's Posts |
FAQ |
Pictures & Albums |
All Albums |
Miscellaneous |
What is My IP |
Whois |
Mark Forums Read |
1- # vmstat -Iwt 2 10 System configuration: lcpu=12 mem=95552MB kthr memory page faults cpu time ----------- --------------------- ------------------------------------ ------------------ ----------- -------- r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se 3 5 0 23753841 4488 586 1170 189 193 3072 179730 914 180733 2811 36 5 35 23 11:07:50 3 4 0 23755046 5331 503 1013 133 998 1534 4589 973 162455 2804 38 4 34 24 11:07:52 3 4 0 23756975 6917 299 1333 79 1163 2687 5666 988 164606 2656 33 4 38 25 11:07:54 4 4 0 23761781 3591 619 1821 130 1190 3456 8642 1572 193356 3999 38 6 32 24 11:07:56 2 8 0 23763840 8226 18 128 7 2617 2305 16329 667 139440 648 32 4 22 43 11:07:58 2 7 0 23767065 8815 197 305 64 1417 2304 5975 825 143228 1195 26 4 26 44 11:08:00 4 2 0 23759338 11529 1055 2715 165 39 0 0 2025 228979 5643 53 6 22 19 11:08:02 4 4 0 23760748 5454 1058 3783 134 94 767 18381 2225 224592 7124 52 7 26 15 11:08:04 4 8 0 23753183 8488 1183 2250 166 117 0 0 1319 215322 4030 46 6 30 18 11:08:06 3 4 0 23751832 5324 1144 2208 151 0 0 0 1001 237314 3221 44 5 31 19 11:08:08
1- # vmstat -s 265127922 total address trans. faults 183756033 page ins 283704430 page outs 8950733 paging space page ins 10283755 paging space page outs 0 total reclaims 191958685 zero filled pages faults 22534 executable filled pages faults 3952287579 pages examined by clock 531 revolutions of the clock hand 331366667 pages freed by the clock 5580959 backtracks 60221 free frame waits 0 extend XPT waits 28225464 pending I/O waits 467478058 start I/Os 86479049 iodones 400870079 cpu context switches 128381660 device interrupts 6431808 software interrupts 140107246 decrementer interrupts 208373 mpc-sent interrupts 208372 mpc-receive interrupts 81079 phantom interrupts 0 traps 17874678181 syscalls
1- vmstat -v 24461312 memory pages 23479680 lruable pages 10593 free pages 3 memory pools 1426811 pinned pages 80.0 maxpin percentage 10.0 minperm percentage 90.0 maxperm percentage 10.0 numperm percentage 2354938 file pages 0.0 compressed percentage 0 compressed pages 10.0 numclient percentage 80.0 maxclient percentage 2354938 client pages 0 remote pageouts scheduled 209 pending disk I/Os blocked with no pbuf 4126832 paging space I/Os blocked with no psbuf 2484 filesystem I/Os blocked with no fsbuf 159034 client filesystem I/Os blocked with no fsbuf 27265 external pager filesystem I/Os blocked with no fsbuf 0 Virtualized Partition Memory Page Faults 0.0 Time resolving virtualized partition memory page faults
1- # iostat -Dl System configuration: lcpu=12 drives=6 paths=14 vdisks=0 Disks: xfers read write queue -------------- -------------------------------- ------------------------------------ ------------------------------------ -------------------------------------- %tm bps tps bread bwrtn rps avg min max time fail wps avg min max time fail avg min max avg avg serv act serv serv serv outs serv serv serv outs time time time wqsz sqsz qfull hdisk3 2.8 437.1K 15.4 52.0K 385.1K 3.3 5.7 0.1 593.4 0 0 12.1 2.0 0.3 1.9S 0 0 1.3 0.0 1.9S 0.0 0.0 0.3 hdisk2 65.3 9.7M 513.7 2.8M 6.9M 190.7 7.0 0.1 1.0S 0 0 323.0 1.2 0.2 2.2S 0 0 0.4 0.0 2.5S 0.0 0.1 68.6 hdisk4 5.7 4.8M 19.7 3.0M 1.9M 12.4 9.4 0.1 636.3 0 0 7.3 18.7 0.3 642.7 0 0 7.8 0.0 710.2 0.0 0.0 3.5 hdisk1 31.7 689.4K 88.1 339.8K 349.5K 73.7 9.7 0.1 1.5S 0 0 14.4 24.2 0.2 5.0S 0 0 37.2 0.0 3.3S 0.8 0.1 14.3 hdisk0 0.4 8.0K 1.2 2.3K 5.7K 0.2 3.8 0.1 80.0 0 0 1.0 14.0 0.3 239.6 0 0 4.8 0.0 138.1 0.0 0.0 0.2 cd0 0.0 0.0 0.0 0.0 0.0
2- # vmo -a cpu_scale_memp = 8 data_stagger_interval = 161 defps = 1 force_relalias_lite = 0 framesets = 2 htabscale = n/a kernel_heap_psize = 4096 kernel_psize = 16777216 large_page_heap_size = 0 lgpg_regions = 0 lgpg_size = 0 low_ps_handling = 1 lru_file_repage = 0 lru_poll_interval = 10 lrubucket = 131072 maxclient% = 80 maxfree = 1128 maxperm = 21131711 maxperm% = 90 maxpin = 19745296 maxpin% = 80 mbuf_heap_psize = 65536 memory_affinity = 1 memory_frames = 24461312 memplace_data = 2 memplace_mapped_file = 2 memplace_shm_anonymous = 2 memplace_shm_named = 2 memplace_stack = 2 memplace_text = 2 memplace_unmapped_file = 2 mempools = 3 minfree = 360 minperm = 2347967 minperm% = 10 nokilluid = 0 npskill = 66816 npsrpgmax = 534528 npsrpgmin = 400896 npsscrubmax = 534528 npsscrubmin = 400896 npswarn = 267264 num_spec_dataseg = 0 numpsblks = 8552448 page_steal_method = 0 pagecoloring = n/a pinnable_frames = 23035107 pta_balance_threshold = n/a relalias_percentage = 0 rpgclean = 0 rpgcontrol = 2 scrub = 0 scrubclean = 0 soft_min_lgpgs_vmpool = 0 spec_dataseg_int = 512 strict_maxclient = 1 strict_maxperm = 0 v_pinshm = 1 vm_modlist_threshold = -1 vmm_fork_policy = 1 vmm_mpsize_support = 1
6 # df -g Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/hd4 1.00 0.59 41% 2607 2% / /dev/hd2 9.00 2.77 70% 46274 7% /usr /dev/hd9var 1.00 0.51 49% 6054 5% /var /dev/hd3 15.00 12.94 14% 6378 1% /tmp /dev/fwdump 0.75 0.58 23% 18 1% /var/adm/ras/platform /dev/hd1 1.00 0.90 10% 2686 2% /home /proc - - - - - /proc /dev/hd10opt 0.25 0.06 78% 2744 18% /opt /dev/fslv00 40.00 4.75 89% 7870 1% /u01 /dev/fslv01 2439.00 303.03 88% 155441 1% /u03 /dev/fslv03 736.00 453.95 39% 302 1% /u06
# lsfs -a Name Nodename Mount Pt VFS Size Options Auto Accounting /dev/hd4 -- / jfs2 2097152 -- yes no /dev/hd1 -- /home jfs2 2097152 -- yes no /dev/hd2 -- /usr jfs2 18874368 -- yes no /dev/hd9var -- /var jfs2 2097152 -- yes no /dev/hd3 -- /tmp jfs2 31457280 -- yes no /proc -- /proc procfs -- -- yes no /dev/hd10opt -- /opt jfs2 524288 -- yes no /dev/fwdump -- /var/adm/ras/platform jfs2 1572864 -- no no /dev/fslv00 -- /u01 jfs2 83886080 rw yes no /dev/cd0 -- /cdrom cdrfs -- ro no no /dev/fslv01 -- /u03 jfs2 5114953728 rw yes no /dev/fslv03 -- /u06 jfs2 1543503872 rw yes no
# vmstat -Iwt 2 60 System configuration: lcpu=12 mem=95552MB kthr memory page faults cpu time ----------- --------------------- ------------------------------------ ------------------ ----------- -------- r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se 3 5 0 23672463 6306 721 1577 190 0 3845 38344 2321 280580 6847 49 7 28 16 11:15:16 5 5 0 23667200 16050 882 1317 182 0 3839 114724 3499 212953 9851 42 7 34 16 11:15:18 4 4 0 23665961 13864 800 1822 187 0 0 0 2072 197964 6533 37 6 40 17 11:15:20 3 3 0 23665658 10070 824 2467 140 0 0 0 2513 238096 7844 51 8 27 14 11:15:22 5 2 0 23666031 6715 673 1605 105 0 0 0 1913 219637 5721 45 6 36 13 11:15:24 3 3 0 23664804 8824 813 1772 134 0 1922 84411 2132 239534 6637 51 8 28 13 11:15:26 3 4 0 23663616 6852 837 2191 124 0 0 0 2663 228650 7188 50 6 33 11 11:15:28 3 3 0 23669456 6866 973 1620 126 0 4612 84116 2321 206489 6073 51 7 31 12 11:15:30 4 3 0 23666857 6025 748 2226 131 0 0 0 2791 282167 8116 55 7 24 14 11:15:32 4 2 0 23668267 4446 1003 2398 130 0 1918 11726 2793 256456 8230 56 7 23 13 11:15:34 4 4 0 23664017 8151 980 1753 132 0 1537 6443 2343 220099 6434 58 6 27 10 11:15:36 3 2 0 23663927 4922 782 1767 100 0 0 0 2267 223306 6805 60 6 24 10 11:15:38 4 2 0 23658560 12919 676 1549 79 0 2690 18895 2187 224466 6233 57 7 27 9 11:15:40 3 3 0 23656293 12658 715 865 129 0 0 0 1783 214221 4877 38 5 44 13 11:15:42 2 3 0 23657869 8643 678 969 153 0 0 0 1889 301592 5231 45 7 34 13 11:15:44 3 3 0 23657894 5460 836 964 184 0 0 0 1855 282626 5156 42 6 36 17 11:15:46 5 2 0 23657889 5503 843 1079 162 0 1537 35402 2060 302257 5667 47 7 36 10 11:15:48 6 2 0 23656408 5782 1048 1435 141 0 1150 17793 2393 230622 6704 39 6 40 14 11:15:50 2 2 0 23656693 5947 1095 1118 165 0 1918 19894 2185 207166 6112 35 6 43 16 11:15:52 1 4 0 23657221 8873 776 956 187 0 3070 37269 1878 192255 5243 33 6 45 16 11:15:54 kthr memory page faults cpu time ----------- --------------------- ------------------------------------ ------------------ ----------- -------- r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se 2 3 0 23657527 5388 848 1250 108 0 0 0 1819 195527 5239 31 5 46 18 11:15:56 2 3 0 23657037 9893 1113 1407 169 0 4020 13917 1424 169697 4268 33 6 45 16 11:15:58 2 3 0 23653639 10178 766 1374 124 0 0 0 1314 167220 4016 27 5 51 18 11:16:00 2 2 0 23653559 5788 1210 1735 166 0 0 0 1900 174277 5591 30 6 48 16 11:16:02 1 4 0 23653209 9374 941 1358 156 0 3455 60912 1677 169961 4749 29 6 48 17 11:16:04 2 3 0 23654151 7416 945 1853 103 0 1536 17657 1797 183827 5427 31 6 48 15 11:16:06 2 3 0 23654831 7700 891 1811 102 0 2304 14676 1762 182699 5475 31 6 47 16 11:16:08 3 3 0 23655418 6974 1049 1942 119 0 1928 31798 1895 188258 6236 31 6 49 14 11:16:10 2 3 0 23656643 7518 686 1390 105 0 2304 29210 1579 175302 4929 30 5 48 16 11:16:12 3 5 0 23657394 7158 774 1906 129 0 1919 39091 1783 173957 5791 30 6 47 17 11:16:14 3 3 0 23657257 6758 875 1921 145 0 1536 12846 1740 170483 5606 32 6 45 18 11:16:16 2 3 0 23657352 6090 1031 2013 155 0 1543 33713 1724 167794 5181 28 6 54 13 11:16:18 4 3 0 23657904 5533 987 1765 135 0 1915 21869 1565 181148 4551 38 7 39 16 11:16:20 2 4 0 23657548 6579 1150 2161 161 0 2692 59685 1481 169558 4843 38 6 37 19 11:16:22 3 4 0 23658335 8827 1242 1947 129 0 3840 63737 1806 173918 5534 40 6 36 18 11:16:24 3 4 0 23658874 7997 753 1666 134 0 1537 34471 1561 177663 4868 42 7 29 23 11:16:26 3 4 0 23658588 5935 801 1289 124 0 384 1216 1057 162675 3293 40 4 34 22 11:16:28 5 4 0 23664044 5747 1125 1500 140 0 4617 58064 1269 166761 3910 42 6 34 17 11:16:30 3 4 0 23664050 6244 1240 1516 130 0 2314 49367 1390 171119 4206 39 5 37 18 11:16:32 3 5 0 23657293 11345 1242 1745 144 0 1537 16441 1434 173183 4427 48 6 27 20 11:16:34 kthr memory page faults cpu time ----------- --------------------- ------------------------------------ ------------------ ----------- -------- r b p avm fre fi fo pi po fr sr in sy cs us sy id wa hr mi se 3 4 0 23657618 6008 1399 1928 116 0 0 0 1373 170068 4180 41 5 32 21 11:16:36 2 3 0 23657888 7125 1303 2007 98 0 3074 79303 1274 178513 4339 41 6 36 17 11:16:38 3 2 0 23652966 10955 1155 2213 99 0 1539 16391 1303 179017 4345 39 6 40 15 11:16:40 2 3 0 23653256 6928 1088 1965 75 0 0 0 1679 181101 5075 31 6 50 13 11:16:42 1 3 0 23651843 8769 988 1631 74 0 1920 17736 1155 172272 3833 26 6 50 18 11:16:44 2 3 0 23651865 6028 853 1550 69 0 0 0 1088 161105 3502 31 5 47 17 11:16:46 1 2 0 23650202 7527 820 1137 81 0 1151 11867 774 138546 2499 20 4 58 18 11:16:48 2 2 0 23649060 10391 761 1540 73 0 2303 53094 964 139689 3212 24 5 55 16 11:16:50 2 2 0 23650671 9213 1132 1415 84 0 1921 27448 821 138905 2840 25 5 54 16 11:16:52 2 2 0 23650576 5869 1190 1731 86 0 384 4955 1049 133312 3530 33 4 50 13 11:16:54 3 2 0 23650182 6663 908 1482 96 0 1923 79024 943 134015 3196 21 5 57 18 11:16:56 2 3 0 23650127 5840 1064 1865 120 0 1536 46032 1587 143906 5171 22 5 53 20 11:16:58 2 2 0 23650519 8906 910 1620 116 0 3456 128881 1249 144559 3884 29 6 46 19 11:17:00 1 5 0 23653924 5952 568 1318 137 0 1537 84186 931 135264 2830 25 4 51 19 11:17:02 4 3 0 23650279 8565 713 1112 116 0 769 18499 1045 146943 3113 34 4 46 17 11:17:04 1 2 0 23651293 5751 774 90 82 0 0 0 440 131645 1009 20 3 61 16 11:17:06 1 2 0 23649061 10811 675 282 134 0 2305 23686 864 138348 2034 20 4 57 19 11:17:08 1 2 0 23648982 8443 938 389 156 0 0 0 880 138223 2066 21 3 57 18 11:17:10 2 2 0 23648981 6796 1011 1170 139 0 767 31809 1257 141085 3424 27 4 51 18 11:17:12 2 2 0 23649380 8591 948 1317 119 0 2688 52401 935 138633 3022 21 5 56 18 11:17:14
filesystemio_options asynch
set lines 130 trimout on trimspool on set timing on set autotrace on spool query.log "put your query here" spool off
select start_time ,sql_hash_value ,elapsed_seconds ,message from v$session_longops order by start_time;
select * from v$sgastat ;
SQL> select * from v$sgastat ; POOL NAME BYTES ------------ -------------------------- ---------- fixed_sga 2234488 buffer_cache 7.9306E+10 log_buffer 64872448 shared pool ENQUEUE STATS 11760 shared pool VIRTUAL CIRCUITS 3736 shared pool transaction 5846232 shared pool table definiti 92952 shared pool KGSKI scheduler heap 2 de 232 shared pool KTCN: Obj Invalidation Se 2336 shared pool kgl lock hash table state 130200 shared pool kwqmncal: allocate buffer 8096 POOL NAME BYTES ------------ -------------------------- ---------- shared pool ASM file 19200 shared pool qmn tasks 4128 shared pool kglsim main lru size 151040 shared pool FileOpenBlock 13195576 shared pool log_checkpoint_timeout 12360 shared pool PX subheap 73200 shared pool post agent 960 shared pool partitioning d 973536 shared pool message pool freequeue 757568 shared pool qesblGF:bfm 680 shared pool PARAMETER TABLE 2048 POOL NAME BYTES ------------ -------------------------- ---------- shared pool state objects 5504080 shared pool pso tbs: ksunfy 624000 shared pool Cursor Stats 41326632 shared pool object stat dummy stat 288 shared pool pso child tracebuf ptrs 9600 shared pool KGLS SP 4704 shared pool kzull 28024 shared pool kfgbsg 40 shared pool namhsh_kfdsg 4104 shared pool object queue 2291632 shared pool set_descriptor_array 65664 POOL NAME BYTES ------------ -------------------------- ---------- shared pool qesmmaInitialize: ta_qesm 264 shared pool kgllk hash table 1904640 shared pool dbwriter coalesce bitmap 128 shared pool KEWS External IDs 768 shared pool kzsrs filename 280 shared pool dbwr suspend/resume ptr a 16 shared pool KCK type array 936 shared pool jsksncb: 9 28992 shared pool joxlod pcod hp 152072 shared pool file # translation table 86096 shared pool KTCCC OBJECT 928 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kksss-heap 236232 shared pool kglsim heap 29578752 shared pool ksunfy: nodes of hierarch 320 shared pool kzekm heap descriptor 304 shared pool Core dump directory 264 shared pool sched job queue 3616 shared pool LGWR-network Server info 27648 shared pool Parameter Handle 1600 shared pool recov_kgqbtctx 4392 shared pool plwda:PLW_STR_NEW_RVAL 24 shared pool plwspv:PLW_STR_NEW_VAL 80 POOL NAME BYTES ------------ -------------------------- ---------- shared pool MS alert log 72704 shared pool latch classes 352 shared pool name-service table 15856 shared pool namhsh_kfgsg 288 shared pool Active Session History - 1528 shared pool temporary foreign ref 2848 shared pool ksmd unit test 1 5184 shared pool Detached dump directory 264 shared pool temp lob duration state o 3296 shared pool jsksncb: 3 4048 shared pool kspd run-time context 16 POOL NAME BYTES ------------ -------------------------- ---------- shared pool incr ckpt write count arr 168 shared pool enqueue 4154008 shared pool kks stbkt 1572864 shared pool simulator latch/bucket st 11264 shared pool knlsg 120 shared pool KGLS SD 2592 shared pool policy hash table descrpt 280 shared pool sim trace buf context 200 shared pool qesmmaInitialize: 112 shared pool xsoqophift 2848 shared pool list 4096 POOL NAME BYTES ------------ -------------------------- ---------- shared pool ksfm state object 32 shared pool kpssnfy: kpsssgct 32 shared pool dbwr message active flag 8 shared pool jsksncb: 8 1024 shared pool free memory 765096160 shared pool sessions 12729608 shared pool row cache 7506880 shared pool ksb ci process list (each 696 shared pool ksuloi: garbage collectio 48 shared pool ksfd shared pool recovery 24 shared pool kpummst global in the SGA 1136 POOL NAME BYTES ------------ -------------------------- ---------- shared pool PCursor 350580920 shared pool grplut_kfgsg 512 shared pool kcbl seq io throughput 16000 shared pool parameters 9304 shared pool agent name 64 shared pool sim cache sizes 640 shared pool LGWR post requested array 8 shared pool sql area:KOKA 125488 shared pool savepoints 12184 shared pool mvobj part des 223504 shared pool ktcmvcb 429359008 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kks sga 48 shared pool kfgsga 104 shared pool SGA - SWRF Metric Eidbuf 681920 shared pool ptr to sessions under idl 96 shared pool character set memory 188408 shared pool qesmmaInitialize: pa_qesm 11088 shared pool db_block_hash_buckets 754974720 shared pool file # to first dba, exte 6160 shared pool KEWS statistic maps 2728 shared pool kebm slave message 152 shared pool X$KSFQP ANCHOR 80 POOL NAME BYTES ------------ -------------------------- ---------- shared pool ksir State Object 3360 shared pool KEWS fixed SGA 4600 shared pool messages 249600 shared pool joxlod exec hp 1110400 shared pool koh dur heap 352 shared pool ksv reaper 4128 shared pool Wait event pointers 336 shared pool KSXR pending consumption 20192 shared pool AW SGA 40 shared pool SHARED SERVERS INFO 240 shared pool primem_kfmdsg 1032 POOL NAME BYTES ------------ -------------------------- ---------- shared pool MTTR advisory context 1648 shared pool param hash values 5760 shared pool PX QC deq stats 1480 shared pool log file size history arr 168 shared pool dummy 194736 shared pool SHRINK STAT 3000 shared pool constraints 597072 shared pool cinfo_kfnsg 4104 shared pool kks stats 40 shared pool KSIR SGA 128 shared pool replication session stats 710400 POOL NAME BYTES ------------ -------------------------- ---------- shared pool osp pool handles 8 shared pool KSK SGA 76080 shared pool cross-platform compliance 2120 shared pool kfasga 1048 shared pool plwppwp:PLW_STR_NEW_VAL_V 40 shared pool obj stat memo 1763016 shared pool KTC cch latches 2720 shared pool generic process shared st 96 shared pool KRBMROS ANCHOR 96 shared pool KGX rowlist 1504 shared pool kzulsg SGA 2080 POOL NAME BYTES ------------ -------------------------- ---------- shared pool miscellaneous 2408 shared pool UNDO INFO HASH 84480 shared pool UNDO STAT INFO 59904 shared pool enqueue_hash 232080 shared pool groups_kfgbsg 4096 shared pool fdhsh_kffsg 16392 shared pool processes 9600 shared pool PX subheap desc 256 shared pool latch recovery structures 1096 shared pool sim trace buf 5144 shared pool Banner Storage 2048 POOL NAME BYTES ------------ -------------------------- ---------- shared pool Managed Standby Proc Arra 24576 shared pool max allowable # log files 337600 shared pool KQR L SO 454016 shared pool ASM rollback operations 2592 shared pool SGA struct - SWRF Metrics 2096 shared pool kponfy 672 shared pool kfdsga 120 shared pool namrec_kfdsg 24 shared pool msg Q child latches 1344 shared pool returns from metrics req 526336 shared pool java static objs 32128 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KSI resource types 2704 shared pool ktlbk state objects 1837440 shared pool kqlpWrntoStr:string 224 shared pool KTI pool states 264 shared pool KSFQ buffer pool 3872 shared pool dbwr outstanding ios per 128 shared pool KGKP randnum 40000 shared pool trigger defini 228144 shared pool CCursor 443998304 shared pool ksunfy: is parent statist 3080 shared pool ksuloi: long op free list 192 POOL NAME BYTES ------------ -------------------------- ---------- shared pool ksr message pool free que 34480 shared pool KSXR pending reply queue 100280 shared pool PLS chunk 352 shared pool sim kghx free lists 8 shared pool sim state object 40 shared pool latch recovery alignment 56 shared pool object queue hash table d 22656 shared pool PARAMETER ENTRY 64 shared pool analytic workspace 3616 shared pool sga node map 16 shared pool OS proc request holder 55072 POOL NAME BYTES ------------ -------------------------- ---------- shared pool BRANCH TABLE SEGMENTED AR 276576 shared pool parallel_max_servers 1536 shared pool KGSKI sga 80 shared pool redo allocation latch(es) 42560 shared pool SGA - SWRF Time Model Bas 64 shared pool SGA - SWRF DrvMet Runtime 4960 shared pool kksss 99152 shared pool name-service entry 2592 shared pool KKJ SGA 848 shared pool row cache child latch 6400 shared pool Processor group descripto 192 POOL NAME BYTES ------------ -------------------------- ---------- shared pool slave class sga anchor 88 shared pool reservation state object 3168 shared pool xslongops 2592 shared pool returns from remote ops 49152 shared pool Heap0: KGL 34029392 shared pool done Q child latches 1344 shared pool xsoqmehift 2848 shared pool kodosgi kopfdo 416 shared pool TXN TABLE SEGMENTED ARRAY 229408 shared pool database creation languag 568 shared pool trace buffer header array 18704 POOL NAME BYTES ------------ -------------------------- ---------- shared pool where to latch num map 7184 shared pool KKJ WRK LAT 480 shared pool kfkrec_kfdsg 24 shared pool dpslut_kfdsg 512 shared pool hot latch diagnostics 160 shared pool resumable 2720 shared pool KTCN: Hash Table Segmente 5184 shared pool kolfsgi: KOLF's SGA initi 8 shared pool PLS non-lib hp 16456 shared pool Auto tune undo info 96 shared pool ArchLog Dest Array 7656 POOL NAME BYTES ------------ -------------------------- ---------- shared pool PX msg pool struct 1088 shared pool prmtzdini tz region 404888 shared pool KGLS SGA 24 shared pool krvxlctx 248 shared pool reserved entries for all 4096 shared pool SGA param ownership table 184 shared pool KEWS sysstat values 256 shared pool xsoqojhift 4128 shared pool kebm test replies 28672 shared pool kfkhsh_kfdsg 4104 shared pool KFG SO child 5056 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KSXR pending messages que 856352 shared pool grptab_kfgsg 2464 shared pool Wait History 1152000 shared pool kso req alloc heapds 280 shared pool pspool_kfsg 80 shared pool latch nowait fails or sle 114848 shared pool PRESENTATION TABLE 2072 shared pool Monitor Modification Hash 512 shared pool sim_knlasg 1280 shared pool PX server deq stats 1480 shared pool RTA Boundary Info thread 12672 POOL NAME BYTES ------------ -------------------------- ---------- shared pool PARALLEL T RECO LATCH 1920 shared pool plwppwp:PLW_STR_NEW_LEN_V 40 shared pool qesmmaInitialize: ia_qesm 264 shared pool SGA Param Source Table 184 shared pool kglsim pin list arr 1224 shared pool KCB undo bitvec 4096 shared pool kglsim latch area 2720 shared pool X$KSVIT table 512 shared pool Transportable DB Converte 2552 shared pool dgtab_kfmdsg 13184 shared pool invalid low rba queue 3072 POOL NAME BYTES ------------ -------------------------- ---------- shared pool trigger inform 3240 shared pool kglsim main lru count 76800 shared pool plwpil:wa 4264 shared pool event-class map 3512 shared pool qmtb_init_data 1712 shared pool LISTEN ADDRESS ENTRY 64 shared pool SERVICE NAME ENTRY 104 shared pool memory transfer history 19208 shared pool PL/SQL DIANA 18760352 shared pool PL/SQL PPCODE 541168 shared pool parameter handle 366504 POOL NAME BYTES ------------ -------------------------- ---------- shared pool repository 7036528 shared pool joxs heap 6312 shared pool SGA Obsolete Param Source 16 shared pool SGA - SWRF RawMet Runtime 3280 shared pool Array of cached attr 400 shared pool spfile callback table: ks 448 shared pool kfmdsg 144 shared pool CGS system incarn array 24864 shared pool rules engine context 200 shared pool AWR Table Info (KEW layer 872 shared pool character set object 449784 POOL NAME BYTES ------------ -------------------------- ---------- shared pool simulator hash latch 20480 shared pool kglsim object batch 56379624 shared pool ksws service object 2016 shared pool temporary table lock 3744 shared pool KEWS sesstat values 1228800 shared pool DBWR event stats array 192 shared pool KUPP subheap desc 232 shared pool kscdnfyinitnext 16 shared pool writes stopped lock state 48 shared pool kqlpaac:value-1 400 shared pool dbwr suspend/resume array 16 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KCB Table Scan 40 shared pool KTU lat struct 2720 shared pool KSI Indexes 288 shared pool branch so 296 shared pool PQ/BizCard 1536 shared pool active checkp 1536 shared pool plwshs:temphdl 48 shared pool post/wait queues 6144 shared pool KQR S SO 109888 shared pool resize request state obje 366400 shared pool obj htab chun 655872 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KCB private handles 14400 shared pool KTU latch cleanup 1872 shared pool writes stopped lock conte 48 shared pool kglsim latches 136 shared pool KFM state obj 3360 shared pool KKKI consumer 1104 shared pool kfkid hash 4104 shared pool File Space Usage 28808 shared pool latchnum to latch map 3104 shared pool sim lru segments 7680 shared pool PG latch table 640 POOL NAME BYTES ------------ -------------------------- ---------- shared pool PX QC msg stats 2288 shared pool sched job slv 5952 shared pool KQR M SO 1270440 shared pool channel context areas 30272 shared pool resize operation history 28808 shared pool ksb process so list 576 shared pool kgqbt_alloc_block 1024 shared pool kks stats latch 640 shared pool jsksncb: 2 7648 shared pool kfkid hrec 24 shared pool type object de 719688 POOL NAME BYTES ------------ -------------------------- ---------- shared pool trigger source 13880 shared pool kglsim count of pinned he 8160 shared pool kelr system metrics table 280 shared pool ksunfy: system-global sta 3080 shared pool knlu_txn_init_btree:init 48 shared pool work area tab 270144 shared pool State object pools 3072 shared pool policy hash ta 4136 shared pool Log Archive Config Contex 360 shared pool rule set evalu 107032 shared pool sga dev dict 56 POOL NAME BYTES ------------ -------------------------- ---------- shared pool block media rcv state obj 2592 shared pool SGA - SWRF Metrics WCTime 1216 shared pool KQR ENQ 165120 shared pool KFK SGA 1144 shared pool knstsg 48 shared pool LRMPD SGA Table 161280 shared pool ksws service events 27648 shared pool fixed allocation callback 1808 shared pool kebm slave reply 88 shared pool Global Context Heap descr 400 shared pool kspload:comment 320 POOL NAME BYTES ------------ -------------------------- ---------- shared pool x$ksmfs table 24 shared pool idtab_kfksg 44296 shared pool kks stats mem 64 shared pool KTU latches 2040 shared pool KTF MAPPINGS 12288 shared pool dev2node map 4096 shared pool KCB Table Scan Bitmap 256 shared pool service names array 40 shared pool qtree_kwqbspse 48 shared pool broker globals 160 shared pool media recovery state obje 6336 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KRSF SGA 56 shared pool KQR X PO 5600 shared pool SGA - AWR Metric RBSM str 9600 shared pool change tracking recovery 262144 shared pool client/application info l 1920 shared pool os statistics 9192 shared pool process count for each CI 288 shared pool sim segment num bufs 3840 shared pool ksv slave class 14840 shared pool kodosgi kodos 32 shared pool kkj jobq slav 1280 POOL NAME BYTES ------------ -------------------------- ---------- shared pool dsktab_kfgsg 50440 shared pool ksuloi: child latches for 1920 shared pool kglsim alloc latches 136 shared pool stat hash values 1488 shared pool prirec_kfmdsg 24 shared pool ASM map operations 3360 shared pool name-service request 2592 shared pool Nettimeout Histogram 48800 shared pool krvxdka 592 shared pool kfmsg 3608 shared pool sys event stats for Other 196672 POOL NAME BYTES ------------ -------------------------- ---------- shared pool system default language h 568 shared pool Client ID trace settings 3872 shared pool Policy Cache Heap descrpt 160 shared pool session idle latches 1920 shared pool SQL Workarea Histogram 1056 shared pool downed inst bit vector 40 shared pool kscdnfyinithead 16 shared pool KKJ SHRD WRQS 288 shared pool ksleid alloc 112 shared pool kglsim sga 30456 shared pool trace buffer 5865472 POOL NAME BYTES ------------ -------------------------- ---------- shared pool temporary tabl 101464 shared pool KCB where statistics arra 25824 shared pool kzctxgjsi ksuseclid memor 10944 shared pool KSXR global channels 1176 shared pool sort segment handle 289504 shared pool LISTEN ADDRESS TABLE 2048 shared pool qtree_kwqbsgn 80 shared pool Checkpoint queue 3148800 shared pool ASH buffers 23592960 shared pool SYSTEM PARAMETERS 279712 shared pool log_simultaneous_copies 4800 POOL NAME BYTES ------------ -------------------------- ---------- shared pool UNDO INFO 16 shared pool private strands 34873344 shared pool message pool context area 10640 shared pool PX server msg stats 2288 shared pool KQR M PO 19184592 shared pool parameter table block 2638328 shared pool parameter text value 4880 shared pool change notification regis 16416 shared pool Prefetch history buffer 11328 shared pool change notification obj m 16416 shared pool Service-level trace setti 536 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kcrrny 33760 shared pool Closed Thread SCN Bitvec 8448 shared pool SCHEDULING POLICY VECTOR 104 shared pool XCT XGA 784 shared pool State object subpools 4608 shared pool OS file lock 8576 shared pool x$rule_set 17608 shared pool kscdnfyglobalflags 8 shared pool KEWS statistic name 1760 shared pool KTI latch structure 42240 shared pool event descriptor table 49360 POOL NAME BYTES ------------ -------------------------- ---------- shared pool X$KSVII table 512 shared pool kxfpdp pointers 28800 shared pool KSFD SGA I/O b 4190248 shared pool HTTP fixed headers 72 shared pool event statistics per sess 22118400 shared pool event statistics ptr arra 19200 shared pool ksbtnfy: infrequent actio 1776 shared pool KEWS statistic metadata 12032 shared pool latch hashvalue table 1552 shared pool sga listelement 2048 shared pool bloom filter 3104 POOL NAME BYTES ------------ -------------------------- ---------- shared pool Service-level ID trace se 3744 shared pool kffsga 120 shared pool xscalc 4000 shared pool Prefetch history buffer a 320 shared pool kscdnfyinitflags 8 shared pool dbwr working sets kcbdbws 32 shared pool dbwriter coalesce struct 96 shared pool Temporary storage for RTA 16 shared pool jsksncb: 6 3480 shared pool kkj jobq wor 4128 shared pool jsksncb: 4 4080 POOL NAME BYTES ------------ -------------------------- ---------- shared pool dlo fib struct 32800 shared pool kmgsb circular statistics 108800 shared pool DISPATCHERS INFO 240 shared pool kebm run-once actions 16 shared pool KCB Table Scan Buffer 4198400 shared pool parameter blocks 11520 shared pool qmps connections 65280 shared pool lckhsr_kffsg 24 shared pool modification 287104 shared pool quiesce system context 384 shared pool kga sga 8 POOL NAME BYTES ------------ -------------------------- ---------- shared pool spfile cleanup structure 16760 shared pool xssinfo 5952 shared pool Prefetch client count per 32 shared pool kcrfa structures 93632 shared pool kglsim hash table 8208 shared pool Undo Meta Data 2112 shared pool branch 855984 shared pool call 745816 shared pool 1:kngisga 32088 shared pool User dump directory 264 shared pool kglsim alloc latch area 2720 POOL NAME BYTES ------------ -------------------------- ---------- shared pool fdrec_kffsg 24 shared pool kglsim hash table bkts 4194304 shared pool instance cnxn information 115200 shared pool segmented arrays 12768 shared pool sim segment hits 7680 shared pool PL/SQL MPCODE 123659624 shared pool procs: ksunfy 2419200 shared pool object queue hash buckets 787968 shared pool sim cache nbufs 640 shared pool Oracle Text Commit new id 1440 shared pool archive_lag_target 9624 POOL NAME BYTES ------------ -------------------------- ---------- shared pool buffer handles 1680008 shared pool db_files 475400 shared pool plugin datafile array 9232 shared pool parameter value memory 440 shared pool krvxmctx 40 shared pool KGLS heap 36440088 shared pool monitoring co 45760 shared pool buffers waiting for write 48 shared pool network connections 66280 shared pool change tracking state cha 3744 shared pool kokcd 3672 POOL NAME BYTES ------------ -------------------------- ---------- shared pool osp allocation 175480 shared pool plwda:PLW_STR_NEW_LEN_VEC 40 shared pool SGA - SWRF Metric CHBs 1339392 shared pool time manager context 40 shared pool xsoqsehift 3104 shared pool kwqmncini-tbl 272 shared pool KGSK scheduler 639816 shared pool joxs struct 144 shared pool jsksncb: 7 489472 shared pool jsksncb-latch 3840 shared pool trace_knlasg 504 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KSXR receive buffers 1036000 shared pool kglsim free obj list 408 shared pool procs_kfgbsg 616 shared pool block_sizes_array 48 shared pool post stats 1088 shared pool plis struct 136 shared pool LGWR debug module memory 8192 shared pool sys event stats 196672 shared pool Saved job ids 8000 shared pool object level stat table 1728 shared pool qm_init_sga:qmdpsg 32 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KQR L PO 4522968 shared pool KSFV SGA 824 shared pool KGSK sga 448 shared pool RVWR post requested array 8 shared pool KGX 122976 shared pool Cleanup state objects 384 shared pool AQ Propagation Scheduling 16000 shared pool sess Q child latches 1344 shared pool dbwriter coalesce buffer 2105344 shared pool ksim client list 168 shared pool ksws RLB SGA ctx 40 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kcbl statistics 6144 shared pool dbwr actual working sets 96 shared pool database NCHAR language h 568 shared pool UNDO INFO SEGMENTED ARRAY 470352 shared pool kwqicaqe2kc1 8208 shared pool SEQ S.O. 384000 shared pool evaluation con 4544 shared pool event classes 128 shared pool KESTB existence bitvec se 128 shared pool kolbsgi: KOLB's SGA initi 8 shared pool Alert log 264 POOL NAME BYTES ------------ -------------------------- ---------- shared pool ksfv subheap descriptor 184 shared pool kglsim free heap list 408 shared pool KEWS sesstat seg tbl 8 shared pool kebm slave descriptors 1352 shared pool logout storm management 9600 shared pool PLS cca hp desc 352 shared pool KSXR SGA 27848 shared pool multiblock re 123120 shared pool kkzias 144 shared pool SCHEDULING POLICY TABLE 160 shared pool plwda:PLW_STR_NEW_VAL_VEC 40 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kcbl state objects 12800 shared pool FileIdentificatonBlock 1150008 shared pool distributed_transactions- 23048 shared pool joxlod rsrc hp 7392 shared pool sql area 3125436312 shared pool txncallback 401608 shared pool KCB buffer wait statistic 8344 shared pool kglsim size of pinned mem 16048 shared pool kea advisor definition ca 480 shared pool threshold ale 4032 shared pool execution ID memory 256 POOL NAME BYTES ------------ -------------------------- ---------- shared pool enqueue resources 2146680 shared pool kelt translation table 312 shared pool trace buf hdr xtend 205744 shared pool kglsim recovery area 2904 shared pool KSQ event description 5776 shared pool KESTB existence bitvec 16384 shared pool ksb cic process list 576 shared pool PQ/ResSched 1040 shared pool latch descriptor table 1552 shared pool QSMQUTL summar 400 shared pool object level stats hash t 512 POOL NAME BYTES ------------ -------------------------- ---------- shared pool channel handle 331616 shared pool sql area:PLSQL 44591928 shared pool Parameter Table 34560 shared pool Sort Segment 573968 shared pool KTI-UNDO 20484288 shared pool lcktab_kffsg 2592 shared pool SGA - SWRF Metrics ksuTim 1216 shared pool kzulu 392 shared pool library cache 323103448 shared pool simulator hash buckets 33619968 shared pool kpscad: kpscscon 1288 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kso req alloc 4136 shared pool kwrsnfy: kwrs 9744 shared pool Temporary Tables State Ob 562016 shared pool KTUR HIST INFO 4840 shared pool KTC latches 2720 shared pool KTPR HIST TB 2808 shared pool eventlist to post commits 3216 shared pool KQF optimizer stats table 4816 shared pool kewr MMON Remote Flush Re 28672 shared pool ksuloi: long op used list 192 shared pool Global Context 47016 POOL NAME BYTES ------------ -------------------------- ---------- shared pool kelr other metrics table 40 shared pool trace events array 68000 shared pool SERVICE NAMES TABLE 2048 shared pool channel sga anchor 280 shared pool Label Cache Heap descrptr 160 shared pool quiescing session 3872 shared pool process group array 33680 shared pool property service SO 3104 shared pool KGKP sga 32 shared pool lckhsh_kffsg 4104 shared pool JSX SGA 112 POOL NAME BYTES ------------ -------------------------- ---------- shared pool Background process state 48 shared pool SQL Memory Manager Base W 13400 shared pool Client ID trace setting h 536 shared pool object level 284832 shared pool Pre-Warm Initialized Seti 768 shared pool heap_kfsg 136 shared pool alter system errs: kspnfy 114688 shared pool qesmmaInitialize: oa_qesm 112 shared pool SGA structure for kelr 2336 shared pool kghx free lists 44576 shared pool kscdnfyinitprev 16 POOL NAME BYTES ------------ -------------------------- ---------- shared pool X$KSVIS table 128 shared pool KGSKI schedule 8296 shared pool kks stats hds 1024 shared pool KTI latches 8448 shared pool enqueue_hash_chain_latche 1920 shared pool KTPR SUBHEAP 168 shared pool KCB incremental ckpt entr 512 shared pool KTCN: Row Change Segmente 34496 shared pool rule set 24312 shared pool ksuloi: long op statistic 172000 shared pool kgsk subheap descriptor 136 POOL NAME BYTES ------------ -------------------------- ---------- shared pool KEWS aggregation objs 4032 shared pool KSXR large reply queue 168104 shared pool DML lock 2601672 shared pool object stat dummy elem 40 shared pool plwppwp:garbage handle 40 shared pool rules engine aggregate st 1416 shared pool SGA structure for SWRF (K 240 shared pool kohsg 8 shared pool buffer_pool_desc_array 3384 shared pool listener addresses 40 shared pool trigger condition node 72 POOL NAME BYTES ------------ -------------------------- ---------- shared pool error message file name 56 shared pool KTC latch cleanup 432 shared pool KFG state obj 4128 shared pool kwqmncini-slv 240 shared pool KSN WaitID 520 large pool free memory 16467112 large pool PX msg pool 310104 java pool free memory 30756288 java pool joxs heap 1032192 java pool joxlod exec hp 18543168 streams pool free memory 16781720 POOL NAME BYTES ------------ -------------------------- ---------- streams pool kwqbcqini:spilledovermsgs 1136 streams pool recov_kgqmctx 520 streams pool recov_kgqbtctx 5952 streams pool spilled:kwqbl 128 streams pool deqtree_kgqmctx 72 streams pool Sender info 2856 streams pool kwqbsinfy:bqg 536 streams pool substree_kgqmctx 72 streams pool msgtree_kgqmctx 72 streams pool kwqbsinfy:sta 432 streams pool time manager index 72 POOL NAME BYTES ------------ -------------------------- ---------- streams pool KGH: NO ACCESS 16760864 تم اختيار 650 صف SQL> spool off;
|
|