024考试回忆

　　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 hxdye 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)

[1] [2] 下一页