Oracle database resource manager

Hi Experts,

I have a requirement to control the parallelism for few set of users, as those users are consuming huge amount of DB resource and we need to restrict them. In order to restrict that, I was trying to create the resource manager.

I created one test user and followed the below steps to restrict that user to use PARALLELISM 4. After creating that and adding the user in the consumer group, I took a different session using the new user and tried to query a table using /*parallel (c,8)*/ hint, but it is using the below details :

SQL> select executions, px_servers_executions, sql_fulltext from gv$sqlstats where sql_id ='cc0j8tcu8ky12';