Re: Performance problem on inserting

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:RKPZ9.6140$V6.8296_at_news.indigo.ie...
> Do alter session set sql_trace=true for sql*plus sessions on both
machines,
> and do a 10046 trace and rerun the scripts.
>
> then run tkprof with the wait option and post the results. let's see
what's
> being waited on.
>
> the 8i tk can't do the 10046 wait analysis but it would be useful to have
> too.

AFAIK You can run the 9i tkprof against an 8i trace file.

<disclaimer>
the script tells you not to do this but gives no reasons </disclaimer>
if you install the dbms_support package @?/rdbms/admin/dbmssupp when connected as sysdba you get a simple pl/sql interface to generate trace files with wait and bind information if needed.

exec sys.dbms_support.start_trace(); will generate a trace file for your session with wait info.

--
Niall Litchfield
Oracle DBA
Audit Commission UK