Tag Archives: dba_audit_session

OEM模块审计查询语句占用较大资源

发现一个导致Oracle自己的低效SQL,在AWR报告中占用较大的资源。 这个SQL在Elapsed Time、CPU Time、User I/O Wait Time、Buffer Gets、Physical Reads都会出现,其SQL模块是Oracle Enterprise Manager.Metric Engine。显然这是一个OEM自己的SQL,检查完整SQL语句: <pre lang=’SQL’>SELECT TO_CHAR(current_timestamp AT TIME ZONE ‘GMT’, ‘YYYY-MM-DD HH24:MI:SS TZD’) AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, ‘YYYY-MM-DD HH24:MI:SS’) >= TO_CHAR(current_timestamp – … Continue reading

Posted in BUG | Tagged , , | Leave a comment