对外贸网站建设的建议,2022口碑最好的十款手机,注册域名免费永久,WordPress非首页输出文章ORACLE10G如何清除OEM下的历史警告信息问题描述#xff1a;OEM的HOME页面可以显示ORACLE的报警信息#xff0c;但报警事件清除后该信息不会自动清除。随着时间的增长#xff0c;信息量逐渐加大#xff0c;解决方法是手工予以清除。SampleCluster DatabaseTablespaces FullT…ORACLE10G如何清除OEM下的历史警告信息问题描述OEM的HOME页面可以显示ORACLE的报警信息但报警事件清除后该信息不会自动清除。随着时间的增长信息量逐渐加大解决方法是手工予以清除。SampleCluster DatabaseTablespaces FullTablespace Free Space (MB)2008-12-8 10:24:36Sample1Database InstanceWaits by Wait ClassDatabase Time Spent Waiting (%)2008-12-10 0:45:07Sample1Database InstanceGlobal Cache StatisticsGlobal Cache Average CurrentBlock Request Time (centi-seconds)2008-12-10 0:45:07Sample2Database InstanceWaits by Wait ClassDatabase Time Spent Waiting (%)2008-12-10 0:44:42SampleCluster DatabaseInvalid Objects by SchemaOwners Invalid Object Count2008-12-9 9:31:08解决步骤1、用下面的语句组装生成清除警告信息的脚本select exec em_severity.delete_current_severity( || target_guid ||, || metric_guid || , || key_value || ); from sysman.MGMT_CURRENT_SEVERITYEXECEM_SEVERITY.DELETE_CURRENT_SEVERITY(||TARGET_GUID||,||METRIC_GUID|--------------------------------------------------------------------------------exec em_severity.delete_current_severity(01BA0082955EC11184C650961DC16313,86821B5F0CE858D6E4A7F7390E88B73C, );exec em_severity.delete_current_severity(6DB37247A7C97ED3ED8BAA58B26CA47A,C733EA1CFA96377F492528E305462C9D,Other);exec em_severity.delete_current_severity(6DB37247A7C97ED3ED8BAA58B26CA47A,D6438569B496BC9205481E8A70F92F1E,SYS_p550b);exec em_severity.delete_current_severity(6F95E72E3550CDA14CA88B085851A52C,2448AD7604076832840D5B18E562B9C2,ADCPHC);3 rows selected.2、以sysman用户login SQLPLUS后执行上一步生成的脚本(注意是sysman用户用sys不行)Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0Connected as SYSMANSQL exec em_severity.delete_current_severity(FC17617395481D6B11DED9FE7CA63BF8,D6438569B496BC9205481E8A70F92F1E,SYS_p550a);PL/SQL procedure successfully completedSQL可能出现的问题ORA-06550: line 1, column 7:PLS-00201: identifier EM_SEVERITY.DELETE_CURRENT_SEVERITY must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignored问题原因及处理可能你用sys登录执行了脚本必须以sysman登录执行
