Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    6

    Unanswered: Parallel process job become single process job !!!!!!

    Hi, expert

    I send a parallel job at oracle DB yesterday. I saw the system starting parallel process from toad.
    But a few moment, the parallel became single job and waiting and the wait event dispaly db file sequential read.

    Can any one tell me how to fix this problem?
    I'll very appreciate.

    Thanks.

    Best Regards.
    Thomas Chang

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112
    Is it a query that you are talking about ? if yes, check explain plan with attention of the P(arrallel) => S (erial) operation

Posting Permissions

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