Temp TBS issue

From: sachin DBA <sachintugnayat_at_gmail.com>
Date: 23 Mar 2006 00:09:45 -0800
Message-ID: <1143101385.300131.262350@z34g2000cwc.googlegroups.com>

Dear Gurus,

Why I m getting some values in minus.......... and which TBS is more used and which not.

select
tablespace_name,sum(bytes_used)/1024/1024,sum(bytes_free)/1024/1024 from v$temP_space_header group by tablespace_name;

TABLESPACE_NAME       BYTES_USED     BYTES_FREE
----------------                -------------------------
TEMP1                           -234839516               234871484
TEMP1_TS                       30481.8828                           0
TEMP2_TS                       30341.8828                       140
TEMP4_TS                       -234843424             234873904
TEMP_TS                                    1

510

Thanks

Sachin Received on Thu Mar 23 2006 - 02:09:45 CST