Coalescing tablespace free space and EVENTS
Date: 1996/05/10
Message-ID: <31939D7B.3CDC_at_mink.att.com>#1/1
I think this was posted and answered in this newsgroup some time back but I was unable to find the relevant articles in my Netscape News-reader. So, please bear with me and post your replies or mail directly to me.
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?
o On a more general note, what are the various 'EVENTS' that I
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'
EVENT=".......".
I would appreciate any feedback/comments/help.
Thank you,
--Vikas Agnihotri
vikas_at_mink.att.com
Received on Fri May 10 1996 - 00:00:00 CEST