Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2004
    Posts
    3

    Question Unanswered: Creating a database

    We one database and many tables in it but all in one dbspace.

    How many dbspace I need to create?
    Which tables in which dbspace is more performance.
    Are there any database model about it?

    Many thankssssss..... :-)

  2. #2
    Join Date
    Nov 2004
    Posts
    4
    Hi.

    You need create more less 7 dbspaces:
    1 - rootdbs,
    2 - logdbs,
    3 - phydbs,
    4 - datadbs,
    5 - indexdbs,
    6 - tempdbs1,
    7 - tempdbs2.

    Using to database: create database name_data in datadbs;
    using to table: create table name_table (......) in datadbs;
    Using to index: create index name_index ...... in indexdbs;


    Sorry, i dont model.

  3. #3
    Join Date
    Dec 2004
    Posts
    3

    only for data dbspaces...

    Many thanks for reply!
    But I referenced about data dbspace; so how many tables for data dbspaces, or which tables in each datadbs?? (without take in account rootdbs, logdbs, phydbs, indexdbs, tempdbs1, tempdbs2...)

    Thanks again!

  4. #4
    Join Date
    Nov 2004
    Posts
    4
    Good, it does not have as to define an amount of tables for dbspaces.
    The recommended one is separates the tables that tend to grow very, of the proper others, creating if necessary, dbspaces for each one.

    I know that not aid very, but I go to see if I find a model and you sending.

  5. #5
    Join Date
    Dec 2004
    Posts
    3
    Many thanks mroberto!
    Pls, if you have any model or template pls send my. Thanks again!

  6. #6
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Also keep in mynd the extent sizes for the tables when you recreate them, and try to place you high use tables on the center tracks of the disk.

    Cheers

    Artem

Posting Permissions

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