Home Oracle Commands

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

"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 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



Back to the Top

Simon Sheppard
SS64.com