No question at this time
DBA Top 10
1 A. Kavsek 11100
2 M. Cadot 7600
3 B. Vroman 5100
4 P. Wisse 5000
5 T. Boles 2000
5 . Lauri 2000
7 J. Péran 1100
8 J. Schnackenberg 700
9 R. Pattyn 600
10 T. P 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48435
Total active users1504
Act. users last 24h5
Act. users last hour0
Registered user hits last week139
Registered user hits last month778
Go up

Instance loaded and Scan Listeners
Next thread: Migrating OWB repository into a new database
Prev thread: How many way we can Patch the RAC databases ??? Need documents for Oracle Patching

Message Score Author Date
Dear all, Who updates Instance load information...... Jill Salalila Jul 07, 2018, 08:13
Workload management involves : – Failover : If...... javed akhtar Jul 09, 2018, 12:44
Hi Javed, >> My question was different! Who ...... Jill Salalila Jul 13, 2018, 17:04

Follow up by mail Click here


Subject: Instance loaded and Scan Listeners
Author: Jill Salalila, Philippines
Date: Jul 07, 2018, 08:13, 465 days ago
Os info: OL 6.7
Oracle info: 11.2.0.3
Message: Dear all,

Who updates Instance load information to SCAN LISTENERS?

Q1) How do Scan Listeners know each instance load information and routing client request to least loaded node?

Q2) Who provides all loaded (instance load) to scan ? Does it by PMON or by LBA?

Thanks in advance.



Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Instance loaded and Scan Listeners
Author: javed akhtar, India
Date: Jul 09, 2018, 12:44, 463 days ago
Message: Workload management involves :
– Failover : If connection to an instance fails, client should automatically connect to another instance
– Load balancing : Workload should spread across various instances to obtain maximum performance/throughput
Failover can be
– Connect Time Connection Failover (CTCF) while making initial connection ()
- Run time connection failover (RTCF) after connection has been established or (transparent application failover (TAF)
FAILOVER_METHOD = NONE, BASIC, PRECONNECT
FAILOVER TYPE = SESSION, SELECT
Load balancing can be :
– Connect time load balancing (CTLB)
. On client side
. On server side
– Run time load balancing (RTLB)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Instance loaded and Scan Listeners
Author: Jill Salalila, Philippines
Date: Jul 13, 2018, 17:04, 459 days ago
Message: Hi Javed,

>> My question was different!

Who updates load information to SCAN ?
I found answer, PMON does it.

>> My another question is

If PMON does instance load to SCAN, What is the purpose of LOAD BALANCING ADVISORIES ?

REF_LINK
--------

http://jvardhan.blogspot.com/2012/02/load-balancing-in-11g-r2-with-scan.html"
Please update
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here