RE: SQL/T or maybe it's SQL T?
Date: Mon, 23 May 2011 15:27:17 -0500
Message-ID: <D95BD5AFADBB0F4E9BB6C53F14D3A050055BBAC614_at_JRCEXC1V1.research.na.admworld.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sandra Becker
Sent: Friday, May 20, 2011 3:00 PM
To: Taylor, Chris David
Cc: aprilcsims_at_gmail.com; 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_at_ingrambarge.com<mailto:ChrisDavid.Taylor_at_ingrambarge.com>> 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_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>
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_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of April Sims
Sent: Friday, May 20, 2011 2:47 PM
To: sbecker6925_at_gmail.com<mailto:sbecker6925_at_gmail.com>
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_at_gmail.com<mailto:sbecker6925_at_gmail.com>> 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_at_gmail.com<mailto:aprilcsims_at_gmail.com>
--
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.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 23 2011 - 15:27:17 CDT