What are the basic element of Base configuration of an
oracle Database ?
Answer Posted / sawant
It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop a tablespace?
What is coalesce function?
How to return top 5 rows in oracle?
How to use select statement to count the number of rows in oracle?
How to lock and unlock a user account in oracle?
What are the data types in oracle?
In which language oracle has been developed?
What happens if you lost a data file?
How to open and close an explicit cursor in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Which are the five query types available in oracle?
What is a sub query and what are the different types of subqueries?
How to update values in a table in oracle?
Explain parameter file in oracle.
Where are the settings stored for each instance in oracle?