Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> query performance
I have two databases, TEST and DEVL. I open TOAD and log into DEVL and run
a typical query out of our application. It takes 2 seconds to return the
result. I log into TEST and run the same query. It takes 177 seconds for
the query to return the result set.
The view that the query is based on contains 106 rows in DEVL and 165 rows in TEST.
I have compared all the Oracle parameters of both databases. I only had a few differences including open_cursors, shared_pool_reserved_size, and shared_pool_size. In all cases the TEST database had a larger value than DEVL. The differences were less than 10% except with open_cursors. TEST had 500, DEVL had 300.
What would explain the difference in performance between the two databases? What else should I be looking at?
Thanks for any help.
-- Jim Poe (jpoe_at_fulcrumit.com)Received on Wed Oct 10 2001 - 15:44:01 CDT