Hello, everyone, I have an ORACLE who runs awr reports, CPU time, elapsed time, ordered by reads, order by gets charts, is this statement

 SELECT * FROM ALL_IND_COLUMNS WHERE (INDEX_OWNER=: OWNER OR: OWNER is null) AND (INDEX_NAME=: NAME OR: NAME is null) AND (TABLE_OWNER=: TABLEOWNER OR: TABLEOWNER is null) AND (TABLE_NAME=: TABLENAME OR: TABLENAME is null) AND (COLUMN_NAME=: COLUMNNAME OR: COLUMNNAME is null) 

Hard disk IO is very high, the need to optimize the index?

CodePudding user response:

Oh, this is the data dictionary of your application during a visit to him?

CodePudding user response:

No obvious access, the likelihood is the antivirus 360

CodePudding user response:

The whole report handed out to see