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 …
Today Oracle released the next download for the new SQL Developer. You can find the download here. The download is avaible for: Windows 32/64 Bit Max OSX Linux Also check out Jeff Smith Blog for some more Information. There’s two big things you need to know about: 1. About 500 bug fixes 2. Support for…
This new feature allows to transform an SQL statement that contains views. The result is a SQL statement in which the views are dissolved and integrated into the SQL.This support for the DBA to find application logic errors or performance problems. Here is a example where a query from your application and Views are used. In my…
My colleague has tested on his blog whether Stored Outlines under 12c still work. The answer? YES. But the Oracle documentation shows the Stored Outlines in conjunction with JDBC and SQLJ will no longer be supported. Because many applications use Weblogic or Tomcat to connect to the database this may a significant limitation. I have…
