Category: Performance Tuning

contains posts related to performance tuning

oracle statistics – what are collected – for the new oracle dba

The article explains the difference between analyze and dbms_stats packages. Both these packages can be used to gather statistics

db_file_multiblock_read_count size – for the new oracle dba

you are a new oracle dba and you already know that the db_file_multiblock_read_count is used by oracle to specify the maximum number of blocks to read from disk in a full table scan. This parameter is important for performance tuning I/O(reads or writes to disk).

dba_tab_columns low value and high value – advanced performance tuning article

advanced performance tuning article for the new oracle dba explaining about the low value and high value columns found in the dba_tab_columns table/view.

Oracle db_files parameter complete reference for the new oracle dba career

Oracle db_files parameter complete reference for the new oracle dba career

Oracle open file descriptor performance – performance tuning for the new oracle dba career

A new Oracle DBA can find here information on how to troubleshoot file descriptor performance problems.

Oracle Compatibility init parameter – for the new oracle dba career

Oracle Compatibility init parameter – for the new oracle dba career

PL/SQL using Bulk Binds – some examples – for the new oracle dba

performance benefit of using PL/sql bulk fetching- for the new oracle dba career

Asynchronous IO on HP Unix servers – new oracle dba career

learn about enabling asynchronous IO on HP Unix servers. for the new Oracle DBA.

bind variables – some notes for the new dba

bind variables – some info for the new dba

awr report – brief intro to the new oracle dba

performance tuning – using awr report – for the new dba