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!

Configuring db_cache in order to improve performance

261003Mar 22 2005 — edited Mar 29 2005

Hi my friends,

I have a SQL query that is spending much time to be executed. I would to know if I would increase the db_cache, this query would spend less time to be executed? How could I configure the Oracle db_cache? My database is Oracle 9i.
Is there an other parameter to be configured in the database in order to become the execution faster?

Thanks.

Carla

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2005

Added on Mar 22 2005

#general-database-discussions

14 comments

412 views