Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$SGASTAT

This view contains detailed information on the system global area (SGA).

Column Datatype Description

NAME

VARCHAR2(26)

SGA component name

BYTES

NUMBER

Memory size in bytes

POOL

VARCHAR2(11)

Designates the pool in which the memory in NAME resides:

  • large pool - memory is allocated from the large pool
  • shared pool - memory is allocated from the shared pool
  • java pool - memory is allocated from the Java pool