了解国外公司的Oracle DBA面试试题

Oracle DBA Interview Questions By B G x?Y+SEo  
^jBq<:G"  
　　1. How many memory layers are in the shared pool？ ucY4Q()q  
X [nM,XF  
　　2. How do you find out from the RMAN catalog if a particular archive log has been backed-up？ aVX\<>J #~  
FZ@YbAU
D  
　　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？ *)( ev;H  
Y k0"fI\  
　　4. Define the SGA and： FDRzBncE  
_w(Ir8HQ  
　　？ How you would configure SGA for a mid-sized OLTP environment？ a>M,J!  
zPR6zrU!?M  
　　？ What is involved in tuning the SGA？ Fx1/NF,  
.xo"*H"T)R  
　　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？ BKskt&YB  
[R_ B
W  
　　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？ R6RGa!Xz  
pjs, K  
　　7. How do you tell what your machine name is and what is its IP address？ o#`8:$Y (  
l(RKu;-J  
　　8. How would you go about verifying the network name that the local_listener is currently using？ E.q,Yf3  
;?QnQ~:  
　　9. You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance？ !e%BJ   
w k@ ;1  
　　10. What view（s） do you use to associate a user's SQLPLUS session with his o/s process？ AORf-Y%g  
jk-ABis  
　　11. What is the recommended interval at which to run statspack snapshots， and why？ h,OX(uj  
!#yA?e+  
　　12. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index， even if the index scan may appear to be calculated as more costly？ 62Mpr6#aZ  

-W.9 h^/B  
　　13. Assuming today is Monday， how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM. "+r/ADm-  
uwRz&KC<  
　　14. How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM？ x{ ~2`m  
`?lnMLz  
　　15. What do the 9i dbms_standard.sql_txt（） and dbms_standard.sql_text（） procedures do？ dFoAH:T^y  
)|x1HYo  
　　16. In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed？