topic Table for Program Runtime View in Application Development and Automation Discussions

Table for Program Runtime View

Former Member — Thu, 14 Oct 2010 13:21:27 GMT

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

Re: Table for Program Runtime View

ThomasZloch — Thu, 14 Oct 2010 14:05:30 GMT

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

Re: Table for Program Runtime View

HermannGahm — Thu, 14 Oct 2010 14:47:28 GMT

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

Re: Table for Program Runtime View

ThomasZloch — Thu, 14 Oct 2010 15:52:51 GMT

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

Re: Table for Program Runtime View

Former Member — Thu, 14 Oct 2010 15:55:51 GMT

Hi Thomas and Hermann,

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