1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Quick commands to check temp space usage

Discussion in 'General' started by arunyadav007, Oct 19, 2018.

  1. arunyadav007

    arunyadav007 Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    US
    Quick commands to check Temp space usage
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,645
    Likes Received:
    370
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I've posted temporary tablespace information and queries here:

    TEMPORARY (Tablespace) Insanity?

    Many of the queries in this document are outdated, using sql_address and hash_value rather than sql_id (available since 9i) for queries by a connected user, not using DBA_BLOCKERS to find blocking sessions and completely ignoring important views on TEMP tablespace usage.

    If queries are going to be posted it's best to post CURRENT information, not out-dated scripts from the era of Oracle 7.