Hi Guys,
Hmmm this is really wonderful see each one of them justifying their answers. Truly I agree to what each one of them has said in this thread. DBA synonymous to doctors, insurance providers and what not.
Printable View
Hi Guys,
Hmmm this is really wonderful see each one of them justifying their answers. Truly I agree to what each one of them has said in this thread. DBA synonymous to doctors, insurance providers and what not.
hi guys and oracle gurus !!!
I agree what u say , but there lies one question which is hidden
One point of time , database is going to be stable, that has been said by many of experts in this thread
So when the dba who is paid on hourly basis , or dba who are supposed to fill in activity sheet for task/ job done/ activities done done during the day or week what tasks he will be filling in the details , once the database is stable. ? --- Just monitoring for 8 hours !!!
-- Gayatri
really? I havent seen a single DBA who monitors databases only. Have you seen any or you know any?
Yes, thats what you should put down. http://www.plauder-smilies.de/madgo.gifQuote:
Originally posted by Gayatri
So when the dba who is paid on hourly basis , or dba who are supposed to fill in activity sheet for task/ job done/ activities done done during the day or week what tasks he will be filling in the details , once the database is stable. ? --- Just monitoring for 8 hours !!!
yes , Fact is fact , one must write monitoring as a activity in that case
-- GURUDAS SHENOY
Zurich , Switzerland. :)
As several of the other contributors pointed out, few full time dba's have only one database.
Depending on your definition of database (Microsoft's vs Oracle) I support either 61 or 189. Not counting Access.
For every database that has reached some sort of stability, there are new ones going in, old ones being decommissioned (project manager: i didn't know we used those tables, can you put them back until our new software can do something aobut it?) upgrades and power failures.
Variation on an earlier statement. No database survives contact with it's users.
User change. User requirements change. Businesses change. Releases change. Platforms change.
In reality, the stability you seek (or is it nirvana) is achieved at the end of the last tuning/recovery/maintenance session. Usually at 3 am. But it only lasts until the users get in to work about 8 am. If one is really lucky, it is 3am Saturday to 8 am Monday, but I'll settle.
I have just been reading this thread but now I think I will contribute
I would like a show of hands from everyone who has a "stable" database. I have never seen one and I want to shake the hand of the DBA who has one.
As a DBA, if you can keep users happy, have the database tuned perfectly, convince the company upgrades are no longer needed and new systems do not need to be created then you deserve to monitor for 8 hours a day because even god got to rest on the 7th day.
A DBA's job is a dynamic one, I will be the first to admit someday's you may have to find ways to fill your day such as reading up new features and honing skills you haven't used in a while or monitoring but the majority of your time is spent working on current or upcoming projects.
We have over 200 Oracle instances here and most are "stable" but I didn't spend my day monitoring. I installed Oracle on a Sun box to test a new version of Solaris for an upcoming upgrade, installed Oracle client on another to test a new version of Cognos reporting tools. There is always something to do in a dynamic environment. If you have a server room of stable system's I would say its time to get out of the company because they have limited user's, and no vision for the future. Things are always changing that effects a DBA's job, not only database but OS, hardware and network.
At least my job as DBA is getting more dynamic, I dont only have to take care of databases now, I have to sort of administer, configure iAS now what a nightmare!
And sometimes, people think you know everything about Oracle (both development, sql, pl/sql and administration) if they heard you are a DBA sigh...
Gayatri after 100+ replies, you return back to your first question!!! First of all ,we are living in real world not in a dream world that you think nothing will happens and just 8 hours monitoring. There is no DBA I know that not do to Developers coaching, I recieve at least 10 call/emails each day from developers. Second why you so obsess about timesheet and worksheet, Yes I proudly put 8 hours monitoring and developers coaching and researching new features in my timesheet , nothing else. Nothing wrong with that, hope you understand finally!!!!!!
And I would say, it's time to take a cup of coffee and surf over the Internet for a while, answer some messages in the Oracle forums for instance :-)Quote:
If you have a server room of stable system's I would say its time to get out of the company because they have limited user's, and no vision for the future.