Re: Some question about temp segment

In article <7e9u7v$tne$1_at_imsp009a.netvigator.com>,   "Eric" <eric1081_at_netvigator.com> wrote:
> During my preparation for OCP, I have the following question:
>
> 1. What does oracle do if the user's default temporary tablespace is full in
> a sort operation?

It generates an error message and cancels the operation.

> 2. Any dynamic view I can use to monitor the temporary segment?

No. But you can query dba_segments where segment_type = 'TEMPORARY'.

> 3. I think temporary segment and sort segment the same thing, are they ?

Not necessarily. All "sort" segments are temporary segments, but not all temporary segments are sort segments. For example, when you drop a table, it actually gets converted to a temporary segment which then gets cleaned up. But this cleanup can sometimes take quite some time. We have this problem every time we try to recreate a large index. We drop the index, issue a create, and the create fails because the temp segment is still taking up space in the index tablespace.

Chuck Hamilton
chuckh_at_safeplace.net
--
If at first you don't succeed, skydiving isn't for you.

--
Chuck Hamilton
chuckh_at_safeplace.net

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 09:33:45 CDT