Re: Diff between utlxplp.sql and utlxpls.sql ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Dec 2005 09:18:44 -0800
Message-ID: <1135358306.206109@jetspin.drizzle.com>

Raaj wrote:
> Dear Daniel,
>
> I know utlxplp.sql works parallel and utlxpls.sql works
> serial. What are those parallel and serial. You have mentioned utlxplp
> shows parallel query information. "What are those parallel query"?
>
> I am new to Oracle.
>
> Thanks for all,
> Raaj

Parallel DML

---

Parallel execution dramatically reduces response time for data-intensive operations on large databases typically associated with decision support systems and data warehouses. In addition to conventional tables, you can use parallel query and parallel DML with range- and hash-partitioned tables. By doing so, you can enhance scalability and performance for batch operations.

The semantics and restrictions for parallel DML sessions are the same whether you are using index-organized tables or not.

Source:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14220/partconc.htm#i464835

Use the Oracle search engine at http://tahiti.oracle.com when you have basic questions.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Dec 23 2005 - 11:18:44 CST