Re: Dealing with "orphaned" sessions

From: Bass Chorng <bchorng_at_yahoo.com>
Date: 5 Jun 2001 12:58:05 -0700
Message-ID: <bd9a9a76.0106051158.1f8a9fee@posting.google.com>

> At the risk of looking like a total fool, how would I check for temp
> segments? I've poked around with DBA_EXTENTS and DBA_SEGMENTS and
> don't see anything that identifies temp segments. If it is simply any
> segment in the TEMP tablespace, a SELECT TABLESPACE_NAME FROM
> DBA_SEGMENTS WHERE TABLESPACE_NAME = 'nameofmytempts' returns zero
> rows.

Your query is as simple as you think. I dont know why it returns nothing. Or you can alter your criteria to be where segment_type = 'TEMPORARY'.

You can also check into v$sort_segment see what that returns.

-Bass Chorng Received on Tue Jun 05 2001 - 14:58:05 CDT