熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

024考試回憶

2013-11-13 16:13:58  來源: Oracle 

  
  //
  
   Tuning Overview
   Oracle Alert and Trace Files
   Utilities and Dynamic Performance views
   Tuning the Shared Pool
   Tuning the Buffer Cache
   tuning the Redo Log Buffer
   Database Configuration and I/O Issues
   Using Oracle Blocks Efficiently
   Optimizing sort Operations
   Tuning Rollback Segments
   Monitoring and Detecting Lock Contention
   SQL Issues and Tuning Considerations for Different Applications
   Managing a Mixed Workload
   Tuning with Oracle Expert
   Multithreaded Server Tuning Issues
  
   which view can be used to monitor full table scan?
   v$sysstat
   no v$session_longops so I have to choose v$sysstat
  
   Three types for tunning session scopes
   instance
   structure
   application
  
   After u query v$dispatcher and you add more dispatcher following which situation will u meet possibly?
   shared server process contention (*)
   rbs header contention
  
   which two statment are true for OLTP?
   Using small block size instead of large size
   Config more rbs
  
   which two statments are true for stored outline?
   Storaged in sys schema
   Can be grouped with catogory
  
   The first step of using DBMS_resource_manager package
   create_pending_area
  
   Which two views will be queried when you monitor lock contention?
   v$lock
   v$locked_object
   v$locked_objects (error)
  
   考了一個關於optimizer firstrows 的題 計不清楚了
  
   Dead lock detected message is recorded in which file
   background_dump_dest
  
   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 異步
   選 具體看看書吧
  
   log buffer must be the multiple of OS block size
  
   which operations can avoid sort?
   看書
  
   Why u set next value equal init value when create rbs?
   minimal rbs header contention
   rbs used in circulate mode
   我不會
  
   CURSOR_SPACE_FOR_TIME考了 我印象很深因為這個地方的書我沒看懂
From:http://tw.wingwit.com/Article/program/Oracle/201311/17992.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.