Search
Ashish sinha
- May 19, 2020
- 2 min
PRAGMA SERIALLY_REUSABLE IN ORACLE
The SERIALLY_REUSABLE Pragma specifies that the package state is needed for only one call to the server (for example, an OCI call to the database or a stored procedure invocation through a database link). After this call, the storage for the package variables can be reused, reducing the memory overhead for long-running sessions. This Pragma is appropriate for packages that declare large temporary work areas that are used once in the same session. The state of a serially reusa
11 views0 comments