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!

Are views cached

580602Jun 5 2007 — edited Jun 11 2007

I have a view say view1

the first time i run it,it returns in 110 sec
the second time i run it,it returns in 10 sec

Are the views cached in oracle.IF so how to disable it
Kindly help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 9 2007

Added on Jun 5 2007

#general-database-discussions

9 comments

3,499 views