|
-
See the descriptions for the columns of v$tables in Oracle 8i documentation under Oracle8i SQL reference.
Unix:
$ps -ef|grep <string> you have used for Background process.
Ex: $ps -ef|grep <sqlldr> If you have used sqlldr for background job.
NT:
I guess processes window
Database:
V$SQLAREA ( don't remember exact view)
I have scripts for locks identification at my desk. Drop me an e-mail as reminder I will attach and send 'em tomorrow!
You have to kill the session thru which you initiated the job to kill the process manually. Its not going to release the locks even, depending upon the transaction status.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|