I would suggest you do a 10046 trace on the perl job and looked at what is causing the waits. Also with 9i and above there is wait option is included in Tkprof. This will provide some insight on what the database is waiting on.

You can google 10046 oracle trace if you need information on how to do it.

Regards,
Mike Towery

Reply via email to