This discussion is archived
2 Replies Latest reply: Aug 21, 2012 12:29 AM by EJP RSS

Better scalability and availability through Oracle DB

800839 Newbie
Currently Being Moderated
Hi,

I have a Employee management application, in which millions of employees will fill time-sheet every day. We have a clustering in place where we have clustered the web-logic servers (managed servers) along with the Oracle Real Application Cluster(where we are using oracle as DB) to provide a better scalability and availability.
But from the database side, how we can ensure the concurrency as well as the data integrity if multiple employees does the time-sheet insertion or updation at the same time.Yes for sure we can handle it using various Isolation levels or locking strategies. But that will slow down the process? Because when the locking is done on a particular resource until it is released the other user cannot do his operation. Hence can slow down the process considerably. How to go about this from the database perspective? How we can handle concurrent users accessing the DB tables records and still go through with a better scalability and performance.
Any ideas are really appreciated.

Thanks.
  • 1. Re: Better scalability and availability through Oracle DB
    Kayaman Guru
    Currently Being Moderated
    797836 wrote:
    Yes for sure we can handle it using various Isolation levels or locking strategies.
    Yes, that's what they were designed for.
    But that will slow down the process?
    Yes. That's the price you have to pay. Is there an actual problem or are you just guessing?
    Because when the locking is done on a particular resource until it is released the other user cannot do his operation.
    That depends entirely on the locking type.
    Hence can slow down the process considerably.
    What is "considerably" in your opinion? What type of locking are you currently doing and how long are your transactions?
    How we can handle concurrent users accessing the DB tables records and still go through with a better scalability and performance.
    Databases are very efficient in handling transactions concurrently. You sound like you're looking for a solution for a problem that doesn't exist.
  • 2. Re: Better scalability and availability through Oracle DB
    EJP Guru
    Currently Being Moderated
    This is a Java JDBC forum and your question is off topic. Try one of the numerous Oracle database forums. Locking this thread.

Legend

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