SQL> SET WRAP OFFSQL> SET LINESIZE 200SQL> SELECT * from V $ bgprocess;
Connecting to an an Oracle Instance Consists OfESTABLISHING A User Connection and Creating A Session.
9isga IS Dynamic and Size Download SGA_MAX_SIZE;
ALTER SESTEM SET DB_CACHE_SIZE = 64M;
Alter session set nls_language = american; *** You can view it ????
Dictionary cache = row cache? Do not understand
Library Cache Is Managed by a Least Recently Used (LRU) Algorithm Lost Lost Lost
Reading is to read according to DB Block, it is a block, a block read, only one line is also reading a block.
DB_CACHE_SIZEDB_KEEP_CACHE_SIZEDB_RECYCLE_CACHE_SIZEDB_CACHE_ADVICE
ALTER system set db_cache_advice = on;
PGA (Program Global Area) The PGA IS Memory Reserved for Each User Processthat Connects To An Oracle Database;
Dedicated Server PGA includes Stack Space Session InformationSort AREACURSOR INFORMATION
The PGA in Shared Server includes Stack SPACE SORT AREACURSOR INFORMATION where session information is placed in SGA.
Server Process: Connects to the Oracle Instancend Is Started When A User Establishes a session.and it can be deficated or shared server.