Monthly Archives: November 2015

DBMS_STATS: GATHER_STATS_JOB encountered errors. ORA-20000: Unable to set values for table

SYMPTOMS Alert log shows the error messages below: … Begin automatic SQL Tuning Advisor run for special tuning task “SYS_AUTO_SQL_TUNING_TASK” 2012-05-24 22:00:13.107000 +02:00 DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file. Errors in file /data01/oracle/diag/rdbms/octoprd/OCTOPRD2/trace/OCTOPRD2_j002_2772.trc: ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP: does not exist or insufficient privileges … Complete stack of errors in […]

How to restore datafile from Rman by using Avamar

bash-3.2$ sqlplus / as sysdba; SQL*Plus: Release Production on Wed Nov 18 11:49:34 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1.2831E+10 bytes Fixed Size 2193544 bytes Variable Size 2348812152 bytes Database Buffers 1.0469E+10 bytes Redo Buffers 11214848 bytes […]

Exadata parameter _SMM_AUTO_MAX_IO_SIZE

Recommendation Benefit / Impact: Setting _SMM_AUTO_MAX_IO_SIZE to the recommended value permits 1MB IOs for hash joins that spill to disk, which can increase performance up to 40% due to increased throughput. These performance increases can prevent the need to move TEMP to flash. Risk: Slower performance for hash joins that utilize the temp tablespace on […]