Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

first query very slow, subsequent queries fine

422223Apr 1 2005 — edited Apr 3 2005

In our 9i application when we first do a query it is extremely slow. If the database has not been used for sometime. This happens for sure after overnight, but also after an hour or so of inactivity during day.

After the initial query eventually completes, subsequent queries seem fast and no problem. Is just problem with first query.

This does not happen with all data. Just a particular group of data in our database.

any suggestions?

Thanks
John

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2005

Added on Apr 1 2005

#general-database-discussions

4 comments

699 views