Oracle database performance tuning

<<Previous   Next>>

Oracle database performance tuning - June 11, 2010 at 15:30 PM by Babu Kunwar

Explain the purpose of tuning oracle database.

In simple words to improve the performance of our database we need to tune it. Following are the purpose of tuning database:...................
Read Answer

Could you explain the areas where tuning of database is required?

The following are the areas of concern for tuning: Memory Usage, Data Storage, Data Manipulation........................
Read Answer

What are the tools provided by oracle to assist performace tuning? Explain them in brief

OEM which stands for Oracle Enterprise Manager is a valuable set of tools that facilitates the comprehensive management of all components of an Oracle infrastructure, including.................
Read Answer

What is cost based optimization? When is it triggered?

Cost based optimizer as the name suggest does not talk in sense of money. Optimizer means to get best out of the given resource. In Oracle CBO is used so that the tables and indexes....................
Read Answer

Explain the factor that can cause the execution plan of a query to change.

Execution plans are the steps that the database will go through while executing queries. They are generated via the explain plan or set auto trace commands. The execution plans can...................
Read Answer

What is index monitoring feature in oracle? Explain how to use it for index optimization

SQL engine keeps indexes of all the tables that are defined inside a particular database which cause a large amount of the CPU and I/O usage. Index monitoring is a feature that is used to identify....................
Read Answer

Describe when to rebuild an index.

When we execute more number of insert and update queries for a particular database we need to rebuild indexes. Secondly when we execute a lot of delete queries inside a database.....................
Read Answer

Explain the purpose of DBFile Sequential and Scattered Reads.

DBFile: DB_FILES is the maximum number of datafiles that can be opened for a database....................
Read Answer

Explain how to tune the Redo log buffer. 

Redo log buffer is used for logging the events that has happened in database, that is it is used for keeping the track of changes that is taking place to a particular database....................
Read Answer

<<Previous   Next>>

Oracle Backup and Recovery

What is configure command and recovery catalog?, What are different types of backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?...............

Oracle DBA

How do you increase the performance of %LIKE operator?, What is a standby database? Difference between Physical and logical standby databases, What is Cache Fusion Technology?, What is simple replication and advance replication?.............

What are layers in Oracle Architecture?

The Oracle database has a logical layer and a physical layer. The physical layer consists of the files that reside on the disk and logical layer map the data to these files of physical.......... .

Write your comment - Share Knowledge and Experience