User Resource Consumption

User Resource Consumption - User Resource Consumption...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
User Resource Consumption Exceeding a Call-Level Limit: The current statement is rolled back An error message is displayed All previous statements remain intact The user’s session remains connected Exceeding a Session-Level Limit: An error message is returned The user session is disconnected Initialization file and the ALTER TABLE methods are available for enabling or disabling the enforcement of resource limits Altering initialization file- Used when instance can be restarted, resource_limit can be either TRUE or FALSE, ALTER SYSTEM command- used when instance cannot be shut down, changes not reflected in the database parameter file ALTER SYSTEM SET RESOURCE_LIMIT=TRUE; SELECT p.profile, p.resource_name, p.limit FROM dba_users u, dba_profiles p WHERE p.profile=u.profile AND username=’SCOTT’ AND p.resource_type=’KERNEL’; Enforcing Resource Limits: CPU_PER_SESSION- measured in hundredths of a second SESSIONS_PER_USER- limits number of concurrent logins possible for a user CONNECT_TIME- resource limits from time a session starts till it terminates
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at Arizona.

Page1 / 2

User Resource Consumption - User Resource Consumption...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online