DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: v$sqlarea

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    when i query my v$sqlarea.

    i found on statement like

    insert into mytable(col1,col2,col3) values(:1,:2,:3)
    executions=1
    disk_reads=7
    buffer_gets=183.


    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?

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    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

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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.

    d.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width