The wholesale system wide collection of timing data is not generally
a good way to go about trouble shooting performance issues.
You need to pick a process, collect the timing data for that process,
and *only* that process, diagnose where the most time is being spent,
and determine what can be done to speed it up.
This in a nutshell is the basis of Cary's book, at least
per my reading of it.
Always try to fix the stuff with the biggest payoff.
It could be a SQL statement, it could be a misconfigured or
malfunctioning network card. It could be that a developer
is filling a temporary table with lots of data during a transaction,
then deleting the data and doing it over and over again, all the
while doing full table scans. FTS is expensive when you want to
retrieve 3 rows from a temp table with 500 meg of extents in it.
Just for grins though, how about running this script and posting
the output for us? Sometimes you get lucky, and something may
appear really out of whack. No guarantees though. Troubleshooting
system performance problems takes more than an email.
HTH
Jared
=============================================
col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head "TOTAL|WAITS"
col total_timeouts format 999,999,999 head "TOTAL|TIMEOUTS"
col time_waited format 999,999,999 head "TIME|WAITED|SECONDS"
col average_wait format 99999 head "AVG|WAIT|100ths"
set line 150
set trimspool on
select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/
================================================
On Thu, 2003-12-11 at 10:34, [EMAIL PROTECTED] wrote:
> Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot
> performance issues.
>
> Little back ground about our environment. Its third party application (Logician)
> from GE. There are total 11 databases, all on oracle 8174 H-UX 11i in cluster
> environment. All the databases are on EMC Symmetrix using 6 disks. All the clients
> are connecting to database thru Citrix terminal servers.
> In last one year we spend lots of time/money in tuning databases, replacing Citrix
> servers but end result is same. I was wondering if anybody out there has ran into
> same kind of situation. Our (DBAs) guess is the disk layout is not optimal but we
> also dont have any data to prove that disks are the bottleneck. Is there any way to
> collect these kinds of stats in Oracle. We aren't getting much help from our SAN
> administrator.
>
>
>
> DISCLAIMER:
> This message is intended for the sole use of the individual to whom it is addressed,
> and may contain information that is privileged, confidential and exempt from
> disclosure under applicable law. If you are not the addressee you are hereby
> notified that you may not use, copy, disclose, or distribute to anyone the message
> or any information contained in the message. If you have received this message in
> error, please immediately advise the sender by reply email and delete this message.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <[EMAIL PROTECTED]
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
