One of many ...

There's lots of little things in the upcoming release of sqldev. Frank's post reminded me of one that I forgot to show at openworld. We have support for the same DVT Gauge component that he mentions in sqldev's next version. However, all you have to do is write a sql statement. It's really simple to use. For example, I took the free space report from Tom Kyte and added guages.

The only you'll need to do in sqldev is select the correct value and it'll turn it into a gauge. In the base sql, the percent used is

((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100 pct_used " .

In order to make it more graphical I just changed it to this

'SQLDEV:GAUGE:0:100:0:0:'||((kbytes_alloc-nvl(kbytes_free,0))/ kbytes_alloc)*100 pct_used

The SQLDEV:GAUGE trigger the check for values. The first 2 numbers are the min and max values. The next 2 are the low and high values. Lastly, the current value to plot.

Oracle Open World

Open world is almost here. Here's my connect card. I'll pretty much be at the booth or between our sessions. Stop by if you want to chat.

Subscribe to Public Reports

Mark's post on the forums got me to do something I've been meaning to do for a while. I updated the reports section of the exchange today so that you can upload a report.xml. Now when you goto "My Reports" There's a file upload to load the whole xml file. This should allow people to post reports with children or whatever is in the xml.

Also I made this link for getting all public reports. The link is useful if you want to pull public reports into your sqldev. Here's all you have to do:

1) Go into the preferences and add a User Defined Extension:


2) Restart

3) You'll see the Shared Reports show up grouped by tghe user that posted them ( otn user name):

What's up

I forgot I added a real simple way to see what DBs are up in sqldev a while back. If in the worksheet, you run a command, F5 (run script), "pingall" it will do a tnsping of all the connections defined and report back. From this screenshot you'll notice most of my DBs are down. My plan was to hook up an indicator in the tree for down database but never got it well tested.

More Apex/SQLdev

Here's a couple more shots of the up coming Apex and SqlDev intergration.

1) Export your app:



2)Import the app:


3)Import Options: