面试中的OracleDBA试题

会计考友

oracle dba interview questions by b g
1. how many memory layers are in the shared pool?
2. how do you find out from the rman catalog if a particular archive log has been backed-up?
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?
- T" W. `8 ~  G- r) g? 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
/ _' C# u2 K# R9 I3 O$ ?5 `9 `, {involved in tuning it?
  F0 ]; P& R" }: |- d7 `- }8 F6. 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?
8 K0 v/ V+ ~6 V8 e9 n7. how do you tell what your machine name is and w

会计考友

hat is its ip address?
8. how would you go about verifying the network name that the local_listener is currently using?
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?
10. what view(s) do you use to associate a user’s sqlplus session with his o/s process?
11. what is the recommended interval at which to run statspack snapshots, and why?
6 d) ]6 N, }  R2 _8 r1 W0 x12. 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?
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.
( b* I; k8 F) Y$ c9 G; g14. how would you edit your crontab to schedule the running of /test/test.sh to run every
  n, F# A. ~* l' F' gother day at 2pm?

15. what do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
1 B/ ^" T, [+ B16. in which dictionary table or view would you look to determine at which time a snapshot or mview last
successfully refreshed?