| Commit other user sessions [message #135231] |
Tue, 30 August 2005 09:32  |
oradba
Messages: 3
Registered: June 2000
Location: USA
|
Junior Member |
|
|
Hi,
I have very different issue. When any user lock the table normally we kill them. If they do not commit after a couple of hours.
-- kill -9 <OS_PID_OF_SERVER_PROCESS>
But some time in my database warehouse research we have to run very very large queries and we do not want to kill them. Reason because database need to rollback and it will take a while.
We want to commit other users session and we do not have access to those system physically.
As an DBA user how I can commit other users session.
Thanks
M
|
|
|
|
|
|
| Re: Commit other user sessions [message #135622 is a reply to message #135231] |
Thu, 01 September 2005 10:03  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
|
You may want to evaluate the application code, plsql etc that is used and check for unnecesary and/or inapropriate use of manual locking. Also may want some exception handling code in there to rollback a bit sooner, rather than waiting a few hours.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
