What are the main differences between the predefined functions DB_BUFFER_CACHE and LIBRARY_CACHE ? Thank you in advance.
asked Feb 04 '10 at 11:55 AM in Default
The library_cache is the region of memory where Oracle code (statements, procedures, functions) are stored for execution. If a statement, procedure or function is requested, the cache is checked to see if it's already available in memory. If so, it's executed immediately. If not, it's loaded to the cache and executed. This region is shared.
The db_buffer_cache is the region of memory where database data pages are stored. By data I mean that indexes, etc, are included. Configuration seems to be relatively complicated.
This chapter of Oracle's docs:
could get you started on better understanding. That page refers to additional resources.
answered Feb 04 '10 at 07:14 PM