Re: Dropping Segments

amerar_at_iwc.net (Arthur) wrote in message news:<8b622eae.0411300845.28be6f60_at_posting.google.com>...
> Hi All,
>
> I came across this command on some web posting:
>
> alter session set events 'immediate trace name DROP_SEGMENTS level
> TS#+1';
>
> What I am curious about is, whether the above command drops only temp
> segments in the identified tablespace, or ALL segments in the
> tablespace???
>
> I assume this is a way to 'force' SMON to wake up and do its job more
> rapidly?
>
> Any takers on this?

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=47400.1

Temporary segments, instead of SMON.

One time it worked for me, another it didn't, IIRC.

jg

--
@home.com is bogus.
No electrons have been hurt in the manufacturing of this message.