Oracle Enterprise Linux – Use the Features

One of the best features of Oracle Enterprise Linux is the ability to quickly and efficiently deploy an environment that is ready to deploy an Oracle database Server.  This is done via a set of RPM (Redhat Package Manager) packages that are set up to do all of the tedious configuration work for you.  [...]

By |2017-09-20T08:34:23+00:00January 7th, 2014|Performance Wire|Comments Off on Oracle Enterprise Linux – Use the Features

What are Linux Hugepages? Video

Oracle ACE Ed Whalen of Performance Tuning Corporation speaking with Oracle Partner Network (OPN) about Linux Hugepages , what they are and how to use them to improve Oracle Performance on Linux.  Filmed at Oracle Open World 2013. http://www.youtube.com/watch?feature=player_detailpage&v=f3EHWrpunvo  

By |2017-09-20T08:36:31+00:00December 10th, 2013|Out Perform, Video|Comments Off on What are Linux Hugepages? Video

UnOptimized Reads in Oracle Database 11gR2

Many of you who have been reading statspack or AWR reports might be wondering what is the new category of "SQL Statistics; SQL ordered by Physical Reads (UnOptimized)".  What is an UnOptimized read? To begin, we need to clarify the meaning of the statistic. For systems not using Exadata Hardware and the Oracle Database [...]

By |2017-09-20T08:36:47+00:00December 2nd, 2013|Performance Wire|Comments Off on UnOptimized Reads in Oracle Database 11gR2

Direct Path Reads in Oracle Database 11gR2

Updated: 11/26 A new feature introduced in Oracle 11gR2 is the way the Direct Path Read operation is done.  A direct path read is where the data is read directly from the data files into the PGA rather than into the buffer cache in the SGA.  Direct Path reads have been around for a [...]

By |2018-02-23T17:58:49+00:00November 12th, 2013|Performance Wire|Comments Off on Direct Path Reads in Oracle Database 11gR2

Oracle GoldenGate and Archive Logs

The default configuration of an Oracle database created with DBCA is to allow archiving to follow default settings.  This in essence sets the log archive location to be the Fast Recovery area or the location set by the db_recovery_file_dest initialization parameter. Well, GoldenGate does not understand the Oracle defaults and you will get an [...]

By |2017-09-20T08:43:22+00:00September 20th, 2013|Performance Wire|Comments Off on Oracle GoldenGate and Archive Logs

iSCSI Setup on OEL6

Recently I had to set up iSCSI on an OEL 6.4 system.  This is a fairly straight-forward process.  It does take a little bit of effort, but it can be done fairly quickly and efficiently.  The basic process is to follow these steps: Install packages. Configure iSCSI Install packages There are two packages that [...]

By |2017-09-20T08:44:22+00:00September 20th, 2013|Performance Wire|Comments Off on iSCSI Setup on OEL6

Install Flash for OEM 12c on OEL

In order to run Oracle Enterprise Manager DB Control or OEM Cloud Control 12c it is necessary to be able to run Adobe Flash within your FireFox browser on your Linux system.  This is not as easy as it might seem at first.  In order to install the Adobe Flash player on OEL 6.4 [...]

By |2017-09-20T08:45:10+00:00September 19th, 2013|Performance Wire|Comments Off on Install Flash for OEM 12c on OEL

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