Job SAP_PERIODIC_ORACLE_SNAPSHOT

[Former Member]

Hi All,

We have checked that job SAP_PERIODIC_ORACLE_SNAPSHOT plays main role in Updating currect space statistics in DB02.

But I do not find how this job is getting triggered, I expect some house keeping job (might be PERFORMANCE_COLLECTOR) is

triggering this job but I am not sure. I also doubt that job SAP_PERIODIC_ORACLE_SNAPSHOT is running hourly but in DB02

data is 8 hours old so what is the reason that every run of job SAP_PERIODIC_ORACLE_SNAPSHOT is not updating DB02 statastics.

So please let me know how job SAP_PERIODIC_ORACLE_SNAPSHOT is getting started and how it is Updating DB02 space statistics.

Regards,

Shivam Mittal

[former_member204746]

shivam.

I am locking this topic.

you failed to search before asking your question.

[Former Member]

Hi Shivam,,

It is part of RSCOLL00 program which can be configured on ST03 transaction. Scheduling data is stored on TCOLL table on the database.

ST03N -> Expert Mode -> Collector and Performance DB -> Performance Monitor Collector -> Execution Times

As an additional info, performance stat collector jobs are triggered by RSCOLL00 program automatically.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on May 27, 2011 1:50 PM