| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exchanging partition takes a lot of times
See the book - chapter 12, page 250.
It's normal behaviour. There is one bizarre
SQL run if you do the exchange
"without validation" and another (usually cheaper)
if you do it "with validation".
This relates to checking primary and unique keys, rather than the partitioning constraint.
The solution/workaround is to set the constraints to a RELY ENABLE NOVALIDATE. But the last time I checked you still got problems with partitioned tables in involved in parent/child relationships.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: 11 April 2002 17:17
I'm testing the exchange partition and it's taking 90 seconds to exchange a table containing 700 000 rows with a partition containing also 700 000 rows.
I've noticed that SYS is doing a crazy select to check on the PK of the tables even if I used whitout validation in the exchange statement.
I this normal behavior ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: jonathan_at_jlcomp.demon.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 11 2002 - 14:58:26 CDT
 |
 |