On Fri, 30 Mar 2001, Orlando Andico wrote:
..
> Not important. Depends on your SGA. The SHMMAX should be larger than the
> SGA. But I have a box with a 400MB SGA and stock kernel, no problems.
To elaborate: the most important component of the SGA is db_block_buffers
(in your initXXX.ora file). configuring this to as much as your computer
will handle will VASTLY speed up queries. to speed up ORDER BY, increase
sort_buffer. to speed up concurrency, you need dedicated log and rollback
drives.
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> POTS Phone: +63 (2) 848-2893
Mosaic Communications, Inc. GSM Mobile: +63 (917) 531-5893
I'm not suffering from insanity -- I'm enjoying every minute of it!!
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
