How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
65 DBMS_SESSION → the following topics: Requirements Summary of DBMS_SESSION Subprograms
Summary of DBMS_SESSION Subprograms → Table 65-1 DBMS_SESSION Subprograms Subprogram Description SET_IDENTIFIER Sets the identifier
Syntax → DBMS_SESSION.CLOSE_DATABASE_LINK ( dblink VARCHAR2);
Syntax → DBMS_SESSION.IS_SESSION_ALIVE ( uniqueid VARCHAR2) RETURN BOOLEAN;
SET_SQL_TRACE Procedure → This procedure turns tracing on or off. It is equivalent to the following SQL statement: ALTER SESSION SET SQL_TRACE...
Syntax → DBMS_SESSION.FREE_UNUSED_USER_MEMORY;
Example → This 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;
MODIFY_PACKAGE_STATE Procedure → session. The procedure uses the DBMS_SESSION constants shown in Table 65-10. Because the client
SET_CONTEXT Procedure → This procedure sets the context.
Usage Notes → For 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,
Syntax → DBMS_SESSION.SET_CONTEXT ( namespace VARCHAR2, attribute VARCHAR2, value VARCHAR2, username VARCHAR2, client_id VARCHAR2 );
Usage Notes → Because 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,
Usage Notes → Note 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
SET_NLS Procedure → This procedure sets up your national language support (NLS). It is equivalent to the following SQL statement: ALTER SESSION SET =
Parameters → Table 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 ''')"
Syntax → DBMS_SESSION.SET_CLOSE_CACHED_OPEN_CURSORS ( close_cursors BOOLEAN);
CLEAR_CONTEXT → Syntax DBMS_SESSION.CLEAR_CONTEXT namespace VARCHAR2, client_identifier VARCHAR2 attribute VARCHAR2);
Parameters → Table 65-7 SET_SQL_TRACE Procedure Parameters Parameter Description sql_trace TRUE turns tracing on, FALSE turns tracing off.
SET_CLOSE_CACHED_OPEN_CURSORS Procedure → This procedure turns close_cached_open_cursors on or off. It is equivalent to the following SQL statement: ALTER SESSION SET CLOSE_CACHED_OPEN_CURSORS...