I was playing with in-memory feature of Oracle 12c, and wondered when a table is loaded/populated into in-memory buffer (of course I’m talking about a table which is enabled for in-memory). In “the Oracle Database In-Memory blog”, it says Oracle typically populates the table after it has been accessed for the first time. It’s possible to check V$IM_SEGMENTS to see the memory segments of in-memory tables, so we can easily see when the table is (more...)
This is probably as much a note-to-self as it can possibly be. Recently I have enjoyed some more in-depth research about how the Linux kernel works. To that extent I started fairly low-level. Theoretically speaking, you need to understand the hardware-software interface first before you can understand the upper levels. But in practice you get by with less knowledge. But if you are truly interested in how computers work you might want to consider reading (more...)
There are a number of great improvements to the Database-as-a-Service (DBaaS) capability in Enterprise Manager 12c Release 4.
As a recap, in earlier releases it was possible to set up a private database cloud very easily, so that developers, testers or project managers/business users could self-service the creation of new databases, schemas or pluggable databases (PDBs) as per a pre-defined quota, and then have those databases, schemas or PDBs metered and used for dollar chargeback, (more...)
I've published the final part
of my video tutorial and the final part
of my mini series "Parallel Execution Skew" at AllThingsOracle.com
concluding what I planned to publish about the topic of Parallel Execution Skew.
Since all this was published over a longer period of time this post therefore is a summary with pointers to the material.
If you want to get an idea what the material is about, the following video summarizes the (more...)
After I added some database targets to my Enterprise Manager 12c, an incident opened for failed jobs on a newly added database. We have some jobs scheduled to run every 5 minutes on that database, and of course we have some error-handling and alerting mechanism which will notify us if any of them fails, so there shouldn’t be any failed job. I checked run logs of all the scheduler jobs to see if there are (more...)
In a previous blog post, I covered setting up Schema as a Service for schema level consolidation. In this post I’m going to cover how to use the Self Service Portal with Schema as a Service in EM 22.214.171.124. Just as it was in my posting on using the Self Service Portal with DBaaS, our […]
The following is a list of changes I noted during installation of Oracle Linux 7. I imagine the same will apply to Red Hat Enterprise Linux 7, but I haven’t verified that to be the case.
Setting the Hostname
I was accustomed to updating /etc/sysconfig/network with the hostname of my machine as documented here for Oracle Linux 7. I did this and was then surprised to find that my hostname was not picked up. On returning (more...)
(Otherwise known as #E42014 to the Twitterati. Note to the casual reader ... like a lot of conference posts, this is more personal diary entry than having any tech content whatsoever. You have been warned.)
Yes, so this post is hopelessly late, but I really have been busy this time!
Although I feel like I've done quite a few presentations over the past year, a lot of them have been at client sites and the (more...)
Oracle 126.96.36.199 is out, after lots of announcements the product has finally been released. I had just extended my 188.8.131.52.3 cluster to 3 nodes and was about to apply the July PSU when I saw the news. So why not try and upgrade to the brand new thing?
What struck me at first was the list of new features … Oracle’s patching strategy has really changed over time. I (more...)
There is more and more happening in the world of visualization and visualizing Oracle performance specifically with v$active_session_history.
Of these visualizations, the one pushing the envelope the most is Marcin Przepiorowski. Marcin is responsible for writing S-ASH , ie Simulated ASH versions 2.1,2.2 and 2.3. See
Here are some examples of what I have seen happening out there in the web with these visualizations grouped by (more...)
focused on the intersection of software and hardware. It's great community with Software and Hardware. Audiences will be able to learn new idea to combine software and hardware. It gathered idea from engineers, researchers, roboticists, artists, founders of startups, and innovators.
Oreilly launched HD videos (Solid Conference San Francisco 2014: Complete Video Compilation Experience the revolution at the intersection of hardware and software—and imagine the future
) for this conference. Video files (more...)
So how to turn it the option off/disabled…As a privileged database user: > Just don’t set the INMEMORY_SIZE parameter to a non zero value…(the default...
There is a serious problem with export/import utilities between versions.
The first command, executed on Oracle 184.108.40.206, Linux x86_64 was:
[oracle@oradb tmp]$ expdp system directory=tmp dumpfile=oe.dmp schemas=oe
Directory tmp was created as /tmp
Result was the following:
Export: Release 220.127.116.11.0 – Production on Mon Jul 28 22:57:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights
Connected to: Oracle Database 11g (more...)
My biggest complaint about earlier versions of OEM came from the poor integration of BI Publisher with Enterprise Manager. The Information Publisher said boldly that I/P will be discontinued in favor of BI Publisher. That sounded pretty serious so I made the effort to install it.
The installation was difficult, the canned reports were mostly worthless, and the OEM and BI Publisher security models were completely separate. BI Publisher used the WebLogic security model and (more...)