- (800) 887-4513
Tips
Managing Oracle ADR in a test/dev environment
I recently ran into a problem where my test systems were running out of space. Since I like to have a lot of test systems for training purposes, blogging and papers I try to keep…
- Feb 23
- 2 mins read
Microsoft SQL Server Replication – Not Meant for High Availability (HA)
Options for HA Configurations? Not Replication! If you’re considering high availability options, Microsoft SQL Server Replication is not an option. Microsoft SQL Server has other H/A options such as Clustering, Mirroring, and AlwaysOn that deal…
- Jan 21
- 2 mins read
GoldenGate for 10G Download Tip
I recently went to download the latest version of Oracle GoldenGate for Oracle 10g and noticed that it is now classified as Controlled. This happened because Oracle Database 10g is no longer available. However, if…
- Jan 04
- < 1 min read
Microsoft SQL Index Hints
The Microsoft SQL Server query optimizer is a cost-based optimizer. This means it will determine the best method to execute your SQL command based on the information that it has about the database objects. At…
- Oct 02
- 2 mins read
How to Multiplex the Oracle Controlfile in ASM
You may face a situation where you have to multiplex the controlfile across multiple diskgroups, especially after the database is created. However with ASM, this activity is not as simple as it is with filesystems…
- Sep 11
- 2 mins read
Linux Huge Pages for Oracle
When Linux servers that host Oracle database environments are configured with 16GB or more of memory and the total SGA of the Oracle databases is 5GB or more, it is strongly recommended to configure Linux…
- Sep 11
- 2 mins read
AWR Data: How-to Extract & Load
Oracle Automatic Workload Repository (AWR) maintains performance statistics for detecting problems in the Database by collecting and processing data needed for self-tuning. The data gathered resides both in memory as well as in the database….
- Sep 11
- 3 mins read