craig_welton
Legendary Poster
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
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