Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate a report of sql*net traffic

unregistered userMay 26 2015 — edited May 29 2015

Hi!

I am looking for a way to create statistics for sql*net traffice sent/received by hour and day. But no idea where to look for that information. AWR reports displays this:

Other Instance Activity Stats        DB/Inst: ...  Snaps: 5533-5534

-> Ordered by statistic name

Statistic                                 Total per Second per Trans

-------------------------------- ------------------ -------------- -------------

...

bytes received via SQL*Net from       3,683,887    1,023.0   4,186.2
bytes sent via SQL*Net to client      2,701,405      750.2  

3,069.8

Can somebody nudge me in the right direction, where to retrieve that data? Thanks in advance!

Patrick

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2015
Added on May 26 2015
15 comments
17,418 views