Re: Network transfer rate on Oracle
Date: Wed, 3 Feb 2010 14:50:45 +0800
Message-ID: <12ee65601002022250n13d05e3eg26fab25d47680aed_at_mail.gmail.com>
Thanks Greg,
I see two values..
Do I need to add "bytes sent via SQL*Net to client + bytes sent via SQL*Net to dblink" to get the total network traffic?
bytes sent via SQL*Net to client
1
Total number of bytes sent to the client from the foreground processes
bytes sent via SQL*Net to dblink
1
Total number of bytes sent over a database link
- Karl Arao karlarao.wordpress.com
On Wed, Feb 3, 2010 at 2:29 PM, Greg Rahn <greg_at_structureddata.org> wrote:
> Look at AWR for "bytes sent via SQL*Net to client" in the Statistics
> section. There is "Total" and "per Second" metrics.
> This, of course, is an average so the AWR window should be
> representative of the workload to be measured.
>
> On Tue, Feb 2, 2010 at 10:03 PM, Karl Arao <karlarao_at_gmail.com> wrote:
> > Is there a way to know the network transfer rate (MB/s) on the Oracle
> side?
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 03 2010 - 00:50:45 CST