global context instead of for update or another idea ?
Date: Fri, 5 Sep 2008 00:43:01 -0700 (PDT)
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?
hope Received on Fri Sep 05 2008 - 02:43:01 CDT