高一英语：Unit2 English around the world Learning about languages（必修1）.pptVIP

* Shared Pool Components During the parse stage, the server process uses the area in the SGA known as the shared pool to compile the SQL statement. The shared pool has two primary components: ? Library cache ? Data dictionary cache Library Cache The library cache stores information about the most recently used SQL statements in a memory structure called a shared SQL area. The shared SQL area contains: ? The text of the SQL statement ? The parse tree: A compiled version of the statement ? The execution plan: The steps to be taken when executing the statement The optimizer is the function in the Oracle server that determines the optimal execution plan. Shared Pool Components (continued) Library Cache (continued) If a SQL statement is reexecuted and a shared SQL area already contains the execution plan for the statement, the server process does not need to parse the statement. The library cache improves the performance of applications that reuse SQL statements by reducing parse time and memory requirements. If the SQL statement is not reused, it is eventually aged out of the library cache. Data Dictionary Cache The data dictionary cache, also known as the dictionary cache or row cache, is a collection of the most recently used definitions in the database. It includes information about database files, tables, indexes, columns, users, privileges, and other database objects. During the parse phase, the server process looks for the information in the dictionary cache to resolve the object names specified in the SQL statement and to validate the access privileges. If necessary, the server process initiates the loading of this information from the data files. Sizing the Shared Pool The size of the shared pool is specified by the initialization parameter SHARED_POOL_SIZE. Period 3 Learning about language Unit 2 English around the world Revision ( 3m )Match: (Review the new words) 1.come up 2.culture 3.actually 4