Tags » SQL Developer

Getting a 10053 trace file with SQL Developer

In this post I want to share with you a technique which will allow you to generate a 10053 Optimizer trace file and to seamlessly output it in to SQL Developer (or SQLplus if you prefer), without having to access the remote database server. 1,148 more words


Can not connect to Virtualbox Guest Oracle Database 12c Developer Day Database VM due to Oracle Linux firewall

It seems there’s a firewall present on the latest Developer Days Database image which I’ve just downloaded from Oracle.


I enjoy using these images because it is a complete reference install of Oracle Linux, Oracle Database and Oracle SQL Developer (among others). 256 more words


Oracle SQL Developer 4 does not run on Oracle Java 7 on Ubuntu 14.04

Wow, ain’t this awkward :-). I cannot run Oracle SQL Developer 4 (4.0.2) on Ubuntu with Oracle JDK 7..

To be complete: when running SQL Developer with JDK 7 from Oracle itself, displays the following error; 270 more words


Control OraSASH Repository with SQL Developer

SQL Developer and OraSASH are great tools. That is why I made up my mind to add some reports to SQL Developer to facilitate usage of OraSASH. 186 more words


Import Report Definition in SQL Developer

Once you have an xml file containing a report definition, this file can be imported in SQL Developer.

Make sure that the view “Report” is displayed. 37 more words


SQL Developer Report Table Info

SQL Developer is one of my favourite tools for database administration. It is easy to customize and runs on nearly any system. Of course Grid Control is not bad either, but I use SQL Developer more often to analyse a database than Grid Control. 154 more words