Posted by: Derek Kuhr
Oracle database administration, Oracle development
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