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


Introduction To Oracle Server Consolidation (v2b, 10-February-2009) Technical Paper Free
Firefighting Diagnostic Template (1h, 17-June-2010) Free
Oracle Table Compression (Sept-2005) Free
Forecasting data collection script for Oracle and OS (v1.2 03-Sept-2008) Free
Advanced CPU Forecasting Excel Workbook (1d, 30-July-2008) Free
Intro to Oracle Performance Diagnosis - Desktop Conf Presentation (Feb 2006) Free
Hash Text Perl Script (14-Jul-2009) Free
All About Oracle's In-Memory Undo (06-May-2009) PRESENTATION Free
Forecasting Oracle Performance Book (Apress) $25.95