CoderZone.org

Category: >> Oracle PL/SQL >> Cache Stats Bookmark and Share

<< lastnext >>

Snippet Name: Cache Stats

Description: Shows stats of objects in shared memory.

Filename: dba_cache_stats.sql
Parameters: None
Description:

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile info...
» Find users with deadly privileges
» Audit User Logins (User Login Trig...
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 11th, 2009

SET pagesize 55;
SET linesize 100;
col namespace heading "Name" format a25;
col gethitratio format 9999999 heading "Get Hit|Ratio";
col pinhitratio format 9999999 heading "Pin Hit|Ratio";
col reloads format 9999999 heading "Reloads";
col invalidations format 9999999 heading "Invalid|Count";
 
SELECT namespace,
       gethitratio,
       pinhitratio,
       reloads,
       invalidations
FROM v$librarycache
ORDER BY reloads DESC, namespace
/
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 8