Topic: SGA=> Shared Pool => Library Cache
Shared SQL Areas and Private SQL Areas:
Oracle represents each SQL statement it executes with a shared SQL area and a private SQL area. Oracle recognizes when two users are executing the same SQL statement and reuses the shared SQL area for those users. However, each user must have a separate copy of the statementís private SQL area.
[See: Oracle documet part number a67781.pdf - Oracle 8i Concepts, Page : 186)
Suppose same SQL statement using by 5 users (Cache hit). So by the last statement "However, each user must have a separate copy of the statementís private SQL area." , there must be 5 SQL statements in 5 different private SQl Area and one in Shared Library Cache... So total Six SQl statements in the memory..? is it true...? Please somebody explain...
Thomas P S
Click Here to Expand Forum to Full Width