Resource Cost (ORCL)
Go Up to Data, Schema, and Miscellaneous Utilities
When you create a profile, you can assign a composite resource limit to it. The composite limit is a weighted average of four individual resource limits:
- Connect time
- Private SGA
- CPU per session
- Logical reads per session
The default setting is to weight each of these measures equally. You can alter the weights by issuing an ALTER RESOURCE COST command. DBArtisan provides a visual interface for constructing such a command.
Altering Resource Cost
- On the Utilities menu, select Alter Resource Cost.
- DBArtisan opens the Alter Resource Cost dialog.
The table below describes the options and functionality on the Alter Resource Cost dialog:
Option | Description |
---|---|
Weightings |
In the box, specify the weightings for each resource limit by typing the weight value in the corresponding box: Connect time, Private SGA, CPU per session, or Logical reads per session. |
Enable Resource Limits |
Select to To enable the resource limit changes immediately. |