Forum Stats

  • 3,825,060 Users
  • 2,260,463 Discussions
  • 7,896,401 Comments

Discussions

Xml performance issue | pointers for improvement

Heisonline
Heisonline Member Posts: 31 Red Ribbon

Dear Experts ,

Currently we are facing much more issues when all digital applications now connected to our oracle database by xml interface and expecting quick response from oracle about processing.


Situation :

Application A : send xml to update in oracle by xml :===> oracle scheduler pick xml and process .

many time same xml contains with customer no changes took more 59 sec to process and sometime it porcess with 2 seconds.

Example :

<?xml version="1.0" encoding="UTF-8"?>

<STORESET STORE_KEY="20"><DATASET NUM="1">

<ROWSET TABLE_NAME="D_CUST_AUTH_PERSON">

<ROW NUM="1">

<STORE_KEY>20</STORE_KEY>

<CUST_NO>116895</CUST_NO>

<AUTH_PERSON_ID>1</AUTH_PERSON_ID>

<DAILY_CARD_SEQ_NO>9</DAILY_CARD_SEQ_NO>

</ROW>

</ROWSET>

</DATASET>

</STORESET>

These kind of xmls we are getting .

==> What should I implement to make processing faster .

Awaiting for your response . Thank you!!