Oracle 12c New Features

Posted on Posted in Uncategorized

Top 12 Features of Oracle 12C Summarized.
Summary: The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas. Summarized below is the list of Top 12 Features of Oracle 12C as I see it. I have summarized below, the top 12 which I found interesting.

01. Pluggable Databases Through Database Consolidation:

Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through the introduction of Container Databases also called CBD and Pluggable Databases (PDB). The memory and process is owned by the Container Database. The container holds the metadata where the PDBs hold the user data. You can create upto 253 PDBs including the seed PDB.

In a large setup, it is common to see 20 or 30 different instances running in production environment. With these many instances, it is a maintenance nightmare as all these instances have to be separately

•RAC Enabled
•Backed up and
•Data Guarded.

With Pluggable Databases feature, you just have to do all this for ONE single instance. Without this feature, prior to 12C, you would have to create separate schemas and there is always a thread of security how much ever the isolation we build into it. There are problems with namespace conflicts, there is always going to be one public synonym that you can create. With PDBs you can have a separate HR or Scott schema for each PDB, separate Emp, Dept Tables and separate public synonyms. Additionally, 2 PDBs can talk to each other through the regular DB Link feature. There is no high startup cost of creating a database any more. Instead of one instance per day, the shift is into one instance per many databases. For the developer community, you can be oblivious of all this and still continue to use the PDBs as if it were a traditional database, but for the DBAs the world would look like it has changed a lot.

Another cool feature is, you can allocate a CPU percentage for each PDB.

Another initiative being, it has announced a strategic tieup with during the first week of July 2013.

02. Redaction Policy:

This is one of the top features in Oracle 12C. Data Redaction in simple terms means, masking of data. You can setup a Data Redaction policy, for example SSN field in a Employee table can be masked. This is called redaction. From Sql Develop you can do this by going to the table: Employee->Right click on Security Policy->click on New->click on Redaction Policy->Enter SSN.
When you do a select * from employee, it will show that the SSN is masked.
The new data masking will use a package called DBMS_REDACT. It is the extension to the FGAC and VPD present in earlier versions.
By doing this, whoever needs to view the data will be able to see it where as the other users will not be able to view it.

03. Top N Query and Fetch and offset Replacement to Rownum:

With the release of Oracle Database 12c, Oracle has introduced this new SQL syntax to simplify fetching the first few rows. The new sql syntax “Fetch First X Rows only” can be used.

04. Adaptive Query Optimization and Online Stats Gathering:

With this feature, it helps the optimizer to make runtime adjustments to execution plan which leads to better stats. For statements like CTAS (Create Table As Select) and IAS (Insert As Select), the stats is gathered online so that it is available immediately.

05. Restore a Table easily through RMAN:

Earlier if you had to restore a particular table, you had to do all sorts of things like restoring a tablespace and or do Export and Import. The new restore command in RMAN simplifies this task.

06. Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement.

07. Inline PL/SQL Functions and Procedures:

The in line feature is extended in Oracle 12C. In addition to Views, we can now have PL/SQL Procedures and Functions as in line constructs. The query can be written as if it is calling a real stored procedure, but however the functions do not actually exist in the database. You will not be able to find them in ALL_OBJECTS. I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.

08. Generated as Identity/Sequence Replacement:

You can now create a col with ‘generated as identity’ clause. Thats it. Doing this is equivalent to creating a separate sequence and doing a sequence.nextval for each row. This is another handy and a neat feature which will help developer community. This is also called No Sequence Auto Increment Primary Key.

09. Multiple Indexes on a Single Column:

Prior to 12C, a column cant be in more than one index. In 12C, you can include a column in B-tree index as well as a Bit Map index. But, please note that only one index is usable at a given time.

10. Online Migration of Table Partition or Sub Partition:

You can very easily migrate a partition or sub partition from one tablespace to another. Similar to how the online migration was achieved for a non-partitioned table in prior releases, a table partition or sub partition can be moved to another tablespace online or offline. When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.

11. Temporary UNDO:

Prior to 12C, undo records generated by TEMP Tablespace is stored in the undo tablespace. With Temp undo feature in 12C, temp undo records can be stored in temporary table instead of UNDO TS. The benefit is – reduced undo tablespace and reduced redo log space used.

SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=0; –disables the hard limit

12. In Database Archiving:

This feature enables archiving rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression but are not visible to the application. These records are skipped during FTS (Full Table Scan).

Other Features:

Advanced Replication and Streams are Dead. It is being replaced with Oracle Golden Gate.

Invisible Columns. You can now have a invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries

PGA Aggregate Limit setting:

In 12c, you can set a hard limit on PGA by enabling the automatic PGA management, which requires PGA_AGGREGATE_LIMIT parameter settings. Therefore, you can now set the hard limit on PGA by setting the new parameter to avoid excessive PGA usage.

DDL Logging:

The DDL statements will automatically get recorded in xml/log file if ENABLE_DDL_LOGGING is set to True. ALTER SYSTEM|SESSION SET ENABLE_DDL_LOGGING=TRUE

