Re: "Tuning" small tasks ...

Hi Jan,

i had this once (maybe not your problem)

- check v$sessions for pq - processes (may be transient)
- check if pq is running on this tables, 
- check parallel clause for table.

regards

s.kapitza

"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
Received on Fri Dec 20 2002 - 10:16:08 CST