Ah but see, I didn't say 'DBA privs'. Most of the tools can be used by
an account that has select only on any of the v$ or dba_ views.
I also said "database aware". Which means they understand what the
results mean.
And then there are things like....
the hosting company we use has reports on performance etc that
authorized users can look at. Reports are on CPU, Webservers, page
downloads and Oracle. Here's the sad part. There are 4 Oracle reports:
- Dictionary Cache Hits (ARGH!!!!!!!!!!!!!!!!!)
- Percentage of Current Processes (as in we have 30 processes attached
and 300 processes configured in the init.ora)
- Sessions Waiting for Lock
- Total Sort Rate (rate of sorts per minute) on disk and in memory)
NONE of these are really useful, as they are reported on a daily basis.
The first we know is really useless, and one of these days I'm going to
install a cron job to run Connor's BCHR script, just for giggles.
The percentage of current processes makes no sense to me, as we run
with connection pooling.
Sessions waiting for Lock on a daily basis? I suppose it could be
useful, if only to point me to an app to start tuning.
And what really worries me is that the Sort Rate report is the "most
popular" (most viewed) of all of them. Not by me, I just learned about
these reports yesterday.
I need to have a LONG talk with the hosting company.
- April Wells <awells_at_csedge.com> wrote:
>
> I will go along with that.
> Whole heartedly in fact
> But with a disclaimer.
> They (the users with access to the tools) have to be willing to learn
> the
> tool, and what the results MEAN. If they are willing to learn
> (really
> learn, not just hear part then think they know all there is to know
> about
> tuning code), I will give them access to the tools in a min.
>
> We have one developer who I trust implicitly. She wants to learn,
> tries to
> use good coding standards and tries to write the tightest code
> possible. I
> would give her DBA privs on the development instance in a heartbeat,
> and any
> tool at my disposal to help her do her job.
>
> BUT...
>
> When you deal with parts of the user base (some of the developers)
> that
> think it is really cool to have a tool that has a really neat button
> that
> does everything for them, so they don't have to worry about the
> details of
> their code (SQL Navigator is our company's code generator of
> choice... not
> toad, that would be silly), then you have to deal with them having
> been
> 'educated' about tuning and what they should tell the DBAs to do to
> the
> system to tune it... and then they get an ORA-4030 error and decide
> that
> there needs to be a UNIX Kernel change because that will make their
> code
> run... you find out that a little bit of knowledge is a truly
> horrible
> thing.
>
>
> April
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L
> Sent: 4/16/2003 5:58 AM
>
> If the developer is database-aware enough to want to use something
> like
> Spotlight, or any tool that does not degrade performance, I'll give
> it
> to them if I can.
>
>
> --- Shamita & Chiran Ghosh <shamita-chiran_at_attbi.com> wrote:
> > Hello, How does the list feel about providing developers access to
> > ad-hoc/real-time, problem solving diagnostics tool such as
> Spotlight,
> > Mamba
> > etc. to developers to provide first-line support. I'm not so crazy
> > about the
> > it; but was wondering on what the list's opinion would be. Comments
> > please.
> > Thanks.
> >
> >
> > Chiran Ghosh
> >
> > email: Shamita-Chiran_at_attbi.com
> >
> >
>
> > ATTACHMENT part 2 application/ms-tnef name=winmail.dat
>
>
>
> __________________________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo
> http://search.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> The information contained in this communication, including
> attachments, is strictly
> confidential and for the intended use of the addressee only; it may
> also contain
> proprietary, price sensitive, or legally privileged information.
> Notice is hereby given that
> any disclosure, distribution, dissemination, use, or copying of the
> information by anyone
> other than the intended recipient is strictly prohibited and may be
> illegal. If you have
> received this communication in error, please notify the sender
> immediately by reply e-mail,
> delete this communication, and destroy all copies.
>
>
> Corporate Systems, Inc. has taken reasonable precautions to ensure
> that any attachment to
> this e-mail has been swept for viruses. We specifically disclaim all
> liability and will
> accept no responsibility for any damage sustained as a result of
> software viruses and advise
> you to carry out your own virus checks before opening any attachment.
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Apr 16 2003 - 08:43:51 CDT
