Perl DBI vs SQLPLUS vs TOAD [message #495939] |
Wed, 23 February 2011 06:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6c65f88060a0573c028ae71ff33f40dc?s=64&d=mm&r=g) |
vvanjanikumar
Messages: 3 Registered: February 2011 Location: india
|
Junior Member |
|
|
Hi,
We have a query executing from perl.
my $sth = $dbh->prepare($sql)
my $rc = $sth->execute
$ref = $sth->fetchall_arrayref()
the sql was executing with a good plan (output in < 3 min) until some time in Dec 2010.
We did analyze some of the tables as part of a DB maintenance release.
Post that execution plan changed with some full table scans and total execution time of more than 1.5 hours.
We verified the query and did some tests in sqlplus and toad and could see that the results are obtained in less than 3 min.
We tried sql profiles as well, but couldn't make any changes to the execution plans.
Can you please advice how to proceed.
Cheers,
Veera
|
|
|
|
Re: Perl DBI vs SQLPLUS vs TOAD [message #495944 is a reply to message #495939] |
Wed, 23 February 2011 07:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You did many things but we can't know what you have.
Do you think we can make any advice on something we don't see?
Post code, post explain plan, post execution session, post table row numbers, post indexes, post constraints, pmost NLS parameters (in ALL environment), post everything that make a change in an execution plan.
Regards
Michel
|
|
|
|