In article <3a67b2a8_at_newsgate.imsbiz.com>,
"Antony Mak" <cheong_at_broadway-ps.com> wrote:
> I have found that it is a temporary segment for sorting. But why the
> tablespace can not be reuse by others and continue to extent?
>
> Thanks in advance
>
> Antony
>
If you have the tablespace defined as type temporary then unless you
are running OPS or have multiple temp tablespaces assigned then Oracle
will allocate one temp segment for the entire db. Multiple user
sessions will use this one segment. You can see sort segment
allocation and usage information using v$sort_segment and v$sort_usage.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 19 2001 - 08:07:04 CST
