Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 8th, 2006, 12:46 PM
Registered User
 
Join Date: Jul 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Urgent OLTP Help

Dear Gurus,

I wish you can help me out on a problem.
I am just new to OLTP systems and now, have just built a system that can accept and throw ISO8583 financial messages. The design of the system was basically divided into two:

1. Communications
2. Authorization

The team and I used VB6 as our main tool for creating communication modules. We also used MSMQ and COM+ but am not really sure if the later really works with Oracle 10gR2 (our backend). Our Authorization modules are composed of nested oracle procedures that accepts, parses and processes messages.

Everything was working well until we found out that there were instances that oracle wasn't able to provide output procedure values. We partially solved the problem by checking on the locks and table indexes. This only covered part of the problem but under stressful condition, oracle starts to act weird and returns NULL output values. So what we did was to include rollbacks into our system so as to recover from traffic but to our dismay it still didn't worked out.

Here is the design of the system:
Every time a transaction comes in, it checks the card information from the mother database(masterfile), gets the card's status, balance and substracts it with the total transaction amount (which can be queried on a separate table - lets name this as table B) the card incurred throughout the day to get the latest balance of the card (since the masterfile can only be updated at night to avoid data integrity problems)

My problem right now is focused on the second table (table B) mentioned above. Some transactions like sale transaction updates this table as other transactions like void and reversal transactions concurrently thus creating heavy traffic (or deadlocks).

We've used PL/SQL commands like LOCK TABLE <table> FOR ROW EXCLUSIVE... sort of commands but still, traffic is heavy.

Can anyone help me out on this problem? Thanks







Similar Threads
Thread Thread Starter Forum Replies Last Post
urgent deb_kareng ASP.NET 2.0 Professional 1 August 13th, 2007 07:29 AM
it's urgent deb_kareng ASP.NET 2.0 Professional 3 August 7th, 2007 07:40 AM
urgent help yash_coolbuddy_forindia BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 May 7th, 2007 08:40 AM
urgent???????????? nsr35 Beginning VB 6 1 October 3rd, 2005 10:57 AM
urgent ??????????????? nsr35 Pro VB Databases 0 October 3rd, 2005 04:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.