December 3, 2003
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.
– Perform a wait even analysis on each component of Oracle9iAS can
provide insights into the main source of latency for each Oracle9iAS
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
Kittrell, NC, 27544
firstname.lastname@example.org • Phone (800)
Copyright © 1996, 1997, 1998, 1999, 2000, 2001, 2002 by Burleson
, Inc. All rights reserved.