Table for Program Runtime View

[Former Member]

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

[ThomasZloch]

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

[HermannGahm]

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

[ThomasZloch]

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

[Former Member]

Hi Thomas and Hermann,

yes, i want to check the performance before and after we moved our changes.