emporary tablespace and file system filling up.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: emporary tablespace and file system filling up.

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    I need some help. When I run a stored procedure (Oracle 8i on Solaris 8.0), the temp tablespace fills up and so much so, that the entire file system gets full.
    The stored proc does a series of inserts only in one table.
    df -k shows 0 bytes free.
    The same procedure in the same DB on NT gives no such problem.
    Any ideas?
    Hemant

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Check the proc. code for both databases; they could be slightly different. If the proc is designed to just perform inserts, it might be doing some sorting before/after the inserts, blowing out your temp space.

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    I believe the autoextend is on for your temp tablespace segment check that out, if it is, the size of datafile will grow & occupy the entire disk. Also check the o/p of df -k before the pl/sql block is run
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

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