temp file size not listed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: temp file size not listed

  1. #1
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    temp file size not listed

    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.
    "What is past is PROLOGUE"

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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>

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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?
    Last edited by dbasan; 05-18-2004 at 03:11 PM.
    "What is past is PROLOGUE"

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    how about:
    select object_name, object_type from dba_objects where object_name like 'PCT%';
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width