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 11:17:28 -0700 (PDT)
unexpected behavior in 9.2.
blocks are not appearing for a table in v$bh.
at all.
not via a table scan, not via index access.
I don't see any of this table's blocks in v$bh in
production, either.
testing environment
9.2.0.4 on w2k adv svr sp4 /3GB
4 GB physical memory
sga max size set to 2.5 GB
db_block_size=8KB
db_cache_size=1.5 GB
db_keep_size=.5 GB
test heap table has 46246 blocks (363 MB).
alter table <table_name> storage (buffer pool keep);
alter table <table_name> cache;
bounced database instance.
select distinct <column_name> from <table_name>
where pk_id in ( ... list of 10 values ... );
verified that table access is via index.
still no blocks appear in v$bh, x$bh or the views that
Jonathan published here:
http://www.jlcomp.demon.co.uk/faq/pin_table.html
has anyone seen this, did I miss something?
I'll admit that since we went from 7.3.4 to 8.1.6, I
stopped using the keep pool and marking tables as
"CACHE". There is one table that is getting hammered,
that I would very much like to cache.
thanks in advance.
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:
