Board index » jbuilder » Database Pilot issues analyze statement
Database Pilot issues analyze statement
2005-10-12 11:25:17 PM
I recently had a developer connect to a production Oracle database (8.1.7) with Database Pilot using Oracle jbdc. A few hours later the database was reported as sluggish when issued certain SQL. Investigation revealed that Database Pilot had issued the ANALYZE statement against several tables. A SQL trace revealed that it does this each time a table is selected in the tree view or against a table specified in an executed SQL statement.
This entry was created when I highlighted table TEST in the tree view?
PARSING IN CURSOR #5 len=45 dep=0 uid=59 oct=62 lid=59 tim=0 hv=608376794 ad='26902a0c'
analyze table TIM.TEST estimate statistics
END OF STMT
I need to stop Database Pilot from issuing the analyze statements. Has anybody else encountered this issue?