| During ADD Constraints [message #318814] |
Thu, 08 May 2008 01:26  |
vishal_srivastava
Messages: 20
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 #318815 is a reply to message #318814 ] |
Thu, 08 May 2008 01:32  |
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | Where should i monitor the progress of creation
|
Nowhere.
| Quote: | where should i check about ,HOW MUCH SPACE IT IS TAKING.
|
Why UPPER CASE?
DBA_SEGMENTS
| Quote: | Tell me method to fast (constraints addition) on large tables.
|
Use PARALLEL, if you have disks and cpu enough.
Regards
Michel
|
|
|
|
| Re: During ADD Constraints [message #318970 is a reply to message #318815 ] |
Thu, 08 May 2008 09:54 |
JRowbottom
Messages: 2663
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).
|
|
|
]
Members
Search
Help
Register
Login
Home
