since the latest upgrade, we are having an issue with application performance - even within sections which were untouched. Application loads and works very slow - unusable in future live environment.
We would like to identify if it's something related to formspider or some other (maybe incorrect) setting in database.
Do we have any possibilities to identify behavior of formspider in database and some tools/queries which would identify loading times in application sections?
It might not be related to formspider at all, but we need to be sure. Database was restarted, no objects are locked, etc ...
Many thanks, Tomas
asked 11 Jan '13, 02:27
You may use DBMS_PROFILER to trace your performance issues.
How to install DBMS_PROFILER:
Get the "runid" parameter from followinq query:
Use "runid" parameter in followind query to see objects used:
Use "runid" and "unit_number" parameters to see details on specific object:
answered 11 Jan '13, 05:03