The OMS Patcher is a newer patching mechanism for the OMS specifically, (I know, the name kind of gave it away…) Although there are a number of similarities to Oracle’s infamous OPatch, I’ve been spending a lot of time on OTN’s support forums and via email, assisting folks as they apply the first system patch to 18.104.22.168.0. Admit it, we know how much you (more...)
The second edition of Cary Millsap‘s MASTERING ORACLE TRACE DATA (MOTD) is finally available. You can order it through amazon.com. I had the pleasure not only to review MOTD while Cary was working on it, but also to write a foreword that summarizes what I think about the book. So, if you are asking yourself whether you should buy MOTD, here is my opinion/foreword…
In late 1999, through an Oracle Support note, I (more...)
This post is all about how you can back up Oracle in Azure, well 'all about' is an exaggeration - this is what i have set up for our current Oracle backups in Azure. There is of course more than one way to do this - the solution below works for us but may not work for you.
Feedback on this would be great but please make it constructive ("this is shit" is not constructive (more...)
Searching google for answers is something we all do with every question or request for information we have. I sometimes wonder how much of this data is simply wrong. This can be because people write stuff they don’t know about, people are sharing false information (that was published by others by accident or on purpose), […]
Monitoring templates are an essential feature to a basic Enterprise Manager environment, ensuring consistent monitoring across groups and target types. There’s an incredibly vast group of experts in the EM community and to demonstrate this, Brian Williams from Blue Medora, a valuable partner of Oracle’s in the Enterprise Manager space, is going to provide a guest blog post on how simple and efficiently you can monitor even (more...)
The OTN database forum supplied a little puzzle a few days ago – starting with the old, old, question: “Why is the plan with the higher cost taking less time to run?”
The standard (usually correct) answer to this question is that the optimizer doesn’t know all it needs to know to predict what’s going to happen, and even if it had perfect information about your data the model used isn’t perfect anyway. This (more...)
Yathra simply means travel or journey. OTNYathra did cover many miles! OTNYathra is my first conference tour, organized by Oracle Technology Network. First and foremost, I would like to thank AIOUG and OTN for having me as a speaker, Oracle ACE Program for taking care of my travel and accommodation, and OneNeck IT Solutions for […]
So Uwe Hesse caught my interest when he blogged about how to add your twitter handle to your time on your taskbar. This is really cool for those of us that present, so that while we demo, you’ll see our twitter handle displayed at all times.
I did notice that his instructions, as most instructions I find for things on the Oracle side are for older versions of (more...)
As I sit here working on performing some GoldenGate migrations to AWS for a client, I’ve been thinking about the glimpse of GoldenGate Cloud Service (GGCS) that was provided to me earlier this week. That glimpse has helped me define what and how GGCS is going to work within the Oracle Cloud space. Ever since this service was announced back at Oracle Open World 2015, I’ve been wanting to get my hands on this cloud (more...)
This is a heads up for some upcoming events I will be appearing on in the next few weeks. I was also accepted (as a standby session) to UKOUG Scotland (which I was at, last year) but unfortunately I will not be able to attend as it collides with some of my other speaking events.
ILOUG Technology Days 2016
On May 30 and 31, in Rishon Le’zion (Israel) I will be giving two sessions on (more...)
“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in April 2016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… TidBit #oratidbit ORACLE_OCM is a […]
I’ve been working with a customer to setup a RMAN backup on his standby database (backup is going to SBT). After a while, we decided that we couldn’t avoid using the RMAN catalog so we created one.
Now, when using the catalog, we can backup the database from either the primary or standby instances and that will register to a shared catalog so we could restore from (more...)
A SQLT report has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions. However, sometimes a SQLT report is not enough to solve a SQL performance problem.(read more)
TROUG Days İstanbul was held last week (April 28th to 29th) at İstanbul Technical University Technopark. I think we used social media, specially twitter very effective, so I wanted to publish some twitter statistics about the event like I did for OUGN Spring Event. The statistics cover the period between April 27 and April 30.
Before sharing the twitter statistics, I would like to write a few words about the event. I feel very proud (more...)
If you speak often at conferences, sharing your screen to demo things, this could be helpful:
Throughout your presentation, the audience will be able to see your Twitter Handle, reminding them to include it with tweets about the event. I used to include it in the slides, but this is better, because it works also with live demonstrations where no slides are being showed. Which is incidentally my favorite way to do presentations