How to run a sosreport

Working with Oracle Support as much as I have you get asked to run a variety of commands to collect diagnostic data. I will have a series of posts describing the different tools used to collect data across a number of different platforms. Today we will start with SOSREPORT. sosreport – this tool captures important […]

Resize Exadata /u01 Filesystem

For those of you whom have never performed this type of activity, please reference the Oracle Support document 1357457.1. 1) Grab the current sizing of /u01 filesystem [root@DM01DB01 ~]# df -h |grep -i u01 Filesystem Size Used Avail Use% Mounted on /dev/mapper/VGExaDb-LVDbOra1 99G 16G 78G 17% /u01 2) Stop your oracle databases, oracle crs, monitoring […]

Hugepages on Exadata? Yes and No… part3

Finally after over 6 weeks got a response back regarding hugepages on Exadata. Yes, hugepages is supported on Exadata platforms, with no changes from a standard linux platform. ie.. while it’s supported, there is nothing specific to exadata in it’s setup. There it has been stated by MOS that it will be supported. I really […]

Oracle Extreme Performance Tour – Exadata and Exalytics

Yesterday I attended the Oracle Extreme Performance Tour. I have spoken with a couple of local Oracle Reps who are allowing me to use PDF versions of their presentations. I found the topics regarding Exadata and Exalytics to be very useful. The first viewable/downloadable PDF is entitled “Evolving Towards Enterprise Big Data Warehouse”. For more […]

Attending the Oracle Extreme Performance Tour

Currently at the Embasssy Suites Cleveland Banquet room attending the Oracle Extreme Performance Tour Seminar. I should have posted about this sooner for people who are within driving distance. http://www.oracle.com/us/dm/h2fy11/40947-nafm10128216mpp253-oem-1483903.html Here are some details from the link above: ****** Below is copyright 2012 per Oracle Corporation ****** A unique opportunity to discover the future of […]

Hugepages on Exadata? Yes and No… part2

So I got my update from Oracle Support… Michael, please review the following 2 documents, and let me know if more information is needed: Doc ID 361468.1 – HugePages on Oracle Linux 64-bit Doc ID 1284261.1 – Enabled Hugepages In Exadata V2 Database Machines are not used at startup I had mentioned to the engineer […]

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 […]

Oracle DBA Interview Questions

Before I started some job searching….around 10 months ago I compiled a list of interview questions for preparation.  Yes I am a seasoned DBA, but not having gone through an interview in 5 years I decided I needed a refresher.  Some questions I came up with, others I found on Google.  I can honestly say […]

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 […]