Why Oracle 23ai from Exadata? With Oracle Database 23ai being postponed to a later date (“tba”) in November 2024, and many people not being part of the Oracle Beta Program, it might be useful to install a regular database 23ai (not the Developer Free Edition), but of course for testing purposes only! This has to […]
Tag: Oracle
Database 19c Certified for Oracle Linux 9 – Preinstall Package Available
Oracle Database 19c is certified for Oracle Linux 9 now (minimum requirement RU19.19). The Oracle Database preinstall package in its initial version is also available on the public Oracle yum server, in the AppStream Repo. https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm […]
Create Oracle Data Guard Standby with DBCA
Demands of Automation You can easily create an Oracle Data Guard Standby Database with the Database Configuration Assistant DBCA. That’s especially interesting if you have automation at work, and are not keen on configuring stuff all over the place. This is available in version 19c upwards. DBCA uses RMAN DUPLICATE FOR STANDBY with an auxiliary […]
DOAG Konferenz 2021 Slides for Download
Thank you all for attending, commenting and discussing my presentations at DOAG Konferenz 2021. I am happy about the good feedback, and the attendance in the rooms. Meeting some of you in DOAG’s GatherTown was a good thing, to mimic the real conference center in Nuremberg. But still a mimic! I’m looking forward to DOAG […]
Very cool interview with Maria Colgan
Community work can be so much fun. When working for the German Oracle User Group, DOAG, one of my favourite jobs is interviewing interesting people for doag.tv. In fall 2019, we recorded a fun interview with Maria Colgan, Master Product Manager for the Oracle Database. I had the chance to prepare the story: Based on […]
Oracle PGA Analysis Query
Sometimes, something in an Oracle Database starts eating PGA, and there is need to find out which process, and where the memory is left, and what or who is responsible for allocating / using / holding it. For a recent issue, I wrote the SQL below. It gives back one line for each Category (SQL, […]
Oracle ACE Director
Uh, there has been no blog entry for some time, had a busy time. So now I have a good reason to blog after returning from Collaborate18 in Las Vegas, where I had the chance to present two talks about SQL Tuning and Oracle Performance on VMware. The Oracle ACE Program usually hosts a dinner […]
Oracle RAC 12.2 High Load on CPU from gdb when Node Missing
Recently I had to battle a new issue with the quite-new Oracle Database RAC Version 12.2.0.1 on Linux x86_64. The idea of RAC is, to compensate the loss of a node or service by restarting services on other nodes. But in my case, when one node in a two-node-Cluster was down (or the crs stack […]
Oracle Enterprise Linux 7: How to stop bash tab completion from escaping the dollar $
Did you ever wonder why bash in Oracle Linux, Red Hat Enterprise Linux and other recent Linuxes escapes the dollar sign ($) when completing paths with the tabulator (tab) key like that: [oracle@oratest01 ~]$ (KLM12102) ls -l \$ORACLE_BASE/diag Answer In bash >= 4.2.29 you have a “direxpand” option, which is NOT set by default. The […]
Oracle: How to identify SQL doing TABLE ACCESS FULL on a given partition
In my last post, I described a quick show case for Oracle 12c Automatic Big Table Caching. But ABTC is just a crock, nevertheless a useful one. The biggest help from Automatic Big Table Caching for “sustainable” database performance management is the temperature of segments, heated up by TABLE ACCESS FULL. In my case, after enabling ABTC […]
Looking forward to speaking at COLLABORATE16 IOUG Forum
Yes, I did it again, submitted and got two papers accepted – speaking at COLLABORATE16 in Las Vegas (#C16LV) is always a highlight of the year! This time, it will be: The Bad One In Your Crop – SQL Tuning Analysis For DBAs 4:30 PM–5:30 PM Apr 11, 2016, Palm-A Oracle Core: 12c InMemory Column […]
Featured by Oracle Magazine
The Oracle Magazine featured me in its January / February 2016 issue. I really feel honoured and would like to say thank you for the opportunity! For details, please see the Performing Databases Blog post about the publication. […]
How to disable Oracle ACFS drivers / registry resource
Sometimes an installed ACFS can cause trouble, especially if we don’t or can’t use it (e.g. when not using an UEK Linux kernel, like with SuSE Linux Enterprise Server SLES). There’s lots of documentation how to create and maintain ACFS file systems, but how to get rid of ACFS at all wasn’t so easy to […]
Oracle 11g and 12c Cardinality Feedback Leads to Hundreds of Child Cursors
Sometimes, advanced features can bring advanced problems. Seeing a project with hundreds of child cursors with a different execution plan each, is never a pleasure, but there has to be a reason. In fact, we are talking about the “USE_FEEDBACK_STATS” reason in v$sql_shared_cursor. Its meaning is: “A hard parse is forced so that the optimizer can reoptimize […]
Oracle Database 11.2 Extended Support Waived
As announced today, Oracle waived the Extended Support for the period of February 2015 until May 2017. See the paper with details here. […]
Oracle 12c in practice – customer report in Cologne #12cjetzt
From Beta to Production – Oracle 12c at TGW In October, I’ll speak at the Oracle #12jetzt (#12cnow) symposium in Köln (Cologne) about the introduction of 12c as standard palttform at our ISV customer TGW Software Services. I had the privilege to continuously working on the 12c product evaluation and introduction from availability of 12c beta2 […]
Oracle dbms_workload_repository awr_global_report_text fails with ORA-06553 PLS-307
My last post was about generating AWR reports from SQL – not a very complicated case. “But” – little word, big meaning. And suddenly we get a strange error message. In my example, I was especially interested in a Real Application Cluster’s “global” report. The subprogram call for that purpose is dbms_workload_repository.awr_global_report_text(), accepting the DBID, begin […]
How to create an Oracle AWR report with SQL and PL/SQL
AWR is a great tool (but needs diagnostics pack). It can create very useful reports for performace analysis over a given period. Most people will pull the AWR Report from the OS level, with ‘@?/rdbms/admin/awrrpt.sql” (or one of the other scripts there). But sometime it’s not possible to access a database server’s OS level, or […]
Oracle 12c RMAN delete obsolete behaves interactively in DBMS_SCHEDULER job type BACKUP_SCRIPT
Situation In Oracle Database 12c, we have the long-missed feature of DBMS_SCHEDULER job type “BACKUP_SCRIPT”, that allows us to create backup jobs without creating them as an OS file, and without need for a wrapper script that’s called by a job type EXECUTABLE (as we usually did that in the last years). Sometimes we also […]
DOAG BI Conference: Oracle Core (for Beginners): In-Memory Column Store
On Thursday, April 23rd I’m speaking at DOAG BI 2015, the leading Oracle Business Intelligence Conference in Germany. (#DOAGBI15) My contribution is: “Oracle Core für Einsteiger: In-Memory Columns Store”. The lecture will show, how the Oracle Database In-Memory option works “under the hood”, and how it is used to the best effect. Please find the presentation […]
Martin Klier Oracle ACE
I feel VERY proud, honoured and grateful, that Oracle awarded me with the Oracle ACE in December 2014. The Oracle ACE program is a community reward, and encourages us to participate, enrich, promote and organise Oracle community events. When speaking about the community, first of all I’d like to highlight my Oracle User Group of Germany, […]
Speaker at DOAG 2015 Datenbank – “Oracle Core für Einsteiger: InMemory Column Store”
The DOAG 2015 Database conference is on the horizon: June 16, 2015 in Düsseldorf, Germany. I’m proud to announce my participation as a speaker, as I was honoured with in the years before. This year, my part will be a new “Beginners” talk in German: “Oracle Core für Einsteiger: InMemory Column Store” Abstract: ==================== Der Vortrag richtet […]
DOAG Noon2Noon Event Nürnberg / MySQL vs. Oracle – Review
It was time to try something new in our DOAG Database Community. And please, please just not another frontal conference: twenty guys look forward, one looks back, like eight-oars-and-coxswain. I don’t know if DOAG invented it, but it was a success: The Noon2Noon Event. How does it work? It’s like 24 hours of BarCamp, starting with […]
Oracle: Did my SQL get worse over time? (AWR query)
Sometimes, we get statements to look at, and are told “it’s getting worse and worse”. Since DBAs are well advised not to take anything for granted and only to believe what they see with own eyes, here comes a SQL on AWR to see Buffer Gets per Minute, over time. select s.BEGIN_INTERVAL_TIME, round(t.BUFFER_GETS_DELTA/ 0.0001+ (extract […]
Martin Klier in DOAG.tv Interview: Oracle Standard Edition
A while ago, DOAG.tv interviewed me about Oracle’s Standard Edition and database system migrations. The material was published just recently, so I’d like to share it. Enjoy, and if there are questions, just let me know! http://www.doag.org/home/aktuelle-news/article/oracle-database-standard-edition-versus-enterprise-edition.html I have to add a corrigenda: SE RAC is not – at least not at the moment – limited […]
DOAG 2014 Presentation and Whitepaper online: Database I/O
Hi, my #DOAG2014 presentation and whitepaper are online now! “Oracle Core für Einsteiger: Datenbank I/O” Presentation: http://www.performing-databases.com/uploads/media/OracleCoreDatabaseIO-Klier-2014.pdf Whitepaper: http://www.performing-databases.com/uploads/media/Klier-Database-IO.pdf Thank you all for attending! Regards Martin Klier […]
Oracle 12c InMemory – don’t stop thinking about performance
Oracle has released its new database version 12.1.0.2 that includes the famous in-memory column store. InMemory option promises a big advantage for OLAP-like work loads by keeping table contents in a columnar in-memory structure. InMemory is not new, they did that for decades, but the interesting part is “columnar”. There’s much writing about that on […]
Oracle 12.1.0.2 with In Memory Option available for Linux
As of today, the Oracle Database 12.1.0.2 with InMemory Columnar Store is available at https://edelivery.oracle.com. According to the price list of July 10th, it will be sold as an option for Enterprise Edition (Exadata NOT mandatory), for US$ 23,000 per CPU (calculation like EE). Hope it will do well, beta demos were extremely impressive. Yours […]
Oracle 11.2 PSU2 Grid Infrastructure stack start … failed to complete at crsconfig_lib.pm line 11814
Oh, sometimes it’s just (own or close-people’s) PEBKAC that costs you time and gray hair… Patching 11.2.0.4.x to PSU2 on Linux was such an issue. Problem “opatch auto” with all comfort worked well, applied the patch, but re-starting the clusterware failed with: Starting CRS… Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been […]
Oracle on Linux: How to hide your password when using a wrapper script
Sometimes, a DBA has to write an externally called wrapper script for various Oracle-supplied commands accepting password inputs. A prominent and simple example is SQL*plus (sqlplus). The Problem The process list shows all parameters of a command that’s currently executed. wrapper1.sh Accepts all connection infos on the command line: #!/bin/bash cmdstring=”sqlplus ${1}/${2}@${3}” echo “Executed command: […]
DOAG Würzburg: “Resolving child cursor issues resulting in mutex waits”
I feel honored that DOAG asked me once more for being a speaker at an event – this time it’s DOAG Regionalgruppe Würzburg. I will give my (updated) C12LV and Oracle Open World 2012 talk “Resolving child cursor issues resulting in mutex waits” there, supported by my new business Performing Databases GmbH. My abstract: In […]
Klug GmbH integrierte Systeme wins Oracle Excellence Award Germany 2013 category “ISV”
I’m proud to announce that my employer, Klug GmbH integrierte Systeme, Teunz (Germany), won the Oracle Excellence Award Germany 2013 in the category of Independent Software Vendors (ISVs). […]
Oracle Clusterware root.sh issue: USM driver install actions failed (oracleoks.ko)
As I already said in my last post about “Can’t install ohasd service“, setting up Oracle Clusterware 11.2.0.4 on SuSE Linux Enterprise Server (SLES) SP2 should work flawlessly, but sometimes it does not. 🙂 This time, it was about the USM drivers. USM driver install actions failed /u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/install /u01/app/grid/11.2.0/crs/install/rootcrs.pl execution failed USM drivers […]
Speaking at COLLABORATE 14: “YOUR machine and MY database – a performing relationship!?”
I’m excited to announce that IOUG accepted my talk “YOUR machine and MY database – a performing relationship!?” for COLLABORATE 14 in Las Vegas. I’d love to see you there – for tech talk, gossip and meeting old and new friends! Abstract: Databases affect machines, machines affect databases. Optimizing one is pointless without knowing the […]
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 […]
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 Support allows SR details in notification emails
Yes, they did it! Finally, last night’s announcement from Oracle Support brought a long-missed feature: We can opt-in to get Service Request details in MOS’ notification emails. It’s of great benefit when you are on the road, no need to log in to the far-famed support portal. This is how the CUA has to allow […]
Oracle SQL Developer connection storm at startup
Oracle SQL Developer (tested with version 3.2.20.09) does some unwanted network connection testing against all configured connections (by TNSPING). We noticed that it causes a kind of unwanted “inverse” connection storm to all configured databases, when we start the SQL Developer. It’s not restoring aborted connections or stuff like that, all was quit before stopping […]
DOAG Webinar: ORACLE Datenbank Architektur – nicht nur für Einsteiger (German Language)
On Friday, 08/03/2013, I’ll present an online lecture about Oracle Architecture for the DOAG (Deutsche Oracle Anwendergruppe, German Oracle User’s Group) and the DOAG SIG Database. Link: http://www.doag.org/termine/termine.php?tid=454245 The lesson will contain (excerpt from TOC): Oracle Datenbank-Architektur Verbindung, Namespace(s) und Abschottung Instanz und Datenbank Alles Blöcke, oder was? Redo, Undo und was man […]
R.I.P. Oracle Database 10g: “Oracle depends on humidity”
Or: “Why we should be happy about Adaptive Cursor Sharing” Premier Support for 10g R2 ended in July 2010, and Extended Support will end in July 2013, 11gR2 is widely used, and 12c is on the horizon. Maybe it’s time for writing a kind of obituary for my first Oracle love, and to spread a […]
Oracle: RHEL6 and Oracle Enterprise Linux 6 certified for Database 11.2.0.3
Hi Linux-DBAs, Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 are now certified for Oracle Database 11.2.0.3. Please see this link: https://support.oracle.com/CSP/main/article?cmd=show&id=1441282.1&type=NOT Best regards Martin […]
IOUG 2012 presentation: RESOLVING CHILD CURSOR ISSUES RESULTING IN MUTEX WAITS
Hi folks, thanks for attending my lesson! Here comes the paper and presentation. If there are further questions, feel free to contact me – email and stuff is in the documents. 2012_893_Whitepaper (pdf) 2012_893_Presentation (pdf) Regards Martin […]
Upgrading Oracle Clusterware: [INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system
Upgrading Oracle Grid Infrastructure 11.2 (it’s just another marketing name for the Oracle Clusterware, formerly known as Cluster Ready Services CRS) usually is easy: The runInstaller offers an upgrade mode, and discovers nodes and versions without further effort. But what, if not? The message will be “[INS-40406] The installer detects no existing Oracle Grid Infrastructure […]
DOAG Conference 2011 – Impressions and Look-at’s
Once again this year, the German Oracle Users Group has its annual conference and exhibition in Nuremberg. (DOAG Konferenz und Ausstellung 2011, Nürnberg). Being there is nearly a must for Oracle guys in German speaking countries. As usual, here comes my unordered, incomplete and ad-hoc list of things I wrote down to have a closer […]
Oracle Clusterware 11.2: ASM crashes at startup
These days, a customer’s Oracle Clusterware (2 nodes) crashed one ASM instance at every startup. More Facts: It was not possible to start it manually, too. The CSSD was running. For obvious reasons, CRSD did not start. The other ASM instance in the cluster recognized CLUSTER RECONFIGURATION for a short period of time. The ASM […]
Oracle Grid Infrastructure: How to recover from a messed up ASM/CSSD diskstring
Oracle Grid Infrastructure 11.2 with voting files and OCR in an ASM diskgroup can be a little tricky if you mess up the voting file voodoo. You know the basic situation? With Oracle Grid Infrastructure aka Oracle Clusterware, we are storing your cluster quorum and config repository (OCR) into a disk group. But CSSD needs […]
DOAG Konferenz 2010 – Look at’s
For the last three days, I have been in Nuremberg, attending the DOAG Konferenz 2010 (annual conference of the german Oracle user group). This year, my list of “Look at’s” is way shorter than last years list was. It’s not the fault of the event, I just did not write down that many facts. My […]
Oracle Database patch set 11.2.0.2 is out
For all who may concern 😉 Oracle 11.2.0.2 is out for Linux x86 and Linux x86_64 It’s patch set 10098816! Packaging: Starting with the first patch set for Oracle Database 11g Release 2 (11.2.0.2), Oracle Database patch sets are full installations of the Oracle Database software. In past releases, Oracle Database patch sets consisted of […]
Oracle ASM quote of the week
Please, do yourself a favour and NEVER EVER use ASM on Windows! “Dear Sir, obviously I forgot to put a file system on drives E:, F: and G: of the DB machine. I did this now, and hope you excuse the delay. Best regards John Doe Windows Server Administrator” /* no comment */ Martin […]
Oracle 11g trace particular SQL_ID
As a follow-up of my last post, I learned that creating traces is much simpler in 11g than I expected it to be. Dion Cho and Tanel Poder pointed me to some interesting links http://oraclue.com/2009/03/24/oracle-event-sql_trace-in-11g/ http://tech.e2sn.com/oracle/troubleshooting/oradebug-doc describing how to set up a trace event on one SQL_ID without need to do it on session level […]