Temp space
__________________________________________________________________________
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