Home » RDBMS Server » Server Administration » locked_object (merged)
locked_object (merged) [message #331134] Wed, 02 July 2008 06:03 Go to next message
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
locked objects [message #331141 is a reply to message #331134] Wed, 02 July 2008 06:15 Go to previous messageGo to next message
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
Re: locked_object [message #331144 is a reply to message #331134] Wed, 02 July 2008 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How does finding something can hurt?
Precise what you're thinking.

Regards
Michel
Re: locked_object [message #331150 is a reply to message #331134] Wed, 02 July 2008 07:06 Go to previous messageGo to next message
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


Re: locked objects [message #331151 is a reply to message #331141] Wed, 02 July 2008 07:14 Go to previous messageGo to next message
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.
Re: locked objects [message #331169 is a reply to message #331141] Wed, 02 July 2008 08:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your question.

Regards
Michel
Re: locked objects [message #331177 is a reply to message #331151] Wed, 02 July 2008 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. commit or rollback
2. Question

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

Regards
Michel
Re: locked_object (merged) [message #331187 is a reply to message #331134] Wed, 02 July 2008 09:30 Go to previous messageGo to next message
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,
Re: locked_object (merged) [message #331193 is a reply to message #331134] Wed, 02 July 2008 09:40 Go to previous messageGo to next message
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
Re: locked_object (merged) [message #331194 is a reply to message #331134] Wed, 02 July 2008 09:42 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I am sorry but what is difference between BLOCKING and LOCKING

Thanks,
Re: locked_object (merged) [message #331196 is a reply to message #331134] Wed, 02 July 2008 09:44 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
http://www.orafaq.com/node/854
Previous Topic: SQl net tracing
Next Topic: Automatic Startup - second instance
Goto Forum:
  


Current Time: Sun Dec 04 00:16:33 CST 2016

Total time taken to generate the page: 0.05152 seconds