RE: What can free space in a TS?

What segments exist in that TS?

select segment_name, segment_type, owner from dba_segments where tablespace_name = '<TS>';

What's living in that TS that is so active?

--Scott Shafer
  San Antonio, TX

> -----Original Message-----
> From: Jesse, Rich [SMTP:Rich.Jesse_at_qtiworld.com]
> Sent: Friday, January 05, 2001 1:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What can free space in a TS?
>
> Sorry, all, but it's not a TEMP space.
>
> I knew I should have mentioned that in the message... <blush>
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI
> USA
>
>
> > -----Original Message-----
> > From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
> > Sent: Friday, January 05, 2001 13:38
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: What can free space in a TS?
> >
> >
> >
> > do a select from dba_users:
> >
> > select username from dba_users
> > where temporary_tablespace='<TS in question>';
> >
> > If someone has that tablespace as their temporary tablespace, it will
> > fragment it
>
>
> -----------------------------------------------------------------------
>
> This message has been scanned for viruses with Trend Micro's Interscan
> VirusWall.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jan 05 2001 - 14:17:00 CST