OTN LA tour 2015: El Salvador

If you trust all the travel warning, advisories (and extra Oracle approvals) that we received before going to El Salvador then you could think that just making it back out of the country alive was a huge success by itself. We were careful to not walk around alone outside too much but other than that always felt taken care of very well and very secure. The rather long drive from the airport allowed a brief glimpse into this beautiful place with endless green rain forests climbing up and down black volcanos under a clear blue sky. Heli and I went for a quick swim in the hotel pool and some local food before calling it an early night.

IMG_5261The event took place in a private club with a pool, they had four tracks with a mix of local and international speakers but no translators. I sat in Deiby’s session on undo management and how to avoid ORA-01555 errors. It was in spanish but was able to follow most of the talk anyway. Yay for my spanish. And yay for Deiby’s easy explanations. I delivered three talks myself that day and was very happy with how they went. Since there were no translators available and the audience was not 100% confident in english I made sure to explain things as simple and slow and with as little words as possible. Made me realize about how many things I usually say are just fillers around the core of the content. I also attended Alex session on Orion which I had previously omissed because I would rather use SLOB for IO benchmarks. But among other things I was reminded that orion has a very easy way of running a whole series of tests and plotting them is also easy as the output are easy csv files.

OTN LA Tour 2015: Guatemala

Guatemala was one of the shorter stops on the OTN Latin America tour. We arrived on midday on Sunday, spent all day Monday at the conference and left again on tuesday morning. In all of the cities we visited they closed the main streets on Sundays so that pedestrians and cyclists could enjoy the city without the risk of getting run over by cars. I used this opportunity for a run through the city and was rewarded with nice views and busy streets with people working out, walking their dogs or simply enjoying the street vendors for fruit, burritos and other local fare.
Deiby Gomez and others from the user group took us out to a local restaurant where we also met Dan and enjoyed very traditional local food. Heli and I both had a fish dish consisting of shrimp tamales, a whole fried fish and a gigantic fish soup with more shrimps, mussels, crab and snails. Yummy but way too much to finish.

otnlatour_guatemalaThe conference on the next day was huge. The user group had to cap the registration at 500 attendees because they already hit capacity which could be seen on packed rooms and felt even more at the very long lunch line. They even provided translators so that even people with only basic english skills could follow the presentations of the international speakers. I loved it and made sure not to speak too quickly. And judging by the relaxed smile of my translator I succeeded in doing so. Tons of pictures were taken after the closing session, a part I always enjoy. It is all fun as long as no selfie sticks are involved.

Organizers and speakers shared dinner at a driving range where we could show off our golf skills or rather the lack thereof. My arms still hurt a few days after the event but it was a lot of fun nonetheless. Deiby opened a celebratory bottle of local Zacapa rum (to which I would never say no) and thanked the volunteers and speakers for their efforts in helping this usergroup grow to this success so quickly.

OTN LA Tour 2015: Mexico City

After a very quick and efficient immigration to Mexico I was greeted by Arturo Viveros from the ORAMEX user group who provided much more than an efficient ride to the hotel through yet even more traffic but also a warm welcome and a nice chat. Heli and Bruno would not arrive until later that day but Anton Els was already there and I was more than happy to see him again for a perfect dinner of seafood tacos in the center of Mexico City.

pedro_otn_mexicoThe conference itself was at a technical university a good 42 minutes away from the city center. We quickly found the rooms that we were supposed to present in and made our way to the general registration, exhibition and keynote area. And again, I was surprised by the very long line and the huge number of attendees. In fact, the organizers had to close the registration ahead of time because they were already at capacity. Wow. We made it to the keynote hall just in time to see my good friend and president of the Mexican OUG address the audience before Pedro Ciccarello of OTN Latin America introduced the OTN community and the ACE program. The event was not just attended beyond what I could have imagined, it was also very well organized. There was a seperate quiet area for speakers, good catering and most of all lovely room ambassadors that coordinated the timings and were there for all of our needs. A job very well done! My sessions had a decent audience, I received a number of questions and was just answering some follow-up emails before writing this blog. The day finished with dinner and laughs in an old part of the town that was bustling with life around a central plaza.
Continue reading

OTN LA Tour 2015: San Jose, Costa Rica – pura vida!

As I am currently sitting on a plane flying over lush rainforests and impressive volcanoes between Guatemala and El Salvador I realize that this almost marks the halfway point of the nothern leg of this year’s OTN tour of Latin America and I yet have to write a review about it.

San Jose Costa RicaAfter a long layover in Newark between two even longer flight legs I arrived in San Jose, Costa Rica, two days before the conference there. A small angel and diablo inside my head were fighting out wether I should follow Edward to the rain forest of the Arenal volcano or if I should just take it easy, adjust to the location and time zone and put some work in. A decision I am still regretting as I would have loved to get out of the capital city to experience the great gifts of nature that Costa Rica has to offer. The time flew by and I was excited to reconnect with my old friends Edward (and his lovely fiance Dawn) and Alex at the conference hotel the night before the event. I also met Bruno Borges from Brazil and we all shared guaro drinks, stories and a traditional tico meal. Pura Vida!
Continue reading

damn those defaults!

Most defaults are awesome and one of my consulting mantras is to stick with defaults as much as possible and find and verify good reasons when you want to deviate. The oracle database is pretty amazing out of the box and does most things right. This post however is about two defaults that I find to be very dangerous. Why? Because a DBA might just click through a wizard and select an option that has a lot of negative consequences and cannot be easily fixed. Continue reading

a case study of pagination, first_rows and hibernate

I want to share a bit of what I had been working on this week. During a quick check of one of our databases I came across a SQL in EM12c’s top activity section that drew my attention. And upon closer inspection I found more than this one that looked alike and were also pretty high up on the top SQL list. All of them did these pagination type queries from a java application using hibernate as an OR mapper to generate their SQL. Continue reading

