Enabling and Disabling – auto optimizer stats collection

By Ravi Karamsetty | May 20, 2016 |

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g: Login to database as SYSDBA: [sql] SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT WHERE CLIENT_NAME = ‘auto optimizer stats collection’; [/sql] Below is how the job can be disabled: [sql htmlscript=”false”] EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => ‘auto optimizer stats collection’, … Continue reading “Enabling and Disabling – auto optimizer stats collection”

Read More

Which Mobile Platform Should I Support? - dwaprince - can you give suggestion to list out all files which are replication factor is 3 through a command line

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Excellent

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Good

TNS SQL .NET Connectivity Issues – Troubleshooting and Diagnosing Tips - dwaprince - Good