What happens when you unplug a pluggable database that has local users who have been granted common roles? They get copied upon plug-in of the PDB to the target container database!
The picture above shows the situation before the unplug command. It has been implemented with these commands:
SQL> connect / as sysdba
SQL> create role c##role container=all;
SQL> grant select any table to c##role container=all;
SQL> connect sys/oracle_4U@pdb1 (more...)
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 184.108.40.206. 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 220.127.116.11 is out, after lots of announcements the product has finally been released. I had just extended my 18.104.22.168.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 22.214.171.124, 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 126.96.36.199.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...)