Dear,

I'm very new in Oracle.
My company using Oracle 7.3.2. Currently we face some perfomance problem.
When I try to compile a program, it take more than 5 minutes, even longer
when execute the program. Before that when I try to do Select DISTINCT
statement it shown OVERFLOW error message. Then I try to set ARRAYSIZE to 1
then the Overflow problem was solved but the system very slow. I tried to
set Arraysize to 500, the system still very slow.

What show I need to check and what should I do? Please Help.


Thank you.

Best Regards,
Then Chew Fong

>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page