Check out DB server/Schema space and server performance once.
Try to clear temp files and cache from managed servers and try retrievals once.
Thanks fot the reply,
Let me check schema space in DB.
We have tried to clear temp file but still we are facing issue.
Our DB team always monitors the schema space, but how much space is recommended?
DarshanJ - Hi Darshan - Diagnosing performance changes is always a tricky one. To start you should make sure you don't have any obvious issues in your way with testing performance. To start, I would look at the database indexes - ensure all is good there, maybe reindex if needed. Also - take a look at the HFM Error log, data-audit and task_audit tables in the DB - do some truncating/purging if needed. Once you do these little cleanup tasks, do some more testing and let us know the results, good/bad/ugly. I always advise to have client's do cleanup when the system its cold so schedule and outage, take good backups of everything and then cleanup and retest.
Again: Don't forget to always backup EVERYTHING before deleting or changing anything.
You can use the HFMEventViewer utility to cleanup the file system based event log and the database stored event/error log tables:
Oracle Support Document 1084998.1 (How to Extract Hyperion Financial Management (HFM) ErrorLog Entries from Database Using HFMErrorLogViewer.exe) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1084998.1
Here's a little link to an Oracle housekeeping article.
Let us know!!