Oracle 参数 DIAGNOSTICS_CONTROL 官方解释,作用,如何配置最优化建议
参数
DIAGNOSTICS_CONTROL参数控制数据库诊断信息的存储和处理,它决定了数据库内部信息是否被存储到特定的侦测区域,以及侦测区域中存储多少时间,以及如何进行处理。
正确设置Oracle参数
1.可以使用以下命令临时设置DIAGNOSTICS_CONTROL参数:
ALTER SESSION SET DIAGNOSTICS_CONTROL= VALUE
2.可以使用SYSPROC.ADMIN_SET_DIAGNOSIS_CONTROL存储过程设置诊断控制参数:
EXEC SYSPROC.ADMIN_SET_DIAGNOSIS_CONTROL ( VALUE );
3.可以使用ALTER SYSTEM 设置诊断控制参数:
ALTER SYSTEM SET DIAGNOSTICS_CONTROL= VALUE SCOPE=SPFILE;
4.可以connect到SYS用户并使用ALTER SYSTEM设置诊断控制参数:
CONNECT SYS/PASSWORD AS SYSDBA;
ALTER SYSTEM SET DIAGNOSTICS_CONTROL= VALUE SCOPE=BOTH;
5.可以使用武德DBCA配置管理器设置诊断控制参数:
DBCA- Database- Configuration- Configuration Parameters- Advanced Performance
参数名称:diagnostics_control
参数值:VALUE
DIAGNOSTICS_CONTROL enables you to control and monitor the users who perform potentially unsafe database diagnostic operations.
When diagnosing Oracle database issues, an Oracle Support Service staff member might instruct you to perform diagnostic operations. Some diagnostic operations are harmless. However, others could have adverse effects if not performed properly with the guidance of an Oracle Support Service staff member. In order to control and monitor who performs such diagnostic operations, Oracle Database 20 introduces the following security controls:
Potentially unsafe diagnostic operations are internally identified in the database. These operations include setting certain debug events and debug actions with the ALTER SESSION or ALTER SYSTEM statement. For example:CopyALTER SESSION SET EVENTS "1357 trace name context forever, level 2"; ALTER SYSTEM SET EVENTS "trace[vos]";A user can be authorized to perform potentially unsafe diagnostic operations, either by being granted the ENABLE DIAGNOSTICS system privilege, or by being granted the DBA role, or by authenticating as SYSDBA. The DIAGNOSTICS_CONTROL initialization parameter enables you to specify how the database responds when an unauthorized user attempts to perform these diagnostic operations. The possible values are: ERROR: When an unauthorized user attempts to perform a potentially unsafe diagnostic operation, the attempt fails with error ORA-01031: insufficient privileges. WARNING: When an unauthorized user attempts to perform a potentially unsafe diagnostic operation, the attempt succeeds, but a warning is written to the alert log. IGNORE: When an unauthorized user attempts to perform a potentially unsafe diagnostic operation, the attempt succeeds and no error messages or warnings occur. This is the default.
Note:
When altering the DIAGNOSTICS_CONTROL initialization parameter, be aware of the following guidelines:
To modify this parameter with the ALTER SYSTEM command, you must be authenticated AS SYSDBA.
In Oracle RAC environments, it is currently not possible to modify this parameter on remote instances by specifying the SID clause in the ALTER SYSTEM SET statement.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 参数 DIAGNOSTICS_CONTROL 官方解释,作用,如何配置最优化建议
相关文章
- Oracle 视图 DBA_TABLESPACE_USAGE_METRICS 官方解释,作用,如何使用详细说明
- Oracle 参数 ALLOW_ROWID_COLUMN_TYPE 官方解释,作用,如何配置最优化建议
- Oracle 参数 DEFERRED_SEGMENT_CREATION 官方解释,作用,如何配置最优化建议
- Oracle 参数 DIAGNOSTIC_DEST 官方解释,作用,如何配置最优化建议
- Oracle 参数 INSTANCE_TYPE 官方解释,作用,如何配置最优化建议
- Oracle 参数 LOCK_NAME_SPACE 官方解释,作用,如何配置最优化建议
- Oracle 参数 UNDO_RETENTION 官方解释,作用,如何配置最优化建议
- Oracle字符串切割技巧研究(oracle字符串切割)
- Oracle数据源配置:从头到尾(oracle配置数据源)
- Oracle安装与配置指南(oracle安装配置教程)
- Oracle 远程配置实现无缝连接(oracle远程配置)
- 如何在Oracle中将表转换为分区来提高性能(oracle表转分区)
- Oracle ASM安装指南:快速高效地配置存储系统(oracle安装asm)
- 深入浅出:Oracle Q操作快速上手(oracle q 操作)
- Oracle内部运行安全高效配置与管理(oracle内部运行)
- Oracle放开双手拥抱免费之福(oracle 免费的)
- C盘同享Oracle安装令IT技术员拥有一份艰苦的幸福(c盘同享oracle安装)
- 配置CXOracle,指引您快速连接Oracle(cx oracle 配置)
- Oracle数据库中处理空值的技巧(oracle中空值问题)
- 探索Oracle任务查看的魅力(oracle任务查看)
- Oracle中实现主表查询的简单方法(oracle中按主表查询)
- Oracle个性化推荐引领万众新潮流(oracle 个性化推荐)
- Oracle数据求差一次精彩的挑战(oracle两条数据求差)
- Oracle数据库连接遇到持久问题(oracle一直不能连接)
- 在Oracle SCN6上实现安全的数据库管理(oracle scn6)