10-14-2010 2:21 PM
Hi,
is there any table which i can view the runtime for each program including the history?
we have an archiving project and we want to know what is the impact after archiving custom tables on the performance time of the programs using also the same custom tables.
Thanks,
Andy
10-14-2010 3:05 PM
So you want to estimate in advance whether archiving the data in custom tables will reduce runtime of custom reports?
I'd say archiving large tables is always a good idea, and rather than a runtime history of program executions I think that a list of expensive SQL statements (as in ST04, performance, SQL statement analisys, shared cursor cache) might be more helpful for this estimation.
Thomas
10-14-2010 3:47 PM
Hi,
since he wrote:
>we want to know what is the impact after archiving custom tables on the performance
i think he want's to evaluate the times after archiving anc compare them with historic values.
Therefore ST03 or manually saved STAD records is the tool to use.
Same of course for SQL statements (if they are known) that could be captured manually in
ST04 before and after or compared with AWR / ASH data within 7 days in ORACLE.
Kind regards,
Hermann
10-14-2010 4:52 PM
I see, maybe Andy or Victor will confirm whether they want to check before or after, or both. After reading his message again, I'd also say after.
Thomas
10-14-2010 4:55 PM
Hi Thomas and Hermann,
yes, i want to check the performance before and after we moved our changes.