Re: Insert Records - Performance Problem

After your session has done its inserts on production, please post the output of the following:

select e.event, e.time_waited
from v$session_event e, v$session s
where s.audsid = userenv('SessionID')
and e.sid = s.sid;

select s.name, m.value
from v$mystat m, v$statname s
where m.statistic# = s.statistic#
and s.name = 'CPU used by this session';

Thanks,
Steve Adams

In article <7fihbe$6it$1_at_nnrp1.dejanews.com>,   kmyu_at_my-dejanews.com wrote:
> I have a problem in inserting records into Oracle 8. I have two machine, one
> for development and one for production and they have similar setting. The
> development machine takes only 0.8 sec to insert 1000 record, but the
> production machine takes 23 minutes to finish the same task. Is there any clue
> why there is different? I checked for the init.ora. They have similar
> parameters.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 19:51:59 CDT