Performance - EBS (MOSC)

MOSC Banner

How to estimate index creation time required?

edited Mar 27, 2012 9:55AM in Performance - EBS (MOSC) 1 comment
Hi,

I have to create 2 indexes on ORABPEL schema's INVOKE_MESSAGE and DML_MESSAGE tables(1 each)

I tried to create 1 on INVOKE_MESSAGE yesterday w/o taking application outage,but got stuck due to lock acquired on INVOKE_MESSAGE  by another session.

Now my requirement is to estimate  time required to create the index ?

Is there any way that I can calculate it?

I am planning to use below script:

create index HEADERS_REF_IK on ORABPEL.INVOKE_MESSAGE(HEADERS_REF_ID)  TABLESPACE ORABPEL  PARALLEL 16  NOLOGGING;

--After index creation

alter index  HEADERS_REF_IK parallel 1;

NAME                                 TYPE        VALUE

parallel_max_servers       integer     320

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center