SESSIONS_PER_USER: Specify the number of concurrent sessions to which you want to limit the user.
CPU_PER_SESSION: Specify the CPU time limit for a session, expressed in hundredth of seconds.
CPU_PER_CALL: Specify the CPU time limit for a call (a parse, execute, or fetch), expressed in hundredths of seconds.
CONNECT_TIME: Specify the total elapsed time limit for a session, expressed in minutes.
IDLE_TIME: Specify the permitted periods of continuous inactive time during a session, expressed in minutes. Long-running queries and other operations are not subject to this limit.
LOGICAL_READS_PER_SESSION: Specify the permitted number of data blocks read in a session, including blocks read from memory and disk.
LOGICAL_READS_PER_CALL: Specify the permitted the number of data blocks read for a call to process a SQL statement (a parse, execute, or fetch).
PRIVATE_SGA: Specify the amount of private space a session can allocate in the shared pool of the system global area (SGA), expressed in bytes. Use K or M to specify this limit in kilobytes or megabytes.
COMPOSITE_LIMIT: Specify the total resource cost for a session, expressed in service units. Oracle calculates the total service units as a weighted sum of CPU_PER_SESSION, CONNECT_TIME, LOGICAL_READS_PER_SESSION, and PRIVATE_SGA.
详见:
http://download-west.oracle.com/ ... ts_611a.htm#2066026 |