« New InSite Web Site in Place | Main | Hawaii Calls »
February 16, 2007
Playing With 10g
This Thursday, Dale and I met for our Thursday morning staff development time. You know we were anxious to tear into the 10g database and see what we could do. The Oracle Enterprise Manager (OEM) for 10g is web based, and quite comprehensive. For years I have been trying to get the 9i OEM to run as more than a stand alone, with no luck, and here we have a really nice OEM interface right out of the box.
So far, Dale and I have performed a number of DBA management tasks on the 10g database. We have created several LMT's (locally managed tablespaces), created a bunch of new users, imported some fairly decent sized tables, and dropped and recovered a couple tables using Flashback - another 10g improvement. Starting from scratch it took us less than 5 minutes to restore a dropped table. Very nice!
One other thing we looked at on Thursday was the Metrics section. There is a huge amount of data kept on the database, and it is somewhat confusing, however, we did manage to reset one metric limit to keep it from throwing an alert every two minutes. The metrics area will be a lot more useful once we have a production instance going.
Posted by rossm at February 16, 2007 2:44 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.)