Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Maintenance Task other than Standard Jobs

Hi friends,

All of us are faced with the situation of improving the performance of our systems. We generally schedule the standard jobs.

Most of us would be carrying out various other activities such as key tables to be reogranized, index, update statistics. Can we share these key procedures so that people who are not using them can benefit from it. Please put up the activity and the steps to achieve the activity.

Lets open up and make our jobs much easier.

Thanks...in anticipation.

Aliila

Former Member
replied

Hi Friends,

There are many things that improvise the performance and the knowledge which we

have may/mayn't be sufficient but it's right that we can have a day to day practice and

make an usual habit of doing these ongoing tasks everyday to mantain a better health

of the system and of ourshelves

Let's start:

Optimizer Statistics

The Oracle Cost-Based Optimizer requires current information about the distribution of the database data in order to find the best search path. If this information is not up-to-date, or is not available at all, the Cost-Based Optimizer may choose the wrong query path, which can result in severe performance problems.

The Oracle Cost-Based Optimizer requires current information about the distribution of the database data in order to find the best query path. If this information is not up to date or is unavailable, the Cost-Based Optimizer may choose the wrong query path, which can result in severe performance problems.

For detailed information about the update of the "data distribution" database statistics, see SAP Note 403713.

As of Oracle 10g, we can create database statistics for fixed Oracle objects that contain information about current database activities. This is because the rule-based optimizer is no longer used as of this release and accesses to DDIC-objects are optimized by the cost-based optimizer.

command line for creating:

brconnect -u / -c -f stats -t oradict_stats.

Database Growth

Always like to maintain the database growth per month should be less than 30GB as

a standard and ensure that you have an archiving project.

Ensure that your backup strategy meets SAP recommendation of external tool is being used to retain back up.

To reorganise the table/indexes there are different specific SAP Notes so follow them to

reorganise, to have lesser size which in turn improve the performance.

There are other things also to monitor for a better tuning potenital and will post incase

i will come across in future.

Some Important SAP Notes:

871096 Oracle Database 10g - Patchsets/Patches for 10.2.0

766349 FAQ: Oracle SQL optimization

619188 FAQ: Oracle Wait Events

618868 FAQ: Oracle performance

540477 Collective note: Oracle - Hot News notes

354080 Note collection for Oracle performance problems

Thank you,

Tilak

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question