Note:
OLAP Catalog
Obsolete in 10gr2 and De-Supported in 11gR2.
Step-1
A) Create
OLAP verification script.
B) Scripting
query below mention copy in “vi olap.sql”
[oracle@ebstest
~]$ vi olap.sql
prompt
*******************************************
prompt
checking for OLAP features installed
prompt
*******************************************
col c1
heading 'OLAP|Installed' format a20
select
decode(count(*), 0, 'No', 'Yes') c1
from
v$option
where
parameter = 'OLAP';
prompt
*******************************************
prompt
checking for OLAP features used
prompt
*******************************************
col c1
heading 'OLAP|Used' format a20
select
decode(count(*), 0, 'No', 'Yes') c1
from
dba_feature_usage_statistics
where
name like '%OLAP%'
and
first_usage_date is not null;
col name
format a40
select
name,
first_usage_date,
last_usage_date
from
dba_feature_usage_statistics
where
name like '%OLAP%'
and
first_usage_date is not null;
col
comp_id format a10
col comp_name
format a30
col
version format a15
col
status format a10
select
comp_id,
comp_name,
version,
status
from
dba_registry
where
comp_name like '%OLAP%';
Step-2
A)
Source Database Environment.
B)
Connect Sqlplus as a sysdba.
C)
Run script like below mention.
[oracle@ebstest ~]$ vi olap.sql
[oracle@ebstest ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 23
10:55:16 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real
Application Testing options
SQL> @olap.sql
*******************************************
Checking for
OLAP features installed
*******************************************
OLAP
Installed
--------------------
Yes
*******************************************
Checking for
OLAP features used
*******************************************
OLAP
Used
--------------------
Yes
NAME FIRST_USA LAST_USAG
----------------------------------------
--------- ---------
OLAP -
Analytic Workspaces
09-SEP-12 12-MAY-13
OLAP -
Analytic Workspaces
17-MAY-13 17-MAY-13
OLAP -
Analytic Workspaces
19-MAY-13 18-OCT-15
OLAP -
Analytic Workspaces
18-OCT-15 08-OCT-17
OLAP -
Analytic Workspaces
14-OCT-17 09-FEB-19
OLAP -
Analytic Workspaces
16-FEB-19 18-JAN-20
OLAP -
Analytic Workspaces
14-OCT-17 14-OCT-17
7 rows
selected.
COMP_ID COMP_NAME VERSION STATUS
----------
------------------------------ ---------------
----------
AMD OLAP Catalog 11.2.0.4.0 OPTION OFF
APS OLAP Analytic Workspace 12.1.0.2.0
VALID
XOQ Oracle OLAP API 12.1.0.2.0 VALID
SQL>
Note:
As per Script
output we can identify that OLAP in use our database.
Source: Internal Research
No comments:
Post a Comment