If an operation exceeds a
limit for a single call (such as LOGICAL_READS_PER_CALL), the operation is aborted, the current
statement is rolled back, and an error is returned to the user. The rest of the transaction remains
intact; the user can then roll back, commit, or attempt to complete the transaction without
exceeding statement limits.
Oracle provides the DEFAULT profile, which is applied to any new user if no other profile is
specified. This query against the data dictionary view DBA_PROFILES reveals the limits for the
DEFAULT profile:
SQL> select * from dba_profiles
2 where profile = 'DEFAULT';
PROFILE RESOURCE_NAME RESOURCE LIMIT
---------------- ------------------------- -------- -------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
294 Oracle Database 11g DBA Handbook
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
16 rows selected.
Pages:
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495