Re: Opinion on "expert" DBA

I'd have a problem with this for a few reasons:

 The claim to being an expert. (There are always things to learn and knowledge to acquire about Oracle).

 The default settings: The extent sizing isn't quite as brutal as the 50% increase set at default. Ouch.
 An expert not knowing what a temp segment is?

 Hmmmm....an hour of work a day.....where is this place, I'd like to work there :-)
Like someone else posted, even if you aren't putting out fires or trying to prevent them, whatever happened to proactive learning and trying to find ways to make things work better? This person sounds lazy to me (if in fact they only do one hour of work a day).

 No documentation? Maybe that's why they are kept around, cuz no one could come in and figure it out.

 Cache hit ratios in my shop are only a part of what we are required to monitor and report.

 Not telling anyone they are upgrading? Oracle 8 and 8i are not the same thing, otherwise there wouldn't be a reason to upgrade. Hmmmm...wonder how snapshots are going to be implemented on 8.1?

 The reason you are even there is an indication that the place is in disarray...having development work being done on a Production machine. Unless it's been approved to be done that way, I would question that .... we don't allow it.
Just my .02 cents

Not trying to judge, but from what you say, alls I can wish you is good luck

blah wrote:

> What is the opinion here of a DBA who says they are an expert, yet the
> following is
> performance:
>
> 1. Default settings on all tablespaces, and tables carrrying over these
> defaults
> 2. Doesn't know how a temporary tablespace is set up (and thus sets up
> temp tablespaces as permanant objects).
> 3. Says they only perform an hour of DBA work each day -- with five
> multi GB databases.
> 4. Says the databases are "all running fine" and thus doesn't have
> anything to do.
> 5. Doesn't have any documentation on schema or monitoring
> 6. When asked about performance monitoring to MAKE SURE the databases
> are running fine, shows you a couple of shell scripts to check for cache
> hit ratios.
> 7. Says they want to upgrade to a new release of Oracle "without
> implementing the features or telling anyone they are upgrading". (in a
> 24X7 shop where at two of the applications aren't even supported on the
> realease). Doesn't know the new release either. Says it's just the
> same (i.e. Oracle 8 (running snapshots) vs. Oracle 8.1)
>
> etc. etc. etc.
>
> Just curious as to what is going on with this DBA, as I was brought in
> as a consultant to clean up a production machine that seemed to be used
> for both production and development. Sorry if this isn't an appropriate
> post for this board, but ....
Received on Sun Mar 19 2000 - 23:38:43 CST