Oracle user PROFILE limits
Environment: Windows 2003, Oracle 10g
What numbers are going to b reasonable for me to use to create a profile so as to assign it to my regular users and report users in order to restrict them to not eat all the resources like CPU and memory.
The default profile used by users is 'DEFAULT' which has 'unlimited' limits. I am mainly looking good numbers for
Currently I have create one like this:
create profile ABC limit
totally depends on what queries they are going to run
Run explain plan for what you consider the more expensive queries your users might run and start by setting limits twice the larger values you have found.
Over time you might have to fine tune limit values to accomodate real world situations.
Click Here to Expand Forum to Full Width