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,

Mady

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. 

https://blogs.oracle.com/cealteam/epm-1112-hfm-database-housekeeping

Let us know!!

--Joe