Gunnar Berglund wrote:
>
> Hi all,
>
> we are facing some serious problems with the following case:
>
> we have an application which stores quite a lot of documents to
> database (average document size is 2mb). Application loads document
> template from database and when we are having 100-200 hu
Hi Gunnar,
Can you please turn on event# 10046 at level 8 and
trace some of your sessions? You can then run 9i
tkprof on the trace files, to determine the most
expensive SQL statements, from a resource consumption
and wait perspective.
I am sure there is enough expertise on this list to
figure ou
Hi all,
we are facing some serious problems with the following case:
we have an application which stores quite a lot of documents to database (average document size is 2mb). Application loads document template from database and when we are having 100-200 hundred users there will be a queue on