I want to confirm my understanding. When a stored procedure is called the first time the code's compiled version is
cachedand used next time it is executed. However it is cached once for every session and not globally for all
sessions.In other words, if we have a large number of concurrent sessions (x num of sessions) executing the same
procedures(y num of procedures), the memory pressure will be
x * y.
The reason why I am asking this is that the application we are moving from Oracle is heavy on stored procedures with
somepackages running into 8000-10000 lines of code.