I have created resource pools as below. Please let me know the users who assigned to default_pool & system_auto will use how much cpu and memory.
Who will use default_pool & system_auto resource pools usually?
I have created resource pools as below. Please let me know the users who assigned to default_pool & system_auto will use how much cpu and memory.
Who will use default_pool & system_auto resource pools usually?
This explains the built-in resource pools:
default_pool is a catch-all. Users will use that if they are not otherwise assigned to use a pool
If you want to enable dynamic resource pool selection, using a custom function to choose the resource pool for a connection at runtime, you can set resource_pool = system_auto. See the documentation for details.