Strange Segment called 6.2 in TEMP 
Author Message
 Strange Segment called 6.2 in TEMP

I have been watching our 7.3 Oracle database and for the last few days, the
TEMP tablespace has been consumed by a large temporary segment named 6.2.

Does anyone know what this is and if it really should be there? I would have
thought a temporary segment would be temporary rather than{*filter*} around for
over 2 days?

The out put of
SELECT SEGMENT_NAME,OWNER,BYTEs, SEGMENT_TYPE FROM DBA_SEGMENTS WHERE
TABLESPACE_NAME='TEMP'
/

is
SEGMENT_NAME         OWNER                               BYTES SEGMENT_TYPE
-------------------- ------------------------------ ----------
-----------------
6.2                  SYS                             497827840 TEMPORARY

Bernie



Sun, 23 Nov 2003 05:57:16 GMT
 Strange Segment called 6.2 in TEMP

Quote:

> I have been watching our 7.3 Oracle database and for the last few days, the
> TEMP tablespace has been consumed by a large temporary segment named 6.2.

> Does anyone know what this is and if it really should be there? I would have
> thought a temporary segment would be temporary rather than{*filter*} around for
> over 2 days?

> The out put of
> SELECT SEGMENT_NAME,OWNER,BYTEs, SEGMENT_TYPE FROM DBA_SEGMENTS WHERE
> TABLESPACE_NAME='TEMP'
> /

> is
> SEGMENT_NAME         OWNER                               BYTES SEGMENT_TYPE
> -------------------- ------------------------------ ----------
> -----------------
> 6.2                  SYS                             497827840 TEMPORARY

> Bernie

It's OK. You segment has TEMPORARY type, so it uses special type of allocation
for temp tables. That (6.2) temporary segment actually contains all your temp
tables. Even when you don't have any temporary tables, this segment is visible.
For more on this feature, read documentation.


Sun, 23 Nov 2003 12:03:25 GMT
 Strange Segment called 6.2 in TEMP
If file# 6 belongs to your temporary tablespace
(dba_tablespace.contents = 'TEMPORARY'), don't worry about it.

BTW, one other type of segment named number.number is cache segment.
The first and second number, as in the case of temporary segment, is
file#, block#, respectively.

Yong Huang



Sun, 23 Nov 2003 12:25:33 GMT
 Strange Segment called 6.2 in TEMP
Temporary segment doesn't contain tables - it holds interrim results between
sorting, joining etc (unless you are into creating "global temporary tables"
of course).

Also, this segment will disappear when you shut the database down, and when
you bring it up again (and someone needs to sort on disk), it will be
recreated. If your next question is "why is it almost filled the
tablespace?", the answer is that it's supposed to be that way.


Quote:

> > I have been watching our 7.3 Oracle database and for the last few days,
the
> > TEMP tablespace has been consumed by a large temporary segment named
6.2.

> > Does anyone know what this is and if it really should be there? I would
have
> > thought a temporary segment would be temporary rather than{*filter*}
around for
> > over 2 days?

> > The out put of
> > SELECT SEGMENT_NAME,OWNER,BYTEs, SEGMENT_TYPE FROM DBA_SEGMENTS WHERE
> > TABLESPACE_NAME='TEMP'
> > /

> > is
> > SEGMENT_NAME         OWNER                               BYTES
SEGMENT_TYPE
> > -------------------- ------------------------------ ----------
> > -----------------
> > 6.2                  SYS                             497827840 TEMPORARY

> > Bernie

> It's OK. You segment has TEMPORARY type, so it uses special type of
allocation
> for temp tables. That (6.2) temporary segment actually contains all your
temp
> tables. Even when you don't have any temporary tables, this segment is
visible.
> For more on this feature, read documentation.



Sun, 23 Nov 2003 18:09:39 GMT
 
 [ 4 post ] 

 Relevant Pages 

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

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

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

4. temp segment in non-temp tablespace??

5. 01652: unable to extend temp segment

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

7. Some question about temp segment

8. Temp segment, info problem.

9. Formula to calculate size of temp segment when analyzing tables/schemas

10. Question on Temp Segments

11. ORA-01652 unable to extend temp segment by num in tablespace name


 
Powered by phpBB® Forum Software