Database News

Top Articles

Hover to load posts
Features

Top Articles

Hover to load posts
Scripts

Top Articles

Hover to load posts
Mysql

Top Articles

Hover to load posts
MS SQL

Top Articles

Hover to load posts
Oracle

Top Articles

Hover to load posts
MS Access

Top Articles

Hover to load posts
DB2

Top Articles

Hover to load posts
PostgreSQL

Top Articles

Hover to load posts
SAP

Top Articles

Hover to load posts
PHP

Top Articles

Hover to load posts
Forums Forums

Listen Software’s How To: SQL Tuning – Performance

Written By

David Nishimoto

Jul 15, 2002

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

David Nishimoto

Recommended for you...

MySQL

Best Certifications for Database Administrators

We highlight some of the best certifications for database administrators. Learn about the top DBA certifications.

Ronnie Payne

Oct 14, 2022

MS SQL

Best Courses for Database Administrators

We highlight some of the best database administration courses for database admins and developers. Learn more.

Ronnie Payne

Jul 22, 2022

Oracle

TYPE Definition Change in Oracle 21c

SQL*Plus and PL/SQL have been at odds for years -- cases abound where how a task is performed using SQL*Plus differs from how that same or similar task is

David Fitzjarrell

Mar 4, 2021

Oracle

Is COUNT(rowid) Faster Than COUNT(*)?

A long-standing discussion in Oracle forums and newsgroups has been the efficiency of using count(*) to return a rowcount from a given table. A new

David Fitzjarrell

May 18, 2020

DatabaseJournal.com publishes relevant, up-to-date and pragmatic articles on the use of database hardware and management tools and serves as a forum for professional knowledge about proprietary, open source and cloud-based databases--foundational technology for all IT systems. We publish insightful articles about new products, best practices and trends; readers help each other out on various database questions and problems. Database management systems (DBMS) and database security processes are also key areas of focus at DatabaseJournal.com.

Listen Software’s How To: SQL Tuning – Performance

SQL 1: Library Cache

SQL 2: Data Cache Hit Ratio

SQL 3: Buffer Hit Ratio

SQL 4: Shared Pool Free Memory

David Nishimoto

Recommended for you...

Company

Categories