Printable View
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.
im curious, I dont have that view in my database, what does it do?
Code:
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>
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?
how about:
select object_name, object_type from dba_objects where object_name like 'PCT%';