Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Does Oracle support running of gather stats on SYS schema in Oracle Apps?

April 26, 2017apps gather Oracle running schema stats support sys

0

Posted

Does Oracle support running of gather stats on SYS schema in Oracle Apps?

1 Answer

0

Posted

If your Oracle Applications instance is on 10g, then you can decide to run stats for SYS schema. This can be done by exec dbms_stats.gather_schema_stats(‘SYS’); Alternately using command dbms_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.