Re: Book feedback
- From: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
- To: Ram Raman <veeeraman@xxxxxxxxx>, Abel Macias <abel.macias@xxxxxxxxxx>
- Date: Thu, 7 Mar 2013 04:09:47 -0600
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@xxxxxxxxxx> wrote:
> It is mainstream in oracle support
>
> On Mar 6, 2013, at 12:43 PM, Ram Raman <veeeraman@xxxxxxxxx> 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@xxxxxxxxx
> > 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@xxxxxxxxxxxx
>> >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@xxxxxxxxxxxxx [mailto:
>> oracle-l-bounce@xxxxxxxxxxxxx]
>> > On Behalf Of Brent Day
>> > Sent: Tuesday, March 05, 2013 6:25 PM
>> > To: ontario_lover_r@xxxxxxxxx
>> > Cc: oracle-l@xxxxxxxxxxxxx
>> > 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@xxxxxxxxx> 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
>> > > --
>> > > //www.freelists.org/webpage/oracle-l
>> > >
>> > >
>> > --
>> > //www.freelists.org/webpage/oracle-l
>> >
>> >
>> > --
>> > //www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> Cheers -- Carlos Sierra
>> http://carlos-sierra.net/
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
Cheers -- Carlos Sierra
http://carlos-sierra.net/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
