2 Replies Latest reply: Nov 19, 2012 12:43 AM by 886954 RSS

    Define percentage in dba_profile for cpu_per_session, cpu_per_call

      Hi All,

      We are using Oracle Database 10g Enterprise Edition Release

      We would like to apply customize dba_profile on specific users, in this profile we want to restrict the percentage as 10% of following parameters,
      cpu_per_session, cpu_per_call, logical_reads_per_session and logical_reads_per_call

      We have found that the values for cpu_per_session, cpu_per_call can be define in seconds.

      Would you pls advice how can we calculate the percentage of these paramters?