9.1 Full Client Package Oracle statistics issue

[craig_welton]

Hi,

Built a full package in 9.1. After deploying to dev client I noticed how incredibly slow the developer tools were when getting the spec from the local Oracle database. My first thought was that the indexes on the spec tables were not built. Ran ReconfigureMSDE.exe to change the local password and then had a look inside the package database. The indexes were there but when reviewing the statistics on the tables, many of them were blank. Ran the gather statistics function from SQL Developer on each table and it fixed the performance issue.

Any idea on why the stats are not gathered? The pristine package delivered with 9.1 was fine.

release info:
Deployment Server where build was run - 2008 Server SP2 TR: 9.1.0.1A
Local Oracle DB: 11g 11.2.0.1.0
32 Bit Oracle Client: 11.2.0.1.0

thanks,
Craig

 

[fbrammer]

We had the same issue with previous releases. I just added a routine to the installation to run the stats on a full build installation. It added a few minutes to the install.

 

[jdel6654]

There is a known issue with package deployments on 9.1.0.x. Apparently the way the local db is being copied down to the client is a problem. I think you have to go to 9.1.3 to get it fixed.

 

[craig_welton]

Thanks for reply. Guess I didn't search correctly in Oracle support.

(wont be the last time)

Craig