when i query my v$sqlarea.
i found on statement like
insert into mytable(col1,col2,col3) values(:1,:2,:3)
can anybody explain to me why such an simple DML run only
one time take some many buffer_gets and disk_reads.
how to tune it?
What kind of constraints and triggers are on the table?
How many rows are in the table?
What type of indexes are on which columns in the table?
Oracle DBA and Developer
i would use sqltrace/TKPROF or sqlplus trace for more reliable stats. you should also consider delayed block cleanouts as a source of extra work, as well as triggers & indexes as indicated by kmesser.
Click Here to Expand Forum to Full Width