RE: app is slow
- From: "Johnson, George" <George.Johnson@xxxxxxx>
- To: <Brian.Zelli@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <Mark.Bobak@xxxxxxxxxxxx>
- Date: Thu, 4 Jun 2009 10:10:35 +0100
Exactly!
I sometimes tend to find 3rd party app sessions tricky to jump on when
when they get into a DB so I tend to set up temporary "trigger traces" (
firing DBMS_MONITOR/SESSION from a system trigger ) to capture the raw
trace data. Spend a little time with one of Mr Kyte's books, I think
Google online books has some of them available, learn how to interpret
raw trace files. Raw traces can take a little time to learn all the
little flags but I find reading raw traces very enjoyable if a little
time consuming ( I have a wife and kids, I have no time to get a life!
), you really get to learn the nitty gritty of what XYZ is actually
doing.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: 03 June 2009 18:07
To: Brian.Zelli@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: app is slow
Hi Brian,
The best way to determine where a process is spending it's time is to
profile it. Oracle allows that to be done, by using the DBMS_MONITOR
package. Look at the SESSION_TRACE_ENABLE call.
That will allow you to collect raw trace data. Then, you can use
something like the Hotsos Profiler to understand exactly where the time
is going. There are also some free Oracle profiling tools floating
around.....
Once you understand exactly where the most time is being spent, you'll
know where to focus your tuning efforts.
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian
Sent: Wednesday, June 03, 2009 11:07 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: app is slow
How many times have we heard that? Well I have a user/group, that when
they do this one process it seems to be slow. This is a third party
app. My question is how can I monitor what this is doing to see where
it is "slow"? I checked stats on the table and they are current. There
is only one index currently and they said they need more. They input
about 50 -200 records a day on this table and the row size is about 7000
characters with about 14,000 records in the table. They have a notes
column of 2000 and a customer contact column of 4000. Are those a bit
extreme?
ciao,
Brian
This email message may contain legally privileged and/or confidential
information. If you are not the intended recipient(s), or the employee
or agent responsible for the delivery of this message to the intended
recipient(s), you are hereby notified that any disclosure, copying,
distribution, or use of this email message is prohibited. If you have
received this message in error, please notify the sender immediately by
e-mail and delete this email message from your computer. Thank you.
Please consider the environment before printing
********************************************************************************************
This message contains confidential information and is intended only for the
individual or entity named. If you are not the named addressee you should not
disseminate, distribute or copy this email.
Please notify the sender immediately by e-mail if you have received this e-mail
by mistake and delete this e-mail from your system. E-mail transmission cannot
be guaranteed to be secure or error-free as information could be intercepted,
corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The
sender therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This message is
provided for informational purposes and should not be construed as an
invitation or offer to buy or sell any securities or related financial
instruments. GAM operates in many jurisdictions and is regulated or licensed in
those jurisdictions as required.
To the extent this email has been sent to you by any GAM company domiciled in
the EU, being GAM (U.K.) Limited, GAM Sterling Management Limited, GAM
International Management Limited, GAM London Limited, GAM Fund Management
Limited, or GAM Fonds Marketing GmbH i.L., please note the following details in
respect of each such company: - GAM (U.K.) Limited (a company limited by shares
and registered in England and Wales with company number 01664573); - GAM
Sterling Management Limited (a company limited by shares and registered in
England and Wales with company number 01750352); - GAM International Management
Limited (a company limited by shares and registered in England and Wales with
company number 01802911); - GAM London Limited (a company limited by shares and
registered in England and Wales with company number with Company Number
00874802) Each of Registered Office: 12 St. James's Place, London, SW1A 1NX
GAM Sterling Management Limited, GAM International Management Limited and GAM
London Limited are each authorised and regulated by the Financial Services
Authority. GAM Fund Management Limited (a company limited by shares and
registered in Ireland with no. 156828) of Registered Office: George's Court
54-62 Townsend Street Dublin 2, Ireland
GAM Fonds Marketing GmbH, i.L. (a company limited by shares and registered in
Germany under No. HRB 66857) of Friedrichstrasse 154, D-10117 Berlin, Germany.
The competent Commercial Register is "Amtsgericht Charlottenburg" in Berlin.
Liquidator: Daniel Durrer.
Other related posts:
