Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
This package provides access to SQL ALTER
SESSION
and SET
ROLE
statements, and other session information, from PL/SQL. You can use this to set preferences and security levels.
This chapter discusses the following topics:
This package runs with the privileges of the calling user, rather than the package owner SYS
.
Subprogram | Description |
---|---|
Sets the indentifier. |
|
"SET_CONTEXT" and |
Sets the context. |
Clears the context. |
|
Clears the identifier. |
|
Sets role. |
|
Turns tracing on or off. |
|
Sets national language support (NLS). |
|
Closes database link. |
|
Deinstantiates all packages in the session. |
|
Returns an identifier that is unique for all sessions currently connected to this database. |
|
Determines if the named role is enabled for the session. |
|
Determines if the specified session is alive. |
|
Turns |
|
Lets you reclaim unused memory after performing operations requiring large amounts of memory. |
|
Sets or resets the value of a context attribute. |
|
Returns a list of active namespace and context for the current session. |
|
Facilitates changing the current resource consumer group of a user's current session. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|