How to detect Spatial feature usage?
By using all_sdo_geom_metadata view.
column spatial format a10;
SELECT DECODE(COUNT(*), 0, 'No', 'Yes') Spatial
FROM
( SELECT 1 FROM all_sdo_geom_metadata WHERE rownum = 1
);
Sample Output:-
Showing posts with label Licensing Questions. Show all posts
Showing posts with label Licensing Questions. Show all posts
how to enable or disable oracle database features?
chopt tool a command-line utility is used for enabling or disabling a particular database feature for an Oracle home.
Location:- ORACLE_HOME\bin directory
Syntax:- chopt [ enable | disable] <option>
options:
dm = Oracle Data Mining RDBMS Files
olap = Oracle OLAP
partitioning = Oracle Partitioning
rat = Oracle Real Application Testing
ode_net = Oracle Database Extensions for .NET
Example of running the chopt tool:-
chopt enable dm
chopt disable dm
Sample output:-
How to check whether Oracle Management Pack access is available or not?
Following are the two ways to check Management Pack access is available or not:-
1. By using v$parameter
column name format a35;
column value format a35;
SELECT name,value FROM v$parameter WHERE name LIKE '%pack%';
Sample output:-
2. By using CONTROL_MANAGEMENT_PACK_ACCESS parameter
show parameter CONTROL_MANAGEMENT_PACK_ACCESS;
Sample output:-
How to detect Active Data Guard feature usage?
By using v$managed_standby view:-SELECT 'Using Active Data Guard' ADG
FROM v$managed_standby m,
v$database d
WHERE m.process LIKE 'MRP%';
Sample Output:-
How to detect RAC (Real Application Cluster) feature usage?
By Using v$active_instances viewSELECT DECODE(COUNT(*), 0, 'No', 'Yes') RAC
FROM
( SELECT 1 FROM v$active_instances WHERE rownum = 1
);
Sample Output:-
How to detect Partitioning feature usage?
By using dba_part_tables viewcolumn Partitioning format a15;
SELECT DECODE(COUNT(*), 0, 'No', 'Yes') Partitioning
FROM
(SELECT 1
FROM dba_part_tables
WHERE owner NOT IN ('SYSMAN', 'SH', 'SYS', 'SYSTEM')
AND rownum = 1
);
Sample output:-
How to detect used features in oracle?
displays information about what features are being used in database.
This view dba_feature_usage_statistics updates at a regular interval of seven days (default behavior) with what features have been used in the database.
We can manually refresh this view by executing below statement:-
EXEC DBMS_FEATURE_USAGE_INTERNAL.exec_db_usage_sampling(SYSDATE);
dba_feature_usage_statistics description:-
SELECT name Feature,
version,
detected_usages,
TO_CHAR(first_usage_date,'DD-MON-YYYY') first_used,
TO_CHAR(last_usage_date,'DD-MON-YYYY') last_used,
currently_used
FROM dba_feature_usage_statistics
WHERE first_usage_date IS NOT NULL;
Expected Output:-
How to find list of installed features of Oracle Database?
Following are the two ways to know which options are installed on your oracle database:-1. V$OPTION:- displays database options and features
select parameter from v$option where value='TRUE' order by parameter;
Expected output:-
2. DBA_REGISTRY:- displays information about the components installed with database.
select comp_name,version from dba_registry where status='VALID';
Values under status column may be one of the following:
- INVALID
- VALID
- LOADING
- LOADED
- UPGRADING
- UPGRADED
- DOWNGRADING
- DOWNGRADED
- REMOVING
- REMOVED
How to check oracle license, current sessions and maximum sessions?
1.V$LICENSE:- Displays information about license limits.
This view allows you to query the current limits of all of the license settings, the current number of sessions, and the maximum number of concurrent sessions for the instance.
select sessions_max max_sessions,
sessions_warning warning_sessions,
sessions_current current_sessions,
sessions_highwater hw_sessions,
users_max max_users
from v$license;
2. V$PARAMETER
column name format a25;
column value format a5;
column description format a45;
select name,value,description from v$parameter where name like 'license%';
3. PARAMETER LICENSE
show parameter license;
Below is the output of given SQL Scripts:-
Which Oracle version is running?
Two ways to find the version of Oracle Database:-
1. V$VERSION:-
displays version number with database edition.
1. V$VERSION:-
displays version number with database edition.
select * from v$version;
2. PRODUCT_COMPONENT_VERSION:-displays version and status information for component products with database edition.
set lines 200
column product format a50
column version format a15
column status format a20
select * from product_component_version ;
Below is the output of given SQL Scripts:-
