Solved

OEM Network I/O Rate warning

Posted on 2008-06-19
3
436 Views
Last Modified: 2013-12-19
An inexperienced dba is grasping for straws and trying to blame slow Oracle response on the network. She is basing all this on OEM Network I/O Rate for a nic is 0.049MB/sec, fallen below warning... messages from OEM.

The nic shows 1GB connection from time of system boot, no errors, no drop packets...nothing. Network utilization from taskmanager is very low.

Stats from here printout from EOM show Average value .06, High Value 1.6, Low Value 0 over 24 hours. The warning and critical thresholds are not defined.

What drives this warning and does it actually mean there is a network issue or just low traffic on the NIC?
0
Comment
Question by:Difladermaus
  • 2
3 Comments
 
LVL 3

Author Comment

by:Difladermaus
ID: 21821553
info from switch during file transfer test attached
vader-6-19-08-am-test.txt
0
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 21830630
It could be too much Inactive and Dead processes on the computer.

Investigate the number of sessions:

select count(*) from v$session;

You can add to SQLNET.ORA file the parameter

SQLNET.EXPIRE_TIME = 10

to ask the Listener to drop all dead sessions every 10 minutes.
Play with the time ... 60 minutes.

Try to connect fron clent site to measure the time:

% tnsping 100 alias
0
 
LVL 3

Author Closing Comment

by:Difladermaus
ID: 31468738
I gave this info to our software group. I have asked for feedback, but they don't seem too concerned about it at the moment. Thanks for the info. I may revit this if the need arises.

Difladermaus
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to create an alias for a column name in ORACLE sql ? 2 45
Procedure syntax 5 48
Oracle Errors 11 44
populate value based on what is selected in lov 2 27
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question