Re: DBD::Oracle dbd_st_execute slow speed

[email protected] (Mike Towery) Mon, 13 Dec 2010 13:34:16 -0600

Newsgroups	perl.dbi.users
Message-ID	<[email protected]>

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

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.