Welcome! This is a website that everyone can build together. It's easy!

Location: The Oracle DBA... A dying breed?

Discussion: What I need...

Keyword tags: None

Watch

Anonymous  (Get credit for your thread)
oraclebase
oraclebase		 What I need...
Nov 28 2007, 8:48 AM EST
Kevin Little said (posted by me):

Original post: http://www.oracle-base.com/blog/2007/11/22/the-oracle-dba-a-dying-breed/#comments

Looking at it from a change management perspective, every change I implement has to be a file checked into a PVCS source base and submitted through peer review and management approval processes. sql/ddl scripts edited with vi or notepad and deployed using sqlplus, the same sort of thing I did in Oracle 7 years ago. So for this GUI tools like OEM Grid that make changes easier to do with a few mouse clicks don’t help so much, it just contradicts our change management discipline.

What I look for is not so much a tool for a DBA to make it easier to do DBA stuff, what I need is more like a tool that is useful for communicating/collaborating with the other teams that I regularly interact with, which includes Developers, SysAdmins, Incident Management, Change Mangement, Help Desk, Network, Security, Architecture&Engineering and Finance.

What I really need is to set up monitoring/reports/alerts that I can show to or give access to those other team members to see online. I’m looking at OEM public reports, though notably not many of the out-of-the-box reports are very useful to communicate outside of the DBA team usually being too complicated and focusing on the Oracle internals, when what I need is simpler. I need to break it down to a few simple pie charts we can present to Architecture and Finance to justify why we need to purchase more disks or memory or such. Or a report I can generate to Network showing the frequency of dropped sqlnet connections. Or to get really simple, bunch of green (up) / red (down) lights next to a list of database and associated application names, which would be useful to Help Desk and Incident Management to direct triage of problems. 1  out of 1 found this valuable. Do you?    
oraclebase
oraclebase		 RE: What I need...
Nov 28 2007, 8:56 AM EST
Some of the Enterprise Manager performance graphs are simple enough to show to non-DBA staff. Also, the ADDM reports are fairly human readable. :)

I agree change management can be harder when you have to reduce everything to a script in a version control system, but some changes you can perform in Enterprise Manager, show the SQL, but not actually proceed with the changes. So for simple changes EM might actually be able to write your script for you...

You can set up multiple users in EM, each with different levels of privilege. You may find it beneficial to create locked down users in EM for specific people so that they can see information first hand.

SQL Developer allows you to generate user-defined reports in the form of charts. It would be up to you to define the SQL, but you may be able to get some interesting and, most important, simple stuff out of that.

Cheers

Tim... Do you find this valuable?