« The Electric Bike Needs Maintenance | Main | Hey, I'm Outta Here »
July 13, 2006
Oracle XE and Other Stuff
Today Dale and I took a look at Oracle XE (Express Edition). This is the free edition of Oracle 10g and it has an http interface. It reminds me a bit of WebDB, not a good thing. In other words, the management functions and general interface are pretty limited. I tried to import a .dmp file and it couldn't import it.
Remaining questions are: Can you connect to this db with PL/SQL Developer? Can you connect using SQL Developer (formerly Raptor)? This db doesn't come with an Apache web server, but uses some form of http server - needs further investigation.
If we can get a more user friendly interface and also figure out some import strategies so we can get some data to work with, then we'll be able to give a better evaluation of this product.
In addition to exploring XE, we once again opened up OEM and worked on Aero's tablespace datafile allocations - making them more realistic compared to actual disk usage. I created the tablespaces with either 400 MB or 600 MB of disk space allocated. A few needed more, most needed far less, so we reclaimed a bunch of that disk space. We now have Aero's data storage pretty well allocated.
Posted by rossm at July 13, 2006 1:47 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)