During ADD Constraints [message #318814] |
Thu, 08 May 2008 01:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vishal_srivastava
Messages: 21 Registered: January 2008
|
Junior Member |
|
|
Hi, All
I am adding primary key on 3 columns.The table size is 4GB.
I have used ENABLE NOVALIDATE.
Where should i monitor the progress of creation or where should i check about ,HOW MUCH SPACE IT IS TAKING.
Tell me method to fast (constraints addition) on large tables.
Thanks in advance.
|
|
|
|
|
Re: During ADD Constraints [message #318970 is a reply to message #318815] |
Thu, 08 May 2008 09:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You can monitor it using the v$session_longops view.
A PK index creation will do two Table Scans and a Sort Output (or at least that's what my test here did).
|
|
|