Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic element of Base configuration of an
oracle Database ?
- 2 Answers
- 5258 Views
- I also Faced
- E-Mail Answers
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
What is the sid in oracle?
How to apply filtering criteria at group level in oracle?
What happens to the indexes if a table is recovered?
how to make an oracle object
Can you tell me how to add new column in existing views?how?How is possible?
How to write a query with an inner join in oracle?
How to write text literals in oracle?
What is the difference between postgresql and oracle?
What is redo log?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to use subqueries in the from clause in oracle?
What is a lookup table in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
what are the advantages of running a database in archive log mode?
