Monitoring Indexes cause increase the number of sessions to max limit and database down

Hello,

After activate the monitoring of indexes on production OLTP single instance database 11gR2, the number of sessions grew and we had to kill the pmon and deactivate monitoring.

 

After execute for all indexes in production database of owner = 'APPLICATION_OWNER' and index_type in ('NORMAL','FUNCTION-BASED NORMAL','BITMAP'))

execute immediate 'alter index index_owner.index_name monitoring usage;

 

Then, the sessions increase to max

ORA-00020: maximum number of processes (10000) exceeded

 

And we need to kill pmon and deactivate the monitoring

 

Is this a bug?

Do you recommend any solution to avoid it?