Re: Coalescing tablespace free space and EVENTS
Date: 1996/05/12
Message-ID: <3196565B.4247_at_gespro.com>#1/1
Vikas Agnihotri wrote:
>
> o How do I use ALTER SESSION SET EVENTS '.....';
> to coalesce the free space in my tablespace on demand without
> waiting for SMON to do it?
> I tried to do it as
> ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME COALESCE 7';
> where 7 is my TS# in SYS.TS$ and I got the following
> error
> "ORA-2194 event specification syntax error 230 (minor error 214) near
> '7'
>
> I would appreciate any feedback/comments/help.
>
> Thank you,
> --Vikas Agnihotri
> vikas_at_mink.att.com
The level in the following statement
ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME COALESCE level'
is obtain by combining two things:
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';