Re: memory sort and disk sort

OS:HP-UX 11i SERVer:9.4FC2 memory:12G CPU:12 Buffer 3000000(6G) LRU_MAX_DIRTY 1.5 LRU_MIN_DIRTY 1 RA_AHEAD 16 checkpoint 15 minutes LRU writes is very few. -- Posted via http://dbforums.com

On Fri, 24 Oct 2003 02:03:10 -0400, dusong wrote: In a vacuum these ONCONFIG values look OK, but we need to see the onstat output to make a diagnosis. Certainly you have lots of cache and an RA of 16 does not look outrageous (is that the RA_PAGES or RA_THRESHOLD and what's the other one's value?) Is KAIO enabled (not on by default on HP)? Art S. Kagel > OS:HP-UX 11i > > SERVer:9.4FC2 > > memory:12G > > CPU:12 > > > > Buffer 3000000(6G) > > LRU_MAX_DIRTY 1.5 > > LRU_MIN_DIRTY 1> > RA_AHEAD 16 > > checkpoint 15 minutes > > > > LRU writes is very few. > > > -- > Posted via http://dbforums.com

Thanks for your answer! The KAIO is not open! I try to send the onconfig and onstat_p file but fail,Can you tell me your E-mail,I would send this two file to you. my E-mail is :song_du@163.net IBM Informix Dynamic Server Version 9.40.FC2W2 -- On-Line -- Up 3 days 20:54:43 -- 7974488 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 2513181 18806956 409655914 99.39 1244064 2863990 5121645 75.71 isamtot open start read write rewrite delete commit rollbk 395390248 40381996 23683373 237457225 1159088 1553081 28937 296172 1728 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 8063.66 3449.07 57 162 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 243109 156 322993464 0 0 972 92377 493880 ixda-RA idx-RA da-RA RA-pgsused lchwaits 1322131 39167 115082 1475322 353609 -- Posted via http://dbforums.com