temp file size not listed

[dbasan]

When i give the query:

select * from pct$;
TABLESPACE_NAME Avail Used Free Used % STATUS
------------------------------ ---------- ---------- ---------- ------- ---------
TEMP 0 0 0 0.00 ONLINE

Why is the temp tablespace coulmns are empty even though the sorting activites are at high?

db: 8.1.7.4 on solaris 8.

[davey23uk]

im curious, I dont have that view in my database, what does it do?

SQL*Plus: Release 8.1.7.0.0 - Production on Sun May 16 23:59:31 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

SQL>  select object_name from dba_objects where object_name like 'PCT%';

no rows selected

SQL>

[dbasan]

the output is

SQL> select object_name from dba_objects where object_name like 'PCT%';

OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
PCT$

also the description
====================
SQL> desc pct$;
Name Null? Type
------------------------------------------------------------------------- -------- -------------------------------------------------
TABLESPACE_NAME VARCHAR2(30)
AVAIL NUMBER
USED NUMBER
FREE NUMBER
Us
ed % VARCHAR2(7)
CONTENTS VARCHAR2(9)
EXTENT_MANAGEMENT VARCHAR2(10)
STATUS VARCHAR2 (9)

why the temp file shows 0 as size?

[marist89]

how about:
select object_name, object_type from dba_objects where object_name like 'PCT%';