Oracle 12C database New Features

  • Pluggable Databases
create a container database(root db) and plug many database inside it.....
what's the question in your mind now?
why oracle making it so complicated, first create container db then create plugable db? Obviously managing them will require lots of effors...


The Benefit whcih we get, all these databases then share the exact same oracle server processes (aka background processes) and memory (Unlike in the previous versions where each database got its own set of background processes and shared memory allocation).


Means
You will have only one pmon and can create many instance on a single server.

Isn't it sounds extraordinary?

Comments

  1. Rohit Dubey19 February 2025 at 12:18

    Thank you for taking the time to research and write this article. It's much appreciated.

    ReplyDelete
  2. Anonymous19 June 2025 at 01:49

    Very useful.

    ReplyDelete
  3. Daniel3 January 2026 at 03:57

    Very, very well explained. Nice article

    ReplyDelete

Post a Comment

Popular posts from this blog

Image
 USER TYPES in SNOWFLAKE   "Securing is better than sorry"  It's always wiser to take precautions and secure something properly, even if it seems unnecessary, rather than risk potential problems or regret later by not being careful enough;  Snowflake have TYPE property for the USER object. This is one of the long-awaited no-brainer features we all wanted! Make sure to secure your data by securing your user first. Key things to remember  Never rely on one factor authentication(Always enroll at least in 2nd factor authentication) Old-fashioned password logins are vulnerable in today's digital world, so configure strong authentication, such as OAuth, Key pair, and federated authentications. In snowflake there are 4 properties of the user that can be set PERSON | SERVICE | LEGACY_SERVICE | NULL PERSON: Users do not have restrictions when the TYPE property is set to PERSON, NULL, or when TYPE is unset. NULL: See PERSON. SERVICE: To improve the security posture of ...
Read more

DATA MOVEMENT: CHALLENGE OR STRENGTH ?

  Organizations in highly regulated industries go through many business events that trigger the need for a data migration. The typical “lift and shift” approach to data migration, however, results in a considerable amount of time and resource allocation—without any concrete business value to show for it. Adlib goes beyond just automating the process of moving your data between repositories. We add value to your content before, during, and after migration, for enriched content that’s easier to find and easier to use. Oracle Data Pump  is a newer, faster and more flexible alternative to the "exp" and "imp" utilities used in previous Oracle versions. In addition to basic import and export functionality data pump provides a PL/SQL API and support for external tables. In order to use Data Pump, the database administrator must create a directory object and grant privileges to the user on that directory object. You would login to SQL*Plus as system and enter the following ...
Read more

Oracle RAC Split Brain/ Node Eviction

Many people asks this question why and how nodes are evicted from cluster... Here is the simple answer.. It occurs when the instance members in a RAC fail to ping/connect to each other via this private interconnect, but the servers are all pysically up and running and the database instance on each of these servers is also running. These individual nodes are running fine and can conceptually accept user connections and work independently. So basically due to lack of commincation the instance thinks that the other instance that it is not able to connect is down and it needs to do something about the situation. The problem is if we leave these instance running, the sane block might get read, updated in these individual instances and there would be data integrity issue, as the blocks changed in one instance, will not be locked and could be over-written by another instance. Oracle has efficiently implemented check for the split brain syndrome. In RAC if any node becomes inactive, or if ot...
Read more