How To Automatic Kill Inactive Sessions using Resource Manager

Database server crashed after memory on server used by inactive sessions The Following Example used to illustrate the scenario for User XX, please Review and modify whatever needed to confirm Automatic Kill of the Huge number of Inactive Sessions after a period of Idle Time . 1.CREATE THE PLAN 2.CREATE THE CONSUMER GROUPS 3.CREATE DIRECTIVES … Read more