OraFAQ Forum: Server Administration » During ADD Constraints

Home » RDBMS Server » Server Administration » During ADD Constraints (Solaris9,Oracle 9.2.0.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

During ADD Constraints [message #318814]

Thu, 08 May 2008 01:26

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.

Report message to a moderator

Re: During ADD Constraints [message #318815 is a reply to message #318814]

Thu, 08 May 2008 01:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: During ADD Constraints [message #318821 is a reply to message #318815]

Thu, 08 May 2008 02:01

vishal_srivastava
Messages: 21
Registered: January 2008

Junior Member

Thanks

Report message to a moderator

Re: During ADD Constraints [message #318970 is a reply to message #318815]

Thu, 08 May 2008 09:54

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).

Report message to a moderator

Previous Topic:	Database link in use
Next Topic:	dbms_resource_manager

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 02:06:50 CST 2024