Re: Oracle process eating /tmp

I haven't worked in DGUX or seen the pattern elsewhere, but from what you have described, my first suspicion is temporary sort area files from queries with 'order by' clauses or unions. If the file size is similar to the sort-area_size or sort_area_retained parm in the init.ora, that would be even more suspicious. The temp files would possibly reflect the PGA (Program Global Area assigned to users) rather than the db SGA.

At least it is a thought.
In article <npmEu1pKp.GAL_at_netcom.com>,
  "npm_at_netcom.com" <npm_at_netcom.com> wrote:
>
> I'm running into a strange problem with oracle, I'm not a DBA so I may
> say this wrong. They're running Oracle 7.2.3 on a Digital Unix 3.2G
> system. They've got an application that uses Oracle and it appears
> to create "deleted files" in /tmp that are actually open and assigned
> to file descriptors 1 & 2 (stdout and stderr). Then it consumes all
> available disk space and causes havoc. Output from lsof looks like
> this:
>
> Process PID Owner Mode FileSize inode file
system
> oracle 19714 oracle 0r VREG 11,0 26 187 / (/dev/re0a)
> oracle 19714 oracle 1w VREG 11,0 61926315 186 / (/dev/re0a)
> oracle 19714 oracle 2w VREG 11,0 61926315 186 / (/dev/re0a)
> xyz0000 19965 ptman 0r VREG 11,0 26 187 / (/dev/re0a)
> xyz0000 19965 ptman 1w VREG 11,0 61926315 186 / (/dev/re0a)
> xyz0000 19965 ptman 2w VREG 11,0 61926315 186 / (/dev/re0a)
>
> The file descriptor referenced is in /tmp and does not point to an
> existing file so I suspect, strongly, that something is opening up
> a file in /tmp, deleting the file, then holding the file open and
> writing to it.
>
> Has anyone run into this, and more importantly, have any clues on how
> to fix it?
>
> Many Thanks!
> --
> Nancy Milligan Milligan Consulting Services
> npm_at_netcom.com System Administration, Perl/C/shell
programming
> Internet Connectivity, Security, Usenet, WWW, and so
on.
> http://nmcs.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Jun 04 1998 - 21:46:59 CDT