Message-Id: <10751.127423@fatcity.com> From: Jacques Kilchoer Date: Wed, 24 Jan 2001 15:17:25 -0800 Subject: RE: Opinions on Performance Tuning Software This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0865B.CFE6CFD0 Content-Type: text/plain; charset="iso-8859-1" >-----Original Message----- >From: Mark Leith [mailto:mark@cool-tools.co.uk] >Sent: mercredi, 24. janvier 2001 11:41 >If it is like Spotlight (Quests diagnostic tool) then you have to > have the client open to monitor the database, and cannot monitor > in background (I think anyway, maybe Jacques could clarify). Sorry I'm late, busy day today. Disclaimer: I've only been at quest for less than a month, so I'm not fully familiar with all their products. Spotlight is used for graphical displays of the current areas of high activity in the database. You can look at the top sessions and the queries by session, tablespace usage, etc... For background monitoring you have to tie it in with another Quest product called IWatch. My personal opinion of graphical tools (I've been using quite a few of them since I've been employed at Quest) a) There's probably nothing displayed by the tools that you couldn't find by yourself with the right database queries. However - the tools usually show it to you in a display that's much easier to read, and it's much more convenient. You see the list of queries, click a button and the explain plan for the selected query shows up. I am a firm believer in SQL scripts but the GUI is definitely better. That's why you see people typing in documents in Microsoft Word instead of vi. b) Having a graphical tool that shows you everything does not mean that you can take an Oracle novice and expect them to know what to do. A DBA is still needed to interpret the data and know what actions need to be taken. c) If you are using a graphical tool, for each action that the graphical tool can take, it behooves you to be able to duplicate the same action using SQL scripts. For one thing, you will learn more that way. Also when you switch jobs you don't know that the new company will have the same tools, so you should be able to find the same information with no extra software. So I would say - first try to duplicate what the tool is doing with SQL scripts. Once you know how to do that, then use the "fancy" software. Also having scripts enables you to check that your helper program is showing you accurate results. ------ any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com ------_=_NextPart_001_01C0865B.CFE6CFD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Opinions on Performance Tuning Software

>-----Original Message-----
>From: Mark Leith [mailto:mark@cool-tools.co.uk]<= /FONT>
>Sent: mercredi, 24. janvier 2001 11:41

>If it is like Spotlight (Quests diagnostic tool) = then you have to
> have the client open to monitor the database, = and cannot monitor
> in background (I think anyway, maybe Jacques = could clarify). 

Sorry I'm late, busy day today.
Disclaimer: I've only been at quest for less than a = month, so I'm not fully familiar with all their products.
Spotlight is used for graphical displays of the = current areas of high activity in the database. You can look at the top = sessions and the queries by session, tablespace usage, etc... For = background monitoring you have to tie it in with another Quest product = called IWatch.

My personal opinion of graphical tools (I've been = using quite a few of them since I've been employed at Quest)
a) There's probably nothing displayed by the tools = that you couldn't find by yourself with the right database queries. = However - the tools usually show it to you in a display that's much = easier to read, and it's much more convenient. You see the list of = queries, click a button and the explain plan for the selected query = shows up. I am a firm believer in SQL scripts but the GUI is definitely = better. That's why you see people typing in documents in Microsoft Word = instead of vi.

b) Having a graphical tool that shows you everything = does not mean that you can take an Oracle novice and expect them to = know what to do. A DBA is still needed to interpret the data and know = what actions need to be taken.

c) If you are using a graphical tool, for each action = that the graphical tool can take, it behooves you to be able to = duplicate the same action using SQL scripts. For one thing, you will = learn more that way. Also when you switch jobs you don't know that the = new company will have the same tools, so you should be able to find the = same information with no extra software. So I would say - first try to = duplicate what the tool is doing with SQL scripts. Once you know how to = do that, then use the "fancy" software. Also having scripts = enables you to check that your helper program is showing you accurate = results.

------
any ignorant comments made are the sole = responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.