7 Replies Latest reply: Apr 8, 2013 5:03 AM by yasirdba RSS

    Can i store other data on disk where oracle installed

    yasirdba
      May be some one other had already asked this question but i didn't find it.

      We have window server2k8 with 1.5TB hard, we have three partition , two primary & one is logical.
      Oracle data size is 10 GB size, In production our system is transactional.

      My question:
      Is it better to make two partition of hard disk primary & logical partitions. Then Use primary partition for oracle installation and logical partition for data(any) storage.
      Does it has any effect on oracle performance.

      Edited by: 909855 on Mar 31, 2013 11:13 PM
        • 1. Re: Can i store other data on disk where oracle installed
          Maran Viswarayar
          Its always better to place the datafiles ,redologs and Archived redologs in separate luns

          How many harddisks you have and how they have been configured ?
          • 2. Re: Can i store other data on disk where oracle installed
            Kh$n
            How you configure storage??.
            • 3. Re: Can i store other data on disk where oracle installed
              yasirdba
              my question is not about storage of oracle data file, archive logs etc.
              actually i asking about other data (which i will transfer from other server to this server for backup purpose).

              if i will place this data on disk where oracle installed, Does it has any effect on oracle performance.
              • 4. Re: Can i store other data on disk where oracle installed
                Aman....
                909855 wrote:
                my question is not about storage of oracle data file, archive logs etc.
                actually i asking about other data (which i will transfer from other server to this server for backup purpose).

                if i will place this data on disk where oracle installed, Does it has any effect on oracle performance.
                The answer would be "it depends" . If that "other data" is just going to sit on the storage along with more active files like control files and redo logs, it probably won't do anything else except to grab the space but if it's going to get updated as well very quickly, it may impact the performance as it's going to make the disk even busier.

                Aman....
                • 5. Re: Can i store other data on disk where oracle installed
                  Justin_Mungal
                  909855 wrote:
                  May be some one other had already asked this question but i didn't find it.

                  We have window server2k8 with 1.5TB hard, we have three partition , two primary & one is logical.
                  Oracle data size is 10 GB size, In production our system is transactional.

                  My question:
                  Is it better to make two partition of hard disk primary & logical partitions. Then Use primary partition for oracle installation and logical partition for data(any) storage.
                  Does it has any effect on oracle performance.

                  Edited by: 909855 on Mar 31, 2013 11:13 PM
                  From a performance standpoint, creating separate partitions on the same spindles won't make a difference. I suggest you rethink your storage layout if this is a production Oracle database server, and if you're planning on using just one disk. Running everything from a single disk is bad not only for performance, but also for recovery. The following gives you an outline of the planning process for an Oracle Database:
                  http://docs.oracle.com/cd/E11882_01/server.112/e25494/create001.htm#ADMIN11071

                  Regarding I/O configuration and performance, the following will be helpful.
                  http://docs.oracle.com/cd/E11882_01/server.112/e16638/iodesign.htm#i20394
                  • 6. Re: Can i store other data on disk where oracle installed
                    Kh$n
                    No effect on performance it will only occupy space.
                    • 7. Re: Can i store other data on disk where oracle installed
                      yasirdba
                      i have one hard disk physical
                      on it have made three partition
                      one disk for OS
                      one disk for oracle
                      one for backup data from other server.