Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic elements of Base configuration of an
oracle Database ?
- 1 Answers
- 5659 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
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 index hunting contributes in improving the query performance?
Explain environment of openedge?
What are different cursor types in dbms?
What is built_in Subprogram ?
What do you understand by index hunting?
Is sql is a dbms?
What is key dbms?
Explain what are service-specific middleware?
What is query in rdbms?
What do you mean by Correlated subquery in database?
How to activate all indexes in firebird?
What is tuple and attribute?
What is the purpose of sql?
How do I check my drivers?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
