Home » Other » Training & Certification » holding session (oracle10g)
holding session [message #314210] Wed, 16 April 2008 01:35 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

can anybody tell me the difference of holding session and blocking session in oracle database?

thanks in advance
Balaji
Re: holding session [message #314219 is a reply to message #314210] Wed, 16 April 2008 01:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You may hold a lock without blocking anyone if you are the lone interested in this resource.

Regards
Michel
Re: holding session [message #314232 is a reply to message #314210] Wed, 16 April 2008 02:27 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks michel
Re: holding session [message #317069 is a reply to message #314219] Tue, 29 April 2008 07:10 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

by your answer for holding session i got some idea about it.but i have also asked about blocking session.because we find number of holding session with sid which acquires a single blocking session . say for example there are 10 holding sessions with distinct waiting session like 2,8,6,10,9,11,8,20,10,8 .all these 10 holding sessions acquired by a single block session.

kindly explain in detail.


Regards
Balaji
Re: holding session [message #317071 is a reply to message #314219] Tue, 29 April 2008 07:13 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


By your answer for holding session i got some idea about it.but i have also asked about blocking session.because we find number of holding session with sid which acquires a single blocking session . say for example there are 10 holding sessions with distinct waiting session like 2,8,6,10,9,11,8,20,10,8 .all these 10 holding sessions acquired by a single block session.


kindly explain in detail.
Re: holding session [message #317072 is a reply to message #317069] Tue, 29 April 2008 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand what you post.
What hold and block what?
What kind of lock or resource?

Post what you did and the result you have.

Regards
Michel
Re: holding session [message #317413 is a reply to message #317072] Thu, 01 May 2008 02:21 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


here is the clear example when active sessions went high


HOLDING_SESSION COUNT(DISTINCTWAITING_SESSION)
--------------- ------------------------------
1369 -------------- 14
10886 -------------- 14
1556 -------------- 14
1921 -------------- 14
1946 -------------- 14
3758 -------------- 14
4279 -------------- 14
5661 -------------- 14
1486 -------------- 14
8632 -------------- 14
10007 -------------- 14
10077 -------------- 14
10179 -------------- 14
10314 -------------- 14
6149

15 rows selected.

Only Blocking

BLOCKING_SESSION COUNT(1)
---------------- ----------
1556 1


please explain me this part clearly

hope it is clear for u.










[Updated on: Thu, 01 May 2008 02:24]

Report message to a moderator

Re: holding session [message #317423 is a reply to message #317413] Thu, 01 May 2008 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 59993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
hope it is clear for u.

What is clear is you don't want to follow rules.
"hope it is clear for u"!

Regards
Michel
Re: holding session [message #317430 is a reply to message #314210] Thu, 01 May 2008 03:39 Go to previous message
flyboy
Messages: 1780
Registered: November 2006
Senior Member
> hope it is clear for u.

I am afraid that without source SELECT statements(?), which generated these results, even "u" would be unclear what you are trying to show.
Previous Topic: Oracle 11i eBusiness Suite Financials books for sale
Next Topic: employee supervisor relationship help please
Goto Forum:
  


Current Time: Fri Dec 19 19:07:13 CST 2014

Total time taken to generate the page: 0.10136 seconds