hat is its ip address? ( Y* Z4 I2 U% w0 H& U% R
8. how would you go about verifying the network name that the local_listener is currently using?
$ m* J1 w0 E1 y: N9 a* U9. you have 4 instances running on the same unix box. how can you determine which shared memory and
# \4 I+ P6 D: ^" n( z Y9 S- ssemaphores are associated with which instance?
+ }6 F$ [ L' u+ Z10. what view(s) do you use to associate a user’s sqlplus session with his o/s process? R8 i8 W/ a q$ I
11. what is the recommended interval at which to run statspack snapshots, and why? 0 |% }- d; b" O
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?
6 b0 T4 f5 \& z& p2 }( ~13. assuming today is monday, how would you use the dbms_job package to schedule the execution of a
0 k6 g, t2 A2 \8 Z, R9 u" f) C* agiven procedure owned by scott to start wednesday at 9am and to run subsequently every other day at 2am.
3 p2 H- v; D7 `) e+ K3 T- {5 M' n$ m14. how would you edit your crontab to schedule the running of /test/test.sh to run every 8 W" L* E7 w$ f% x
other day at 2pm?
. z* j( e' u" Z3 A# j
, M3 x0 ~/ G: C, _1 S15. what do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Y* F$ {5 S+ ]7 c o. a16. in which dictionary table or view would you look to determine at which time a snapshot or mview last
3 Q% @5 A: G! z. J! {8 y: w, D3 s6 ksuccessfully refreshed? |