OLAPSYS

With Oracle OLAP to perform complex queries on dimensional cubes

OLAP -- think about OLAP -- "Online Analytical Processing" -- fast, quick responses -- DW -- tools to do big things fast.

Oracle has two different technologies offering in online analytical processing (OLAP) area namely Oracle Essbase and Oracle Database OLAP.

For In-memory and fusion middleware based business application, Oracle Essbase is a right choice, for In-Database multidimensional analysis , Oracle Database OLAP is a choice

Analytic Workspace Manager (AWM)

OLAP usage can be checked using below. (olap_info.sql)

-- This will show OLAP components present in the database and their status.

SQL> select comp_id, comp_name, version, status, schema from dba_registry where comp_name like '%OLAP%';
no rows selected

-- This will show recent date incase OLAP is present and used in this database. If database is recent and any application specific AWs(not default AWs) shows then it means OLAP is in use.

SQL> select name "FEATURE", version, detected_usages, first_usage_date "FROM", last_usage_date "TO", currently_used from DBA_FEATURE_USAGE_STATISTICS where name like '%OLAP%';
FEATURE VERSION DETECTED_USAGES FROM TO CURRE
OLAP - Analytic Workspaces 12.1.0.2.0 0 FALSE
OLAP - Cubes 12.1.0.2.0 0 FALSE
OLAP - Analytic Workspaces 11.2.0.4.0 0 FALSE
OLAP - Cubes 11.2.0.4.0 0 FALSE

-- This list AWs present in the database which are related to OLAP

SQL> select * from dba_aws order by owner, aw_name;
no rows selected

-- This list AWs present under which shcema in the database which are related to OLAP
SQL> select username, awname, owner#, awseq# from aw$, dba_users where user_id = owner#;
no rows selected


Based on the above its confirmed as OLAP is not present and not used in this database.

Unlock & Lock can be done like any other user.

for example, alter user OLAPSYS account lock; --> To lock the user
alter user OLAPSYS account unlock; --> To unlock the user

Password also can be changed like the normal user.