[ajoybasu]

Hi,

I am using Stored Procedures to perform certain calculations and set the statuses based on the rules. But we found that any updates being my made the Stored procedure does not reflect immediatley on the OTM screens. The changes become visible only after a certain amount of time.

Can you let me know why this is so . Is there some Cache settings that needs to be updated or changed.

Are there are any disadvantages of using Stored Procedures when compared to Agents with DirectSQL?

Regards
Ajoy

[chrisplough]

Ajoy,

You've hit against the main disadvantage of stored procedures within OTM. The App server utilizes many large caches in order to maintain performance levels. Disabling these caches isn't an option within the application -- and if it was, would degrade performance significantly.

The only supported way to ensure that these changes are immediately reflected are to utilize Agents with DirectSQL, so that the application becomes aware of the execution and then updates the appropriate caches. The disadvantage of this approach is that Agents are significantly more expensive (in terms of performance) than stored procedures.

Thanks!
--Chris