DB version: 11g (11.2.0.4 )
Platform : RHEL 6.5
I have a 3-Node RAC DB which is 25 TeraBytes in size.
Lately, this DB was experiencing some performance issues. For better diagnosis, I want to reduce the AWR snapshot interval from 1 hour to 30 minutes using the below command.
exec dbms_workload_repository.modify_snapshot_settings
(
interval => 30,
retention => 20160 -----> (minutes equivalent of 2 weeks)
);
Since this is a critical production system, application team have concerns on the below 2 items
1. Performance impact ( CPU, Storage I/O)
Application team want me to quantify (in percentage) the performance impact.
Is it safe to say that the DB will be 1 to 2% slower ?
2. Extra space requirements for SYSAUX
I gather that AWR data is stored in Sysaux tablespace. Any idea what will be extra space (in percentage) that will be consumed in
SYSAUX tablespace because of this change ?
Any other potential problems ?
Related info : This DB is monitored by OEM Grid control