global context instead of for update or another idea ?

From: hopehope_123 <>
Date: Fri, 5 Sep 2008 00:43:01 -0700 (PDT)
Message-ID: <>

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

Original text of this message