Question on redo size in the Statistics
Indrakala Venugopal, August 27, 2002 - 11:50 am UTC
Tom,
Why does redo size appear when you take statistics of queries?
Pasted below are the statistics i got. Can you please tell me the areas i need to look inorder to improve performance.
Statistics
----------------------------------------------------------
96 recursive calls
122 db block gets
760692 consistent gets
76553 physical reads
232656 redo size
3914384 bytes sent via SQL*Net to client
615652 bytes received via SQL*Net from client
9311 SQL*Net roundtrips to/from client
325 sorts (memory)
0 sorts (disk)
139649 rows processed
regards
IK
August 27, 2002 - 1:34 pm UTC
The redo can appear for many reasons -- delayed block cleanout, space management (dictionary updates)
Caution, smart aleck answer ahead, read at your own caution:
Given the amount of information you supply above in regards to "how to improve performance" the only answer I can give given the amount of information you provide is:
Answer) only query DUAL. DUAL is very fast.
Seriously, read the designing and tuning for performance guide that comes with the database. That is a good start.
Tianhua Wu, August 27, 2002 - 4:57 pm UTC
set autotrace on will open another session that will insert and delete from plan table. That is probably why you see the redo.
August 27, 2002 - 9:21 pm UTC
Nope -- that other session would have its redo tracked against ITS session, not the one it is peeking at.
delayed block cleanout
space managment
those are the two likely culprits