Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    17

    Unanswered: DB from point of design, manageability, scalability/performance and high availability

    1.Database deployment architecture (assuming 3 million customers):
    a.What’s recommended number of databases and instances with the assumed volume?
    b.What’s the recommended database block size? Are they identical for each database and set of tables?
    c.Is there any dependency that 2 or more databases must (or preferred) be in the same node (due to application dependency, etc.)? If so, why? Documents available? This becomes a non-issue if only one database.
    d.Is it advisable that 2 or more databases could be merged into one physical database? If so, any potential scalability and maintenance issue? Any database configuration issue (init.ora, RBS contention, schema conflict, temp table, etc.)? This becomes a non-issue if only one database.
    e.Any recovery related dependency among databases? If so, documents available? This becomes a non-issue if only one database.

    2.Projected Hardware Capacity requirements (per suitable business unit – e. g. per 1M customers):
    a.CPU
    b.Memory
    c.Disk

    3.Recommended database data file: UNIX file system vs Raw disk (if raw disk – why?)

    4.Oracle Partitioning:
    a.If used: briefly discuss partitioning key and types of indexes
    b.If not used: reason for not using? potential for future?

    5.Recommended instance parameters (init.ora)

    6.Indexes:
    a.Identify all types of indexes used
    b.If non-B Tree indexes used then brief reasoning and any concerns

    7.Database connection technique: Dedicated/Connection Pooling/MTS

    8.Database memory (SGA) requirements and management:
    a.Library Cache
    b.Buffer Pool
    c.Other areas

    9.Scalability (database):
    a.Review available measurement data
    b.Potential concerns

    10.Oracle Release upgrade plan – a roadmap

    11.Oracle optimizer to be used to performance tune the queries

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: DB from point of design, manageability, scalability/performance and high availability

    Originally posted by karraaruna
    1.Database deployment architecture (assuming 3 million customers):
    a.What’s recommended number of databases and instances with the assumed volume?
    b.What’s the recommended database block size? Are they identical for each database and set of tables?
    c.Is there any dependency that 2 or more databases must (or preferred) be in the same node (due to application dependency, etc.)? If so, why? Documents available? This becomes a non-issue if only one database.
    d.Is it advisable that 2 or more databases could be merged into one physical database? If so, any potential scalability and maintenance issue? Any database configuration issue (init.ora, RBS contention, schema conflict, temp table, etc.)? This becomes a non-issue if only one database.
    e.Any recovery related dependency among databases? If so, documents available? This becomes a non-issue if only one database.

    2.Projected Hardware Capacity requirements (per suitable business unit – e. g. per 1M customers):
    a.CPU
    b.Memory
    c.Disk

    3.Recommended database data file: UNIX file system vs Raw disk (if raw disk – why?)

    4.Oracle Partitioning:
    a.If used: briefly discuss partitioning key and types of indexes
    b.If not used: reason for not using? potential for future?

    5.Recommended instance parameters (init.ora)

    6.Indexes:
    a.Identify all types of indexes used
    b.If non-B Tree indexes used then brief reasoning and any concerns

    7.Database connection technique: Dedicated/Connection Pooling/MTS

    8.Database memory (SGA) requirements and management:
    a.Library Cache
    b.Buffer Pool
    c.Other areas

    9.Scalability (database):
    a.Review available measurement data
    b.Potential concerns

    10.Oracle Release upgrade plan – a roadmap

    11.Oracle optimizer to be used to performance tune the queries
    Blimey, you don't want to know much do you?
    Sounds like to need to hire a consultant systems architect / DBA rather than post a question on a message board!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •