26. 举出3种可以收集three advisory statistics 解答:Buffer Cache Advice, Segment Level Statistics, Timed Statistics
/ n2 D. l W+ C: Q+ t* W 27. Audit trace 存放在哪个oracle目录结构中?9 _7 R1 W+ I) s6 B, [% e$ _
解答:unix $ORACLE_HOME/rdbms/audit Windows the event viewer& T* h2 V) {6 S$ |
28. 解释materialized views的作用8 K4 _9 D# N- c
解答:Materialized views 用于减少那些汇总,集合和分组的信息的集合数量。它们通常适合于数据仓库和DSS系统。' b' v) f0 o |. p! b, z, k0 K
29. 当用户进程出错,哪个后台进程负责清理它8 k. S1 C( J3 c' u2 L
解答: PMON
" j% h* y ]* i) g# m 30. 哪个后台进程刷新materialized views?
9 R5 }$ z H& x; G, z 解答:The Job Queue Processes. |