Oracle DBA - Oracle Optimization

Page : 1 2 3 4 5 6 7 8 9 10 11

Oracle Database Tuning

For optimum performance an Oracle database should be regularly tuned. Only tune a database after it has been up and running for a little while.

Oracle Histograms

Histograms can be generated by two different methods ... both involve the keyword "SIZE".

Oracle Optimizer: Moving to and working with CBO

If your application was developed in earlier releases of Oracle (v. 7 and earlier), chances are that your database is running in Rule based optimizer. This article will help you understand the Oracle Optimizer and various efficient ways of moving to Cost based Optimizer.

Oracle Partitioned Tables

Oracle supports partitioning only for tables, indexes on tables, materialized views, and indexes on materialized views. Oracle does not support partitioning of clustered tables or indexes on clustered tables.

Oracle Partitions : Divide and perform

Creating Oracle partitions is very similar to creating a table or index. You must use the CREATE TABLE statement with the PARTITION CLAUSE. The first step to create a partitioned table would be to identify the column(s) to partition on and the range of values which go to each partition. Then you determine the tablespaces where each partition should go.

Oracle Performance Tuning – Part 1

Performance tuning is a broad and somewhat complex topic area when it comes to Oracle databases. Two of the biggest questions faced by your average DBA concern where to start and what to do. All you may know is that someone (a user) reports a problem about a slow or poor performing application or query. Where do you even begin to start when faced with this situation?

Oracle Performance Tuning – Part 2

In the interest of being complete, I will cover some preliminary steps that will be needed in order to view what is taking place. These steps include running the plustrce SQL script, creating an "EXPLAIN_PLAN" table, granting a role, and configuring your SQL*Plus environment to see execution plans. All of these steps are covered in "Using Autotrace in SQL*Plus" in Oracle9i Database Performance Tuning Guide and Reference Release 2 (9.2). For Oracle10g, the steps are covered in "Tuning SQL*Plus" in SQL*Plus® User's Guide and Reference Release 10.2.

Oracle tuning fallacies

There are many Oracle experts who have very different approaches to Oracle tuning and database optimization. There are Oracle scientists, pragmatists and statisticians, all of whom are successful at Oracle tuning, but with very different approaches solving the Oracle tuning problem.

Oracle Tuning Method and Advanced Refernce

Kyle Hailey's Oracle Performace Tuning Reference page that contains a performance monitor, tuning method and reference to explainations of latches, wait events and system statistics. When you are responsible for addressing the complaint, "The database is running too slowly!" "What is happening in the database?" "Is my test running correctly?" How do you respond? Assuming (shouldn't assume) that the machine is running correctly (usually isn't) In this discussion we are going to look at: What data to collect Ways to collect the data How to analyse it Some tunning examples