DBA

zhaozj2021-02-16  75

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.

转载请注明原文地址:https://www.9cbs.com/read-12749.html

New Post(0)