12c shows patch information in alert log

I just noticed that on a pretty recent database installation (12.1.0.2) it shows information on applied patches in the alert log during instance startup. Usually one had to run opatch to get this kind of information and I think it is neat to have this in the alert log aswell now.

===========================================================
Dumping current patch information
===========================================================
Patch Id: 19769480
Patch Description: Database Patch Set Update : 12.1.0.2.2 (19769480)
Patch Apply Time: 2015-05-14 10:15:32 GMT+02:00
Bugs Fixed: 14643995,16359751,16870214,17835294,18250893,18288842,18354830,
18436647,18456643,18610915,18618122,18674024,18674047,18791688,18845653,
18849537,18885870,18921743,18948177,18952989,18964939,18964978,18967382,
18988834,18990693,19001359,19001390,19016730,19018206,19022470,19024808,
19028800,19044962,19048007,19050649,19052488,19054077,19058490,19065556,
19067244,19068610,19068970,19074147,19075256,19076343,19077215,19124589,
19134173,19143550,19149990,19154375,19155797,19157754,19174430,19174521,
19174942,19176223,19176326,19178851,19180770,19185876,19189317,19189525,
19195895,19197175,19248799,19279273,19280225,19289642,19303936,19304354,
19309466,19329654,19371175,19382851,19390567,19409212,19430401,19434529,
19439759,19440586,19468347,19501299,19518079,19520602,19532017,19561643,
19577410,19597439,19676905,19706965,19708632,19723336,19769480,20074391,
20284155

Patch Id: 20299023
Patch Description: Database Patch Set Update : 12.1.0.2.3 (20299023)
Patch Apply Time: 2015-05-14 10:15:40 GMT+02:00
Bugs Fixed: 16619249,17274537,18202441,18306996,18417036,18607546,18681056,
18856999,18909599,18940497,19012119,19018447,19023822,19035573,19065677,
19081128,19183343,19238590,19272708,19291380,19315691,19335438,19358317,
19385656,19393542,19487147,19512341,19524384,19536415,19547370,19597583,
19606174,19619732,19627012,19637186,19644859,19649152,19658708,19670108,
19684504,19687159,19730508,19791377,19805359,19841800,19865345,19873610,
19896336,19915271,19928926,19978542,20235511,20347562,20348653,20425790,
20440930

Patch Id: 20415564
Patch Description: Database PSU 12.1.0.2.3, Oracle JavaVM Component (Apr2015)
Patch Apply Time: 2015-05-14 10:17:58 GMT+02:00
Bugs Fixed: 19153980,19223010,19231857,19245191,19699946,19855285,19877336,
19895326,19895362,19909862,20408829,20408866,20415564
===========================================================

I do not know when this started but I have not seen this in 12.1.0.1 installations.

OTN EMEA tour 2015

I am thrilled to be able to go on another OTN tour this year. As a successor to the 2014 MENA tour to Tunisia, Saudi Arabia and Dubai we are organizing a true EMEA tour that visits all three continents of the region. Together with my fellow ACE Directors Heli, Debra and Tariq we will visit Lisbon, Amman and Johannesburg in a week filled with presentations, networking and a lot of travel. You can read more about the tour at otnemea.com.

Unfortunately, the tour will “only” be three stops this year but we are already talking to more local sponsors about adding more new locations to the next tour. And if you are interested in hosting an event as part of an EMEA OTN tour in your country, please let me know.

find database upgrade dates in AWR

Just a really tiny quick tip. Today I was wondering when exactly we performed upgrades on a particular database. Luckily, there is a view in AWR for that.

SQL> select version, min(startup_time) from dba_hist_database_instance group by version order by 1 desc;

VERSION           MIN(STARTUP_TIME)
----------------- --------------------------
11.2.0.4.0        09-APR-14 07.40.14.000 AM
11.2.0.3.0        16-JAN-13 04.08.53.000 PM
11.2.0.2.0        09-MAY-11 03.35.26.000 PM
10.2.0.4.0        22-JAN-10 01.39.35.000 PM

debugging puppet and facter with strace

I worked on a slightly annoying problem yesterday and thought I’d share the process with you. On one of our linux boxes puppet stopped working with an error that was not very helpful:

[root@portrix]# puppet agent --test
Info: Retrieving pluginfacts
Info: Retrieving plugin
Info: Loading facts
Error: Could not retrieve local facts: private method `split' called for nil:NilClass
Error: Failed to apply catalog: Could not retrieve local facts: private method `split' called for nil:NilClass

All this told me was that something was wrong with facter during the puppet run. I was able to reproduce the error with just facter but even the debug output was not much more helpful:
Continue reading

DOAG 2014 review

I had merely 10 hours at home between the end of the 2014 OTN APAC tour and my travel to Nuremberg for this year’s DOAG conference which I picked over the last two OTNAPAC stops in Bangkok and Auckland even though I am sure the weather there would have been much better than what Nuremberg had to offer.

the pragmas at DOAG2014But the DOAG conference is always worth a visit and has constantly been improving over the last few years. It has seen a huge increase in foreign speakers that elavated the level of the content to one of the best conferences worldwide. And it also seems to me that my fellow germans have warmed up much more to the general idea of networking and easy chatting.

Unfortunately most of my conference experience this year was dedicated to “slide polishing” in a quiet corner. They accepted two brand new talks and both slidedecks were in need of some extra last-minute work. In my first presentation I gave an introduction to puppet config management for Linux and Solaris and a bit of a taste of how to enable devops for Oracle databases and managing resources within DBs with a puppet module developed by Bert Hajee. The talk went very well and I was surprised by the rather large audience for a systems topic. Yay!
Continue reading