Some question about temp segment 
Author Message
 Some question about temp segment
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?
2. Any dynamic view I can use to monitor the temporary segment?
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.

Tnks

Jack



Fri, 21 Sep 2001 03:00:00 GMT
 Some question about temp segment

Hi Eric,
Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

Quote:

>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

Quote:
>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

Quote:
>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.
Quote:

>Meanwhile, where can I get information to help my preparation for OCP, e.g.
>sample question... etc.

>Tnks

>Jack



Fri, 21 Sep 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Question on Temp Segments

2. Newbie Question on Temp Segments

3. Newbie question on Temp Segments

4. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

5. ORA-01652: unable to extend temp segment by 256 in tablespace TEMP

6. ORA-01652: unable to extend temp segment by 512 in tablespace TEMP

7. temp segment in non-temp tablespace??

8. IMPort / temp segment question

9. 01652: unable to extend temp segment

10. ORA-1652: unable to extend temp segment by 7680 in tablespace

11. Strange Segment called 6.2 in TEMP

12. Temp segment, info problem.


 
Powered by phpBB® Forum Software