From: leng@cougar.vut.edu.au (Leng Kaing) Subject: Re: Coalescing Free Space Date: 1996/05/05 Message-ID: <4mi167$j9f@cougar.vut.edu.au>#1/1 references: <317BC352.4398@leadingbits.via.at> <3189CE60.6896@leadingbits.via.at> <4mgmqe$1n7@news.utdallas.edu> followup-to: comp.databases.oracle,comp.databases.ms-access organization: Victoria University of Technology newsgroups: comp.databases.oracle,comp.databases.ms-access Yan Chen (chloe@utdallas.edu) wrote: : Hi everyone, : Did anyone use "alter session set events 'immediate trace : name coalesce level n';" before? Please tell me what exactly : this command is doing. Also is there any information about : how oracle coalesces its free space? it should be version- : specific I think. Yep. I've used it in situations where I just wanted the free space to be coalesced NOW, not when SMON is ready. Can't remember exactly remember the delay involved if you waited for SMON. This command is works for 7.1.3. I hear that in 7.2, there's a similar command. Again, can't remember what it is. Well, I'm only on 7.1.3 for VMS! HTH, Leng. -- Leng Kaing DBA - Directory Technology P/L Email: lkaing@ventnds1.telecom.com.au Ph: +61-3-9892-9081 Fax: +61-3-9892-9344 WWW: http://www.vut.edu.au/voug