Peoplecnc.com - HOW DISPLAY THE ORACLE DATABASE SYSTEM GLOBAL AREA DATA

ERP and Technical Documentation

Oracle ERP1
JDEdwards

Topics
Home General News (1/202) ERP White Papers (0/225) JDEdwards - Peoplesoft - Oracle ERP1 White Paper (9/218) Oracle Documentation and White Papers (19/456) Oracle DBA Commands (1/222) Webserver / Apache (2/232)

User Functions
Username: Password: Don't have an account yet? Sign up as a New User Lost your password?

Events
There are no upcoming events

Older Stories

Wednesday 17-May

Thursday 11-May

Wednesday 10-May

Monday 08-May

Welcome to Peoplecnc.com
Wednesday, September 08 2010 @ 07:17 AM CDT

HOW DISPLAY THE ORACLE DATABASE SYSTEM GLOBAL AREA DATA

Monday, May 01 2006 @ 12:57 PM CDT
Contributed by: sv800
Views: 2,886

Command to display the information about shared data processes of oracle databases

The Oracle database system global data

It stores information about shared data processes of the server like data buffer, cache size.

First, logon using sql*plus to the oracle database

Command:

SQL> SHOW SGA

Total System Global Area 1471948828 bytes
Fixed Size 75804 bytes
Variable Size 387203072 bytes
Database Buffers 1084170240 bytes
Redo Buffers 499712 bytes
------------------

Notice this area grows or shrinks dynamically

What's Related
More by sv800 More from Oracle Documentation and White Papers

Story Options
Mail Story to a Friend Printable Story Format