Re: Performance problem on inserting

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 7 Feb 2003 16:27:07 -0000
Message-ID: <3e43de5e$0$4015$ed9e5944@reading.news.pipex.net>

"Kamal" <kamal80_at_virgilio.it> wrote in message news:4e766a02.0302070711.57972fff_at_posting.google.com...
> Hi everybody, here you are with the tkprof report file...
> Tnx in advance if you read it.
>
>

Hi

you didn't get any wait information, as was suggested. Also did you check the redo log sizing and placement.

One thing however I do notice is updates to tsq$ suggesting to me that you might have quotas on storage in the 9.2 instance?

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Feb 07 2003 - 10:27:07 CST