Home > Technical Papers/Books >

  Piranhas In The Pool, SQL Performance Killers (July 2001)
 
 
Our Price: Free


Availability: Available for download now
Product Code: SP1

Description
 
This paper investigates the effects of non-sharable SQL on Oracle performance and presents quantitative results of controlled testing of the issue. Oracle shared pool and library cache internals are discussed, as well as DBA strategies for managing performance of high-volume non-sharable SQL. The new 8.1.6 CURSOR_SHARING parameter is also tested for its effectiveness at solving these issues.
 


Browse for more products in the same category as this item:

Technical Papers/Books