OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » holding session (oracle10g)

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

holding session [message #314210]

Wed, 16 April 2008 01:35

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

Report message to a moderator

Re: holding session [message #314219 is a reply to message #314210]

Wed, 16 April 2008 01:51

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

Senior Member
Account Moderator

You may hold a lock without blocking anyone if you are the lone interested in this resource.

Regards
Michel

Report message to a moderator

Re: holding session [message #314232 is a reply to message #314210]

Wed, 16 April 2008 02:27

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks michel

Report message to a moderator

Re: holding session [message #317069 is a reply to message #314219]

Tue, 29 April 2008 07:10

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

Report message to a moderator

Re: holding session [message #317071 is a reply to message #314219]

Tue, 29 April 2008 07:13

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.

Report message to a moderator

Re: holding session [message #317072 is a reply to message #317069]

Tue, 29 April 2008 07:14

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

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

Report message to a moderator

Re: holding session [message #317413 is a reply to message #317072]

Thu, 01 May 2008 02:21

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

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

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

Report message to a moderator

Re: holding session [message #317430 is a reply to message #314210]

Thu, 01 May 2008 03:39

flyboy
Messages: 1903
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.

Report message to a moderator

Previous Topic:	Oracle 11i eBusiness Suite Financials books for sale
Next Topic:	employee supervisor relationship help please

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 03:36:42 CST 2024