Listen Software's How To: SQL Tuning - Performance

Monday Jul 15th 2002 by David Nishimoto
Share:

SQL code to analyze the library cache, data cache hit ratio, buffer hit ratio, and shared pool free memory.

SQL 1: Library Cache

Click here for code example 1.

SQL 2: Data Cache Hit Ratio

Click here for code example 2.

SQL 3: Buffer Hit Ratio

Click here for code example 3.

SQL 4: Shared Pool Free Memory

Click here for code example 4.


Back to the LSS "How To" Series Main Page


Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved