Re: Book feedback
Date: Thu, 7 Mar 2013 04:09:47 -0600
Message-ID: <CAGzKQQc_QtfrBRCrN0DtjV+aYTASXBh6AH7fo=Rme-+Q1BgPKw_at_mail.gmail.com>
Ram,
SQLTXPLAIN (SQLT) is becoming popular in the SQL Tuning space. Oracle Support uses it all the time simply because it allows a support engineer to collect what they need to diagnose a SQL statement performing poorly. Then analyze the issue in a stand-alone disconnected way.
Back to your question"Is SQLTXPLAIN 'mainstream' in companies? Do the people in the list use it?". Several large enterprises have adopted it (or its child tool SQL Health-Check SQLHC). Some of these enterprises install it on pretty much all their servers. Of course they have known and used it for a long time. If you are a newbie on SQLT, I suggest you go slow: Try it first on your non-Production environments, then when you are ready to benefit of it on Production you can install it there.
If your site has dozens, hundreds, or thousands of databases, then you can install SQLT with installation parameters in a file. This technique allows to rapidly install it on many systems. You can use same parameter file for further upgrades (SQLT has a new version about once a month).
Cheers -- Carlos
On Wed, Mar 6, 2013 at 1:33 PM, Abel Macias <abel.macias_at_oracle.com> wrote:
> It is mainstream in oracle support
>
> On Mar 6, 2013, at 12:43 PM, Ram Raman <veeeraman_at_gmail.com> wrote:
>
>
> Is SQLTXPLAIN 'mainstream' in companies? Do the people in the list use it?
>
> On Wed, Mar 6, 2013 at 5:50 AM, Carlos Sierra <carlos.sierra.usa_at_gmail.com
> > wrote:
>
>> Not sure if Stelios is in this list so I CC him. Stelios: you may want to
>> join oracle-l
>> I read a couple of first-version chapters and I was pleased with the
>> content. I will read it once I get my printed copy (i still prefer to read
>> technical stuff in paper...) I will get 3 printed copies and I plan to
>> share one with Abel Macias and one with Mauro Pagano.
>>
>> Anyways, I met Stelios a few years ago and I know he is well versed in
>> SQLTXPLAIN, so I expect this book to be of good quality. He contacted me
>> with questions during his writing, so I am confident the book will be
>> mostly accurate. But since SQLT evolves faster than humans, I expect the
>> book to become obsolete in less than 2 years!
>>
>> I truly appreciate Stelios volunteering to write this much-needed book,
>> specially considering that he has invested an enormous amount of his
>> personal time in order to accomplish this endeavor.
>>
>> Cheers -- Carlos
>>
>> On Tue, Mar 5, 2013 at 9:24 PM, Michael Schmitt <mschmitt_at_uchicago.edu
>> >wrote:
>>
>> > I have the alpha book as well and have really liked what I have read so
>> > far. I found it hits that nice balance between informative and
>> readability
>> > that you don't always find
>> >
>> >
>> > -----Original Message-----
>> > From: oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org]
>> > On Behalf Of Brent Day
>> > Sent: Tuesday, March 05, 2013 6:25 PM
>> > To: ontario_lover_r_at_yahoo.com
>> > Cc: oracle-l_at_freelists.org
>> > Subject: Re: Book feedback
>> >
>> > I have the alpha book and its a pretty good read. I have not read the
>> > latest update but am hing to this weekend.
>> >
>> > Brent
>> >
>> >
>> > On Mar 5, 2013, at 2:59 PM, Rob G <ontario_lover_r_at_yahoo.com> wrote:
>> >
>> > >
>> > > Does anyone have this book, any feedback?
>> >
>> http://www.amazon.com/Oracle-SQL-Tuning-SQLTXPLAIN/dp/1430248092/ref=sr_1_14?s=books&ie=UTF8&qid62520502&sr=1-14&keywords=oracle
>> > > --
>> > > http://www.freelists.org/webpage/oracle-l
>> > >
>> > >
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>> >
>> >
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> Cheers -- Carlos Sierra
>> http://carlos-sierra.net/
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
-- Cheers -- Carlos Sierra http://carlos-sierra.net/ -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 07 2013 - 11:09:47 CET