Re: Performance problems when large jobs are run

Hi,

What is the 2nd step in improving performance ? The SQL have been tuned.

Thank u very much.

Van Messner wrote in message ...
>Hello Dana:
>
> You may already have checked these things but two possible problems
are:
>How much memory do you have? If the shared pool size is 150M and you don't
>have enough memory, you may be engaging in a lot of very slow page
swapping.
>In that case you'd actually want to reduce the shared pool size.
>Have you tuned the SQL? Oracle recommends this as the first step in
>improving performance. Since you are getting bad results from simple
>querries the problem may be in your SQL.
>
>Van
>

[... deleted ...] Received on Mon Nov 23 1998 - 02:53:44 CST