Oracle
DBA Interview Questions and Answers
1)How
many memory layers are in the shared pool?
A)Sharedpool
contains 3 memory layers.
1.Library
cache:
2.Data
dictionary cache
3.UGA
Library
cache -contains parsed sql statements cursor information execution plansdata
dictionary cache -user account information priveleges information datafile
segment and extent information stored into the data dictionary cache.
2)How
do you find out from the RMAN catalog if a particular archive log has been
backed-up?
A)
3)
How can you tell how much space is left on a given file system and how much
space each of the
file
system's subdirectories take-up?
A)
#df -k to check free space in KB
#df -h to check free space in GB
