Re: Help coalescing free space

You need the joys of the coalesce trace event prior to 7.3 :)

alter session set events 'immediate trace name coalesce level X';

X is the tablespace# from sys.fet$

Regards,
Peter.

Ps. Calling all DBAs, if you haven't read and understood Rama Velpuri's Oracle  Backup & Recovery Handbook and Craig Shallahamer's Space Management and VLDB  papers, are you a really good DBA??? Received on Sat Nov 15 1997 - 00:00:00 CST