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 90 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 1 of 2

65 DBMS_SESSIONthe following topics: Requirements Summary of DBMS_SESSION Subprograms

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

Summary of DBMS_SESSION SubprogramsTable 65-1 DBMS_SESSION Subprograms Subprogram Description SET_IDENTIFIER Sets the identifier

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SyntaxDBMS_SESSION.CLOSE_DATABASE_LINK ( dblink VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SyntaxDBMS_SESSION.IS_SESSION_ALIVE ( uniqueid VARCHAR2) RETURN BOOLEAN;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SET_SQL_TRACE ProcedureThis procedure turns tracing on or off. It is equivalent to the following SQL statement: ALTER SESSION SET SQL_TRACE...

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SyntaxDBMS_SESSION.FREE_UNUSED_USER_MEMORY;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

ExampleThis SQL*Plus script runs a large program with many PL/SQL program units that may or may not use global variables, but it doesn't need them beyond this execution: EXCECUTE large_plsql_program1; To free up PL/SQL cached session memory: EXECUTE DBMS_SESSION.RESET_PACKAGE; To run another large program: EXECUTE large_plsql_program2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

MODIFY_PACKAGE_STATE Proceduresession. The procedure uses the DBMS_SESSION constants shown in Table 65-10. Because the client

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SET_CONTEXT ProcedureThis procedure sets the context.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

Usage NotesFor both FREE_ALL_RESOURCES and REINITIALIZE, reinitialization takes effect after the PL/SQL call that made the current invocation finishes running. Reinitialization occurs only if the package is actually referenced. Packages are reinitialized in the order in which they are referenced. REINITIALIZE differs from FREE_ALL_RESOURCES in that any open cursors are closed, semantically speaking. However,

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

Usage NotesBecause the amount of memory consumed by all executed PL/SQL can become large, you might use RESET_PACKAGE to trim down the session memory footprint at certain points in your database application. However, make sure that resetting package variable values will not affect the application. Also, remember that later execution of programs that have lost their cached memory and cursors will perform slower,

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

Usage NotesNote the following: Sets the application context and associates it with the client_id Username must be a valid SQL identifier client_id is a string of at most 64 bytes client_id is case sensitive; it must match the argument to set_identifier Must be invoked directly or indirectly by the trusted package Can only be used on global namespaces

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SET_NLS ProcedureThis procedure sets up your national language support (NLS). It is equivalent to the following SQL statement: ALTER SESSION SET =

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

ParametersTable 65-8 SET_NLS Procedure Parameters Parameter Description param NLS parameter. The parameter name must begin with 'NLS'. value Parameter value. If the parameter is a text literal, then it needs embedded single-quotes. For example, " set_nls (' nls_date_format ',''' DD-MON-YY ''')"

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SyntaxDBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS ( close_cursors BOOLEAN);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

CLEAR_CONTEXTSyntax DBMS_SESSION.CLEAR_CONTEXT namespace VARCHAR2, client_identifier VARCHAR2 attribute VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SET_CLOSE_CACHED_OPEN_CURSORS ProcedureThis procedure turns close_cached_open_cursors on or off. It is equivalent to the following SQL statement: ALTER SESSION SET CLOSE_CACHED_OPEN_CURSORS...

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SESSION, 2 of 2

SyntaxDBMS_SESSION.RESET_PACKAGE;