|
|
ORACLE Database running slow on AIX ( nmon / topas )
| 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 |
11-10-2010
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
11-10-2010
11-10-2010
11-10-2010
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;
11-10-2010
11-10-2010
select * from v$sgastat ;
11-10-2010
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;|
|
|
|