Hugepages on Exadata? Yes and No… part1

The topic of enabling hugepages on our Exadata environment.  Just opened an SR with Oracle Support to get some clarification.  I know that it is not enabled on the database servers, but is on the cell servers. Here you can see the database version we are using: Here you can see that hugepages in /etc/sysctl.conf […]

SEV 1 SR – 8 Node Exadata Database Hang – Update 3

Before I get to the workaround that we are currently using in the event this happens, I would like to share with you that we are having the problem.  Oracle is still having us perform actions.  I’ll provide you what we are doing first, then I will share the workaround. Oracle wanted us to enable […]

SEV 1 SR – 8 Node Exadata Database Hang – Update 1

Because of the potential bug that we hit (8738555) which is resolved with patchset 11.2.0.2, Oracle has been reviewing some parallel query trace files. Here is some example output of the trace files: *** 2011-10-09 19:44:55.218*** SESSION ID:(116.3167) 2011-10-09 19:44:55.218*** CLIENT ID:() 2011-10-09 19:44:55.218*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-09 19:44:55.218*** MODULE NAME:() 2011-10-09 19:44:55.218*** ACTION NAME:() 2011-10-09 […]

Continuous Physical Data Block Corruption Issues – post 2

So the issues are still persisting in the system.  We still have 3 corrupt data blocks (123456, 123457, 123458).  Only 1 data file is still affected (100).  Here are some of the latest steps that Oracle Support has requested from us: ##################################################Generic Note————————1- Please run the sundiag.sh on each of your exadata cells and upload […]

Oracle Exadata Database Machine – Part 1 high level general administration

Exadata – General Administration For general administration of Exadata you must be proficient with Oracle RAC and its general concepts. Since Exadata X2 series Hardware utilizes 11gR2 (11.2.0.2) I also recommend to read up on RAC. You can click here to access the 11gR2 documentation http://www.oracle.com/pls/db112/portal.portal_db?selected=16&frame=#oracle_real_application_clusters In this blog post I’ll be showing some basic […]

Oracle Exadata Database Machine (X2-2) my thoughts

My take with some external references regarding Exadata. It is fast. The idea of taking CPU intensive queries running on a multi TB database for hours and turning them into queries running in seconds to minutes. I have read the documentation, took a 2 day seminar training class, applied what I have learned a read […]