Oracle Database Discussions

Hi,

I want to ask is that if i can find any objects in the V$locked_Object then do i need to kill those sessions always????

The thing is when i see some objects in the locked_objects i am looking for the query which is locking the object. But after some that that sesssion removed from V$locked_Object

Sometimes if i track any locked object and find the query related to it that time query is normal query of SELECT.

1. So do i need to worry about it to resolve lock? And always i need to kill that session which is in V$Locked_Object.

2. Also please let me know how can i check which SQL statements in a day locking objects in the database Can we check this one?

Please give any idea about.