Hi All,
I want to understand how are session/s established in oracle .
If I connect from sql developer and open multiple tabs for the same user_name/password@tns_name then I believe we have multiple sessions for the same user however
If I invoke a packaged procedure from a begin end block which in turns calls another packaged procedure then both this procedures in different packages will have the same session , Is my Understanding right that a new session would be established only when I login again with the same user_name password or use an autonomous transaction to create a new session within an invoking chain of procedure/functions etc?
Thanks in advance for all the help provided.