11/20
Steve Callan discusses what takes place inside the Oracle database when you're searching for something "LIKE" the value of interest. How does Oracle approach the problem of determining if the string 'ABCD' appears in the string 'ABCABDABCDAB' and if it does, how many times? 11/11
Learn how to join disparate or seemingly unrelated data using an Oracle-provided pseudo column to create the linkage.
11/06
Learn how to use health checks to stay on top of corruption in your Oracle database.
10/31
This article illustrates how Oracle Database 11gR1 has expanded ADDM to encompass Real Application Clusters (RAC) database tuning at the global level and provided the ability to filter out previously identified performance issues from any ADDM analysis report.
10/28
One of the issues that companies are facing in their operations is database migration to new hardware, or a different operating system platform, or even a new database vendor. This article describes the overall process.
10/22
STATSPACK is still very much a viable option for monitoring and diagnosing database performance. Even though it seems as if AWR and ADDM have voted to send STATSPACK to Exile Island, treasures and rewards can still be found, but it's up to you to find them and make the most of what's available.
10/16
Oracle has many hints to choose from; know what they are and how they are different from one another before tossing them into production.
10/14
Oracle's Automatic Workload Repository improves quite a lot on the previous statspack; it installs automatically, has some fairly reasonable default settings, and brings us Active Session History as well. Read on to learn more...
10/02
Oracle’s new ADR with command interface shows promise for DBAs to quickly investigate diagnostic information. This article takes a deeper look at ADRCI’s commands.
9/30
This article discusses a new Oracle Database 11gR1 feature - Adaptive Cursor Sharing - and illustrates how to use it in practical situations to limit hard parsing of SQL statements with bind variables while increasing the relative execution efficiency of those statements.
9/24
The DBMS_PROFILER package has been around since at least Oracle8i days, yet it seems to get short shrift in many of the tuning books and online discussion forums. Learn how easy it is to implement and perhaps you'll add this built-in to your tuning arsenal.
9/11
Join Steve Callan as he shares several ways to get your hands on E-Business Suite.
9/10
Problem solving is high on the skill set that all DBAs should have. A DBA doesn't necessarily need to know how to solve everything but they should have the ability to define a problem, research solutions, and ultimately take action. Read on to learn more...
9/02
Oracle's new ADR with command interface shows promise for
DBAs to quickly investigate diagnostic information.
8/28
Learn how to install EBS, starting from scratch and walk away with an up and
running EBS instance using the Vision Enterprises database.
