Re: Coalescing tablespace free space and EVENTS

Yves,
 Thank you for responding to my posting. I did try what you suggested but I still got the exact same error that I got earlier.
 I am running Oracle 7.2.2.3. Could that be the problem? Anyway, if it is a version related thing, I would think the error message I am getting is not appropriate. It seems like a syntax error thing.

  Could you also clarify what you mean by 'number of entries to coalesce'? If I dont have 5 extents to coalesce in tablespace 7, would the 'level=327687' fail **WITH** the error that I get? I am just trying to understand what is going on here. Any help/pointers appreciated.   

  Also, could you point me to or mail me information about all the other 'EVENTS' that you know of that I can use? I suppose this is all undocumented.

Thank you,
--Vikas Agnihotri
  vikas_at_mink.att.c

Yves Bergeron wrote:
>
> The level in the following statement
> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME COALESCE level'
> is obtain by combining two things:
> - the number of extents to coalesce
> - the tablespace number
>
> Example: 0x00050007 contains 0005 as the number of entries to coalesce
> in the tablespace number 7
>
> 0x00050007 represent the value 327687 in decimal form
>
> In your situation, the statement should be something like that:
> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME COALESCE 327687';
>
> Please note that this event may not be available if your version is 7.1
> and over.
Received on Mon May 13 1996 - 00:00:00 CEST