Re: How to create pl/sql that run efficiently in background ?
From: Palooka <nobody_at_nowhere.com>
Date: Tue, 03 Feb 2009 03:43:44 +0000
Message-ID: <Q3Phl.7985$pR5.1702_at_newsfe24.ams2>
krislioe_at_gmail.com wrote:
> Hi sql gurus,
>
> We have application on Oracle 10g where 150+users (from multiple
> branch) concurrently input transaction. The transaction number is
> centralized, means all user use same transaction number counter.
>
> To avoid the contention that occured, we think of using pl/sql
> procedure that run in background to do :
> - select transaction that not yet has number
> - query the last transaction number counter(a column in a table),
> increment by 1, update the transaction with the number
> - commit
> - process another transaction
>
> What is the best approach to do this ?
> (means a pl/sql that does not cause high CPU utilization, because it
> will run all day long to look for unnumbered transaction)
>
Ever heard of sequences? Received on Mon Feb 02 2009 - 21:43:44 CST
Date: Tue, 03 Feb 2009 03:43:44 +0000
Message-ID: <Q3Phl.7985$pR5.1702_at_newsfe24.ams2>
krislioe_at_gmail.com wrote:
> Hi sql gurus,
>
> We have application on Oracle 10g where 150+users (from multiple
> branch) concurrently input transaction. The transaction number is
> centralized, means all user use same transaction number counter.
>
> To avoid the contention that occured, we think of using pl/sql
> procedure that run in background to do :
> - select transaction that not yet has number
> - query the last transaction number counter(a column in a table),
> increment by 1, update the transaction with the number
> - commit
> - process another transaction
>
> What is the best approach to do this ?
> (means a pl/sql that does not cause high CPU utilization, because it
> will run all day long to look for unnumbered transaction)
>
Ever heard of sequences? Received on Mon Feb 02 2009 - 21:43:44 CST