cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
petermason
Level 13

Database Tuning - Manual V's Automated

Hi All,

Is anyone using the automated tuning feature to perform their database tuning? If so have you encountered any issues with it?

Does it take longer than performing manual tuning?

Please share any advice or comments you have on manual or automated tuning and your experiences with it.

Thanks

Peter

4 Replies
petermason
Level 13

Re: Database Tuning - Manual V's Automated

It seems that the only way to tune large DB's is off line. The tuning task will fail after 4 hours if it is run online.

0 Kudos
d_aloy
Level 12

Re: Database Tuning - Manual V's Automated

Hi Peter

Base don my own experience, automated db tuning works fine.

However we still see the requirement or running a manual purge every now and then (2-3 months) to keep the db size within limits

Regards

David

0 Kudos
petermason
Level 13

Re: Database Tuning - Manual V's Automated

Hi David,

Thanks for your reply.

How large are your databases and how long does the tuning process take on them?

Regards

Peter

0 Kudos
d_aloy
Level 12

Re: Database Tuning - Manual V's Automated

Hi Peter

Apologies for the (very) delayed response.

We've had 50-60GB databases going down to 15GB after manual purge with tuning. The process takes about an hour or a bit more depending on how big is the db when starting.

Regards

David

0 Kudos