DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Common questions to ask the developers..

  1. #1
    Join Date
    Aug 2002
    Posts
    15

    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Jan 2001
    Posts
    3,134

    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.

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    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

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  7. #7
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    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

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925


    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
  •  


Click Here to Expand Forum to Full Width