No question at this time
DBA Top 10
1 B. Vroman 14600
2 M. Cadot 11000
3 J. Schnackenberg 8200
4 T. Boles 7950
5 A. Kavsek 6200
6 M. Hidayathullah ... 2200
7 G. Lambregts 1100
8 T. P 1000
9 P. Wisse 900
10 B. Derous 500
10 . Lauri 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48286
Total active users1591
Act. users last 24h3
Act. users last hour0
Registered user hits last week242
Registered user hits last month1121
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, 134 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, 132 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, 128 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