You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SESSIONS


1 to 20 of 1296 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Reference, 12c Release 1 (12.1)

SESSIONS

1.255 SESSIONSSESSIONS specifies the maximum number of sessions that can be created in the system. Because every … approximately 10% for recursive sessions. Oracle uses the default value of this parameter as its minimum … SESSIONS. Therefore, if you increase the value of SESSIONS, you should consider whether to adjust

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Processes

5.8.1 About Terminating Sessionsother sessions. You terminate a current session using the SQL statement ALTER SYSTEM KILL SESSION. The … terminate sessions with a named service at the current instance. See Also: Oracle Database PL/SQL

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Connections and Sessionsdatabase application. A single connection can have 0, 1, or more sessions established on it. The sessions … are independent: a commit in one session does not affect transactions in other sessions. Note: If … sessions intact. Multiple sessions can exist concurrently for a single database user. As shown

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Processes

5.8 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.

Database Performance Tuning Guide, 12c Release 1 (12.1)

Analyzing Sampled Data

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

Database Administrator's Guide, 12c Release 1 (12.1)

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, 12c Release 1 (12.1)

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, 12c Release 1 (12.1)

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.

Database Administrator's Guide, 12c Release 1 (12.1)

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

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Troubleshooting RMAN Operations

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, 12c Release 1 (12.1)

Tuning the Shared Pool and the Large Pool

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, 12c Release 1 (12.1)

Example Export Sessions

Example Export SessionsThis section provides examples of the following types of Export sessions: Example Export Session in … Full Database Mode Example Export Session in User Mode Example Export Sessions in Table Mode

Database Utilities, 12c Release 1 (12.1)

Example Import Sessions

Example Import SessionsThis section gives some examples of import sessions that show you how to use the parameter file and

Database Utilities, 12c Release 1 (12.1)

Initiating Multiple SQL*Loader Sessions

Initiating Multiple SQL*Loader SessionsEach SQL*Loader session takes a different data file as input. In all sessions executing a direct … example, to start three SQL*Loader direct path load sessions on the same table, you would execute each … PARALLEL=TRUE The previous commands must be executed in separate sessions, or if permitted on your

Provider for OLE DB Developer's Guide for Microsoft Windows, 12c Release 1 (12.1)

Features of OraOLEDB

OraOLEDB Sessions(). Subsequent sessions that are created establish their own independent connections to the particular

Database Development Guide, 12c Release 1 (12.1)

Performance and Scalability

2.12.14 Explicitly Marking Sessions Stateful or StatelessMarking Sessions Stateful or Stateless wait_for_transaction_request(); do { ub1 state; /* mark database … explicitly mark sessions as stateful or stateless when you use the OCI session pool. See Also

Database Utilities, 12c Release 1 (12.1)

Example Export Sessions in Table Mode

Example Export Sessions in Table ModeIn table mode, you can export table data or the table definitions. (If no rows are exported, then the CREATE TABLE statement is placed in the export file, with grants and indexes, if they are specified.) A user with the EXP_FULL_DATABASE role can use table mode to export tables from any user's schema by specifying TABLES=schemaname.tablename. If schemaname is not specified, then Export defaults to

Database Concepts, 12c Release 1 (12.1)

Process Architecture

Automatic Workload Repository AWR is a repository of historical performance data that includes cumulative…Manageability Monitor Processes (MMON and MMNL) The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR). For example, MMON writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects. The manageability monitor lite process (MMNL) writes statistics from the Active Session

Database Administrator's Guide, 12c Release 1 (12.1)

Scheduling Jobs with Oracle Scheduler

A resource consumer group consumer group is a collection of user sessions that are grouped together…29.7.1.2 Creating Job Classes You create a job class using the CREATE_JOB_CLASS procedure in the DBMS_SCHEDULER package or Cloud Control. Job classes are always created in the SYS schema. The following statement creates a job class for all finance jobs: BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS ( job_class_name => 'finance_jobs', resource_consumer_group => 'finance_group'); END; / All jobs in this job

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Subprogram Side Effectspackage state be maintained across user sessions. Minimizing side effects is especially important