Published by : Obay Salah , November 19, 2024

 The default method for joining a specific Session within a Consumer Group is through the Username. When a user connects to the database, Oracle opens this Session within the specified Consumer Group in the INITIAL_RSRC_CONSUMER_GROUP variable, which appears in the DBA_USERS table.

Of course, the initial GROUP can be changed at any time, either manually or through Consumer Group Switching.

The Consumer Group can be applied through several properties, including (EXPLICIT & ORACLE_USER).

Here, we use a procedure called SET_CONSUMER_GROUP_MAPPING to specify the properties, after which we use another procedure called SET_CONSUMER_GROUP_MAPPING_PRI.

Through these, we can apply users to groups based on these properties, so we can, for example, assign users to groups based on the Service_Name.

If a user connects with a specific Service Name, they will be included in the Consumer Group, and if they connect through another Service Name, they will be assigned to another group.

If we use the Client_Machine, the user's membership in the group depends on the machine or device they are using, allowing us to benefit from these procedures.

Tags : Database

You May Also Like

Comments

no comment yet!