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…)

A lot of developers use embedded SQL, or other tools to access their data. If a query is not optimized it can cause problems.

(more…)

In Oracle 11g we have the memory_max_target parameter which governs the total maximum RAM for both the PGA and SGA regions and the new memory_target parameter which governs the existing sizes. This allows RAM to be de-allocated from the SGA and transferred to the PGA.

(more…)

Oracle will do sorting when executing queries that use ORDER BY, GROUP BY, when a Index is created, and when MERGE SORT is invoked by the SQL optimizer.

(more…)