Email Alerts
-
Online patching support highlights upcoming Oracle EBS 12.2 release
Oracle EBS 12.2 is expected out this year, and support for online patching will be one of its key features. Tip
-
Oracle vs. SQL Server faceoff: Oracle Database wins on high availability security
An Oracle user group member argues that Oracle wins in the battle of Oracle vs. SQL Server. Faceoff
-
In-memory databases: Oracle TimesTen vs. Sybase ASE
In this first part, expert Mich Talebzadeh looks at the Oracle TimesTen in-memory database, detailing how it works and explaining when it’s beneficial over a traditional relational database management system. Tip
-
How to copy an Oracle database
Contributor Raymond Lefebvre, a database director, explains how to do one of the most common things DBAs are required to do – copy an Oracle database. Tip
-
Consolidate Oracle databases with session schema management
In part two of this series on database consolidation, the author explains how an Oracle consolidation can be done using session schema management. Tip
-
Upgrading to Oracle Database 11g
If you have previously installed an earlier version of the Oracle database server, you can upgrade your database to Oracle Database 11g. Multiple upgrade paths are supported; the right choice for you will depend on factors such as your current Oracle... Tip
-
How do I do that in Oracle?
This series is a collection of tips that explain in detail how to perform specific tasks in Oracle related to database administration. Tip
-
Inside the Oracle 11g SQL Performance Advisor, part 1
This preview from the forthcoming book "Oracle 11g New Features" describes the goals of holistic SQL tuning and the steps to perform automated SQL tuning with Oracle 11g's new SQL Performance Advisor feature. Tip
-
Inside the Oracle 11g SQL Performance Advisor, part 2
Part 2 of this excerpt from "Oracle 11g New Features" explains how to create a SQL Tuning Set (STS) to be used as input for the SQL Performance Advisor, Oracle 11g's new automatic SQL tuning feature. Tip
-
Using the cost-based optimizer to improve Database 10g performance
An advantage of upgrading to Oracle 10g is that the cost-based optimizer (CBO) has been improved to choose the best execution plans based on statistics of the data. But one of the most common causes of performance issues in 10g databases is bad stati... Tip