Blog - comments

When I studied Oracle New Feature Guide "Media Failure: PDB SYSTEM Data File" , I was surprised tha...
Hayat Khan

Really a nice article to study.

Thanks,

Amol Bhoite

ana 100 goid

mokok

ana 100 gold

mokok

Bonjour,

Tout d'abord merci pour cet article. J'aimerai savoir si ACFS est gratuit ?

Chris

Chris
Blog Jérôme Witt OOW Day 3: Oracle database 12c features review

dbi services Blog

Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, 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 the 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 3: Oracle database 12c features review

Today, we had the opportunity to follow several sessions concerning the upcoming Oracle Database 12c release. Like Apple, Oracle keeps the secret over Oracle Database 12c, but tends to deviate from the Silicon Valley secret culture. However, we can relay all that we heard to you ;-)

OOW2012-Oraboat                                                            

Over the past 10 years, Oracle has worked on plenty of state of the art topics like compression, in-memory operations, scalability, and this is still true for Oracle Database 12c.

Instead of discussing high-level database administration and configuration, we will simply summarize some real-life, daily useables:

  • Moving and Renaming ad datafile is now ONLINE
  • RMAN TABLE Point-In-Time Recovery (combination of data pump and RMAN, auxiliary instance required)
  • Global Temporary Tables can now be used on an Active Guard standby database
  • Automatic data optimization, cold data are now totally handled by the database (extension from the Oracle 11g feature with a time lifecycle) allows for better Infrastructure Management (moving cold data to cheaper file system)
  • Oracle Enterprise Manage Express (lightweight EM Cloud Control 12c version) replaces the Oracle Database console and is installed automatically
  • The TRUNCATE command has been enhanced with a CASCADE option which follows child records

Oracle Dabatase 12c comes with around 1000 new features. Some of them are reserved for Exadata customers: the Oracle dictionary with approximately 226 new static views, 131 performance views, and 13 new database init* parameters.

The most interesting new parameter concerns the management of the Private Global Area (PGA). PGA_AGGREGATE_TARGET was neither a limit nor a max size to address this problem which is why Oracle introduced the parameter PGA_AGGREGATE_LIMIT which is a real memory limit.

The DBA job will not became easier, some very useful Oracle 11g are still not widely used, like Result cache, or the parameter RESUMABLE_TIMEOUT.

Year after year, the database technology evolves very quickly and tools like Oracle Enterprise Manager Cloud Control (12c) evolve in the same way.

Rate this blog entry:
3

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 Monday, 21 April 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)
NewsOfficesContact

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