286 thoughts on “Oracle 12c New Features

  1. Very well voiced indeed. !
    [url=]thesis on service delivery and customer satisfaction[/url] customer service thesis pdf [url=]thesis[/url] mba thesis

  2. You mentioned that fantastically!
    [url=]essay writing service coupon[/url] essay writing service uk [url=]online paper writing service[/url] essay help service

  3. Many thanks. Numerous data.
    [url=]i didn t do my homework form[/url] i didn t do my homework form [url=]do my homework[/url] do my finance homework

  4. Tips very well considered..
    [url=]dissertation writers online[/url] best dissertation writing [url=]doctoral dissertation help usa[/url] buy dissertation writing services

  5. Superb data. Appreciate it.
    [url=]bachelor thesis writing service[/url] thesis statement [url=]service quality thesis philippines[/url] community service thesis statement

  6. You have made your point quite effectively!!
    [url=]essay paper writing service[/url] student essay writing [url=]admission essay writing service[/url] essay writing service uk cheap

  7. Wow quite a lot of amazing tips.
    [url=]write my research paper for me[/url] elements of a research proposal [url=]proposal writing[/url] research paper help

  8. Reliable information. Thanks a lot.
    [url=]do my homework for money[/url] do my homework for money [url=]do my programming homework[/url] homework

  9. Nicely put. Cheers!
    [url=]dissertation writing help[/url] doctoral dissertation [url=]dissertations[/url] dissertation writing services

  10. After reading your article, it reminded me of some things about gate io that I studied before. The content is similar to yours, but your thinking is very special, which gave me a different idea. Thank you. But I still have some questions I want to ask you, I will always pay attention. Thanks.

  11. Really loads of very good information!
    [url=]pay to write essay[/url] pay for essay [url=]buy an essay online[/url] buy essay online

  12. I’ve been researching the benefits of [url=]metformin 2023[/url] and it seems like it could have a positive impact on cardiovascular health.

  13. At the beginning, I was still puzzled. Since I read your article, I have been very impressed. It has provided a lot of innovative ideas for my thesis related to Thank u. But I still have some doubts, can you help me? Thanks.

  14. Thanks a lot, I appreciate this!
    [url=]how to write a philosophy paper[/url] my paper writer [url=]research paper writer services[/url] how to write a philosophy paper

  15. You have made your point!
    [url=]do my finance homework[/url] cpm homework help [url=]hire someone to do my homework[/url] do my math homework

  16. Thank you very much for sharing. Your article was very helpful for me to build a paper on After reading your article, I think the idea is very good and the creative techniques are also very innovative. However, I have some different opinions, and I will continue to follow your reply.

  17. Good forum posts. Cheers.
    [url=]write my term paper[/url] ai essay writer [url=]paper writing[/url] write my research paper

  18. I am a website designer. Recently, I am designing a website template about The boss’s requirements are very strange, which makes me very difficult. I have consulted many websites, and later I discovered your blog, which is the style I hope to need. thank you very much. Would you allow me to use your blog style as a reference? thank you!

  19. Nicely put. Many thanks.
    [url=]write my paper for me[/url] do my essay for me [url=]write my paper for me[/url] essay writers online

  20. I am a student of BAK College. The recent paper competition gave me a lot of headaches, and I checked a lot of information. Finally, after reading your article, it suddenly dawned on me that I can still have such an idea. grateful. But I still have some questions, hope you can help me.

  21. With thanks! Helpful information.
    [url=]good thesis statements[/url] thesis creator [url=]good thesis statement[/url] good thesis statements

  22. Thanks a lot, Very good information.
    [url=]thesis statements[/url] thesis statement meaning [url=]working thesis[/url] thesis paper

  23. Thank you! Excellent stuff.
    [url=]phd paper[/url] phd dissertation help [url=]dissertation paper[/url] dissertation help

  24. I may need your help. I’ve been doing research on gate io recently, and I’ve tried a lot of different things. Later, I read your article, and I think your way of writing has given me some innovative ideas, thank you very much.

  25. I may need your help. I’ve been doing research on gate io recently, and I’ve tried a lot of different things. Later, I read your article, and I think your way of writing has given me some innovative ideas, thank you very much.

  26. Fantastic facts. Appreciate it!
    [url=]should i do my homework[/url] do my programming homework [url=]cpm homework help[/url] do my homework for me

  27. You actually explained this very well!
    [url=]argumentative thesis[/url] thesis template [url=]thesis writing[/url] a thesis statement

  28. I may need your help. I’ve been doing research on gate io recently, and I’ve tried a lot of different things. Later, I read your article, and I think your way of writing has given me some innovative ideas, thank you very much.

  29. This is nicely put! .
    [url=]buy a paper[/url] paper writing service [url=]buy college paper[/url] professional paper writing service

  30. I may need your help. I tried many ways but couldn’t solve it, but after reading your article, I think you have a way to help me. I’m looking forward for your reply. Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

× 6 = 30