-
Common questions to ask the developers..
Hi,
I have to move a few databases from dev to test and production.I want to have the test environment setup as prod.I am not assosiated with development in any way.I want to ask the developers questions like
a) DB SIZING :
a) what are your largest tables
b) how many tables have LOBs.
b) PL/SQL :
a) how many stored procs
can any body suggest a check/standard doc that I can read ?
Thanks,
copernicus
-
Don't you have access to the database on the dev. All the questions that you have raised can be answered by a DBA and not the likely the developers
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Common questions to ask the developers..
1) I'm sorry, were you dropped at birth?
2) Has you medication kicked in yet
3) First day with the new hands?
4) Brain farts are a bitch huh?
5) Your kidding right?
6) You want it WHEN!? (Followed by loud inappropriate laughter)
7) Of course, this couldn’t be a coding issue so it MUST be an Oracle problem, right?
Anyone else?
MH
I remember when this place was cool.
-
You can find out this information with Oracle Enterprise Manager or using the dictionary tables like DBA_OBJECTS.
David Knight
OCP DBA 8i, 9i, 10g
-
1) Analyze all tables in development to get the statistics (average row length).
2) Ask developers the maximum expected number of rows for each table.
3) Ask for the monthly/weekly/anually expecteg growth rate.
4) Based on the above, compute the expected size for each table.
HTH.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally posted by LKBrwn_DBA
1) Analyze all tables in development to get the statistics (average row length).
2) Ask developers the maximum expected number of rows for each table.
3) Ask for the monthly/weekly/anually expecteg growth rate.
4) Based on the above, compute the expected size for each table.
HTH.
Aren't these the problems of a DBA than a Developer, who has the indepth access to the instances?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Originally posted by sambavan
Aren't these the problems of a DBA than a Developer, who has the indepth access to the instances?
Sam
1 and 4 are done by the DBA, but 2 and three have to be requested from the persons most familiar with the application.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|