Donald K. Burleson Oracle Tips

Oracle latch analysis

There is nothing more irritating than spending an hour and a half reading an in-depth white paper on something like Oracle latch analysis (that provides numerous graphs and a bibliography the size of your arm), and then discovering that following the author's advice yields no noticeable benefit on the database. 

This chapter will work to give you what you need to maximize memory inside and outside your database by focusing on the following topics:

·        How to determine if you are giving the right amount of memory to Oracle

·        What new memory options in Oracle offer the most potential for improving performance

·        How to keep data, code, and object definitions in memory so response times are the fastest possible

·        How to quickly pinpoint user sessions that degrade response times by using excessive memory resources

Once you understand these things, you will be in a better position to ensure that your Oracle database is properly configured from a memory standpoint.  To begin, you need to analyze the current memory configuration and usage of the database.

The above is an excerpt from Oracle Performance Troubleshooting by Robin Schumacher.

It's only $19.95 and you can order it and get instant access to the Oracle scripts here:

http://www.rampant-books.com/book_2003_1_perf.htm