Database Software

Hi guys,

Snapshot creation in OWB 11g is taking too much time. I just tried with adding 1 mapping and it took about 2-3 minutes.

OMB+> OMBCREATE SNAPSHOT 'Test1' ADD MAPPING 'M_TEST'

I checked in session views and found the below query taking most of the time -

insert into LWCONTEXT (snapshotID, compuoid, type, elementid, rootid, uoid, role, physicalName, logicalName, classname, metadatasignature, objType, associd, assocUOID, assocRole, assocPhysName, assocLogName, assocClassName, assocType, diffCol, assocCol) select /*ordered use_nl(cmp1)*/ 83770, lc.compuoid, lc.type, lc.elementid, lc.rootid, lc.uoid, lc.linkfromrole, lc.name, lc.logicalName, lc.classname, lc.metadatasignature, lc.objtype, cmp1.elementid, cmp1.uoid, lc.linktorole, cmp1.name, cmp1.logicalname, cmp1.classname, 2, lc.uoid, cmp1.uoid from (select /*ordered use_nl(inter)*/ t.compuoid, t.type, t.elementid, t.rootid, t.uoid, t.name, t.logicalName, t.classname, t.metadatasignature, t.objtype, inter.linkfromrole, inter.linktorole, inter.linkto from temptable t, INTERLINK inter where inter.linkfrom = t.elementid) lc,CMPELEMENT_V cmp1 where lc.linkto = cmp1.elementid

I did an explain plan, and it looked ok to me.

Has anybody faced the same issue in 11g or earlier releases?

Is there a way to make it go faster?

regards
Sudhanshu