Thanks everybody for attending my talk “Oracle Datenbank Architektur – nicht nur für Einsteiger” at DOAG Conference 2013. It was a great feeling to have a packed room there. As promised, here comes my presentation and whitepaper (both in German). OracleArchitektur-DOAG OracleArchitekturNichtNurFürEinsteiger_Klier Feedback is always appreciated! […]
Year: 2013
DOAG Presentation: Oracle Standard Edition RAC
Wednesday last week, I had a presentation for my regional Oracle Users Group (DOAG Regio Nürnberg). The month before I was asked to display the difference between Enterprise Edition and Standard Edition RACs. Here comes the presentation (German), for questions and suggestions just let me know. Stay highly available Martin Klier […]
Martin Klier now on twitter
After ignoring the little bird telling things for quite a while, I decided to join the tweeters. Twitter might bring more color into my daily reading. 🙂 If you feel like, just follow me – @MartinKlierDBA […]
How to move a datafile as Oracle Managed File (OMF) before and after
Sometimes, you just have to move your data files away from where they sit. But when you love Oracle Managed Files as I do, you may want to have it being an OMF afterwards as well as before. Doing it the way you would have done it with ASM, fails. (RMAN> copy datafile 10 to […]
Oracle 12c: Change hostname for Grid Infrastructure / Oracle restart
Few days ago, we cloned a VM test system with ASM. Changing the hostname in this case is mandatory from our network, we have lots of issues if they are duplicate. But changing an Oracle Restart or generally, Grid Infrastructure setup’s hostname isn’t so easy – it’s written many configs. The only way is to […]
Oracle 12c New Features – Look at’s for 12.1.0.1.0
A new product … Last week I spent some days of intense investigation and testing the new database 12c. I found lots of great stuff (even about 11g 🙂 ), and some for sure will make it into a separate blog post. So these are just my notes of a very interesting couple of days, […]
DOAG Konferenz 2013: “Oracle Architektur – nicht nur für Einsteiger”
After speaking about mutex waits last year, this time DOAG accepted my lecture “Oracle Architektur – nicht nur für Einsteiger” about Oracle Database basic architecture for this year’s DOAG Konferenz 2013 in Nürnberg. It will be the first lesson in a brand-new stream of the conference: The so-called “Einsteigerpaket” (beginners package) allows […]
How NLS settings can affect Oracle’s join behavior – v$ example
Recently, I had a problem with accessing Active Session History being not fast enough on Oracle Database 11.2 and 12.1. Looking at the explain plan, wow, no doubt why: Accessing two fixed tables with TABLE ACCESS FULL and joining them with NESTED LOOP. This couldn’t have been “works as designed”, it would render gv$active_session_history nearly […]
Oracle SQL: Optimizing a WHERE predicate inequality with a Function Based Index
Intro Recently, on Oracle 11.2.0.3, I saw a join of three tables, using three times TABLE ACCESS FULL and HASH JOIN, without an obvious reason. During separating and understanding its components, the following scenario turned out to be the culprit. select * from CARDTEST where OBJECT_ID<DATA_OBJECT_ID; The optimizer is unable to calculate the cardinality of […]
Oracle Database 12c Release 1 available
Since today, Oracle allows downloading the newest release of the Database product 12c via http://edelivery.oracle.com So far I only can see it for the Linux platform, and docs are still missing. But this may change rapidly. Take care Martin Klier […]