StatsPack is an Oracle package for monitoring performance statistics.

(more…)

Rollback segment size refers to needing an accurate minimum number of bytes required by the rollback segment for any single given transaction or for the most important of these. There are differences between the kind of transactions (INSERTS,UPDATES and DELETES). For example the INSERTS generates less UNDO than deleting records because while rolling back an insert only requires deleting the row, rolling back a delete requires reinserting that row. It would take less bytes to store a rowid than to store information to reconstruct the actual row itself.

(more…)

Oracle 11g has a new hint telling data to persist in cache for x number of minutes. The syntax is:

(more…)

If a table or index becomes fragmented (not continuous on disk) performance can decrease. You can see which objects have over 10 extents with:

(more…)