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:
