On 2/16/07, Orlando Andico <[EMAIL PROTECTED]> wrote:
You should turn on auto-tuning. The main value proposition of 10g over
9i is that you don't have to screw around with db_block_buffers etc.
anymore. Just set the target SGA that you want and let the system
self-tune.
OTOH I'm no Oracle expert (my knowledge is so dated, back with 8i) so
my suggestion would be to contact your friendly Oracle Support person.
Same here Im no Oracle expert as well:) Thanks for explaining the
db_block_buffer and further googling it has helped a lot. Im thinking
of doing some accounting and let this people (our dbas) realized how
expensive the resources they are wasting, they should be charged for
every thread they want to spawn.
--
sometimes truth is stranger than fiction
-bad religion-
http://www.bloglines.com/blog/mailist
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph
