Re: Hot block question -10gr2 solaris 10
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx
- Date: Tue, 3 Mar 2009 10:56:45 -0800
Chris,
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@xxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
