Skip to Main Content

Database Software

Share Package Variable among sessions

Nimish GargJan 5 2016 — edited Jan 11 2016

There are times when we populate a package level collection and use that in multiple times for in-memory access and performance tuning. Sometimes that collection is same for all the users, like I have one for my app_config data, but I need to populate it for every time for every session which consume pga unnecessary and also consume other-resources.

There should be a way to share package level collection/variable in some way. It will solve alot of hassle

Post Details
Added on Jan 5 2016