Oracle9iAS Monitoring

December 3,  2003
Don Burleson

 


In order to develop a coherent picture of overall Oracle9iAS performance we must collect data from a variety of sources. Things to monitor and adjust:

  • Resource usage monitoring Assuming that each Oracle9iAS component is optimally tuned, any hardware-related overload must be addressed with more hardware.  The solutions may be to add a new app server, add RAM or CPU to existing servers, or install faster disks.  In UNIX or Linux you can monitor Oracle9iAS servers with the vmstat utility, top, glance or iostat, and store the data into Oracle tables for time-based resource analysis.  In a Windows environment you can use the Windows performance monitor to measure hardware usage. 
     

  • Response time monitoring Several components within Oracle9iAS allow you to track overall response time and the components of response time.  For example, web applications using the Oracle9iAS forms Server can use the Forms Server log to generate detailed response time report.  We will address this in greater detail later in this chapter.
     

  • Wait event monitoring Perform a wait even analysis on each component of Oracle9iAS can provide insights into the main source of latency for each Oracle9iAS component.

Need Oracle App Server Support?

We continue to offer personal app server mentoring for Oracle DBAs who must quickly learn the intricate details of Oracle Application Server.  You can have an Oracle expert right at your fingertips, anytime day or night.

We work with dozens of App Server Oracle databases every year, so we know exactly how to quickly assist you with any Oracle Application Server question. 

Call 800-766-1884 for a custom evaluation.

Burleson Oracle Consulting
www.dba-oracle.com
www.remote-dba.net 

 

 

 

 

 
 

 

 

Burleson Consulting
 Kittrell, NC, 27544

Email: info@remote-dba.net Phone (800)
766-1884

Copyright © 1996, 1997, 1998, 1999, 2000, 2001, 2002 by Burleson , Inc. All rights reserved.