|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
This chapter contains the following topics:
OLAP_API_SESSION_INIT package contains procedures for maintaining a configuration table of initialization parameters. When the OLAP API opens a session, it executes the
ALTER SESSION commands listed in the table for any user who has the specified roles. Only the OLAP API uses this table; no other type of application executes the commands stored in it.
During installation, the table is populated with
ALTER SESSION commands that have been shown to enhance the performance of the OLAP API. Unless new settings prove to be more beneficial, you do not have to make changes to the table.
The information in the table can be queried through the
ALL_OLAP_ALTER_SESSION view alias, which is also described in this chapter.
Note:This package is owned by the
SYSuser. You must explicitly be granted execution rights before you can use it.
ALL_OLAP_ALTER_SESSION is the public synonym for
V$OLAP_ALTER_SESSION, which is a view for the
OLAP$ALTER_SESSION table. The view and table are owned by the
Each row of
ALL_OLAP_ALTER_SESSION identifies a role and a session initialization parameter. When a user opens a session using the OLAP API, the session is initialized using the parameters for roles granted to that user.