Oracle DBA standard jobs

[former_member203165]

Hi,

Is there any sequence for scheduling dba jobs in DB13(Check DB, Verify DB,Update statistics etc)?.

Regards

Chandrasehkar

[tamil_arasan]

Hi Chardrashekar,

There is no sequence as experts told, please have a look at below notes/Link

1) 25152 - New scheduling calendar in CCMS (DB13) ORACLE

2) 66322 - CCMS: Database administration (transaction DB13)

3) http://help.sap.com/saphelp_nw70/helpdata/EN/02/fb1c42128a5733e10000000a155106/content.htm

Thanks

Pradeep

[divyanshu_srivastava3]

You 1st check DB.

You then update stats

And then verify DB

[former_member203165]

Hi,

Is there ant standard SAP note for this or any link?

Regards

Chandrashekar

[divyanshu_srivastava3]

This sequence is logical.

You 1st Check DB

if required, you built stats

You verify DB

[former_member188883]

Hi Chandrasekhar,

There is no sequence for this . It is based on requirement and suggestions from EWA report.

Ideally we have Update statistics & Check DB configured on daily basis.

Verify DB to be scheduled either on weekends or low load activities as it consumes good amount of DB resources. So plan this job accordingly.

Regards,

Deepak Kori

[raulc1]

You normally schedule on a daily basis:

UpdateStats first and 1h later CheckDB

Reason for this is that otherwise you may get warnings related to index stats being obsolete

Then on weekend run once VerifyDB and Cleanuplogs

Note VerifyDB takes a long time.

This is a best practice, I have not seen this documented on any note.