Results for PROCESSES


1 to 20 of 32982 results. Prev  Next
Results per page:   20  | 40 | 60


Automatic Storage Management Administrator's Guide, Release 19c

Initialization Parameters for Oracle ASM Instances

PROCESSESThe PROCESSES initialization parameter affects Oracle ASM, but the default value is usually … instance. In a non-Exadata environment, the recommended settings are: For n = 10, PROCESSES = 10* n … + 450 In an Oracle Exadata environment, the recommended setting is PROCESSES = MAX (450 + 10* n, 1024 … ). See Also: Oracle Database

Automatic Storage Management Administrator's Guide, Release 18c

Initialization Parameters for Oracle ASM Instances

PROCESSESThe PROCESSES initialization parameter affects Oracle ASM, but the default value is usually … instance. In a non-Exadata environment, the recommended settings are: For n = 10, PROCESSES = 10* n … + 450 In an Oracle Exadata environment, the recommended setting is PROCESSES = MAX (450 + 10* n, 1024 … ). See Also: Oracle Database

SQL Tuning Guide, Release 19c

SQL Processing

3.3 How Oracle Database Processes DDLOracle Database processes DDL differently from DML. For example, when you create a table, the … and carries out the command. The database processes DDL differently because it is a means of

SQL Tuning Guide, Release 19c

SQL Processing

3.2 How Oracle Database Processes DMLMost DML statements have a query component. In a query, execution of a cursor places the results of the query into a set of rows called the result set. This section contains the following topics: How Row Sets Are Fetched Result set rows can be fetched either a row at a time or in groups. Read Consistency In general, a query retrieves data by using the Oracle Database read consistency mechanism, which

Database Administrator's Guide, Release 19c

Managing Processes

5.1.2 Shared Server ProcessesA shared server process can service multiple user processes. Consider an order entry system with … dedicated server processes. A customer phones the order desk and places an order, and the clerk taking … Oracle Database Shared Server Processes Description of \"Figure 5-2 Oracle Database Shared Server … Processes\"

Database Administrator's Guide, Release 19c

Managing Processes

5.1.1 Dedicated Server Processesserver processes work. In this diagram two user processes are connected to the database through … dedicated server processes. In general, it is better to be connected through a dispatcher and use a shared … because it keeps the number of processes required for the running instance low. In the following … server

Database Administrator's Guide, Release 19c

Managing Processes

5.7 Managing Prespawned ProcessesOracle Database can prespawn processes for better client connection performance. About Managing … Prespawned Processes Oracle Database can prespawn foreground and background processes in process pools … . Managing Pools for Prespawned Processes You can use the DBMS_PROCESS package to configure and … modify the

Database Administrator's Guide, Release 19c

Planning for Read-Only Materialized Views

38.2.4.4 Sufficient Job ProcessesIt is important that you have allocated sufficient job processes to handle the automation of your … replication environment. The job processes automatically refresh materialized views. By the nature of … require between one and three job processes, depending on user-defined jobs and the scheduled link … process. The job processes

Database Administrator's Guide, Release 19c

Managing Processes

5.4.3.4 Limiting the Number of Shared Server SessionsThe SHARED_SERVER_SESSIONS initialization parameter specifies the maximum number of concurrent shared server user sessions. Setting this parameter, which is a dynamic parameter, lets you reserve database sessions for dedicated servers. This in turn ensures that administrative tasks that require dedicated servers, such as backing up or recovering the database, are not preempted by shared server sessions.

Database Administrator's Guide, Release 19c

Managing Processes

5.5.3 Data Dictionary Views for Database Resident Connection PoolingYou can query data dictionary views to obtain information about your connection pool and to monitor the performance of database resident connection pooling. Table 5-3 Data Dictionary Views for Database Resident Connection Pooling View Description DBA_CPOOL_INFO Contains information about the connection pool such as the pool status, the maximum and minimum number of connections, and timeout for idle

Database Administrator's Guide, Release 19c

Managing Processes

5.4.5 Disabling Shared ServerYou disable shared server by setting the SHARED_SERVERS initialization parameter to 0. You can do this dynamically with the ALTER SYSTEM statement. Set the SHARED_SERVERS initialization parameter to 0. When you disable shared server, no new clients can connect in shared mode. However, Oracle Database retains some shared servers until all shared server connections are closed. The number of shared servers

Database Administrator's Guide, Release 19c

Managing Processes

5.5.2 Configuring the Connection Pool for Database Resident Connection Poolingvalue is 1. Creating multiple Connection Broker processes helps distribute the load of client connection

Database Administrator's Guide, Release 19c

Managing Processes

5.2.1 Comparing DRCP to Dedicated Server and Shared Serverprocesses and sessions. There is one server and one session for each client. Memory requirement is

Database Administrator's Guide, Release 19c

Managing Processes

Database administrators have specific responsibilities and must understand how to complete database…Oracle Databases uses several processes so that multiple users and applications can connect to a … single database instance simultaneously. About Dedicated and Shared Server Processes Oracle Database … creates server processes to handle the requests of user processes connected to an instance. About … Background

Database Administrator's Guide, Release 19c

Managing Processes

5.4.4.4 Altering the Number of DispatchersYou can control the number of dispatcher processes in the instance. Unlike the number of shared … load on the dispatcher processes: V$QUEUE V$DISPATCHER V$DISPATCHER_RATE If these views indicate that … the load on the dispatcher processes is consistently high, then performance may be improved by … starting additional dispatcher

Database Administrator's Guide, Release 19c

Managing Processes

5.10 Terminating Sessionsthe ALTER SYSTEM CANCEL SQL statement. Parent topic: Managing Processes 5.10.1 About Terminating

Database Administrator's Guide, Release 19c

Managing Processes

5.10.4 Terminating an Inactive SessionIf the session is not making a SQL call to Oracle Database (is INACTIVE ) when it is terminated, the ORA-00028 message is not returned immediately. The message is not returned until the user subsequently attempts to use the terminated session. When an inactive session has been terminated, the STATUS of the session in the V$SESSION view is KILLED. The row for the terminated session is removed from

Database Administrator's Guide, Release 19c

Managing Processes

5.8.2.3 Forcing Parallel SQL ExecutionYou can force parallel execution of all subsequent DML, DDL, or query statements for which parallelization is possible with the ALTER SESSION FORCE PARALLEL DML|DDL|QUERY statement. Additionally you can force a specific degree of parallelism to be in effect, overriding any PARALLEL clause associated with subsequent statements. If you do not specify a degree of parallelism in this statement, the default

Database Administrator's Guide, Release 19c

Managing Processes

5.10.3 Terminating an Active SessionTerminating an active session ends the session. If a user session is processing a transaction ( ACTIVE status) when you terminate the session, then the transaction is rolled back and the user immediately receives the following message: ORA-00028: your session has been killed If, after receiving the ORA-00028 message, a user submits additional statements before reconnecting to the database, then Oracle

Database Administrator's Guide, Release 19c

Managing Processes

5.4.3 Enabling Shared Server… Decreasing the Number of Shared Server Processes You can decrease the minimum number of shared servers … Shared Server Processes The MAX_SHARED_SERVERS initialization parameter specifies the maximum number of





Was this page helpful?

Integrated Cloud Applications & Platform Services