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...

Thanks
Thomas P S