|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance. Latest Answer : System Global Area (SGA) is component of instance which consist shared memory & control information of the instance It consist of shared pool, database buffer cached, redo log buffer, large pool, Java pool. ... Database buffers, Redo Log Buffer the Shared Pool and Cursors. Latest Answer : Shared pool, data buffer cache, redo log buffer. ... Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas. Latest Answer : Shared Pool compromises of Library Cache and Dictionary Cache.Library Cache stores and shares sql stmts where as plsql stmts in memory.Dictionary Cache: Oracle continously request and update information in the data dictionary of the db.To maximize the ... A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution Latest Answer : HiShared SQL areas are shared memory areas; any Oracle process can use a shared SQL area. The use of shared SQL areas reduces memory usage on the database server, thereby increasing system throughput. Shared SQL areas are aged out of the shared ... Program Global Area (PGA) is a memory buffer that contains data and control information for a server process. Latest Answer : A programme global area is a memory buffer that contains data and consitute the Oracle Database and Instance.Ex: A client server process uses its Pga to hold the state of the session programme variables and packages. ... Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
