Home » RDBMS Server » Networking and Gateways » How many Bytes sent by Oracle
How many Bytes sent by Oracle [message #312473] Wed, 09 April 2008 00:22 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member

Is there any way to know how many byets is sent to oracle and received by oracle?

thanx,
Re: How many Bytes sent by Oracle [message #312474 is a reply to message #312473] Wed, 09 April 2008 00:27 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
yes, from where to where?
Re: How many Bytes sent by Oracle [message #312475 is a reply to message #312473] Wed, 09 April 2008 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See v$sysstat, statistics:
bytes received via SQL*Net from client
bytes received via SQL*Net from dblink
bytes sent via SQL*Net to client
bytes sent via SQL*Net to dblink

Regards
Michel
Re: How many Bytes sent by Oracle [message #312479 is a reply to message #312473] Wed, 09 April 2008 00:43 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
thanx....

select NAME,VALUE from v$sysstat where NAME like '%SQL*Net%'


But from when to when??


thanx.
Re: How many Bytes sent by Oracle [message #312482 is a reply to message #312473] Wed, 09 April 2008 00:43 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
If I want to know ...how many bytes sent today?? is it possible.
Re: How many Bytes sent by Oracle [message #312488 is a reply to message #312473] Wed, 09 April 2008 00:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I used by setting TRACE_LEVEL_LISTENER parameter in the listener.ora file and then by analyzing trcasst with statistics parameter.
Re: How many Bytes sent by Oracle [message #312493 is a reply to message #312473] Wed, 09 April 2008 00:57 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
If u do it today, then how can u get the data of yesterday?

[Updated on: Wed, 09 April 2008 00:58]

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312499 is a reply to message #312493] Wed, 09 April 2008 01:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use IM/SMS speak.

Regards
Michel
Previous Topic: Connecting Through .NET
Next Topic: connecting oracle to mssql using jdbc driver
Goto Forum:
  


Current Time: Sun Dec 04 06:30:11 CST 2016

Total time taken to generate the page: 0.13135 seconds