Re: Full Oracle Block

On Thu, 15 Jan 2004 08:44:18 -0800, Vincento Harris wrote:

> Oracle version 8.1.7.4
> Os Hp Unix 11
>
> There is table that is updated very often , though pctused and
> pctfree are at the defaults.Lately there has been consistent ORA-060
> (Dealock detected waiting for resource)
>
> The initrans is 1 and the maxtrans is 255.Is it possible that the
> block is close to full and there is no room for creating a new ITL ?
>
> As usual "nothing has changed"
>
> What would be the best way to investigate how full the block is?
> 100% statistics are run nightly both on tables and indexes
> Mike

Try dumping few blocks, by using
 alter system dump datafile <file #> block <block #>;

It will send the dump of the named blocks into the trace file on USER_DUMP_DEST.

-- 
None of us is as dumb as all of us.
(http://www.despair.com/meetings.html)