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 them as small as possible.  For my upcoming presentation at IOUG Collaborate 14 I needed a couple of Oracle [...]

By |2017-09-20T08:31:21+00:00February 23rd, 2014|Out Perform, Tips|Comments Off on Managing Oracle ADR in a test/dev environment

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 database as a whole.  Log Shipping is typically used as a low cost H/A implementation, however, its best used as a secondary [...]

By |2017-09-20T08:32:06+00:00January 21st, 2014|Tips|Comments Off on Microsoft SQL Server Replication – Not Meant for H/A

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 you are like me, you still have customers that need to migrate from 10g to 11g or 12c and [...]

By |2017-09-20T08:34:40+00:00January 4th, 2014|Tips|Comments Off on GoldenGate for 10G Download Tip

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 the database objects.  At times, the optimizer does not know best and you need to give a hint to nudge it in the [...]

By |2017-09-20T08:40:36+00:00October 2nd, 2013|Tips|Comments Off on Microsoft SQL Index Hints

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 where you can copy files from one folder/directory to another and then edit the init.ora parameter file to add [...]

By |2017-09-20T08:45:42+00:00September 11th, 2013|Tips|Comments Off on How to Multiplex the Oracle Controlfile in ASM

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 HugePages at the OS level. With HugePages, the Linux memory page size is set at 2MB (instead of the [...]

By |2017-09-20T08:46:00+00:00September 11th, 2013|Tips|Comments Off on Linux Huge Pages for Oracle

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. You can utilize both reports and views to access this data. Oracle allows you to transport the data AWR [...]

By |2017-09-20T08:46:11+00:00September 11th, 2013|Tips|Comments Off on AWR Data: How-to Extract & Load