Databases Reference
In-Depth Information
It's important for the DBA to keep track of how many stored procedures and functions
are running during the course of a business day, because there are memory and per-
formance implications for the objects that share space in the database's shared pool.
If there are too many other SQL statements and frequent accesses to database con-
trol structures, then the stored functions and procedures may be temporarily
removed from the shared pool, thus affecting the response time the next time the
user calls the stored function or procedure because it must be reread from disk.
Terms to Know
concatenation
numeric literal
date function
shared pool
DUAL
single-row function
explicit conversion
stored function
function
string function
implicit conversion
string literal
NULL
user-defined function
numeric function
