On Mon, 13 Mar 2000, Brian Baquiran wrote:
..
> I should have added "on equivalent hardware".
>
> > Our production system here in MosCom has 2GB of memory,
> > which helps A LOT in speeding up those queries :)
>
> Yes it would, particularly if you have the entire dataset in memory.
I try. :)
Right now I only have a 380MB SGA (that's 90% DB_BLOCK_BUFFERS) but the
performance is pretty sweet. :)
People who say Oracle is hard to tune haven't heard of DB_BLOCK_BUFFERS.
:)
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> +63 (2) 937-2293
Mosaic Communications, Inc. +63 (917) 531-5893
Any sufficiently perverted technology is indistinguishable from Perl.
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
