ALTER RESOURCE COST

Define the resource costs used by the CREATE PROFILE command

Syntax:

   ALTER RESOURCE COST option(s)

options are any combination of

   CPU_PER_SESSION int
   CONNECT_TIME int
   LOGICAL_READS_PER_SESSION int
   PRIVATE_SGA int

int is the integer weight applied to each option

The units being costed are
CPU = 1/100 sec
connect_time = 1/100 sec
SGA = bytes

You must have the system privilege: ALTER RESOURCE COST

"There is no such thing as an ugly woman - there are only the ones who do not know how to make themselves attractive" ~ Christian Dior

Related Oracle Commands:

PROFILE - CREATE PROFILE
PROFILE - ALTER PROFILE

Related Views:

 DBA_PROFILES
 DBA_SYS_PRIVS          USER_SYS_PRIVS      ROLE_SYS_PRIVS
 V$SESSION
 V$SESSION_CONNECT_INFO
 V$SESSTAT
 V$SESS_IO


 
Copyright © 1999-2024 SS64.com
Some rights reserved