Easier than ever local connections

I'm constantly trying to make things in the tool easier to get people started working with the database. The first step is always create a connection. You may wonder how can that get easier it's fairly simple as it is.

Well for a local database it is now easier than ever. I added a new context menu "Create Local Connections". When you have a local database it will automatically setup a connection for sys,system and any user which has an open account. So now in roughly 15 seconds you have a connection to each user in your local database. Then just simply open, enter the password and your up an running writing code. I plan on later extending this to something like "create connection based on connection X"

SQL Developer 2.1 EA1

There's tons of things in the new EA. The two biggest is the modeler is now integrated and the new unit testing. I'm going to do a few short demos of each and some of the things they offer. First the modeler not only allow you to open a model and see what was created in the full SQL Developer Data Modeler but it allows for drag and drop.

I'm going to try and do a bunch of short demos of some of the new things.

Here's the first, a very short demo of how to do it.

Apex performance week over week

I've looking into tuning the public apex.oracle.com. I could tell from the system standpoint that what we've done has been working. Now the real test is how is the end user's response times. I put a quick query together to attempt to measure that. Here's what I used which shows the trailing 24 hours pitted against the same time period 14 days ago.

select t.dt "Hour" ,t.cnt "Today Views" ,round(t.av,2) "Avg time",
      l.cnt "2 Week Ago Views",round(l.av,2) "2 Week Ago Avg" , 
      case when (t.cnt-l.cnt) > 0 then '<span style="color:green;">'||round((l.cnt/t.cnt)*100) ||'% ('||(t.cnt-l.cnt)||')</span>' else '<span style="color:red;">-'||round((l.cnt/t.cnt)*100) ||'% ('||(t.cnt-l.cnt)||')</span>' end "Count Diff" , 
      case when (t.av - l.av) > 0 then '<span style="color:red;">-'||round((l.av/t.av)*100)   ||'% ('||(round((t.av - l.av),2))||')</span>' else '<span style="color:green;">'||round((l.av/t.av)*100)|| '% ('||(round((t.av - l.av),2))||')</span>' end   "Avg Diff"
from ( 
select to_char(time_stamp,'HH24') dt,count(1) cnt,avg(elap) av
  from apex_030200.wwv_flow_activity_log
  where time_stamp > sysdate - 1
group by   to_char(time_stamp,'HH24')
 ) t,
( select to_char(time_stamp,'HH24') dt,count(1) cnt ,avg(elap) av
  from apex_030200.wwv_flow_activity_log
  where time_stamp between  sysdate -14 -1 and sysdate -14
group by   to_char(time_stamp,'HH24')
) l
where t.dt = l.dt
order by 1

Here's the results of the query when run for apex.oracle.com this morning. From these measure points, it appears what we're doing is working.

Apex Listener

After demoing at RMOUG using the listener, it seemed a good time to show where it's at. Here's a quick snap of the new way to configure it vs. mod_plsql's notepad/vi interface. You can probably tell from the screen which webserver I've been using to test it.

Forgot to show this at RMOUG today

I ran out of time and had a couple more things to show today. Here's the first that I ran out of time for.

The thing I meant to show was the ability to use the sql formatter to format your sql in the worksheet into a string for other programming languages. I'll show how to format for java here.

First here's the starting sql. You'll notice I even put in aliased column names quotes.



Now the preferences have to be changed for how to format. I'm going to try to add a simple right click -> Format to Java or something in the future but for now just change this preference.





Now a quick format.



And the sql query is properly escaped and ready to be copy-n-pasted into your favorite java code.