msouterblight1
VIP Member
All,
Our 8.12 Package Builds are running slow. During the server build, the spec copy is taking longer than I would expect, especially on the FDASPEC records. There are 445395 records in the table, and it takes over an hour and a half to finish the copy!!! GBRSPEC has 4487038 records, and it only takes about 20 minutes.
Is this common???
Any ideas on how I can speed it up?
We have reindexed the table and we have run statistics.
Thanks,
Matthew
EOne 8.12, Oracle 10G Release 2, Solaris 10 Enterprise and Web Servers, Redhat 4 Web Servers.
Our 8.12 Package Builds are running slow. During the server build, the spec copy is taking longer than I would expect, especially on the FDASPEC records. There are 445395 records in the table, and it takes over an hour and a half to finish the copy!!! GBRSPEC has 4487038 records, and it only takes about 20 minutes.
Is this common???
Any ideas on how I can speed it up?
We have reindexed the table and we have run statistics.
Thanks,
Matthew
EOne 8.12, Oracle 10G Release 2, Solaris 10 Enterprise and Web Servers, Redhat 4 Web Servers.