OraFAQ Forum: Server Administration » locked

Home » RDBMS Server » Server Administration » locked_object (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

locked_object (merged) [message #331134]

Wed, 02 July 2008 06:03

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I can see many objects inside the V$LOCKED_OBJECT view.
If i can find the objects inside it then does will it cause any problem in the application?

How can i trace which query is locking the objcts?

SELECT * FROM V$LOCKED_OBJECT

Thanks

Report message to a moderator

locked objects [message #331141 is a reply to message #331134]

Wed, 02 July 2008 06:15

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

I can see many objects inside the V$LOCKED_OBJECT view.
If i can find the objects inside it then does will it cause any problem in the application?

How can i trace which query is locking the objcts?

SELECT * FROM V$LOCKED_OBJECT

Thanks

Report message to a moderator

Re: locked_object [message #331144 is a reply to message #331134]

Wed, 02 July 2008 06:22

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How does finding something can hurt?
Precise what you're thinking.

Regards
Michel

Report message to a moderator

Re: locked_object [message #331150 is a reply to message #331134]

Wed, 02 July 2008 07:06

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Hi,

Actually i want to ask is that if i can find any objects in the V$LOCKED_Object then do i need to perform any activity.

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

So do i need to worry about it to resolve lock?

Please give some idea about.
Sorry if any wrong statement in my question. Smile

Report message to a moderator

Re: locked objects [message #331151 is a reply to message #331141]

Wed, 02 July 2008 07:14

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Hi,

Actually 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.
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?

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.
Sorry if any wrong statement in my question.

Report message to a moderator

Re: locked objects [message #331169 is a reply to message #331141]

Wed, 02 July 2008 08:18

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't multipost your question.

Regards
Michel

Report message to a moderator

Re: locked objects [message #331177 is a reply to message #331151]

Wed, 02 July 2008 08:26

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1. commit or rollback
2. Question

locked objects are good, they indicate the database is properly working.

Regards
Michel

Report message to a moderator

Re: locked_object (merged) [message #331187 is a reply to message #331134]

Wed, 02 July 2008 09:30

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

Quote:

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?

Actually i want to know which queries are locking during a day.
Or the queries which are locking objects more time.

Can we track this?
This thing i want to know for query optimization purpose.

Thanks,

Report message to a moderator

Re: locked_object (merged) [message #331193 is a reply to message #331134]

Wed, 02 July 2008 09:40

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I would suggest you to read about LOCKS .Its not a problem but a method Oracle uses to access tables .

But BLOCKING , yes its a problem and you need to jump in to solve this

Report message to a moderator