OraFAQ Forum: Performance Tuning » contention on temprary tablespace

Home » RDBMS Server » Performance Tuning » contention on temprary tablespace (oracle 9.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

contention on temprary tablespace [message #395483]

Wed, 01 April 2009 10:46

rituraj
Messages: 18
Registered: April 2009
Location: INDIA

Junior Member

hi
there is contention on my temporary tablespace because of one users faulty query.how can i find that bcause of which user and which query the contention is.And what will be the solution for this.
thank you

Report message to a moderator

Re: contention on temprary tablespace [message #395485 is a reply to message #395483]

Wed, 01 April 2009 10:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/wiki/Oracle_database_FAQ#How_can_one_see_who_is_using_a_temporary_segment.3F

Report message to a moderator

Re: contention on temprary tablespace [message #395490 is a reply to message #395485]

Wed, 01 April 2009 11:06

rituraj
Messages: 18
Registered: April 2009
Location: INDIA

Junior Member

hi
thanks for your quick reply mahesh.
from that query i cud find the user name,sid and all this thing bt i also want to find out the perticular query also which was faulty.
thank you

Report message to a moderator

Re: contention on temprary tablespace [message #395491 is a reply to message #395490]

Wed, 01 April 2009 11:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just search. Smile

These questions are asked somewhat frequently.
Please search the forum/google/docs.

Hint:
Use v$sqltext.
From the previous examples you already know the potential offending SID and SERIAL.

Report message to a moderator

Previous Topic:	Performance degrades suddenly.
Next Topic:	how to give kill session priviledge to normal user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 14 12:02:13 CDT 2026