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.

Carlisms

As open world approaches, I'm reminded it's the last time I saw Carl. He will be very much missed this year. Here's a few random quotes going through my IM logs over the years.

yeah doesn't everybody know i'm overqualified for html???


damn you are lazy and i say that with all respect


me: hi
carlback: hello
me: howdy
carlback: cool thanks
me: you are on my dang list now 4 times: carl carlback carlbacktest carlback@gmail
carlback: i have some people to add but for some reason not working in yahoo so going to have them use google talk
carlback: sheeeeeeet, thats cause i have alot to say ;)
me: yeah but no one wants to listen
carlback: luckly i like the sound of my own voice



carlbacktest: last 15% is freakn nightmare


kris rice: I found your freeze issue. I'll have a build in ~5 minute with it fixed
carlbacktest: nice
carlbacktest: what was it
kris rice: It was trying to highlight errors and since you code is perfect there weren't any ;)
carlbacktest: doh


carlbacktest: I mean giant robots!

In Memoriam - Carl

Together with Dom Lindars, I had the great pleasure to help hire Carl into Oracle 6 years ago and have worked with him ever since. How we found him he wrote about last year which for Oracle was very non-typical. Carl turned to be anything but typical, I would have never guessed what a great friend we had found that day. He is on my instant messenger list with no less than 5 different accounts. We worked together in the same office for a little over a year. We could always count on Carl for a story ranging from collecting salamanders as a student job to using his geo/mapping background helping design with the Presido of San Francisco wild life preserve to growing up in southern California in an orange grove. Whenever my son would come to the office he would always make time to talk with him.

Then he and I both joined this "marvel" team. We talked the move over for a long time if it made sense for us to do. He was a little unsure about this plsql based app versus the svg coding he was doing for the sales group. I think anyone reading this knows how well it turned out.

He always made time to chat with my son on everything from games to giant robots to godzilla movies. Shortly after joining this team marvel we had an offsite in DC, again he made time to talk "shop" with my son. After he moved to vegas my son called him a traitor for switching from Playstation to XBOX for a choice of gaming console. However, he didn't switch before my son beat him playing over the internet ! At one team outing my family accompanied me and again Carl sat beside my son and made sure to talk with him throughout the boring dinner.


His Bio on twitter sums it up best "Super Cool Guy".

Carl will be missed by all in my home. He was a great person.

My family's condolences to his daughter, his fiance and the rest of his family.