I read Debra’s post this morning and the fact she had to write it was pretty disappointing. I realise there will always be haters out there who find fault with what people in the community do, but even so…
The instance that I’ve built for my students in a Fedora VM is quite stable except for one feature. The feature is the hibernation process of the base operating system. Sometimes when the base operating system hibernates, it causes the Oracle shared memory segment to fail. When that happens you get the following error:
ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory Process (more...)
Although I normally use the job or scheduler facility to run database-centric style processes, most commonly PL/SQL programs, there is nothing to stop you from using the scheduler to gain control over tasks that might normally need to be done outside of the database. And of course, in the world of virtualization, cloud and other such innovations, the ability to initiate and perform tasks from within the database becomes increasingly useful, since often access (more...)
The reason for running the test again was the fact that I was informed during (more...)
I recently posted about not going on the APAC OTN Tour. My motivation for doing so was to explain just once, why not, hopefully to crush the rumours and debate as to why.
Actually for my UK friends, it was a bit like Will Young leaving Strictly Come Dancing, if you don't say why, people simply make up their own mind.
Anyway, I posted the blog and received great messages of support both publicly (more...)
Enterprise Manager Cloud Control provides a centralized job scheduling system and it’s possible to control it through both web interface and EMCLI. On the other hand, it seems web interface provides more control over the past jobs, for example it’s not possible to delete a job run with EMCLI, while it’s possible to do it on web interface:
EMCLI verb “get_jobs” reports all runs of the jobs, and “delete job” can delete job and its (more...)
I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. I’m writing a Getting Started series to help folks get interested in the product and maybe even teach a few old dogs (including myself) some new tricks. In my last post, I shared the history of ODI and a bit about what sets it apart from other ETL tools on the market. In this article, I’ll walk through different components of (more...)
If you are going to create custom method in VO/AM and expose it through interface to be called in bindings layer - there will be similar error as below on runtime:
Source of this (more...)
We all know that adding a new index may change the execution plans of existing queries – sometimes improving the performance, other times causing a performance degradation (and sometimes not making any difference).
But is it true even if the new index is not used by the new execution plan? And even if the new index is invisible?
I’ve recently discovered that the answer is yes for a specific scenario that involves a descending and (more...)
In a little over a week I’ll be starting the OTN Asia Pacific (APAC) Tour 2016, or to be more accurate I’ll be starting the first half of it.
I’ll be attending the following events.
- Wellington, New Zealand: October 26th (Event)
- Auckland, New Zealand: October 27th (Event)
- Sydney, Australia: October 31st (Event)
- Gold Coast, Australia: November 2nd (Event)
The tour carries on without me (I had (more...)
I’ve used Python to make graphs of Oracle database performance information. I put the scripts out on GitHub at https://github.com/bobbydurrett/PythonDBAGraphs. As a result I’m keeping my Python skills a little fresher and learning about git for version control and GitHub as a forum for sharing Open Source. Really, these Python scripts were an experiment. I don’t claim that I have done any great programming or that I will.
But, as I review what I have done (more...)
Just letting people in DFW area know that I’m speaking at the DOUG Performance & Tuning and 12.2 New Features Technical Day!
- Thursday 20 October 2016 9:30am-5:30pm
- Courtyard & TownePlace Suites DFW Airport North/Grapevine, TX
2200 Bass Pro Court|Grapevine, TX 76051
Speakers (Seven Oracle ACE Directors!):
- I’ll speak about In-Memory Processing for Databases where I plan (more...)
Last week I enjoyed being at the first international conference that the resurrected Polish Oracle user group has put on. I say enjoyed – I actually mean really enjoyed! Why did I like the conference so much? Three major components came together.
(Before anyone rushes to mention the Polish custom of entertaining you with alcohol, (more...)
In the article you will have a look at the new Oracle 12c feature called in database row archiving available since Oracle 12c. In Oracle versions prior to 12c all table data was an active visible set of data, that is subject to DML performed by the application. In Oracle 12c the In database row archiving feature enable us to have two sets of table data an active visible set of data that coexists (more...)
During investigating I ran once again into statistics in the Oracle database that still provide a useful details, but the actual naming of the statistic is describing a situation that in reality does not exist anymore. The statistics I am talking about are ‘calls to kcmgcs’, ‘calls to kcmgrs’, ‘calls to kcmgas’ and ‘calls to get snapshot scn: kcmgss’.
Disclaimer: this is research. Any of these techniques potentially can crash your instance or leave your (more...)
Last January, in the following tweet, I pointed out that the documentation vaguely mentions that a trace file may be split into several files.
— Christian Antognini (@ChrisAntognini) January 20, 2016
As a follow-up, few days later Jonathan Lewis published a post entitled Trace file size.
Until recently, I didn’t bother to investigate how that feature works. But, (more...)
This year’s Oracle Open World was an exciting experience for AuraPlayer, with many flocking to our booth for live demos and attending Mia’s sessions with clients like Rogers Group Inc. We were sad that many were unable to attend the conference, so we are bringing Oracle Open World to you in our October webinar series!
In the first installment of this series, “Digital Transformation: From Legacy to Enterprise Mobility,” we will demonstrate step-by-step how best (more...)
My tour started on Monday afternoon when I left my house around 1.30PM to get on the bus to the train station. The 2PM train left exactly on time for the Amsterdam airport. I arrived at Schiphol around 3:30PM, perfectly on time to catch the 5PM flight to Copenhagen.
The flight to Copenhagen was very uneventful. From the airport I took the train (more...)