Re: need advice for query time on Oracle

Thanks,

I set the trace on in sqlplus and redo the query, following is the statistics of the query on our production server:

Statistics

            recursive calls
         54  db block gets
       2989  consistent gets
       1596  physical reads
            redo size
        232  bytes sent via SQL*Net to client
        316  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
            sorts (memory)
            sorts (disk)
          1  rows processed

While the statistics in my pc is:
Statistics

         18  recursive calls
         57  db block gets
       3157  consistent gets
          1  physical reads
            redo size
        434  bytes sent via SQL*Net to client
        425  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          2  sorts (memory)
            sorts (disk)
          1  rows processed

I noticed the "physical reads" in the production server is pretty big. I also checked the "db_block_buffer" is 20,000, db_block_size=8096. Since the RAM in that server is 10G, maybe increasing the db_block_buffer
will improve the performance?

--
Posted via http://dbforums.com