Forum Stats

  • 3,840,360 Users
  • 2,262,592 Discussions
  • 7,901,243 Comments

Discussions

Is it possible to enable queuing for user transactions

870002
870002 Member Posts: 40
edited Jun 1, 2016 6:17AM in Advanced Queueing

We are using oracle database 11g and websphere portal as front end application.

In a certain process when multiple transactions are triggered from users, we are facing deadlock issues and the whole system is hanged.

Now could you please assist us whether it is possible to enable queuing in database and restrict user sessions to complete one by one.

Answers

  • WGabriel
    WGabriel Member Posts: 202 Bronze Badge
    edited Jun 1, 2016 6:17AM

    Hello,

    first of all it would be better to analyze the reasons for the deadlocks in your portal. You did not find any vulnerability?

    In principle, it would be possible to redesign your portal transactions for using AQ functionality. But this would imply a complete redesign,

    because all data modifications (DML actions) have to be done in a dedicated process using an enqueue / dequeue mechanism.

    All of your portal data which should be modified will be queued for each user and a new AQ process will do the data changes.

    Kind regards,

    WoG

This discussion has been closed.