Query to Check Installed component in the oracle database?

Here are the two queries to find out the installed components in the oracle database. 

set pages 1000 lines 120 
col comp_name for a40 
1. select comp_name, version, status , modified from dba_registry; 
2. select parameter from v$option where value = 'TRUE' order by parameter; 

Purge AWR Snapshots Manually from Oracle Database

Query to find AWR snapshot retention period using below query.

SQL> select dbms_stats.get_stats_history_retention from dual;



Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer