Eye on Oracle

Mar 9 2007   8:52AM GMT

Your Oracle wish list

Derek Kuhr Derek Kuhr Profile: Derek Kuhr

At one time or another, most of you have probably checked out the Ask Tom Web site. Like our own Ask the Expert feature, Tom Kyte’s Ask Tom site is a go-to when you’re stumped by an Oracle problem, like resolving an error or writing a complex SQL query. All the old questions are archived, and frequently, answers continue to be updated years after the questions were originally asked.

For example, in September 2005, an Ask Tom user, Alex, asked Tom the following:

I was wondering if there are some things you don’t like about Oracle? I personally wish more things came set up out of the box such as autotrace, intermedia text, scott schema etc. Any thoughts on this?

Tom named some gripes (he called for better error messages, for instance) and then wrote, “I’ll publish this to see what others add.”

Many, many Oracle users have added to the list since then. Some of the problems have already been resolved — one of the first to comment requested better cross-platform data file compatibility. 10gR2 now allows cross-platform full database transports with the same endianness.

The most recent complaint was added just a few days ago. Tim Kessler requested a polling option in SQL*Plus to continually execute a SQL statement for a given interval for monitoring functions.

What about you? What’s on your Oracle wish list? What bug slows you down? What one feature would make your life as an Oracle DBA easier?

-Elisa, Assistant Editor

4  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Dave Lock
    I have two for you, Command Line recall in SqlPlus, (I started out on Oracle 6.0 many moons ago and after a few years moved into other areas, I didn't come back to Oracle until 10g and was amazed and dissappointed how little SqlPlus as changed in all those years. The second gripe/wish, how about a nice simple tool to "shrink" the System tablespace?
    0 pointsBadges:
  • Irvin
    Hi All, On the wish list it should be done something about sqlplus on unix and linux regarding the history 1 line in the buffer this is not enough. I'm dreaming to get something modern like bash is for the shell which means more longer history and possibilities to keep the history like isqlplus
    0 pointsBadges:
  • Susan Giordano
    I would like jobs scheduled via the Oracle Job Scheduler to be able to run when the system is in restricted sesssion. This inability is apparently a "feature". Makes no sense to me...
    0 pointsBadges:
  • Andras Gabor
    I have 2 comments on the sqlplus buffer requests: - on windows: if you use the sqlplus with cmd.exe (that is not sqlplusw.exe but sqlplus.exe) you get the functionality fine. - on linux/unix you can use rlwrap with most command line utility to add line buffering.
    0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: