Training Schedule
FORECASTING
Publications
Tools
About OraPub
About OraPub Training
Testimonials
Class Pics
OraPub Consulting
Forecasting Forum
Speaker Request
About

  Home > Publications >

  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:

Publications


Piranhas In The Pool, SQL Performance Killers (July 2001) Free
OraPub

 About Us
 Privacy Policy
 Send Us Feedback
Company Info | Advertising | Product Index | Category Index | Help | Terms of Use
Copyright © 2005 OraPub, Inc.. All Rights Reserved.
Portland, Oregon USA - tel:+1.503.636.0228
Online Store Builder Powered By Volusion.