| Can PMON be killed? [message #295707] |
Wed, 23 January 2008 02:33  |
catchme_lenin
Messages: 35
Registered: January 2008
Location: Dubai
|
Member |
|
|
Hi guru,
I run a Package in oracle 8.0. It has many proceudres. In one stage, it is updating a table, which is in remote database. Before update statement, I Locked the table (in Exclusive mode without Nowait) also
Since it was taking more than 7 hrs to run the package, i just killed the session. But, now I couldnt even compile a procedure on the locked table.
My DBA says that the PMON is running. It will take its own time for recovering data.
How to release the lock in the killed session?
How to stop the PMON in the kiled session?
|
|
|
|
| Re: Can PMON be killed? [message #295709 is a reply to message #295707] |
Wed, 23 January 2008 02:38  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
The session is rolling back what you did during those seven hours. That could take up some time (even more that seven hours, maybe more, maybe less)
PMON is a database-process, you don't kill it. (It would kill the database)
You will just have to wait.
|
|
|
|
|
|
|
|
| Re: Can PMON be killed? [message #295737 is a reply to message #295713] |
Wed, 23 January 2008 04:18 |
catchme_lenin
Messages: 35
Registered: January 2008
Location: Dubai
|
Member |
|
|
Hi Michel,
Is it possible to see how much has been recovered and how much (how many rows) yet to be recovered? how long will the oracle take for recovery?
Thnx in advance.
-Lenin.
|
|
|
|
|
|
| Re: Can PMON be killed? [message #295758 is a reply to message #295740] |
Wed, 23 January 2008 05:45 |
catchme_lenin
Messages: 35
Registered: January 2008
Location: Dubai
|
Member |
|
|
Hi Michel,
I checked the used_ublk 1 hr before. It was 19. Even now, it is 19. and still continues.
That means, oracle has to recover 19 records. right?
To recover 19 records, will the oracle take more than hour?
Will be there any other problem? Like dead-lock or anything else??
Sorry if I am wrong.
The SID for the killed session is 43. I gave the following query. I am using TOAD.
SELECT used_ublk, s.taddr, T.addr FROM v$session s, v$transaction T
WHERE s.taddr = T.addr
AND SID = 43
|
|
|
|
|
|
| Re: Can PMON be killed? [message #295783 is a reply to message #295761] |
Wed, 23 January 2008 07:33 |
catchme_lenin
Messages: 35
Registered: January 2008
Location: Dubai
|
Member |
|
|
Michel: Are you sure this is the same session?
Lenin: Yes.
Michel:Query v$lock to see if this session holds locks.
SQL> SELECT * FROM v$lock WHERE SID = 43
2 AND addr = '0700000021638DF8';
Result:
Addr: 0700000021638DF8
SID - 43
Type - TX
ID1 - 393247
ID2 - 1095832
LOMODE - 6
REQUEST - 0
CTIME - 93550
BLOCK - 0
Michel:Query v$session_wait to see if this session is waiting on something.
Lenin: The Event - 'SQL*Net more data from dblink', Seconds in waiting - 93740, State - 'Waiting'.
Michel:Does the associated process still exists at OS level (query v$process)?
Lenin: query has no records for the particular ADDR = 0700000021638DF8.
---
Kindly let me know whether it has been dead locked or session is waiting on something,...
What I have to do to over come this issue?
Thanx a lot, Michel.
-Lenin.
|
|
|
|
| Re: Can PMON be killed? [message #295790 is a reply to message #295783] |
Wed, 23 January 2008 07:54 |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
ADDR in each view are different meanings, don't restrict on this with constant value use joins.
v$process.addr = v$session.paddr
Your session is waiting on db links.
I can't see in what case you are. Too much information are missing.
Sorry.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
