Updating Table Stats in Oracle

To gather statistics in Oracle for a specific table use the following sql. One would need sysadm access to run this sql.
Exec dbms_Stats.gather_table_Stats(‘SYSADM’,'TABLENAME');

To know more about gathering statistics check out this Oracle link

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month