OraFAQ Forum: Networking and Gateways » How many Bytes sent by Oracle

Home » RDBMS Server » Networking and Gateways » How many Bytes sent by Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many Bytes sent by Oracle [message #312473]

Wed, 09 April 2008 00:22

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,

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312474 is a reply to message #312473]

Wed, 09 April 2008 00:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

yes, from where to where?

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312475 is a reply to message #312473]

Wed, 09 April 2008 00:32

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312479 is a reply to message #312473]

Wed, 09 April 2008 00:43

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.

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312482 is a reply to message #312473]

Wed, 09 April 2008 00:43

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

If I want to know ...how many bytes sent today?? is it possible.

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312488 is a reply to message #312473]

Wed, 09 April 2008 00:50

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.

Report message to a moderator

Re: How many Bytes sent by Oracle [message #312493 is a reply to message #312473]

Wed, 09 April 2008 00:57

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

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't use IM/SMS speak.

Regards
Michel

Report message to a moderator

Previous Topic:	Connecting Through .NET
Next Topic:	connecting oracle to mssql using jdbc driver

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 03:44:06 CDT 2024