Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Unanswered: Temp TS growing rapidly

    Hi!
    I am on 2003 server with Oracle 10gR1. My problem is the temp TS is growing in an astonishing speed (in the last 2-3 days) which has consumed most of the disk space though there is no such increase in DB activities.

    Any help is greatly appreciated.

    Thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post formatted results from following query

    Code:
    SELECT   b.TABLESPACE
           , b.segfile#
           , b.segblk#
           , ROUND (  (  ( b.blocks * p.VALUE ) / 1024 / 1024 ), 2 ) size_mb
           , a.SID
           , a.serial#
           , a.username
           , a.osuser
           , a.program
           , a.status
        FROM v$session a
           , v$sort_usage b
           , v$process c
           , v$parameter p
       WHERE p.NAME = 'db_block_size'
         AND a.saddr = b.session_addr
         AND a.paddr = c.addr
    ORDER BY b.TABLESPACE
           , b.segfile#
           , b.segblk#
           , b.blocks;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2009
    Posts
    262
    check Undo retention .

    reduce the number of days for undo retention

Posting Permissions

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