Temp Tablespace - What is this 68.2502?

From: Rama Malladi <rmalladi_at_inteliant.com>
Date: Thu, 19 Oct 2000 19:29:29 -0700
Message-Id: <10654.119821@fatcity.com>

Hi,
 My Temp Tablespace is taking up 2GB. It should not be that high.. When I issued the following Query, I got the following result... Do you know what this 68.2502 is? Where does it come from? I have no clue!

select SEGMENT_NAME, TABLESPACE_NAME, SEGMENT_TYPE, BYTES from dba_extents where TABLESPACE_NAME='TEMP';

SEGMENT_NAME     TABLE     SEGMENT_TYPE            BYTES


------------------------------ -----      ------------------         -------

---

68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000
68.2502                        TEMP  TEMPORARY             5120000

.....

The list goes on like this
select SEGMENT_NAME, TABLESPACE_NAME, BYTES from dba_segments where TABLESPACE_NAME='TEMP';

SEGMENT_NAME	TABLESPACE_NAME                  BYTES
68.2502		TEMP                           		2073600000

Received on Thu Oct 19 2000 - 21:29:29 CDT