Hi to all,
I wonder if there’s a secret parameter to set a commit point for all the wmprocess table (and others).
When I look at the current oracle session, I can see that there’s lots of insert of this kind :
[highlight=sql]
insert into WMPROCESSSTEP (ROOTCONTEXTID,PARENTCONTEXTID,CONTEXTID,INSTANCEID,INSTANCEITERATION,
STEPITERATION,STEPID,STATUS,GLOBALDATA,SYSTEM,PIPELINE,AUDITTIMESTAMP,
SERVERID,USERNAME,ROLENAME)
VALUES(:v0,:v1,:v2,:v3,:v4,:v5,:v6,:v7,:v8,:v9,:v10,:v11,:v12,:v13,:v14)
[/highlight]
etc…
The insert iis very quick but, is there a way to commit every 1000 lines or more to have less access on these tables?
thank you for your help
Sylvain