Oracle has come up with new feature called multitenant database. Using this feature we can have many pluggable databases plugged into single container database.
This article explains pluggable databases architecture and how to create them.
I am not covering administration part. Viewers can check the documentation mentioned in reference section to check administrative part for managing pluggable databases.
One thing you (ought to) learn very early on in an Oracle career is that there are always cases you haven’t previously considered. It’s a feature that is frequently the downfall of “I found it on the internet” SQL. Here’s one (heavily paraphrased) example that appeared on the OTN database forum a few days ago:
select table_name,round((blocks*8),2)||’kb’ “size” from user_tables where table_name = ‘MYTABLE';
As the volume of the data in your tables grows, particularly in the big data world, you may run into some memory issues or package restrictions with pulling down the tables to your R environment. Some of the R packages and drivers have some recommended numbers or limits for the number of records that can be fetched. Caveate: My laptop is a Mac and at this point in time the ROracle package is unavailable for a Mac. It is for Windows, Solaris and AIX.
Just a short post on a problem I encountered recently.
I had to install 11.2 GI and right after running the installer I got a message saying permission denied. Below is the exact error:
I had some time to spend, killing time, and thought about something that was “on…
It gives me immense pleasure to share with you the news that
“I am an Oracle Ace Associate“.
Thanks to the “Oracle ACE Program” for accepting me to receive the Oracle ACE Associate award.
My heart is full of gratitude for Sir Murali Vallath who nominated me for this.
Thanks to AIOUG for giving me an opportunity to speak during SANGAM 14 and publishing my white paper on ‘Histograms – Pre-12c and now” in Oracle Connect Issue Dec 2014.
Suppose that I am trying to consolidate multiple databases on to a single server and that I would like to limit the cpu usage of one of the database. Then I decide to test the cpu binding approach and the Instance caging approach.
You can find a great description and how to implement:
First principles, Clarice. Simplicity. Read Marcus Aurelius. Of each particular thing ask: what is it in itself? What is its nature?
The Silence of the Lambs
What do you do when you get a call about a query that keeps running without completing, where the query text itself looks very simple: