Can any one help me to find answer for problems given below.
1.How to find about the statistics jobs being run on a server.
2.If it is currently using ANALYZE, how to change it to dbms_stats.
3.How often the statistics were being run. How to check that the statistics are being run very often than really needed.
1.How to find about the statistics jobs being run on a server.
2.If it is currently using ANALYZE, how to change it to dbms_stats.
3.How often the statistics were being run. How to check that the statistics are being run very often than really needed.
Comment