Re: strange behavior in 9.2.0.4 - no blocks in keep buffer pool for table
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 9 Jun 2004 14:31:47 -0700 (PDT)
--- 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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
