Home / Tag Archives: PGA

Tag Archives: PGA

RMAN Channels

RMAN Channels The RMAN client directs database server sessions to perform all backup and recovery tasks. What constitutes a session depends on the operating system. For example, on Linux, a server session corresponds to a server process, whereas on Windows it corresponds to a thread within the database service. The …

Read More »

Shared Server Architecture

Shared Server Architecture In a shared server architecture, a dispatcher directs multiple incoming network session requests to a pool of shared server processes, eliminating the need for a dedicated server process for each connection. An idle shared server process from the pool picks up a request from a common queue. …

Read More »

Overview of the System Global Area

System Global Area

Overview of the System Global Area The SGA is a read/write memory area that, along with the Oracle background processes, makes up a database instance. All server processes that execute on behalf of users can read information in the instance SGA. Several processes write to the SGA during database operation. …

Read More »

Database Instance Structures

Database Instance Structures   An Oracle database uses memory structures and processes to manage and access the database. All memory structures exist in the main memory of the computers that constitute the R DBMS. When applications connect to an Oracle database, they are connected to a database instance. Oracle Database …

Read More »

SELECT STATEMENT PROCESSING

SELECT STATEMENT PROCESSING

SELECT STATEMENT PROCESSING Server process will receive the statement sent by user process on server side and will handover that to library cache of shared pool The 1st phase of sql execution i.e Parsing will be done in library cache. Then, OPTIMIZER (brain of oracle sql engine) will generate many …

Read More »

COMPONENTS OF ORACLE DATABASE ARCHITECTURE

REDOLOG FILES & CONTROL FILES INTERVIEW QUESTIONS

COMPONENTS OF ORACLE DATABASE ARCHITECTURE USER PROCESS : It is the process which places request from client side and will be created when user starts any application. SERVER PROCESS : It is the process which will do work on behalf of user process on server side. PRIVATE GLOBAL AREA (PGA) …

Read More »

PHASES OF SQL EXECUTION

SELECT STATEMENT PROCESSING

PHASES OF SQL EXECUTION Any SQL statement will undergo following phases to get executed PARSING : This phase will perform following actions Syntax checking of the SQL statement Semantic checking of the statement i.e. checking for the privileges using base tables Diving the statement into literals EXECUTION : This phase …

Read More »

OPERATING SYSTEM FUNCTIONALITY THEORY

OPERATING SYSTEM FUNCTIONALITY

 OPERATING SYSTEM FUNCTIONALITY Whenever user sends a request, primary search for the data will be done in RAM. If the information is available, it will be given to the user. Otherwise, secondary search will be done in hard disk and copy of that info will be placed in RAM before …

Read More »
DON’T MISS OUT!
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.
close-link
GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe