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 H/A
Options for HA Configurations? Not Replication! If you’re considering high availability options, replication is not an option. SQL Server has other H/A options such as Clustering, Mirroring, and AlwaysOn that deal with your RDBMS or…
- Jan 21
- < 1 min 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
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 information that it has about…
- 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