Sometimes, advanced features can bring advanced problems. Seeing a project with hundreds of child cursors with a different execution plan each, is never a pleasure, but there has to be a reason. In fact, we are talking about the “USE_FEEDBACK_STATS” reason in v$sql_shared_cursor. Its meaning is: “A hard parse is forced so that the optimizer can reoptimize […]
Tag: 12c
Oracle 12c in practice – customer report in Cologne #12cjetzt
From Beta to Production – Oracle 12c at TGW In October, I’ll speak at the Oracle #12jetzt (#12cnow) symposium in Köln (Cologne) about the introduction of 12c as standard palttform at our ISV customer TGW Software Services. I had the privilege to continuously working on the 12c product evaluation and introduction from availability of 12c beta2 […]
Oracle 12c RMAN delete obsolete behaves interactively in DBMS_SCHEDULER job type BACKUP_SCRIPT
Situation In Oracle Database 12c, we have the long-missed feature of DBMS_SCHEDULER job type “BACKUP_SCRIPT”, that allows us to create backup jobs without creating them as an OS file, and without need for a wrapper script that’s called by a job type EXECUTABLE (as we usually did that in the last years). Sometimes we also […]
Oracle 12c New Features – Look at’s for 12.1.0.1.0
A new product … Last week I spent some days of intense investigation and testing the new database 12c. I found lots of great stuff (even about 11g 🙂 ), and some for sure will make it into a separate blog post. So these are just my notes of a very interesting couple of days, […]
Oracle Database 12c Release 1 available
Since today, Oracle allows downloading the newest release of the Database product 12c via http://edelivery.oracle.com So far I only can see it for the Linux platform, and docs are still missing. But this may change rapidly. Take care Martin Klier […]