Link to home
Get AccessLog in
Avatar of sakthikumar
sakthikumar

asked on

How to find the process ID in unix

There are a set of tables locked in my ORACLE user, from a process run by Unix cron job.

From the list of information available in
v$locked_object a,
v$session b

How to find which process has locked these tables? So that I can kill the process from unix.
SOLUTION
Avatar of woolmilkporc
woolmilkporc
Flag of Germany image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of sakthikumar
sakthikumar

ASKER

I only have SID from v$locked_objects
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
ASKER CERTIFIED SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
need to check