Re: Some question about temp segment

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 5 Apr 1999 11:43:24 +0200
Message-ID: <923305523.23417.0.rover.d4ee154e@news.demon.nl>

Hi Eric,
Answers embedded

Hth,

Sybrand Bakker, Oracle DBA
Eric wrote in message <7e9u7v$tne$1_at_imsp009a.netvigator.com>...
>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?

abort the operation and return an error
>2. Any dynamic view I can use to monitor the temporary segment?

select segment_name, extents, bytes / 1024 K from dba_segments
where segment_type = 'TEMPORARY' will do the trick

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

Not necessarily
Temporary segments are also used in analyzing operations, the creation of an index etc.

>
>Meanwhile, where can I get information to help my preparation for OCP, e.g.
>sample question... etc.
>
>Tnks
>
>Jack
>
>
>
>
Received on Mon Apr 05 1999 - 04:43:24 CDT