global context instead of for update or another idea ?

Hi ,

is it possible to use global variables in oracle? and is there any way to control concurrency on this memory variable?

i can use a table, and read this by using for update. Under heavy loads, this will create contention.

what else can i do?

i try to use sequence data variable. there are multiple sessions. when one session reads next value, others must wait , and this creates contention also. and i need to use reuse values so sequence does not allow to use older values.

 synchronized methods of java do the same thing , can i do similiar thing in oracle? does global context provide this type of funcionality?

kind regards,
hope Received on Fri Sep 05 2008 - 02:43:01 CDT