Re: Basic query tracing and profiling question...

On Apr 18, 7:46 am, Niall Litchfield <niall.litchfi..._at_dial.pipex.com> wrote:
> fitzjarr..._at_cox.net wrote:
> > On Apr 17, 2:23 pm, Brian K <brikee..._at_geemail.invalid> wrote:
>
> > Query V$SQLAREA where the rownum <= 10 and order by last_load_time> descending to get the 10 most recent queries hitting your database.
> > And simply because I didn't tell you before in no way means I
> > can't. You STILL have a problem with your configuration that even
> > query tuning won't fix. I'm glad you're so unconcerned.
>
> > David Fitzjarrell
>
> What problem is that then? The 1 disk that was mentioned here? But we
> have no way of knowing that the poster has one disk. He does have all
> his data on one windows volume, but that is really quite a long way from
> having it on one disk. Given that the 'disk' is 534gb in size formatted
> with a filesystem on it, in fact, a much more reasonable assumption
> would be that it was either an array local to the server or a volume on
> a SAN, if I was going to take a wild punt on the physical disk storage
> in fact I'd suggest it was most probably on a SAN (since there are 2
> quite large volumes here) or else an array of 144gb disks (say 5 in RAID5).
>
> This sort of response is all too typical of this group these days, I'm
> afraid, someone comes in, asks a question that either betrays that they
> are inexperienced, or else they state that they are inexperienced, or
> both and they get a number of acerbic replies before getting one that
> may or may not answer the question for them - often as not there will be
> barbs aimed at the organization they work for as well without any real
> knowledge of the circumstances under which people are working. Abuse of
> the inexperienced isn't a quality I associate with professionals really.
>
> Finally of course the actual advice here is incomplete for at least two
> reasons. First translating the query spec you gave
>
> > Query V$SQLAREA where the rownum <= 10 and order by last_load_time
> > descending to get the 10 most recent queries hitting your database
>
> would typically translate into the sql statement
>
> select <something> from V$SQLAREA where rownum <= 10 order by
> last_load_time desc;
>
> which doesn't give the most recent 10 statements at all, it merely
> orders the first 10 it finds.
>
> Second of course V$SQLAREA doesn't contain all SQL, so it may or may not
> contain the problem statement(s)
>
> --
> Niall Litchfield
> Oracle DBAhttp://www.orawin.info/services

Niall,
I don't like your comments at all.
You must be well aware most posters here are not prepared to do their homework, and jump to the newsgroup right away. They don't know Oracle, they also don't WANT to learn it, and misuse this forum as a free OTS and a free consultancy area.
With respect to your comment on professionalism: I assume you have become so professional, you don't answer any question anymore, but rather want to chastize people voluntarily taking their part of the burden, and getting annoyed in doing so?

--
Sybrand Bakker
Senior Oracle DBA