Managing Processes

Oracle Databases uses several processes so that multiple users and applications can connect to a single database instance simultaneously.

cisco certification training courses malaysia

• About Dedicated and Shared Server Processes
  Oracle Database creates server processes to handle the requests of user processes connected to an instance.
• About Database Resident Connection Pooling
  Database Resident Connection Pooling (DRCP) provides a connection pool in the database server for typical Web application usage scenarios where the application acquires a database connection, works on it for a relatively short duration, and then releases it. DRCP pools "dedicated" servers. A pooled server is the equivalent of a server foreground process and a database session combined.

ccnp certification training courses malaysia

• About Proxy Resident Connection Pooling
  Proxy resident connection pooling uses Proxy Resident Connection Pool that can be configured using Oracle Connection Manager in Traffic Director Mode. Proxy resident connection pooling provides high availability, security, and performance for database clients.
• Configuring Oracle Database for Shared Server
  You can enable shared server and set or alter shared server initialization parameters.
• Configuring Database Resident Connection Pooling
  The database server is preconfigured to allow database resident connection pooling. However, you must explicitly enable this feature by starting the connection pool.
• About Oracle Database Background Processes
  To maximize performance and accommodate many users, a multiprocess Oracle Database system uses background processes. Background processes consolidate functions that would otherwise be handled by multiple database programs running for each user process. Background processes asynchronously perform I/O and monitor other Oracle Database processes to provide increased parallelism for better performance and reliability.

ccie certification training courses malaysia

• Managing Prespawned Processes
  Oracle Database can prespawn processes for better client connection performance.
• Managing Processes for Parallel SQL Execution
  You can manage parallel processing of SQL statements. In this configuration, Oracle Database can divide the work of processing an SQL statement among multiple parallel processes.
• Managing Processes for External Procedures
  An external procedure is a procedure or function written in a programming language and stored in a shared library. An Oracle server can call external procedures or functions using PL/SQL routines.
• Terminating Sessions
  Sometimes it is necessary to terminate current user sessions. For example, you might want to perform an administrative operation and need to terminate all non-administrative sessions.
• Process and Session Data Dictionary Views
  You can query data dictionary views for information about processes and sessions.

blockchain training courses malaysia