Hemant
Why don't you get resolve the issue of "wonderful SQL query" user is still
around in the database}."
which is occupying that much tempspace? Either the query is resulting in
cartesian join or tables involved have degree > 1 resulting sort type
'hash'. Check your V$sort_usage when that co
Not exactly correct. It is 1 single segment, with multiple extents. The
extents
are reused. The segment is never dropped-and-recreated unless you
(a) Stop and start the database instance [it is then created on the
first request
for a temporary segment]
(b) If it is NOT a TEMPORARY Tablespa