Resource governors can be used to improve performance.
Resource governors are a set of database options you can use to control resources. These options can be set using the SET OPTION statement.
Building a set of users and roles allows you to manage privileges on a database. Another aspect of database security and management is to limit the resources an individual user can use.
For example, you can prevent a single connection from taking too much of the available memory or CPU resources, so you can avoid having a connection slow down other users of the database.
You can use the following options to manage resources:
Limits the number of cursors for a connection.
Limits the number of prepared statements for a connection.
Sets the priority level at which requests from a connection are executed.
Controls the maximum priority level for connections.