RE: How to find no of blocks

Hi Mark,

What do you do to invalidate cached blocks - a direct read, or something else?

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of mteehan_at_erggroup.com
Sent: Thursday, 27 July 2000 13:15
To: Multiple recipients of list ORACLE-L Subject: RE: How to find no of blocks

I have been working on this for quite a while. It is possible to analyze the
buffer cache, but it takes a lot of digging through such files as sql.bsq,
catparr.sql and catpart.sql to find how things hang together. As for linking
object ID's, on 8.1.6, x$bh.obj can be joined to one of sys.obj$.obj# or
sys.obj$.DataObj#, depending on whether its partitioned, or a LOB 'virtual'
object etc (note LOBs are particularly tricky to trace). I have built a pl/sql
script that loads a table with data on each object in the buffer cache, how many
blocks it has, their status, buffer pool, partition etc. After MUCH trial and error, Ive found various means of removing objects and
loading objects to buffer cache using pl/sql scripts, which allows me to
switchover from OLTP to end of day DSS processing without losing my KEEP pool.
Also allows OLTP daily partitioned tables to roll in/out without blatting
memory.
 Works like a treat (It autorefreshes to an access97 interface with buttons to
control the oracle buffer cache).
IMHO Oracle should allow DBA's to do this stuff : it should be possible to
define various buffer pools and assign objects to them to control how memory is
used (Oracle 10 will be here any day now).

Regards
Mark Teehan

• ERG Group -------------------------- The contents of this email and any attachments are confidential and may only be read by the intended recipient.

  ---

--
Author:
  INET: mteehan_at_erggroup.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may