2006年11月16日
有關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.
引用URL
http://cgi.blog.roodo.com/trackback/2482964