This discussion is archived
3 Replies Latest reply: Oct 3, 2012 6:26 AM by Paul Fowler RSS

Can anyone suggest how to fix batch processor performance?

Paul Fowler Explorer
Currently Being Moderated
The DBA's examined the OPA batch process while it was running. Oracle was sitting idle most the time waiting on the batch processor (according to the DBA staff.) Locks were not an issue and the DB was not under any load.

The performance is absolutely dismal and we are going to open an OPA support ticket, but would like a quick answer if anyone on this forum has a quick answer.

(Also, if you try to kill the batch job with <ctrl-c> because it is taking too long, then it leaves the sessions and cursors open. Is there a way to gracefully shut down the batch processor?)

We have a single simple table where the first 5 columns are conditions and the last column is a conclusion.

I filled the table with 1,000,000 rows of conditional data. I ran with a configuration like below:

<configuration>
<options>
<rulebase>../output/MyRules.zip</rulebase>
<database>
<url>jdbc:oracle:thin:myusername/mypassword@mydatabase:1521:mySID</url>
<driver>oracle.jdbc.OracleDriver</driver>
<driversrc>\myjdbcdriverpath\ojdbc6.jar</driversrc>
</database>
<output type="db" />
<mappings>
<boolean-format true-value="TRUE" false-value="FALSE" />
<mapping entity="global" table="SSPNA_IN" primary-key="ID">
<attribute name="bHasNoCountableIncome" field="BHASNOCOUNTABLEINCOME" />
<attribute name="bIsResidentOfNY" field="BISRESIDENTOFNY" />
<attribute name="cSSIBenefitAmt" field="CSSIBENEFITAMT" />
<attribute name="tFedLivingArrangementCD" field="TFEDLIVINGARRANGEMENTCD" />
<attribute name="tManualHMOInd" field="TMANUALHMOIND" />
<attribute name="tPaymentStatusCD" field="TPAYMENTSTATUSCD" />
<attribute name="tPrincipleProviderCD" field="TPRINCIPLEPROVIDERCD" />
<attribute name="cSSPNAPayment" field="CSSPNAPAYMENT" output="true" />
</mapping>
</mappings>
</options>
</configuration>
  • 1. Re: Can anyone suggest how to fix batch processor performance?
    752683 Newbie
    Currently Being Moderated
    This is definitely not something we've seen in the testing environment.

    Can you please raise a SR via Oracle Support and provide the following information?

    1. Product version. Version 10.4.1 added multi-processor support for Java database connection in case you were using 10.4.0
    2. Oracle database version
    3. Is the database installed on a physical server or a VM? What's the machine specification, i.e. CPU and memory size?
    4. Is the SSPNA_IN table indexed?
    5. What is the logging level? Does it help if you change the logging level to ERROR?
    6. Please provide the rulebase project and DDL/DML to create tables and insert sample data.
  • 2. Re: Can anyone suggest how to fix batch processor performance?
    PhilWhitwell Explorer
    Currently Being Moderated
    Paul,
    I am happy to take a look.
    I have been working with a couple of customers to get the best performance for the Batch Processor.
    If you want to set up a meeting my email is phil.whitwell@oracle.com

    Cheers
    Phil
  • 3. Re: Can anyone suggest how to fix batch processor performance?
    Paul Fowler Explorer
    Currently Being Moderated
    This problem appears to have fixed itself.

    I suspect a problem with my PC. Drivers, java version, or something. Perhaps I wasn't running the version of Java I thought I was running and after downloading the latest java and cleaning up my PC some, everything was set straight.

    The database has not changed (to my knowledge.)


    So thank you all who looked into this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points