Browse by Tags

HP-UX 11iv3 default semaphore settings will support 20,480 processes per database.  However, the Tune-n-Tools optimizer limits Oracle to 1,280 processes.  Gotcha!

An argument for why the time model statistics are a useful tool for performance analysis, using an example Statspack report which would give a very different impression without DB Time, etc.  (Eg if it were a 9i Statspack report).

Shrinking Oracle indexes can achieve dramatic performance improvements in some situations.

Oracle's recycle bin can waste space and cause performance issues if not managed.

If the storage system (eg SAN) is periodically overloaded, then database performance can suffer extreme variability.

We look into a case where an application server couldn't connect to the database.  It appeared to everyone else that Oracle wasn't responding, but we proved that it was a networking configuration issue.

Consolidation may be a trendy term, but is having a single clustered Oracle database for all of an enterprise's applications really the ideal situation, or just an architect's (and marketer's) dream?
This post lists the benefits of application separation at the database level.

Oracle can be configured to support case insensitive searches, comparisons and sorting.  While this sounds great for some applications, there are some gotchas...