| How many Bytes sent by Oracle [message #312473] |
Wed, 09 April 2008 00:22  |
tanmoy1048
Messages: 83
Registered: June 2007 |
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  |
anacedent
Messages: 6219
Registered: July 2005
Location: surf meets turf in 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 |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
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 |
tanmoy1048
Messages: 83
Registered: June 2007 |
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 |
tanmoy1048
Messages: 83
Registered: June 2007 |
Member |
|
|
|
If I want to know ...how many bytes sent today?? is it possible.
|
|
|
|
| Re: How many Bytes sent by Oracle [message #312493 is a reply to message #312473 ] |
Wed, 09 April 2008 00:57 |
tanmoy1048
Messages: 83
Registered: June 2007 |
Member |
|
|
|
If u do it today, then how can u get the data of yesterday?
[Updated on: Wed, 09 April 2008 00:58]
|
|
|
| Re: How many Bytes sent by Oracle [message #312499 is a reply to message #312493 ] |
Wed, 09 April 2008 01:13 |
Michel Cadot
Messages: 17697
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
Don't use IM/SMS speak.
Regards
Michel
|
|
|
]
Members
Search
Help
Register
Login
Home
