Do you have current statistics on the applicable tables?





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: esd-dbas
[mailto:oracledba-ezmlmshield-x77339987.[Email address protected]
Sent: Friday, April 04, 2008 6:08 AM
To: LazyDBA Discussion
Subject: Oracle 10g initialization parameters for Deltek Costpoint 6.1
PJPUPPSR process

We recently went from Costpoint 4.0 to Costpoint 6.1 - the underlying
database went from 8.1.7 to 10.2.0.3

Running the PJPUPPSR takes significantly longer (PSR_FINAL_DATA insert)
within the program. This used to take at the most 15 seconds to add a
new record - now it takes up to 5 minutes to add only one.

Anyone else experience something similar - any insight into oracle
initialization parameters that could affect this favorable or
disfavorably?

Hoping we're not the lone ranger - someone else has already dealt with
this issue and knows the resolution.

Thanks!




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Oracle LazyDBA home page