Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Oracle Parallel Server/Real Application Clusters

The following views are specific to an Oracle Parallel Server/Real Application Clusters environment:

*$ACTIVE_INSTANCES

Lists all current instances that have the database mounted.

*$BH

Provides the status and pings of every data buffer in the System Global Area (SGA). Available after database is opened.

*$CACHE

Provides information about the block header of every object the current instance has in its SGA. Available after database is opened.

*$CACHE_LOCK

Provides the lock status of every data block the current instance has in its SGA. Available after database is opened.

*$CLASS_PING

Shows statistics on the number of pings per data block class.

*$FALSE_PING

Lists buffers that are getting excessive pings because they are covered under a different lock. Buffers that are identified can be remapped using the initialization parameter GC_FILES_TO_LOCKS. Available after database is opened.

*$ENQUEUE_STAT

Lists statistics about each of the different types of enqueue request for a particular database instance. An enqueue is used to prevent multiple users or processes from writing to the same data block at the same time. New with Oracle9i.

*$FILES_CACHE_TRANSFER

Shows the number of block pings per datafile. Prior to Oracle9i this view was called *$FILE_PING. Available after database is mounted.

*$GCSHVMASTER

Tracks the mastering of Global Cache Service resources, except those that are in files that are mapped to a specific instance. New with Oracle9 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page