 |
|
Oracle Tips by Burleson |
Watch Oracle Processes
Using the v$process view, you will write a
query that display the following information about your background
processes.
1. The terminal name – On a PC, this will be
your server name
2. The Program name – On UNIX, the background
processes will be named, but on a PC, they are all called oracle.exe
3. The process ID
4. PGA used memory – This is the amount of RAM
consumed by the process
5. PGA allocated memory – This is the amount
of RAM allocated by the process
Your report should look something like this:
TERMINAL PROGRAM PID PGA_USED_MEM PGA_ALLOC_MEM
---------------------------------- ---------- ------------ -----------
BASK ORACLE.EXE 2 107,139
110,567
BASK ORACLE.EXE 3 1,025,643
1,235,559
BASK ORACLE.EXE 4 4,330,847
4,536,823
BASK ORACLE.EXE 6 154,447
218,883
BASK ORACLE.EXE 8 81,003
105,731
BASK ORACLE.EXE 10 454,403
458,547
BASK ORACLE.EXE 13 213,047 10,319,487
BASK ORACLE.EXE 11 454,403
458,547
BASK ORACLE.EXE 9 454,403
458,547
BASK ORACLE.EXE 7 134,747
170,151
BASK ORACLE.EXE 5 120,459
137,807
Please develop the script and e-mail it to
your instructor by the due date.
ANSWER
column
terminal format a20
column program format a20
column pga_used_mem format 999,999,999
column pga_alloc_mem format 999,999,999
select
terminal,
program,
pid,
pga_used_mem,
pga_alloc_mem
from
v$process
order by
program;
spool off;
The main points of this tutorial include:
* The configuration of Oracle is governed by
over 250 parameters
* In Oracle 10g, almost all parameters can be
changed with “alter system” commands
* Special parameters such as the archive log
mode require bouncing Oracle and using special “alter database”
commands to change the values
* All Oracle databases consist of a RAM region
called the SGA and numerous background processes.
* Oracle has over a dozen background processes
to manage specific tasks such as archiving redo logs (ARCH) writing to
database files (DBWR), monitoring processes (PMON), and so on.
* The SGA region contain database block
buffers that are used to make data access faster. RAM access is up to
14,000 times faster than disk access.
* The SGA contains a shared pool region to
parse SQL ad perform internal operations.
We are now ready to move on to the next
tutorial titled “Creating an Oracle database”.
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
|
