Re: Some question about temp segment

From: Larry Dare <ldare_at_yahoo.com>
Date: Tue, 06 Apr 1999 00:57:32 GMT
Message-ID: <7ebm5p$p2q$1@nnrp1.dejanews.com>

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?

No space Available error message..
> 2. Any dynamic view I can use to monitor the temporary segment?
dba_segment is a place to start
> 3. I think temporary segment and sort segment the same thing, are they ?
????
> Meanwhile, where can I get information to help my preparation for OCP, e.g.
> sample question... etc.

Oracle Press: Advance Oracle Tuning and Administration
> Tnks
>
> Jack
>
>

Respectfully,
Larry Dare
ldare_at_yahoo.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 05 1999 - 19:57:32 CDT