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

Thread: Impact on file system

  1. #1
    Join Date
    Sep 2006
    Location
    London
    Posts
    58

    Impact on file system

    I have seven files systems on unix server used for storing data files of our three databases and other purpose. One of the file system /u02 occupy 100% with data and /u03 occupy 94% data on the /u03 file system. We have added one more disk to grow the database files.

    But, there are so many existing old data files resided at mentioned file systems /u02 and /u03.

    Does it require to make room in the mentioned file system? i.e /u02 and /u03

    If not, what would be the impact in terms of storage, performance etc.

    Your suggestion would be appreciated.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You would do well to make sure that the files are fairly evenly distributed over the available devices, to avoid particular disks being more heavily accessed than other.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2006
    Location
    London
    Posts
    58
    How can I check it on your described suggestion?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    look at your iostats

  5. #5
    Join Date
    Sep 2006
    Location
    London
    Posts
    58
    you mean IOstat from OS level or through Database side.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    both

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