Blog - comments

Very useful article. Thanks Franck !

Krishna
Thanks a lot Franck. I agree to use FRA and RMAN deletion policy to manage standby site archived log...
RIck CHEN
I still say that you don't have to delete archivelogs because they are managed by oracle. That's the...
I don't know any documentation about those EC and ECJ. And I'm sorry I don't know the consequence of...
Hi Franck thanks for clarifying this. I was already wondering about the difference between EC and EC...
Reiner
Blog Jérôme Witt OOW Day 4: Dive in, Rock out - Oracle Party & Tomy Kyte's 12 things on Oracle 12c

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

OOW Day 4: Dive in, Rock out - Oracle Party & Tomy Kyte's 12 things on Oracle 12c

Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America's cup boat is really amazing (see picture below) as was last night's party.

Jerome Witt with Pierre Sicot dbi services

OOW2012-Concert

Today, we were really tired ;-) and the speakers too. Most of today's content was a review of what Pierre and I reported during the week.

It fits exactly Tom Kyte session "12 Things to know about Oracle 12c" (12 because of Oracle Database 12c, next it will be 13):

  1. PL/SQL inside SQL: Tom really likes to teach what SQL is and this new feature allows to use DDL inside SQL statements (i. e.: to create a one shot function)
  2. The object DEFAULT clause has been enhanced. Adding a column to an existing table with a default value (much faster with Oracle 12c and it consumes less space than before, pointer to the Oracle Data Dictionary), applies also to sequences, identity types ...
  3. Increased size limit for VARCHAR2,NVARCHAR2, RAW data types to 32K (like in PL/SQL)
  4. Pagination query, SQL keywords to replace ROWNUM records
  5. Row pattern matching  "MATCH_RECOGNIZATION" (identification of patterns within a table ordered/sorted by the SQL statement)
  6. Partitioning enhancements (partition truncate, cascading, global index Cleanup, online moving of a partition, ...)
  7. Adaptive execution plans (change of the plan at runtime, sounds really nice)
  8. Enhanced statistics (Hybrid histograms for more than 254 distinct values, dynamic sampling up to eleven, stats automatically gathered during load)
  9. Temporary UNDO for global temporary tables to eliminate REDO generation (gives more space to really UNDO data)
  10. Data optimization ILM (Information Lifecycle Management, hot & cold data classification, automatic compression)
  11. Application continuity, transaction guard (improvements of Fast Application Notification)
  12. Pluggable databases

Hopefully, you enjoyed with us the Oracle Open World as well as the upcoming DBA challenges with Oracle Database 12c. Please feel free to read our future blog postings about Oracle Database 12c.

For our last night in San Francisco, we need now some "Oracle corporate" (see you next year).

OOW2012-Beverages

Thanks to dbi services for this great opportunity!

Pierre & Jérôme

Rate this blog entry:
2

Jérôme Witt is Senior Consultant at dbi Services. He started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup & recovery, and tuning technologies. His expertise also includes the open source field (Linux/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). Jérôme Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, Jérôme Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. Jérôme Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking & Financial Services, Energy, Automotive etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Friday, 28 November 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter