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 ...
A Cursor is a handle ( a name or pointer) for the memory associated with a specific statement.
Latest Answer: cursor is nothing but it is temprary storage area.In other word cursor is a private sql work area whenever issuing sql and pl/sql statements ,it creates a memory area in server.this memory area is know as cursor area. ...
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. ...
A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication
Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry
Dedicated Server Configuration and Multi-threaded Server Configuration.
In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.
In a Multi-threaded Server Configuration many user processes share a group of server process.
A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.
View page << Previous 1 [2] 3 4 Next >>
Go Top
