Home » RDBMS Server » Server Administration » During ADD Constraints (Solaris9,Oracle 9.2.0.8)
During ADD Constraints [message #318814] Thu, 08 May 2008 01:26 Go to next message
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 #318815 is a reply to message #318814] Thu, 08 May 2008 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 #318821 is a reply to message #318815] Thu, 08 May 2008 02:01 Go to previous messageGo to next message
vishal_srivastava
Messages: 21
Registered: January 2008
Junior Member
Thanks
Re: During ADD Constraints [message #318970 is a reply to message #318815] Thu, 08 May 2008 09:54 Go to previous message
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).
Previous Topic: Database link in use
Next Topic: dbms_resource_manager
Goto Forum:
  


Current Time: Thu Dec 08 22:20:41 CST 2016

Total time taken to generate the page: 0.10584 seconds