| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: which Objects in buffer cache
Hi Harvinder,
How you are inserting rows (can you provide the code)?
Which SQL you are using for querying V$BH?
I have created stupid testcase and able to see both table's blocks in memory (see below).
Jurijs
9268222
SYS:jozh> @ver
BANNER
SYS:jozh> create table test_source (n number) tablespace users; SYS:jozh> create table test_destination (n number) tablespace users; SYS:jozh> begin for f in 1..10000 loop SYS:jozh> insert into test_source values (f); SYS:jozh> end loop; commit; end; SYS:jozh> /
SYS:jozh> insert into test_destination select * from test_source;
10000 rows created.
SYS:jozh> commit;
Commit complete.
SYS:jozh> select OBJD, count(*) from v$bh
SYS:jozh> where OBJD in (
SYS:jozh> select DATA_OBJECT_ID from dba_objects
SYS:jozh> where object_name in ('TEST_SOURCE','TEST_DESTINATION')
SYS:jozh> )
SYS:jozh> group by
SYS:jozh> OBJD;
OBJD COUNT(*)
---------- ----------
9957 24
9958 24
"Harvinder Singh" <Harvinder.Singh_at_MetraTech.com>
Sent by: oracle-l-bounce_at_freelists.org
07.07.2004 20:32
Please respond to oracle-l
To: <oracle-l_at_freelists.org>
cc:
Subject: which Objects in buffer cache
Hi,
We are using v$bh, dba_objects and dba_segments views to see what
objects are in buffer cache. We are reading from 1 table and inserting
into 2nd table. I can see the 1st table but not the 2nd table in this
query result.
I expect oracle to load data from disk to buffer and then write to
buffers and should show the tables and indexes of 2nd table in buffer.
What can be the possible reason that v$bh is not showing
objects/segments of 2nd table?
Thanks
--Harvinder
 |
 |