Oracle 10g: Top Goodies and Gotchas - Page 2

By Lisa Vaas  |  Posted 2004-07-06 Print this article Print

Fair enough—those are the time-savers to which we can look forward. But what about the top gotchas? What should DBAs look out for when working in 10g? Heres that list:
  • Automated features dont quite replace an experienced DBA. Rather than blindly following all ADDM suggestions, for example, DBAs must monitor the AMM to make sure its not overallocating memory areas, Ault suggests. Use ADDM suggestions as guidelines for tuning, based on your own knowledge of the database being tuned.
  • Verify all backups by performing recoveries.
  • The EM interfaces are nice, but knowing the underlying data dictionary is still critical.
  • Start the ASM instance first and shut it down last. "ASM controls access to the disks," Ault says, "and if the ASM instance is not started, none of the other databases can mount their data files. If the ASM instance shuts down, all of the other dependent databases will crash. Another thing to watch out for in ASM is that, at least for now, you must use the EM interface and RMAN to back up a database that uses ASM."
  • Watch out for everything you always watched out for. That includes ensuring that you have enough disk space, watching the placement of ASM RAW devices for file I/O balancing (replacing watching the placement of data files), and making sure that all appropriate OS and Oracle patches are applied.
Oracles rolling out 10g to Apple developers. Click here to read more. Next page: The wouldnt-it-be-nice list.

Lisa Vaas is News Editor/Operations for and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel