Home » RDBMS Server » Performance Tuning » contention on temprary tablespace (oracle 9.2)
contention on temprary tablespace [message #395483] Wed, 01 April 2009 10:46 Go to next message
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
Re: contention on temprary tablespace [message #395485 is a reply to message #395483] Wed, 01 April 2009 10:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: contention on temprary tablespace [message #395490 is a reply to message #395485] Wed, 01 April 2009 11:06 Go to previous messageGo to next message
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
Re: contention on temprary tablespace [message #395491 is a reply to message #395490] Wed, 01 April 2009 11:12 Go to previous message
Mahesh Rajendran
Messages: 10672
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.


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


Current Time: Tue Dec 06 06:41:37 CST 2016

Total time taken to generate the page: 0.09388 seconds