You typically run the dbms_stats package as the SYSTEM user. To run it as a PPM Center user, grant the privilege to run the package by running the following SQL statement as the SYSTEM user from an SQL*Plus session.
grant execute on dbms_stats to <PPM_User>;
The first time you run the dbms_stats package, use method_opt => 'FOR ALL COLUMNS SIZE SKEWONLY'. After the system has been up and running for a while, use method_opt => 'FOR ALL COLUMNS SIZE AUTO'.
Please work with your DBAs for the same..
Thanks!! Mohit Agrawal Please mark it as accepted solution, if this resolves your query and don't forget to give KUDOS :)