Re: Unix filesystem: use buffered IO or direct IO?

From: chao_ping <chao_ping_at_163.com>
Date: 25 Apr 2002 14:13:48 GMT
Message-ID: <3cc80f1c$1@usenetgateway.com>

Since it is an OLTP system and most of them are index-based scan, maybe i should conver to direct io with vxfs/Quick io. And leave cached quick io off, save this memory for oracle sga buffer cache and sort_area_size. Since now so much memory is used for filesystem buffer cache: bash-2.03$ prtmem

Total memory: 7880 Megabytes Kernel Memory: 403 Megabytes Application: 3046 Megabytes Executable & libs: 98 Megabytes File Cache: 4087 Megabytes Free, file cache: 241 Megabytes Free, free: 6 Megabytes How large a sga can i increase it to. Current SGA: SQL> show sga

Total System Global Area 2648026812 bytes Fixed Size 102076 bytes Variable Size 499376128 bytes Database Buffers 2147483648 bytes Redo Buffers 1064960 bytes Thanks for your opnions.

--
an oracle fan, 
an oracle beginner

Posted via dBforums
http://dbforums.com

Received on Thu Apr 25 2002 - 09:13:48 CDT