Performance issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Performance issue

  1. #1
    Join Date
    Oct 2001
    Location
    Stockholm, Sweden
    Posts
    33
    I was wondering if someone can tell me what's preferable in performance matter, when you determine where the "DB-files"
    should be placed?

    control01.ctl
    control02.ctl
    control03.ctl
    indx01.dbf
    rbs01.dbf
    redo01.log
    redo02.log
    redo03.log
    system01.dbf
    temp01.dbf
    tools01.dbf
    users01.dbf

    Which files should be on a different partition? Different disk?

    Does someone know?

    Any links to some documentation regarding this?

    Thanks
    /Johan


  2. #2
    Join Date
    Oct 2001
    Location
    Stockholm, Sweden
    Posts
    33
    By default the files all is placed in the sam directory....
    (typical installation)

    oradata/SID/..

    So the question is how important the placement of these files are...

    Someone with experiences?

    /Johan.....again..


  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    First of all you would want to spread your redo files, control files on to multiple disks. Then spread the index and the data into two disks. Then the others. Say for example that you have four disks, then you would juggle it accross the four disks and monitor the for the hot disks and then rearrange it.

    Plan your database
    Tuning I/O



    Sam

    [Edited by sambavan on 10-09-2001 at 10:57 AM]
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    I suggest you look for documentation on the Optimal Flexible Architecture (OFA). In addition, the Oracle DBA Handbook has a section devoted to your question.

    Here are some ideas:

    1. Put your control files on different disks if possible.
    2. Put your redo log groups on different disks.
    3. Separate your data and your indexes on different disks.

    Points 1 and 2 support easier recovery. Point 3 helps performance by distributing I/O over different devices.

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Oct 2001
    Location
    Stockholm, Sweden
    Posts
    33
    Thanks alot!

    But say for example I've already installed my DB on
    1 disk and "all files" under oradata.

    Is it possible to move these files without having to recreate the database?

    Do I do something like this?

    * Create some filesystems on new disks...
    * Stop the database..
    * Move th files to the new filesystems (redolog control..and so on)
    * Change the parameterfile initSID.ora (to point out the new paths)
    * Start the DB



    [Edited by johan on 10-10-2001 at 03:21 AM]

  6. #6
    Join Date
    Oct 2001
    Location
    Stockholm, Sweden
    Posts
    33
    I succeed in moving the controlfiles to a different filesystem
    since they was specified in the parameterfile. (initSID.ora)

    But how abouy my redolog-files?

    They aren't specified inte the "pfile"...

  7. #7
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    Hi,

    I think you have three loggroups with one member each. Am I right? You have to multiplex the redo log files with more members on another device. In this case you don't have to shutdown the database.

    ALTER DATABASE ADD LOGFILE MEMBER
    'another device:/some directory/redo01_2.log' TO GROUP 1;
    ALTER DATABASE ADD LOGFILE MEMBER
    'another device:/some directory/redo02_2.log' TO GROUP 2;
    ALTER DATABASE ADD LOGFILE MEMBER
    'another device:/some directory/redo03_2.log' TO GROUP 3;

    Good luck!
    Regards/
    Magnus

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