RE: SQL/T or maybe it's SQL T?
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "sbecker6925@xxxxxxxxx" <sbecker6925@xxxxxxxxx>, "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- Date: Mon, 23 May 2011 15:27:17 -0500
A better strategy would be to convince the developers to start using ILO and,
when they start seeing areas of the application slowing to unacceptable levels,
communicate the relevant modules & actions. You can then trace those pieces of
code via dbms_monitor and not have to rely on developers providing you with
what they 'think' is happening slowly.
http://sourceforge.net/projects/hotsos-ilo/
chris
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandra Becker
Sent: Friday, May 20, 2011 3:00 PM
To: Taylor, Chris David
Cc: aprilcsims@xxxxxxxxx; oracle-l
Subject: Re: SQL/T or maybe it's SQL T?
The customer DBA seems to think this is a new tool. Whatever. If it can give
me any additional information in tuning poorly performing queries, I'm open to
looking at it. The biggest problem I have is that no one on our development
team has supplied me with the problem queries yet. How do you tune what you
don't have? I'm asking again for the information and now that an influential
customer also is asking, maybe I'll get it this time.
Sandy
On Fri, May 20, 2011 at 1:52 PM, Taylor, Chris David
<ChrisDavid.Taylor@xxxxxxxxxxxxxxx<mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx>>
wrote:
Hmmmm
Looks like it has been around since 2002
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355<tel:615-517-3355>
Cell: 615-663-1673<tel:615-663-1673>
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of April Sims
Sent: Friday, May 20, 2011 2:47 PM
To: sbecker6925@xxxxxxxxx<mailto:sbecker6925@xxxxxxxxx>
Cc: oracle-l
Subject: Re: SQL/T or maybe it's SQL T?
Document TitleSQLT (SQLTXPLAIN) - Tool that helps to diagnose SQL statements
performing poorly (Doc ID 215187.1)
On Fri, May 20, 2011 at 2:42 PM, Sandra Becker
<sbecker6925@xxxxxxxxx<mailto:sbecker6925@xxxxxxxxx>> wrote:
Has anyone heard of this tool? In a meeting this morning a customer DBA asked
a non-DBA from our company if we had started using this free tool from Oracle
called "SQL T". I tried to find it to check it out but either I'm not spelling
it correctly, I'm looking in the wrong place or the person who told me about it
got the name wrong. He wasn't even sure what it was supposed to do so I'm
working in the dark here.
--
Sandy
Transzap, Inc.
--
April C. Sims
IOUG SELECT Journal Executive Editor
http://aprilcsims.wordpress.com<http://aprilcsims.wordpress.com/>
Twitter, LinkedIn
Oracle Database 11g - Underground Advice for Database Administrators
https://www.packtpub.com/oracle-11g-database-implementations-guide/book
OCP 8i, 9i, 10g DBA
Southern Utah University
aprilcsims@xxxxxxxxx<mailto:aprilcsims@xxxxxxxxx>
--
Sandy
Transzap, Inc.
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential and
exempt from disclosure under applicable law. If the reader of this message is
not the intended recipient or the employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify us
immediately by email reply.
Other related posts:
