Blog Aggregator - Amardeep Sidhu

Let’s deviate from 10G EM R2 for a blog or two. As I mentioned in an earlier discussion, we are in the beginning stages of testing Oracle ASM here at Giant Eagle. I thought I would provide you with some general information on ASM and why we are interested in it. In my next blog, I’ll show you our ASM test plan.

I made the big-time! Tom Parrish recently interviewed me for a DBAZine Podcast. I think streaming audio Podcast’s are an exciting addition to the web experience. Tom and I talk about my newly received Oracle Ace title, technology advancements in the retail industry, blogging, outsourcing and the changing role of the DBA. Oh, and we also talk about what to do, and what NOT to do, when giving presentations.

One of the features that was missing in 10G R1 was a tool that allowed administrators to generate reports on system related information. 9I OEM’s reporting feature could be described as somewhat rudimentary but it got the job done. That job was to quickly generate pre-created and AD-HOC reports using one, or more, database targets as input. Although 10G R1 is far superior to its 9I OEM counterpart, its reporting functionalities were limited.

10G Grid Control R2 comes to the rescue with a new reporting capability that makes 9I OEM’s reporting capabilities pale in comparison. Let’s face it, DBAs have too much to do. The less time we have to spend retrieving information we need to make decisions, the more time we have to make them.

Last week, we discussed 10G Grid Control R2’s feature that allows us to run host commands against multiple targets at the same time. 10G Grid Control R2 also provides an easy-to-use panel that allows administrators to run SQL scripts against multiple database targets simultaneously. Just like its host command counterpart, all we need to do is code up a SQL statement, choose a set of database targets, run the SQL against the multiple targets and review the output. Simple as can be.

A weird combination of topics to start the New Year on but I think it is important for us to cover a few interesting enhancements contained in 10G R2 Enterprise Manager.

In addition, we are starting our official ASM (Automatic Storage Management) evaluation project . The end result of the project would be the conversion of 10.2 Terabytes of disk to Oracle ASM. Could make for a very interesting set of blogs, don’t you think?