Re: x$bh.dbablk values (repost)

2003-06-02 Thread Daniel W. Fink
Wolfgang, Thank you for pointing this out. The ol' Uncertainty Principle (or Schrodinger's Cat). Of course, I may have my principles wrong (no comments on that one!). -- Daniel W. Fink http://www.optimaldba.com Wolfgang Breitling wrote: You are running into the classical problem with

Re: x$bh.dbablk values (repost)

2003-06-02 Thread Anjo Kolk
are you not comparing relative files to absolute files? This may not be a problem in your example, but still. On Monday 02 June 2003 05:24, Daniel W. Fink wrote: Wolfgang, Thank you for pointing this out. The ol' Uncertainty Principle (or Schrodinger's Cat). Of course, I may have my

x$bh.dbablk values (repost)

2003-05-30 Thread Daniel W. Fink
I am reposting this in the hopes that someone can help me with this puzzler. I am working on determining which objects have 'hot blocks'. In two different sessions, I issue select count(*) from random_data where rowid_rownum in (1,2,3); repeatedly to see what happens with the touch count

Re: x$bh.dbablk values (repost)

2003-05-30 Thread Wolfgang Breitling
You are running into the classical problem with monitoring an experiment: To what extent (no pun intended) does the monitoring change the experiment. Referencing dba_extent pulls in the segment headers of all segments owned by 'BCA'. When you interrogate x$bh have nothing else in your sql. Dump