Home » RDBMS Server » Enterprise Manager » Clarify my doubts!!
Clarify my doubts!! [message #68373] Mon, 30 June 2003 23:29
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi,
I m a begineer in Oracle DBA.
I have 3 doubts regarding fundamentals of DBA:
1) Where is the SGA allocated ?(virtual memory or RAM or shared)
2) As Cache is a fast memory, then where is data buffer cache(all 3 types), redo log cache is allocated?
(whether in cache or virtual or main memory)
3) Data dictionary cache stores the most recently used data definitions & the info. regarding the datafiles.
Is this info. reg. the datafiles is also the most recently, & if so then by what method used to get the data whose info. corresponding abt. datafiles is not there in data dictionary?

Any response will be highly appreciable.

TIA,
Sachin
Previous Topic: credential retrieval failure while loading Oracle
Next Topic: Reg. Integrity checks
Goto Forum:
  


Current Time: Sat May 21 14:05:33 CDT 2022