This discussion is archived
4 Replies Latest reply: Jan 28, 2013 12:35 AM by 985694 RSS

Datafile parallel management

985694 Newbie
Currently Being Moderated
Hi,
I would like to know whether ORACLE (11g and previsus versions) is able to manage parallel writes on datafiles belong to the same tablespace?
For example, suppose to have one tablespace named TEST within 4 datafiles. Oracle is able to write data that belong to 4 different transactions in the parallel way?

If this is possible, anyone could tell me how many datafiles set when I create a new tablespace?

Many thanks
  • 1. Re: Datafile parallel management
    orawiss Oracle ACE
    Currently Being Moderated
    Hi,

    Oracle online documentation is your best friend;

    http://tahiti.oracle.com/


    Also have a look into :

    http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-parallel-execution-fundamentals-133639.pdf
  • 2. Re: Datafile parallel management
    JohnWatson Guru
    Currently Being Moderated
    982691 wrote:
    For example, suppose to have one tablespace named TEST within 4 datafiles. Oracle is able to write data that belong to 4 different transactions in the parallel way?
    It doesn't work like that. There is NO correlation between transactions (committed or not) and disc writes.
    If you are asking "can the database writer process write to multiple files concurrently", the answer is "it does asynchronous writes, so provided the operating system can do concurrent writes, that is what will happen".
  • 3. Re: Datafile parallel management
    UweHesse Expert
    Currently Being Moderated
    When your datafiles are stored on RAID respectively ASM, it doesn't matter for performance how many datafiles your tablespace is made of.

    One big datafile (we have even introduced BIGFILE TABLESPACES in 10g) is OK to have in Oracle.
    The question is whether your storage & backup strategy can handle the big file - the Oracle Database for sure can, no worries on that layer.

    Kind regards
    Uwe Hesse

    "Don't believe it, test it!"
    http://uhesse.com
  • 4. Re: Datafile parallel management
    985694 Newbie
    Currently Being Moderated
    Ok, many thanks for you answers.
    Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points