script taking time

Posted by Roshan on Jun 05, 2018; 7:13am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/script-taking-time-tp6155.html

SunOS dw172 5.10 Generic_147440-04 sun4u sparc SUNW,SPARC-Enterprise
DB 9.2.0.6.0

Hi Erman,

I am executing a script which is taking time to run. I have done a healthcheck at DB level. I have added more redo log groups since I was getting checkpoint error.

Please see attached script.
ins_mobiledata.sql

Regards,

Roshan