How to check whether the current database in using Oracle options
1.How to check whether the current database in using Oracle Diagnostics Pack and Oracle Tuning Pack ?
10g Enterprise Edition
============================
If the DB version is 10g Enterprise Edition, please using following sql to check whether the Diagnostics Pack and Tuning Pack are in use or not :
SELECT NAME, currently_used, detected_usages, last_usage_date, last_sample_date
FROM dba_feature_usage_statistics
WHERE NAME IN ('Automatic Workload Repository','SQL Access Advisor','SQL Tuning Advisor','SQL Tuning Set')
AND currently_used = 'TRUE';
Note: If the column "currently_used" show "TRUE" ,It means the feature of pack is in use. "FALSE" measn not in use.
11g Enterprise Edition
===========================
If the DB version is 11.2.0.1, you can refer to following note to check whether the Packs are in use or not.
Database Options/Management Packs Usage Reporting for Oracle Database 11g Release 2 ( Doc ID 1317265.1 )
From the output , we can know whether the following packs are in use or not from "Used" column.
2.If they are in use,how to disable it?
Answer:
+AWR: Disabling and Uninstalling AWR ( Doc ID 1909073.1 )
+ADDM: In 10g, ADDM can be disabled by following parameter: ( Doc ID 562932.1 )
ALTER SYSTEM set "_addm_auto_enable"=false;
+ASH: ALTER SYSTEM set "_ash_enable"=false;
refer to :
Oracle Diagnostic Pack and its related Views. ( Doc ID 1165604.1 )
+SQL Tuning Advisor:
---- Disable automatic SQL tuning advisor
exec DBMS_AUTO_TASK_ADMIN.DISABLE( client_name => 'sql tuning advisor', operation => NULL, window_name => NULL);
+SQL PROFILE:
Refer to : Automatic SQL Tuning and SQL Profiles ( Doc ID 271196.1 )
Disabling the Management Packs in Enterprise Manager:
10.2.0.5 dbconsole
Setup/Management Pack Access (down left hand side)
There is an option to "grant access" or "remove access"
Refer to :
Understanding the Management Packs in Enterprise Manager (dbconsole, grid control and cloud control) ( Doc ID 1566956.1 ) To BottomTo Bottom
Disabling and Uninstalling AWR ( Doc ID 1909073.1 )
In 10g, ADDM can be disabled by following parameter: ( Doc ID 562932.1 )
Automatic SQL Tuning and SQL Profiles ( Doc ID 271196.1 )
Oracle Diagnostic Pack and its related Views. ( Doc ID 1165604.1 )
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24867586/viewspace-1291624/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Check whether SELinux is Enabled or Disabled [ID 432988.1]Linux
- 【SQLSERVER】How to check current pool sizeSQLServer
- How to Check and Enable/Disable Oracle Binary Options (文件 ID 948061.1)Oracle
- How to Perform a Health Check on the DatabaseORMDatabase
- How to check Database corrupt BlockDatabaseBloC
- How to find Current open Cursors in OracleOracle
- How to Restore the Database Using AMDU after Diskgroup CorruptionRESTDatabase
- [20221222]How to Enable and Disable Database Options in oracle 11g.txtDatabaseOracle
- How To Recreate A Database Using TTS (Transportable TableSpace) [ID 733824.1]DatabaseTTS
- Using Regular Expressions in Oracle DatabaseExpressOracleDatabase
- How to Relink Oracle Database SoftwareOracleDatabase
- How to Shrink Undo Segment In Oracle DatabaseOracleDatabase
- How to drop Oracle RAC database manually?OracleDatabase
- How to purge the Oracle Database Recycle BinOracleDatabase
- Using the WITH CHECK OPTION
- How to Move a Database Using Transportable Tablespaces (文件 ID 1493809.1)Database
- 【健康檢查】How to Perform a Health Check on the Database (Doc ID 122669.1)ORMDatabase
- How To Using Flashback Data Archive (Oracle Total Recall)HiveOracle
- How to check payroll result is posted?
- Check database status in RACDatabase
- How to Quiesce a DatabaseUIDatabase
- How to check oracleasm configOracleASM
- How to Find Out How Much Space an Index is UsingIndex
- How to Set Device Name Using UDEV on Oracle Linux 7.1devOracleLinux
- For oracle databases, if the top showing the oracle database, then oracle process is using the top cOracleDatabase
- restore database check readonlyRESTDatabase
- check database patch with opatch toolsDatabase
- Oracle 12Cr2 Using CloneDB to clone a databaseOracleDatabase
- How to Perform a Healthcheck on the DatabaseORMDatabase
- How to enable the flashback database:Database
- How a Database Is Mounted (293)Database
- How to Create Oracle Database QoS Management Administrator AccountsOracleDatabase
- oracle create a new database using backup controlfile to traceOracleDatabase
- Database Testing: How to Regression Test a Relational DatabaseDatabase
- How to Check ASM Login for Oracle Goldengate (OGG) ? [ID 1311784.1]ASMOracleGo
- [原創] How to Quiesce a DatabaseUIDatabase
- How a Standby Database Is Mounted (295)Database
- How a Clone Database Is Mounted (296)Database