Saved Bookmarks
| 1. |
Does Oracle Support Running Of Gather States On Sys Schema In Oracle Apps? |
|
Answer» If your Oracle Applications instance is on 10g, then you can decide to RUN stats forSYS schema. This can be done by exec dbms_stats.gather_schema_stats(‘SYS’);Alternately using commanddbms_stats.gather_schema_stats(‘SYS’,cascade=>TRUE,degree=>20);I will prefer the former with default values.If you wish to DELETE the stats for SYS use exec dbms_stats.delete_schema_stats(‘SYS’);You can schedule a dbms_job for running stats for SYS schema. If your Oracle Applications instance is on 10g, then you can decide to run stats forSYS schema. This can be done by exec dbms_stats.gather_schema_stats(‘SYS’);Alternately using commanddbms_stats.gather_schema_stats(‘SYS’,cascade=>TRUE,degree=>20);I will prefer the former with default values.If you wish to delete the stats for SYS use exec dbms_stats.delete_schema_stats(‘SYS’);You can schedule a dbms_job for running stats for SYS schema. |
|