Oracle 12.2 is finally released on premise and for that reason I would like to share some of my experiences with testing the new Features. First I would like to write about a small new feature, which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see…
Some days ago a customer show me a script where he did intensive PL/SQL Code for logging errors during exection. This additional code was responsible for same Performance Problems during the script execution. After same code Review i find out that there was a much easier way the same Debugging without the Overhead. You can…
Oracle released two new updates for Oracle SQL Developer and the Oracle SQL Developer Data Modeler. The list of bugs fixed for the SQL Developer can be found here. Also a complete list for fixed bugs in the SQL Developer Data Modeler can be found on the OTN Page here. You should install a JDK…
Today i want to explain the new Histograms Enhancements in 12c. But first i want to explain some basic about basic about histograms, because i know that they are not well known by some DBA`s.The Optimizer normaly thinks that the data in a column is uniformly distributed. A example of this is a primary key column…
12c introduce a New Feature which allows the DBA to log all data definition language (DDL) statements to a DDL alert log. I think that this is a usefull feature, for example you can audit a update from your software vendor to see what is happen on your database. But be carefull, this parameter needs…
Its not realy a new feature because many other database vendors have this feature already but it is new to Oracle 12c. You can now limit the Output of rows in a SQL Query. A small example: Check the employees Table SQL> select count(*) from employees; COUNT(*) ———- 107 Now we are only…
Some weeks ago i posted an article which describes how SQL Baselines effects Adaptive Cursor Sharing (german). In this article i want to show what will happen when you use SQL Profiles while SQL Baselines are active. First let us configure a database to capture and use SQL Baselines. SQL> show parameter baselines NAME …
