Results for SESSIONS


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


Database Reference, Release 19c

SESSIONS

Property DescriptionSESSIONS specifies the maximum number of sessions that can be created in the system. Property … can be used in a PDB only to change the value of the SESSIONS parameter for that PDB. ALTER SYSTEM … cannot be used to change the value of the SESSIONS parameter in a non-CDB or in a CDB$ROOT … % for recursive sessions.

Database Administrator's Guide, Release 19c

Managing Processes

5.10 Terminating SessionsSometimes 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. About … Terminating Sessions When a session is terminated, any active transactions of the session are rolled back … available to other sessions.

Database Performance Tuning Guide, Release 19c

Analyzing Sampled Data

9.3.6.2 Top Blocking SessionsThe Top Blocking Sessions subsection lists the blocking sessions that accounted for the highest percentages of sampled session activity.

Database Performance Tuning Guide, Release 19c

Analyzing Sampled Data

9.3.6.1 Top SessionsThe Top Session subsection lists the sessions that were waiting for a particular wait event that

Database Performance Tuning Guide, Release 19c

Analyzing Sampled Data

9.3.6 Top SessionsThe Top Sessions section describes the sessions that were waiting for a particular wait event. Use … this information to identify the sessions that accounted for the highest percentages of sampled … session activity, which may be the cause of a transient performance problem. The Top Sessions section … contains

OLAP Provider for OLE DB Developer's Guide, Release 19c

Features of Oracle OLAP Provider for OLE DB

SessionsOraOLEDB OLAP establishes connections and sessions to the Oracle database. OLE DB When the OLE DB

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

27.5.4 Mapping Sessions to Consumer GroupsYou can map sessions to consumer groups using the SET_CONSUMER_GROUP_MAPPING procedure. You can

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

27.10.3 Viewing Current Consumer Groups for Sessionssessions. The following example queries the V$SESSION view: SELECT sid,serial#,username

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

27.2 Assigning Sessions to Resource Consumer Groupsuse to assign sessions to resource consumer groups. When a session is assigned to a resource consumer … . Note: Sessions that are not assigned to a consumer group are placed in the consumer group … OTHER_GROUPS. Overview of Assigning Sessions to Resource Consumer Groups Before you enable the Resource … Manager, you must specify

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

27.3.5.2 Canceling SQL and Terminating Sessionssessions based on their amount of consumption of system resources, such as CPU and I/O. The SQL … to cancel SQL queries or to terminate sessions based on their consumption of system resources

Database Backup and Recovery User's Guide, Release 19c

Troubleshooting RMAN Operations

24.2.2.2 Matching Server Sessions with Channels in Multiple RMAN SessionsIf multiple RMAN sessions are active, then the V$SESSION.CLIENT_INFO column can yield the same

Database Performance Tuning Guide, Release 19c

Analyzing Sampled Data

9.3.6.3 Top Sessions Running PQsThe Top Sessions Running PQs subsection lists the sessions running parallel queries (PQs) that were

Database Administrator's Guide, Release 19c

Managing Processes

5.4.3.4 Limiting the Number of Shared Server Sessionsshared 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 … sessions. To limit the number of shared server sessions: Set the SHARED_SERVER_SESSIONS initialization … shared

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

You can change the resource consumer group of running sessions.27.2.4.1.3 Switching All Sessions for a User The SWITCH_CONSUMER_GROUP_FOR_USER procedure changes … the resource consumer group for all sessions pertaining to the specified user name. The following PL … /SQL block switches all sessions that belong to user HR to the LOW_GROUP consumer group: BEGIN

Database Administrator's Guide, Release 19c

Monitoring the Database

8.1.1.5 Reading the Trace File for Shared Server SessionsIf shared server is enabled, each session using a dispatcher is routed to a shared server process, and trace information is written to the server trace file only if the session has enabled tracing (or if an error is encountered). Therefore, to track tracing for a specific session that connects using a dispatcher, you might have to explore several shared server trace files. To help you, Oracle provides

Database Administrator's Guide, Release 19c

Managing Resources with Oracle Database Resource Manager

27.2.1 Overview of Assigning Sessions to Resource Consumer GroupsBefore you enable the Resource Manager, you must specify how user sessions are assigned to resource … can switch their sessions from one consumer group to another. The database can also automatically … limits. Parent topic: Assigning Sessions to Resource Consumer Groups

Database Backup and Recovery User's Guide, Release 19c

Troubleshooting RMAN Operations

24.2.2 Correlating Server Sessions with RMAN ChannelsTo identify which server sessions correspond to which RMAN channels, you can query V$SESSION and V … whether you have multiple RMAN sessions active concurrently. This section contains the following topics … : Matching Server Sessions with Channels When One RMAN Session Is Active Matching Server Sessions with Channels

Database Performance Tuning Guide, Release 19c

Tuning the Shared Pool and the Large Pool

14.4.4 Limiting Memory Use for User SessionsTo restrict the memory used by each client session from the SGA, set a resource limit using PRIVATE_SGA. PRIVATE_SGA defines the number of bytes of memory used from the SGA by a session. However, this parameter is rarely used, because most DBAs do not limit SGA consumption on a user-by-user basis. See Also: Oracle Database SQL Language Reference for information about setting the PRIVATE_SGA resource

Database Utilities, Release 19c

Original Import

25.8 Example Import SessionsThese sections give some examples of import sessions that show you how to use the parameter file

Database Utilities, Release 19c

Original Export

24.6 Example Export SessionsExamples of the types of Export sessions. In each example, you are shown how to use both the … Example Export Session in User Mode Example Export Sessions in Table Mode Example Export Session Using Partition-Level Export Parent topic: Original Export





Was this page helpful?

Integrated Cloud Applications & Platform Services