Thanks davey23uk for the reply...

I am experiencing a lot of:

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DECLARE job BINARY_INTEGER :...","PL/SQL MPCODE","BAMIMA: Bam Buffer")...

This becomes a nightmare for my environment...

I decided to implement this and run it at adhoc basis...

Now when I compile the procedure as system or user with dba role.

The user can't find the table or view dba_running_stats.

Thanks