Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007

    Unanswered: Who is using TEMP space

    I have 10 temp dbspaces deffined in my production instance. Normally they run at approx 65 - 70 % free space. For the last couple of days some of the temspaces go as low as 18% free. How can I obtain the list of sessions tha are utilizing the temp spaces by tmpdbspace?

  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    SELECT t.tabname
    ,DECODE(d.is_logging,1,"Y","N") AS db_with_log
    , AS dbspace
    ,DBINFO("UTC_TO_DATETIME",ti_created) AS created
    ,DECODE(hex(mod(ti_flags,256)/16),"0x00000006","Y","N") AS table_using_log
    ,DECODE(hex(mod(ti_flags,256)/16),6,"Y","N") AS table_using_log
    ,ti_npused AS num_usedpages
    ,ti_nptotal AS num_pages
    ,hex(ti_partnum) as partnum
    FROM sysmaster:systabnames t, sysmaster:systabinfo i,
    sysmaster:sysdbspaces s, sysmaster:sysdatabases d
    WHERE t.partnum=ti_partnum
    AND s.dbsnum=TRUNC(t.partnum/1048576)
    AND hex(mod(ti_flags,256)/16) IN ( 6,2 )
    order by owner
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

  3. #3
    Join Date
    Mar 2007

    Smile Thank you CEINMA

    I will try using that statement

Posting Permissions

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