Re: "Tuning" small tasks ...

From: Frank <fbortel_at_home.nl>
Date: Fri, 20 Dec 2002 09:52:46 +0100
Message-ID: <3E02DA5E.10107@home.nl>

Jan Gelbrich wrote:
> 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.

>
>
>

statistics on data dictionary? If so - drop 'em!

Frank Received on Fri Dec 20 2002 - 02:52:46 CST