Friday, July 16, 2010

3.0 Sneak Peek #1

 Ever tinker with SQL to get the best plan possible but have to track what changed by flipping screens or not sure what session stats change due to the new plan ?  Here's the feature for you.  It highlights what changed in the tree as well as shows all the session stats that change from one plan to the next.  As with all things this is work-in-progress and subject to change.

This is an example on a partitioned table I use to test with of the difference between using a date>sysdate-10 and between sysdate-10 and sysdate.  The differences can be see very quickly.




APEX Listener undocumented feature #1

Seems I always forget to doc everything that I code up.  If you have the apex listener, try this out.

The listener will convert
     http://myhost/apex/builder/home
to
     http://myhost/apex/f?p=builder:home

This hopefully is a baby step to nicer urls to hand out to end users.


http://yourhost.yourdomain/apex/<APP_ALIAS>/<PAGE_ALIAS>