Re: Temp space

You can use "fuser" unix command. Which will tell you that which process id are using that space. I guess it could be some help to you. Thanks Sanjeev K. Sagar ---Vadi Vadivelpillai <Vadi_Vadivelpillai@jonesday.com> wrote: > > __________________________________________________________________________ > > This message is intended for the individual or entity named above. If > you are not the intended recipient, please do not read, copy, use or > disclose this communication to others; also please notify the sender by > replying to this message, and then delete it from your system. Thank you. > __________________________________________________________________________ > > Hi DBAs, > > All of a sudden in our production system the users started complaining that > they were > getting temp space full error. We have 4 tempdbspaces configured and when I > checked with onstat -d , I could see only few pages left. > > Is there a way to find out who uses temp space or which process uses the > temp space? > > Please help me . > > Thanks, > > > Vadi > > > _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

sanjeev sagar wrote: > You can use "fuser" unix command. Which will tell you that which fuser works only on file systems, not on dbspaces. > > process id are using that space. I guess it could be some help to you. > > Thanks > > Sanjeev K. Sagar > > ---Vadi Vadivelpillai <Vadi_Vadivelpillai@jonesday.com> wrote: > > > > > __________________________________________________________________________ > > > > This message is intended for the individual or entity named above. > If > > you are not the intended recipient, please do not read, copy, use or > > disclose this communication to others; also please notify the sender > by > > replying to this message, and then delete it from your system. > Thank you. > > > __________________________________________________________________________ > > > > Hi DBAs, > > > > All of a sudden in our production system the users started > complaining that > > they were > > getting temp space full error. We have 4 tempdbspaces configured and > when I > > checked with onstat -d , I could see only few pages left. > > > > Is there a way to find out who uses temp space or which process uses > the > > temp space? > > > > Please help me . > > > > Thanks, > > > > > > Vadi > > > > > > > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com -- Helmut Leininger Bull AG / Vienna Unix Support Email: h.leininger@bull.at helmut.leininger@bull.net This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.