Oracle-L: RE: Network Card Performance

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Sun, 20 Apr 2003 20:36:37 -0800
Message-ID: <F001.00585981.20030420203637@fatcity.com>

Jeff,

If you assume that the 1GB card can actually be used to its capacity (that is, all the wire and other devices through which your network I/O will flow is 1GB rated as well), then...

The amount of improvement you can expect for a given program is proportional to the amount of response time that the program spends consuming network resources. It's Amdahl's Law. There will be no single factor by which your "system-wide performance" will change (unless all your workload elements happen to have exactly the same proportion of their response time consumed by network I/O).

How to figure it out? Extended SQL trace for targeted user actions (Oracle kernel event 10046).

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Hotsos Clinic 101 in London, Reykjavik, Ottawa, Denver, Sydney
- Visit www.hotsos.com for schedule details...
- IOUG-A Live 2003, Orlando, 10am Monday 28 April: "Oracle Operational

Timing Data"

-----Original Message-----
Sent: Friday, April 18, 2003 5:17 PM
To: Multiple recipients of list ORACLE-L

Hi all,

My manager informed me today that they are planning on changing the network card on our Windows 2000 server from a 100MB card to a 1000MB card. The server has 3 oracle databases on it (all less than 500MB). It also hosts fileshares for the client-server applications that use the databases.

What kind of things would you monitor to see the impact this has? How much of a performance gain would you expect? (I would guess the answer is "It depends").

Perhaps some of the statspack experts here could tell me what changes they might expect in the statspack reports.

Thanks,
Jeff Eberhard
Rolls-Royce Gear Systems

This email message and any attachments are for the sole use of the intended recipients and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and destroy the original message and any copies of the message as well as any attachments to the original message.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Eberhard, Jeff
INET: Jeff.Eberhard_at_Rolls-RoyceGS.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cary Millsap
INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------