DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Temp Usage

  1. #1
    Join Date
    May 2013
    Posts
    1

    Temp Usage

    Hi,

    I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should "select table_name from dict where table_name like '%TEMP%' order by 1;"
    to find tables/views that will answer your question.

    Try this one...

    Code:
    SQL> desc V$TEMPSEG_USAGE
     Name                                                                    Null?    Type
     ----------------------------------------------------------------------- -------- ------------------------------------------------
     USERNAME                                                                         VARCHAR2(30)
     USER                                                                             VARCHAR2(30)
     SESSION_ADDR                                                                     RAW(8)
     SESSION_NUM                                                                      NUMBER
     SQLADDR                                                                          RAW(8)
     SQLHASH                                                                          NUMBER
     SQL_ID                                                                           VARCHAR2(13)
     TABLESPACE                                                                       VARCHAR2(31)
     CONTENTS                                                                         VARCHAR2(9)
     SEGTYPE                                                                          VARCHAR2(9)
     SEGFILE#                                                                         NUMBER
     SEGBLK#                                                                          NUMBER
     EXTENTS                                                                          NUMBER
     BLOCKS                                                                           NUMBER
     SEGRFNO#                                                                         NUMBER

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