I need to count a application session from v$session program field.
How reliable is this field to impose the connection restriction base on this count .
It seems a have empty value some times although there is a session active using some tools.
How the info get updated there once connection is broken or terminated.
Is there any other reliable way to fetch the same info?
Your help will be appreciated.