modelling physical writes

  • From: ryan_gaffuri@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 13 Sep 2006 19:40:47 +0000

How do we get solid numbers to determine how many physical writes a specific 
sql or pl/sql package will perform? When we use 10046 I believe it only gets 
physical reads because the dbwriter is asynchronous? I have some concerns about 
using AWR for this. 

Also, how do we get reliable redo numbers? When I use set autotrace on and run 
the same insert multiple times the redo seems to vary by 20% or so. 

Other related posts: