Search

Top 60 Oracle Blogs

Recent comments

October 2013

SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3)

I just learned something new yesterday when demoing large page use on Linux during my AOT seminar.
I had 512 x 2MB hugepages configured in Linux ( 1024 MB ). So I set the USE_LARGE_PAGES = TRUE (it actually is the default anyway in 11.2.0.2+). This allows the use of large pages (it doesn’t force, the ONLY option would force the use of hugepages, otherwise the instance wouldn’t start up). Anyway, the previous behavior with hugepages was, that if Oracle was not able to allocate the entire SGA from the hugepages area, it would silently allocate _the entire SGA _from small pages.

SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3)

I just learned something new yesterday when demoing large page use on Linux during my AOT seminar.

I had 512 x 2MB hugepages configured in Linux ( 1024 MB ). So I set the USE_LARGE_PAGES = TRUE (it actually is the default anyway in 11.2.0.2+). This allows the use of large pages (it doesn’t force, the ONLY option would force the use of hugepages, otherwise the instance wouldn’t start up). Anyway, the previous behavior with hugepages was, that if Oracle was not able to allocate the entire SGA from the hugepages area, it would silently allocate the entire SGA from small pages. It was all or nothing. But to my surprise, when I set my SGA_MAX_SIZE bigger than the amount of allocated hugepages in my testing, the instance started up and the hugepages got allocated too!

SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3)

I just learned something new yesterday when demoing large page use on Linux during my AOT seminar.
I had 512 x 2MB hugepages configured in Linux ( 1024 MB ). So I set the USE_LARGE_PAGES = TRUE (it actually is the default anyway in 11.2.0.2+). This allows the use of large pages (it doesn’t force, the ONLY option would force the use of hugepages, otherwise the instance wouldn’t start up). Anyway, the previous behavior with hugepages was, that if Oracle was not able to allocate the entire SGA from the hugepages area, it would silently allocate _the entire SGA _from small pages.

SGA bigger than than the amount of HugePages configured (Linux – 11.2.0.3)

I just learned something new yesterday when demoing large page use on Linux during my AOT seminar.
I had 512 x 2MB hugepages configured in Linux ( 1024 MB ). So I set the USE_LARGE_PAGES = TRUE (it actually is the default anyway in 11.2.0.2+). This allows the use of large pages (it doesn’t force, the ONLY option would force the use of hugepages, otherwise the instance wouldn’t start up). Anyway, the previous behavior with hugepages was, that if Oracle was not able to allocate the entire SGA from the hugepages area, it would silently allocate _the entire SGA _from small pages.

OTN Nordic Tour 2013 – Oslo

We got on the plane from Copenhagen to Oslo and met up with the OUGN folks for some food in the hotel. We spent a long time talking about non-Oracle stuff, like science and religion. It was fun.

The morning started with a long breakfast, which included me nearly throwing orange juice over Mike Dietrich and him succeeding in throwing tea over me. We both blamed the table, but in reality it was our secret desire for a food fight that caused it. :)

Ohio Oracle User Group last week

 

 


 

 

fast_carMH900424359a

Had a great time last week presenting to the Ohio Oracle User Group (OOUG). I’m generally use to presenting a single presentation but for this day at OOUG, I was the guest speaker and presented 4 back to back presentations.

OOUG members picked me up at the airport, whisked me to my hotel, then picked me up in the morning to take me to the conference venue, then arranged for my transport back to the airport. All in all super smoothly run.

WordPress 3.7

WordPress 3.7 has been released. The downloads are in the usual place.

I updated 5 blogs with not hassles.

It’s worth having a read of this, which mentions the automatic updates that could happen without your intervention… Sounds kind of scary to me. :)

Happy upgrading, possibly for the last time…

Cheers

Tim…

My Strata + Hadoop World Schedule

Next week is Strata + Hadoop World which is bound to be exciting for those who deal with big data on a daily basis.  I’ll be spending my time talking about Cloudera Impala at various places so I’m posting my schedule for those interesting in catching about fast SQL on Hadoop.  Hope to see you there!

Office Hour with Greg Rahn @ the Cloudera Booth
10/29/2013 11:00am – 11:30am EDT (30 minutes)
Room: 3rd Floor, Mercury Ballroom, Booth #403
http://www.cloudera.com/content/cloudera/en/new/strata-hadoop-world.html

Exadata: measuring IO latencies experienced by the cell server

Exadata is about doing IO. I think if there’s one thing people know about Exadata, that’s it. Exadata brings (part of the) processing potentially closer to the storage media, which will be rotating disks for most (Exadata) users, and optionally can be flash.

Hadoop Streaming, Hue, Oozie Workflows, and Hive

Elephant Painting

MapReduce with Hadoop Streaming in bash – Bonus!