David Fitzjarrell

Occasionally bugs creep in to code trees and end up in production. Oracle is not immune to this eventuality, and in Oracle Enterprise Manager (OEM), the

Oracle offers the possibility of encrypted TNS connections through the TCPS protocol. This requires the use of SSL, and as a result, certificates to

Query tuning is a combination of art, science and intuition. Elegant tuning solutions are art, based on science, that science using two of Oracle's

New database versions are always interesting; default parameter values can change; new parameters can be introduced, and new settings can appear. In

Oracle provides a way to clone a new database home from an existing installation and, for the most part, it works well. On x86_64, however, it appears

Security. Each day it seems another breach is reported, another hack revealed, more personal user information is stolen, apparently despite the best

Oracle, in a desire to let the administrator affect performance, has provided various settings in the spfile to enable or disable features that could

Oracle provides an interesting function, ASCIISTR(), to return ASCII strings from a VARCHAR2 or CLOB column, and in general it does an admirable job.

Oracle Solaris is on its way out, which means that for many shops the next project on the board will be to migrate to another operating system for Oracle

Patching is a necessity, and CPU updates can include patches some installations may not need. This 'all or nothing' approach may create issues that didn't

Oracle has decided that Solaris needs to retire, giving those who are running Oracle on Solaris roughly two years to move to another operating system. A

Sometimes it's desired to move data from production to test or development environments, and if done with the original exp/imp utilities, issues can arise