Initialize Missing Oracle Instance Parameters
I
got a call from a client in California who said that their
performance was getting progressively worse as more customers
accessed the Oracle database. Upon inspection I discovered
that their db_cache_size parameter was not present in
the init.ora file. A quick instance bounce (to re-set
sga_max_size and db_cache_size) resulted in a
400 percent performance improvement.
In
another memorable case, I received a call from a data
warehouse client in California who complained that their
performance degraded as the database grew. A quick look
revealed that the sort_area_size parameter was missing
and defaulting to a tiny value. Again, a change of
sort_area_size=1048575, a quick bounce of the instance,
and overall database performance improved by more than 50
percent.
If you like Oracle tuning, you might enjoy my latest book
“Oracle Tuning: The Definitive Reference” by Rampant TechPress.
It’s only $41.95(I don’t think it is right to charge a fortune
for books!) and you can buy it right now at this link:
http://www.rampant-books.com/book_ 2005_1_awr_proactive_tuning.htm
