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 DBMS_SESSION


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


Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Using DBMS_SESSIONSecurity Model Operational Notes

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

86 DBMS_SESSIONinformation, from PL/SQL. You can use DBMS_SESSION to set preferences and security levels. This chapter … contains the following topics: Using DBMS_SESSION Security Model Operational Notes Summary of DBMS_SESSION Subprograms

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Summary of DBMS_SESSION SubprogramsTable 86-1  DBMS_SESSION Package Subprograms Subprogram Description CLEAR_CONTEXT Procedure Clears

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesThe behavior of this procedure depends upon the configuration of the server operating on behalf of the client: Dedicated server: This returns unused PGA memory and session memory to the operating system. Session memory is allocated from the PGA in this configuration. Shared server: This returns unused session memory to the shared_pool. Session memory is allocated from the shared_pool in this configuration.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ExamplesThis example illustrates the use of DBMS_SESSION.MODIFY_PACKAGE_STATE. Consider a package P with some global state (a cursor c and a number cnt ). When the package is first initialized, the package variable cnt is 0 and the cursor c is CLOSED. Then, in the session, change the value of cnt to 111 and also execute an OPEN operation on the cursor. If you call print_status to display the state of the

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-17  SET_SQL_TRACE Procedure Parameters Parameter Description sql_trace TRUE turns tracing on, FALSE turns tracing off.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.SET_IDENTIFIER ( client_id VARCHAR2);

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesTable 86-19  UNIQUE_SESSION_ID Function Return Values Return Description unique_session_id Returns up to 24 bytes.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.SET_CONTEXT ( namespace VARCHAR2, attribute VARCHAR2, value VARCHAR2, username VARCHAR2, client_id VARCHAR2 );

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

CLOSE_DATABASE_LINK ProcedureThis procedure closes an open database link. It is equivalent to the following SQL statement: ALTER SESSION CLOSE DATABASE LINK

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.CLOSE_DATABASE_LINK ( dblink VARCHAR2);

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-7  IS_SESSION_ALIVE Function Parameters Parameter Description uniqueid Unique ID of the session: This is the same one as returned by UNIQUE_SESSION_ID.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-5  IS_ROLE_ENABLED Function Parameters Parameter Description rolename Name of the role.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Return ValuesTable 86-8  IS_SESSION_ALIVE Function Return Values Return Description is_session_alive TRUE or FALSE, depending on whether the session is active.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

SyntaxDBMS_SESSION.RESET_PACKAGE;

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

Usage NotesNote the following: For 8i compatibility, only the first three parameters are used. The first three parameters are required for all types of context. The username parameter must be a valid SQL identifier The client_id parameter must be a string of at most 64 bytes. It is case-sensitive and must match the argument provided for set_identifier. If the namespace parameter is a global context namespace,

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ExamplesCREATE OR REPLACE PROCEDURE high_priority_task is old_group varchar2(30); prev_group varchar2(30); curr_user varchar2(30); BEGIN -- switch invoker to privileged consumer group. If we fail to do so, an -- error will be thrown, but the consumer group will not change -- because 'initial_group_on_error' is set to FALSE dbms_session.switch_current_consumer_group('tkrogrp1', old_group, FALSE); -- set up

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

ParametersTable 86-4  CLOSE_DATABASE_LINK Procedure Parameters Parameter Description dblink Name of the database link to close.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

CLEAR_IDENTIFIER ProcedureThis procedure removes the set_client_id in the session.

Packages and Types Reference, 10g Release 1 (10.1)

86 DBMS_SESSION

IS_ROLE_ENABLED FunctionThis function determines if the named role is enabled for this session.