2006年11月16日 18:33

有關autotrace出來的訊習說明

近來準備033的考試,正在學習使用autorace的方法,但不知到出來的訊習代表的意思為何。經查google後查得到不錯的答案

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4783147586098

recursive calls = basically sql performed on behalf of your sql.  So, if we had 
to PARSE the query for example, we might have had to run some other queries to 
get data dictionary info.  that would be recursive calls.  

db block gets = blocks gotten in "current" mode.  That is, blocks gotten as they 
exist right now.  You'll see these for full table scans (segment headers are 
read in current mode) and modification statements (we modify the block as it 
exists "right now")

consistent gets = blocks gotten in consistent read mode.  This is the mode we 
read blocks in with a select for example.  Also, when you do a searched 
UPDATE/DELETE, we read the blocks in consistent read mode and then get the block 
in current mode to actually do the modification.  A select for update will do 
this as well.

physical reads = self explanatory, physical IO

redo size = self explanatory -- amount of redo generated

sorts (memory)/(disk) -- sorts done.

  • my_work 發表於樂多回應(0)引用(0)DB編輯本文
    樂多分類:網路/3C │昨日人次:0 │累計人次:48
    Ads by Roodo! 

    引用URL

    http://cgi.blog.roodo.com/trackback/2482964