Maintenance Task other than Standard Jobs
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.
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
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.
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