Re: strange behavior in 9.2.0.4 - no blocks in keep buffer pool for table

--- Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
wrote:
> 
> Paul,
> 
> I've just read the item, and there is an error
> in the oci_block_header view ,
> 
> the line:
>     where b.obj = o.obj#
> should read
>     where b.obj = o.dataobj#
> 
> This may fix your problem.
> I'll edit the item later on tonight.
> 
> Regards
> 
> Jonathan Lewis

Jonathan,

thanks for the prompt reply, that worked great.
49672 blocks in the KEEP buffer_pool for that table.
Sorry about posting to the list, should have emailed
you first, I thought that since v$bh was also empty,
that the symptoms had nothing to do with the views.

Paul




        
                
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: