Re: Hot block question -10gr2 solaris 10

It is a temp file. I guess you have set the db_files=300.

Best Regards,
K Gopalakrishnan

Oracle Database 10g Real Application Clusters Handbook http://www.amazon.com/gp/product/007146509X/

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

On Tue, Mar 3, 2009 at 10:40 AM, Newman, Christopher <cjnewman_at_uillinois.edu> wrote:
> We're trying to find a hot block:
>
> select p1 "File #", p2 "Block #", p3 "Reason Code" from v$session_wait
> where event = 'buffer busy waits';
>
>    File #    Block # Reason Code
> ---------- ---------- -----------
>       304          2          13 (File block header)
>       304          2          13
> .....
>
> Here's the issue, there is *no* file# 304.  There are only 240 datafiles
> in the database and only a handful of temp files.  304 matches neither
> the file_id nor relative_fno in dba_data_files.  Nothing maps to that in
> dba_segments either.  Is this a bug, or are we doing something wrong
> here?
>
> Chris Newman
> Database Specialist
> AITS, University of Illinois
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l