024
38/48/57
1. Tuning Overview 1
2. Oracle Alert and Trace Files 2
3. Utilities and Dynamic Performance views 3
4. Tuning the Shared Pool 7
5. Tuning the Buffer Cache 7
6. tuning the Redo Log Buffer 3
7. Database Configuration and I/O Issues 7
8. Using Oracle Blocks Efficiently 4
9. Optimizing sort Operations 4
10. Tuning Rollback Segments 4
11. Monitoring and Detecting Lock Contention 5
12. SQL Issues and Tuning Considerations for Different Applications 5
13. Managing a Mixed Workload 2
14. Tuning with Oracle Expert 1
15. Multithreaded Server Tuning Issues 2
1. which view can be used to monitor full table scan?
v$sysstat
no v$session_longops, so I have to choose v$sysstat.
2. Three types for tunning session scopes
instance
structure
application
3. After u query v$dispatcher and you add more dispatcher, following which situation will u meet possibly?
shared server process contention (*)
rbs header contention
4. which two statment are true for OLTP?
Using small block size instead of large size
Config more rbs
5. which two statments are true for stored outline?
Storaged in sys schema
Can be grouped with catogory
6. The first step of using DBMS_resource_manager package
create_pending_area
7. Which two views will be queried when you monitor lock contention?
v$lock
v$locked_object
v$locked_objects (error)
8. 考了一个关于optimizer first-rows 的题， 计不清楚了
9. Dead lock , detected message is recorded in which file
background_dump_dest
10. I/O slave and DBWR 的工作方式
I/O only works in 异步IO的情况下
DBWR only works in 异步IO的情况下
I/O slave works in 异步， dbwr works in 同步
I/O slave works in 同步， dbwr works in 异步
选2个， 具体看看书吧
11. log buffer must be the multiple of OS block size
12. which operations can avoid sort?
看书10-14
13. Why u set next value equal init value when create rbs?
minimal rbs header contention
rbs used in circulate mode
我不会
14. CURSOR_SPACE_FOR_TIME考了， 我印象很深，因为这个地方的书我没看懂。