Home » RDBMS Server » Networking and Gateways » Network Interfaces (Oracle 11g Red Hat 5.5)
Network Interfaces [message #479585] Mon, 18 October 2010 07:39 Go to next message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
Hi expert,

I know (but it could be wrong) that over 100 connection per second, I could add one more network interface. For example create 2 different listener on 2 separated ETHn

I'm planning my db env and I'd like to know if there is a best practise for to decide how many interface I can configure on my system (Red Hat with Oracle 11g EE)

About the 100 per second, I mean not TCP_SYN packets (new request client/server), but a pool size from a middleware to an istance with a 100 request per second.

Thanks for any suggest.

Cheers,
Lain

[Updated on: Mon, 18 October 2010 08:22]

Report message to a moderator

Re: Network Interfaces [message #479637 is a reply to message #479585] Mon, 18 October 2010 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When you start with the wrong question, no matter how good an answer you get, it won't matter very much.
Re: Network Interfaces [message #479674 is a reply to message #479637] Mon, 18 October 2010 11:58 Go to previous messageGo to next message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
Hi BlackSwan,
I mean that, there are some benefit with one more NIC?
I'm planning the needs, for this reason I'm checking about hardware configuration.
For example I could add RAM, but I'm not realy sure for to add one more NIC (or listener). I remember that I had 2 listener in a past istance configuration (1521 and 1522).
The default initial parameter sessions on 10g is:
<initParam name="sessions" value="335"/>
I could increase it until?
Can u suggest me something? for example when it is recommended to add a listener?
thanks
Re: Network Interfaces [message #479676 is a reply to message #479674] Mon, 18 October 2010 12:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can u suggest me something? for example when it is recommended to add a listener?
For an well designed application that utilizes connection pooling, the answer is NEVER!
Listener is ONLY involved to establish new sessions into the DB.
When the application is started on the Application Server, all needed sessions are established in the DB.
After that the listener is essentially IDLE.

Just for FULL DISCLOSURE I'll add the following.
I have Production DB Severs with multiple NICs in them.
1) OLTP access from Application Servers
2) RAC inter-system packet exchange
3) Dataguard
4) Backups - RMAN

However the Oracle Listener only is configured for #1 above.

[Updated on: Mon, 18 October 2010 12:14]

Report message to a moderator

Re: Network Interfaces [message #479691 is a reply to message #479676] Mon, 18 October 2010 13:10 Go to previous messageGo to next message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
BlackSwan wrote on Mon, 18 October 2010 12:03

I have Production DB Severs with multiple NICs in them.

ok thanks for the quickly response, but maybe explain me what is the criteria for your miltiple NICs?
I never add listener if I have an AS with a connection pooling, but even if I have a pool of 10000+ (for example) connection?
I can configure the oracle parameter (session, queuesize on listener etc.) but nothing about add NICs or Listener?
Many thanks for all suggest.
Cheers,
Lain
Re: Network Interfaces [message #479692 is a reply to message #479691] Mon, 18 October 2010 13:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>explain me what is the criteria for your miltiple NICs?
Multiple NICs allow for isolation of dedicated traffic to individual subnets to reduce collisions & improve network traffic throughput.
Ethernet is still a serial device (disregarding duplex packet exchange) where only a single talker can exist on any subnet at any time.
Re: Network Interfaces [message #479695 is a reply to message #479692] Mon, 18 October 2010 13:49 Go to previous messageGo to next message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
u have added one more NIcs only for a subnet problem and not for an performance issue.
then I shall never have the need to add NICs (listners) on my oracle enviroment for increase the performance.
Thanks for the suggest.
Lain
Re: Network Interfaces [message #479697 is a reply to message #479695] Mon, 18 October 2010 13:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>then I shall never have the need to add NICs (listners) on my oracle enviroment for increase the performance.
post reproducible test case & results that show multiple listeners "increase the performance"
Re: Network Interfaces [message #479699 is a reply to message #479697] Mon, 18 October 2010 14:07 Go to previous messageGo to next message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
perfect, I'm sorry but I don't understand very what is the criteria. What do u mean with "increase the performance"?
for example with 1ML of connection or what?
I haven't a clearly idea and I'd like to study on this item.
Thanks!
Lain
Re: Network Interfaces [message #479812 is a reply to message #479699] Tue, 19 October 2010 09:06 Go to previous message
Lain
Messages: 7
Registered: October 2010
Location: Roma
Junior Member
Hi BlackSwan,
I could like know what's the criteria that I can use to understand what u mean with "increase the performance"
many thanks for all suggest.
Cheers,
Lain
Previous Topic: multiple listeners
Next Topic: when is LOG_DIRECTORY_SERVER and LOG_DIRECTORY_CLIENT set
Goto Forum:
  


Current Time: Wed May 25 05:31:12 CDT 2022