OracleWorld 2003 - Wednesday

by Jonathan Gennick

Wednesday, 12:00PM, San Francisco


It's Wednesday morning, and this is the first dispatch I've had time to sit
down and write since my first
on Monday
.


Investing in our future: Accoss the aisle from the O'Reilly booth was
ThinkQuest, an organization funded
by the Oracle Foundation. ThinkQuest sponsers a nationwide web design competition
for students, and the
grand prize winners showed off their work at the show
. It's heartening to
see young people at a conference like this. My congratulations to all that participated
in the contest. You can view the winning web sites on the winner's
page
. The site I saw is the one on dairy farms. Actually it's part of the
larger, The Inside
Scoop on Farms
site. It's well done. Have a look, and be sure to check out
tipping cow cage on the page
about cows
.


Automatic space and memory management: Two new innovations in Oracle10g
are automatic space and memory management. You can now add storage to an Oracle
databases simply by adding a new disk to a pool managed by the database itself.
Data is striped across all disks, and when you add a new disk, the database
automatically moves data onto that disk to balance the I/O load. If you need
to remove a disk, you can have the database move data off it. The database can
also resize memory structures in the SGA automatically. I haven't delved deeply
into these features yet. Indeed, I've had a tough time even getting close to
the right people! The campground booths demonstrating the features have been
crowded every time I walk by.


HTML DB: Another campground booth that's been generally crowded is the
one demoing HTML DB. I'm very impressed with this product, and there's obviously
lots of interest in it. Using a web interface, a reasonably sophisticated end
user can develop a database application. Anyone who can develop for Microsoft
Access should be able to develop in HTML DB, and believe me, I'd much rather
develop for a database like Oracle that can scale than for a database like Access. Years ago I had to integrate an Access application with Oracle, and it was a very painful project. Mostly I wanted to run away screaming. It's good to see something like HTML DB that sophisticated end users can use instead of Access.


Optimizing Oracle Performance: Cary Millsap's session this morning on
trace data was well-attended. Cary is the author of our just-released book on
Optimizing Oracle Performance.


That's it for now. I'll try to write more later.