Avnish,
The book goes through this a bit on p61. There are a few tools out
there, including three from Oracle. As I mention in the book, I use our
own Hotsos Profiler, described at www.hotsos.com/products/profiler.html.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming
All,
This sounds wy too familiar to me.
My (blind) guess is that sql*net round trips is killing performance.
System-wide could indicate this, but, as Jared states, trace out a specific session, and grab the session-specific info from v$sesstat, before and after.
We brute forced the issue of
I will try to get the output of v$system_event and will send it you guys. In the mean
time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and over
looked rest of the chapters but didnt find an easy way to analyze thousands of lines
trace
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
I will try to get the output of v$system_event and will send it you guys. In the
mean time I have more question..
I am reading Cary's 'Optimizing Oracle Performance Book'. I am half way thru and
over looked rest of the chapters but didnt find
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
Ummm ... what was the problem that prompted you guys to replace citrix servers?
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have
: [EMAIL PROTECTED]
Date: 2003/12/11 Thu PM 01:34:52 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Performance tuning in complex environment
Hello Everyone, I am trying to get some help/suggestions reg. how to troubleshoot
performance issues.
Little back ground about
Not really sure what happened and why we decided to that. I was involved in the
beginning of project and remembered that PM was mentioning about talking to another
Logician client who were facing same issues.
-Original Message-
Jamadagni, Rajendra
Sent: Thursday, December 11, 2003
Thanks
I asked because we also use Citrix and so far we never had a problem related to
Citrix, only problems we had were inefficient coding and oracle bugs, nothing related
to HW/disk/WTS etc. The only problem initially with Citrix was configuring client
printers, but our guys figured it out
Oh I've run into THIS beforeyou are in a sticky technical AND political
situation I am sure.
It is really not that complex.
I'll bet they (your DBAs) have already been told you that the app is
horribly designed and it was a mistake and that the hardware is under
powered canned dataserver
:www.compuware.com
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, December 11, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Performance tuning in complex environment
Not really sure what happened and why we decided to that. I was involved
Avnish - Since nobody has mentioned it yet (my posts arrive late, so
probably will by the time this appears), get Cary Millsap's book Optimizing
Oracle Performance
http://search.barnesandnoble.com/textbooks/booksearch/isbnInquiry.asp?userid
=6WIANMIL0Hisbn=059600527XTXT=Yitm=1
His methods sound
PROTECTED]
Sent: Thursday, December 11, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Performance tuning in complex environment
Not really sure what happened and why we decided to that. I
was involved in the beginning of project and remembered that
PM was mentioning about
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
14 matches
Mail list logo
