dba interview questionspls post me answers fo rthis questions

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?

4. Define the SGA and:
• How you would configure SGA for a mid-sized OLTP environment?
• What is involved in tuning the SGA?

5. What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in tuning it?

6. Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check on an
Oracle 8i or 9i database?

7. How do you tell what your machine name is and what is its IP
address?

Hello, Your Questions are really nice!! but i think the last question is not related to oracle right?

This can be checked using operating system utilities also??

Hi checkout the answers.....well i am also new to the DBA role...so plzz let me know if i am wrong!!

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?
Answer:In unix you go to the specific mount point and say df -k to find the space in the mountpoint.
If u want to find the space in a particular tablespace...u can say
select file_name,bytes/1024/1024 from DB_DATA_FILES where tablespace name=xyz.

4. Define the SGA and:
• How you would configure SGA for a mid-sized OLTP environment?
• What is involved in tuning the SGA?
Answer:SGA stands for system global area and it is an Instance memory structure.
To configure SGA we need to setup the SGA_MAX_SIZE parameter in the init.ora file.
What is involved in tuning the SGA?----sorry no idea


5. What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in tuning it?

Answer:If the Oracle process can find the data already in the Database buffer cache,it can read the data directly from the memory and it is called a cache Hit.
If there is more cache hit the burden on the database reduces.

6. Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check on an
Oracle 8i or 9i database?
Answer:Did not understand whatz statspack....well the regular things we do to check the health of a DB is we check the Alert log files,have an eye on the backup logs and constant montitoring of the tablespaces and the number of sessions connected to the database and so on.....

7. How do you tell what your machine name is and what is its IP
address?
Answer:IPconfig or IFconfig

Plzzzzzz correct me if any of my answers are wrong!!!!

7. How do you tell what your machine name is and what is its IP
address?

If u r working on UNIX O/S them the below cmd wud give u the detailed info bout ur machine

w|more

Cheers........
Naveen

msvkrishna,




[B][COLOR="Blue"]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?
Answer:In unix you go to the specific mount point and say df -k to find the space in the mountpoint.
If u want to find the space in a particular tablespace...u can say
select file_name,bytes/1024/1024 from DB_DATA_FILES where tablespace name=xyz.


I think you have made some syntax errors in writting the query, the exact query is
select file_name,bytes/1024/1024 from DBA_DATA_FILES where tablespace_name='xyz';
[/COLOR][/B]

And on Solaris you can use du -sh to check the space occupied on given mount point.