Re: what is this segment_name 2.85077 ?

Peter Chan <atna_at_hotmail.com> wrote in message news:38E38123.EF4D857A_at_hotmail.com...
> I queried dba_segments and found a weird segment_name...
>
> SEGMENT_NAME SEGMENT_TYPE
> ------------ ------------
> 2.85077 TEMPORARY
>
> Has anyone seen this before...
>
> thanks.

What is the segment_type saying?
The name is just the file_id concatenated with the block the temporary segment starts in.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Mar 30 2000 - 00:00:00 CST