No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 900
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48741
Total active users1338
Act. users last 24h6
Act. users last hour0
Registered user hits last week145
Registered user hits last month435
Go up

Number of DBA per Enviroment
Next thread: date, when the Role is delete from db
Prev thread: 19c (19.5.0.0) install

Message Score Author Date
Good Day Anybody has a link or report that give...... Stan M Aug 19, 2021, 20:40
Hi Stan, I would say one Bruno, 1/2 Michel, ...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Joël Péran Aug 25, 2021, 10:39
Oh, Joël, you are kidding but don't forget: "<i...... Bruno Vroman Sep 01, 2021, 11:04

Follow up by mail Click here

Subject: Number of DBA per Enviroment
Author: Stan M, South Africa
Date: Aug 19, 2021, 20:40, 648 days ago
Os info: Any
Oracle info: 19c
Message: Good Day

Anybody has a link or report that gives a guidline on how many dba's are needed for a certain number or sizes of Oracle databases.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Number of DBA per Enviroment
Author: Joël Péran, France
Date: Aug 25, 2021, 10:39, 642 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message: Hi Stan,

I would say one Bruno, 1/2 Michel, and about 100 Stan :)
Regards
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: Number of DBA per Enviroment
Author: Bruno Vroman, Belgium
Date: Sep 01, 2021, 11:04, 635 days ago
Message: Oh, Joël,

you are kidding but don't forget: "it is never too early to be kind, as we don't know when it will be too late" ;-)

Stan, your question has no simple answer, the size of a database is not a good indicator of the amount of DBA work it needs; activity would be a better correlated characteristic but anyway...

I have large databases (well, "large" compared to the average of DB where I work) that don't need much attention (a lot of historical data, regular load of new data, well known and stable usage, taking benefit of partitions...), and I have some -especially 1 ;-( smaller databases that cause me headaches, with very active but not very skilled developers, or "half-crazy" users...

One advice: as much as possible try to enforce "standards": do the same things in various databases the same way; exceptions are time consuming and source of difficulties, issues.

Best regards,

Bruno.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here