Re: "Tuning" small tasks ...

Thank You, Alex, but we are not running MTS (I should have mentioned in the first place ...),
we have Dedicated Server ... "pity" ...

Some complain "that didnīt happen on the older db !!" - that was Oracle EE 8.0.5, we migrated to 8.1.7. four months ago. Well, but we definitely donīt go back to an older version ...

Any more guesses ? Some SQL*Plus configs ? I have no idea what this could be.
And I did a lot of RTFMing in the last weeks (not only for this problem ...)

regards
Jan

"Alex Filonov" <afilonov_at_yahoo.com> schrieb im Newsbeitrag news:336da121.0212190833.c646661_at_posting.google.com...
> "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:<ats6vj$206uo$1_at_ID-152732.news.dfncis.de>...
> > Hello,
> >
> > it is not really a tuning question I think, but although the instance
has
> > been tuned, I sometimes observe strange things
> > like the follwing in SQL*Plus:
> >
> > - selects on very small tables (100 rows or such) may take 20 seconds
...
> > - desc some_view or desc some_table may also tale 10 seconds ...
> > on other times the responses come up at once, just as it should be ...
> >
> > I could not verify what may cause this behavior. It happens on normal
times
> > or on heavy duty times (with much redo),
> > with 300 sessions online, but only 10 active simultaniously at the peak.
I
> > (think that I) have appropriate hit ratios and so forth.
> >
> > Is there a general reason that could slow down small actions like DESC ?
> >
> > My system:
> > Oracle EE 8.1.7 on AIX 4.3.3,
> > C/S env with 300 users using Oracle Forms runtimes on Windoze.
> > Only 4 developers and 1 admin connect to Oracle by SQL*Plus.
> >
> > Any comments greatfully appreciated.
> >
> > Jan
>
> Are you using MTS? If so, check if you have enough servers.
Received on Fri Dec 20 2002 - 01:44:22 CST