Oracle DBA

Oracle DBA - Oracle Optimization

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

Use a large database block size

Because the database block size is fixed at database creation, this is one decision that is important to get right the first time. For file system based datafiles, without direct I/O, the database block size must match the file system buffer size exactly, as explained here. However, if your database is raw, or if direct I/O is available, then you have the luxury of choosing a larger database block size. There are many advantages to using a large block size, but the most significant is the saving in I/O for index based access paths.

Use Oracle's Explain Plan to Tune Your Queries

Oracle Users are unaware of the issues involved with designing a good query and those who have been at the game for some time want to make sure they are not needlessly burdening the database server. If you use Oracle, Explain Plan is a great way to tune your queries. As a bonus for using Explain Plan, you will learn more about how the DBMS works "behind the scenes", enabling you to write efficient queries the first time around.

Use raw log files

There are two important performance problems with buffered log file I/O. Buffered log file I/O suffers from partial block writes. Buffered log file I/O also suffers from I/O fragmentation.

Using Index Hints in SQL statements - 'Cause we know more about our application than Oracle does

Hints are used to give specific information that we know about our data and application, to Oracle. This further improves the performance of our system. There can be instances where the default optimizer may not be efficient for a certain SQL statements. We can specify HINTS with the SQL statements, to improve the efficiency of those SQL statements. In this article, we shall see how to specify INDEX hints and what the advantages of the same are.

Webinar: Oracle 10g SQL Tuning

In this information-packed Webinar, Oracle expert Don Burleson offers a practical, pragmatic approach to SQL tuning, from his unique perspective as a seasoned Oracle professional. Topics covered include the goals of SQL tuning, from replacing unnecessary, large full-table scans to caching small-table, full-table scans common causes of unnecessary full-table scans; how to plot index usage over time (including scripts to help you do so); and more. Don’s fast-paced presentation underscores his message that Oracle 10g’s AWR will revolutionize SQL tuning by greatly simplifying execution plans, enabling you to predict changes in SQL access before they cripple your database, and build a platform for Al-based database tuning.

Why, When tkprof?

The DBA will use tkprof and session tracing when the database or a particular session is having performance problems. tkprof will generally be used infrequently, when researching a very particular performance issue. A user may complain that the response time for a session is abysmal compared to the prior week. Session tracing and tkprof can be used to see exactly what is happening on the database, enabling the DBA to take corrective action.


A cross platform, Java based application for analyzing Oracle alert logs. AlertView™ is now a client/server application. Install on one system and monitor all of you alert logs.


Athene/MVS creates a performance database, using measured performance data of configuration details, resource usage and transaction, and Oracle database activity.

Database Toolkit

This toolkit for Oracle CODASYL DBMS collects and reports data (current/future transaction volumn, record archival, data storage and historical transaction patterns) and creates various database resize models to support most data administration requirements.

DB Monitoring Suite

This product is a set of database management, tuning, measuring and monitoring tools for Oracle systems.

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

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information

Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info

   Oracle Jobs   

Oracle Forum   
   Ask A Question   

Oracle DBA - Step 1
Oracle DBA - Step 2
Oracle DBA - Step 3
Oracle DBA - Step 4
Oracle DBA - Step 5
Oracle DBA - Step 6
Oracle DBA - Step 7
Oracle DBA - Step 8
Oracle DBA - Step 9
Oracle DBA - Step 10

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