Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Global variables across sessions

falconsJan 7 2003 — edited Jan 13 2003
Does anyone know of a technique of storing information in memory while making this information available to other sessions (=users) ?

We are looking for methods to store a small predefined (about 100) number of values that can be accessed by other sessions very quickly while the values are modified very, very frequently.

Storing the information into a table does not really cut it due to the extreme high volume of transactions involved.
Basically we have a writer process that is adding information to a table but it also needs to update a set of counter variables which need to be continuously checked by other processes.

We have discarded global package variables and temporary tables as the values are not visible to other sessions.
Currently we are using database tables to store the information but the writes and reads on this table are to slow.

Help please,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2003
Added on Jan 7 2003
7 comments
366 views