Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: oracle-l Digest V4 #150
Minor exception to worry about:
The default in 10.2 (if not 10.2) is to use delayed invalidation on calculating statistics.
To avoid a massive cache flush during things like the 'autotstats' job, cursors are somehow marked for invalidation over the next few hours.
On a completely different topic - could people think about trimming posts before responding, please. It's not necessary to keep echoing the ENTIRE chain every time you add a few lines of comment.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 01 2007 - 03:45:21 CDT
![]() |
![]() |