Kris' blog

Apex Listener EA1

2009-10-07T10:22:00.000-07:00

We pushed the first EA of the new listener out this week. Give it a try here. I'll be watching the Apex forum here for question people may have. Here's a few things I forgot to put into the doc. 1) In the zip is a sample configuration file, apex-config.xml . This contains a short comment on each parameter. 2) To change the default location of the config file OR the cache location. Edit the

Easier than ever local connections

2009-09-30T16:51:00.000-07:00

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

SQL Developer 2.1 EA1

2009-09-24T20:22:00.000-07:00

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

Apex performance week over week

2009-04-13T14:15:00.001-07:00

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

Apex Listener

2009-02-16T13:53:00.000-08:00

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

2009-02-12T17:27:00.000-08:00

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

Carlisms

2008-10-31T11:36:00.000-07:00

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 respectme: hi carlback: hello me: howdy carlback: cool thanks me: you are on my

In Memoriam - Carl

2008-10-28T08:33:00.001-07:00

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.

Sqldev talk in St. Louis

2008-05-27T14:44:00.001-07:00

In case anyone reads this is in St. Louis there's a user group meeting Friday at Ameren details are here:http://www.missourioracle.com/

Clob read speeds over jdbc

2008-05-23T16:13:00.000-07:00

Thought I'd pass on some findings on clob read speed over jdbc.In sqldeveloper , when you select #clob# from #table# the tool shows the first ~80 chars of the clob. I spent part of the last 2 days timing the fastest way to read clobs from the db. I mostly work on remote databases so I notice when network latency start getting high. In looking at java.sql.Clob there's a few way to get the text. I

Who needs to store a password.

2008-04-17T12:32:00.001-07:00

In sqldeveloper 1.5, if you don't want to have the option of saving the password for a connection try this:Edit the sqldeveloper/bin/sqldeveloper.conf and add this:AddVMOption -Dsqldev.savepasswd=falseAdding this will remove the checkbox to have the ability to save the password. I added this a while back and forgot until a recent post on the forums reminded me. A customer needed to for some

Sorta off topic

2008-04-16T10:34:00.000-07:00

This is only Oracle in that it's at HQ in the lobby of the 500 building. I've been loading my pictures to flickr and found this one that I had forgotten about.

Which tnsnames?

2008-04-16T08:41:00.000-07:00

It seems to come up often that some people are unsure where the list of connections get picked up from. So, if your not sure which tnsnames file sqldev is using try this:1) Open any worksheetSqldev just needs someplace to process the next command and doesn't actually use the connection for anything.2) Enter : setloglevel oracle.dbtools.raptor.utils INFOThis sets the java logging level on for this

not it..

2008-01-10T21:54:00.001-08:00

I was wondering if I would get out of this since I only blog about once every couple months.Here goes 8 things.1. First pay back to Carl for tagging me... My son beat Carl at Burnout ( my son was 6 at the time )2. Made one of these a couple weeks ago with my son.3. I've jumped out of planes and helicopters4. I'm a ham , N1JLX. My first post to the internet shows that.5. I ride a Honda Valkyrie.6.

One of many ...

2007-12-05T11:20:00.000-08:00

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

Oracle Open World

2007-10-27T20:45:00.000-07:00

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

2007-10-24T16:42:00.000-07:00

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.

What's up

2007-06-08T08:38:00.000-07:00

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

2007-06-05T15:06:00.001-07:00

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:

SQL Injection scanners

2007-05-21T17:29:00.001-07:00

Here's a list of the free sql injection tools over on security-hacks.

Releases

2007-05-17T10:29:00.000-07:00

In the last week, the team has released 3 times.1) SQL Developer 1.1.3 was released2) Jdev 11 Preview was released where sqldev is built in3) SQL Developer Migrations EA #2 was minutes ago posted. If your running 1.1.3, you'll see the update balloon soon.However, I looked up some stats on usage and the majority of people are using 1.0.0 which was release March 2006. Here's the release notes for

Process a zip file

2007-05-15T16:02:00.001-07:00

Some one on the forum asked for an example of how to bulk upload files. Here is an example I used a couple years ago of processing a zip file and uploading the individual files into a table. Then we made an application to manage the file and followed "Create a Procedure to Download Documents" to download.Here's the sql for the table and sequence:create table docs(doc_id number,blob_content

New patch with APEX features

2007-05-10T10:23:00.001-07:00

I just pushed sqldeveloper 1.1.3. There's about 200 bug fixes in this build some more visible ones are here. There are a couple new things like a couple more sqlplus command supported , print , accept. The other thing that you will notice is new reports.Mike Hichwa added some reports for Application Express. So now you can easily see the applications you have access to and some details about

csv with sqldeveloper

2007-05-03T08:46:00.000-07:00

Laurent shows how to format a select * into csv.Give this a try in sqldeveloper, simply add a comment in the select and it's csv. See this:

Interactive Reports part 3

2007-04-16T16:27:00.000-07:00

The next step to having all these great reports in xml files would be to organize them. This one is the simplest by far. The name of the folder is split on the / and sub folders are made. This is very handy when a report gets into 100s of lines of xml since the reports can now be stored in multiple files but foldered together in the tool. Like in sqldev the "Data Dictionary Reports -> Database