Databases Reference
In-Depth Information
8.
In SQL*Plus, verify if the
SGA
is locked querying the parameter
LOCK_SGA
:
SHOW PARAMETER LOCK_SGA
9.
Query the
V$PROCESS
dynamic performance view to obtain a list of
database processes:
SELECT PID, SPID, SERIAL#, PNAME FROM V$PROCESS;
How it works...
In this recipe, we explore the interactions between the Oracle database and the hosting
Operating System, related to memory and processes. To do so, we use two tools: SQL*Plus
command line interface and Oracle Enterprise Manager web interface. We
use a
SYSDBA
account to log in using both the tools.
The first operation after logging in, in step 2, allows us to know the size of the SGA. The SGA
represents the most important memory structure in the Oracle database, and it consists of
different parts. The Shared Pool, the Buffer Cache, and the Redo Log Buffer are the most
important ones. The SGA is shared among all the users of the database.
In the following screenshot, we can see the results of the command in step 2 and the query
in step 3:
If you want to know more details about the size of the different SGA components, execute
the query in step 4; you will obtain a more comprehensive view of the memory used by
the database.
