12/29
Oracle Database 10g offered two new Flashback features that allowed an authorized user to see all versions of any changes made to one or more rows in a table. Database 11gR1 provides the ability to back out one or more independent or dependent transactions with Flashback Transaction Backout. 12/24
How well do you know the sorting rules of your own language? Chances are, Oracle knows them much better than you, in addition to knowing all the rules for all of the languages Oracle supports. Take a tour through Oracle's multilingual linguistic searching and sorting features.
12/10
Learn what Oracle has to offer with respect to searching and sorting, and especially so when it comes to linguistic sorting. You may not know this, but you do have some
control over how sorts are performed within your database's character set and you can compare Apples to apples, as it turns out.
12/04
James Koopmann takes some of the confusion out of Oracle nested tables with this step by step approach to create a table with a nested table.
11/26
Oracle Database 11gR1 offers an intriguing new Flashback feature - Flashback Data Archives - that allows an Oracle DBA to preserve a record of all changes to any table for a definite period of time.
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.
