 oracle 10g blocking sessions [message #472278] |
Thu, 19 August 2010 12:14  |
sudeep_mansh
Messages: 3
Registered: August 2010
Location: Shimoga
|
Junior Member |
|
|
hello,
I am using oracle 10g as server in my lab. I faced some problems initially, but later after increasing the USERS tablespace it is working fine.
But there is still one problem. During the query execution some queries will be blocked and it doesnt leave any consequent queries to execute from the same user.
The blocked sessions will be displayed in the admin page under blocking sessions link. There is a option to kill the session. But when i do that, it affects all the users and the connection will be lost to all the users. again I have startup the database from beginning.
how can i overcome this.
Please reply.
|
|
|
|
| Re: oracle 10g blocking sessions [message #472279 is a reply to message #472278] |
Thu, 19 August 2010 12:21  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, really, REALLY difficult to fix a problem that can not be seen.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
does the following SQL return any rows?
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
id1, id2, lmode, request, type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request
/
How can we reproduce what happens to you?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
