RE: SQL/T or maybe it's SQL T?

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: