Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> modelling physical writes

modelling physical writes

From: <ryan_gaffuri_at_comcast.net>
Date: Wed, 13 Sep 2006 19:40:47 +0000
Message-Id: <091320061940.6493.45085EBF0006CCB70000195D2207021053079D9A00000E09A1020E979D@comcast.net>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 13 2006 - 14:40:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US