Oracle instance is containing memory areas and background processes. Instance is used to communicate with the database files.
When an Oracle Instance started, oracle database allocates memory areas and background process.
The memory areas contains the information of
Memory Structures
Database Buffer Cache
Shared Pool
Redo Buffers
Java pool
Large Pool
Streams Pool
Background process: Background process divided into 2 types
Mandatory Background Process
Optional Background Process
What is the database?
Database is the set of physical datafiles on disk which are created by create database statement.
What are the oracle Database memory structures?
Once started the oracle instance, Oracle Database allocates the memory areas and set of background process. These memory areas store’s the information of
1. Each session information (Both active and inactive)
When an Oracle Instance started, oracle database allocates memory areas and background process.
The memory areas contains the information of
- Program code.
- Information about each connected session even it is in inactive.
- Information needed during program execution, for example current state of the query from which rows are being fetched.
- Information such as lock data that is shared and communicated among the processes.
Memory Structures
Database Buffer Cache
Shared Pool
Redo Buffers
Java pool
Large Pool
Streams Pool
Background process: Background process divided into 2 types
Mandatory Background Process
Optional Background Process
What is the database?
Database is the set of physical datafiles on disk which are created by create database statement.
What are the oracle Database memory structures?
Once started the oracle instance, Oracle Database allocates the memory areas and set of background process. These memory areas store’s the information of
1. Each session information (Both active and inactive)
0 $type={blogger}:
Post a Comment