In article <3so9l0$2ho@vulpes.pwd.nsw.gov.au: paulr@pwd.nsw.gov.au (Paul
Rodenhuis) writes:

:Recently I was looking at the number of sessions running on each
:server.  I was surprised to see 30 on one and 14 on the other.
:Further investigation showed that this was common.
:
:I decided to do something about it, so with various scripts the user
:gets assigned the least-used (in terms of sessions) as II_DBMS_SERVER.
:Now each server has fairly equal numbers.  This does not attempt to
:do any load checking and assumes a fairly even distribution of work
:across the user population.
:
:But how does gcn go about its job?

In 6.4 the GCN returns a random server of the class requested. In 1.1
it maintains an association count and returns the instance with the
lowest association count.

:
:paulr
:
:-- 
:| Paul Rodenhuis | Database Administration  |   Information Services Branch |
:| NSW Public Works Dept  | paulr@pwd.nsw.gov.au | +61-2-372-7037   FAX 7022 |
:| VK2AHB@VK2XY Home +61-2-449-9212  Fax +61-2-449-7827 | Mobile 018-647-364 | 

--
Tony Sweeney, Network Hack	|"Valuing the vengeance which you treasure,
Anchor House, 15-19 Britten St,	| I've redefined the meaning of vendetta"
Chelsea, London SW3 3TY		| "I should have known better."
sweeney@ingres.com		| "154" -- Wire.

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William