Example 1

    The following example specifies the allowed transaction modes for
    any user assigned this profile.

    SQL> CREATE PROFILE DECISION_SUPPORT
    cont>   COMMENT IS 'limit transactions used by report writers'
    cont>   TRANSACTION MODES (NO READ WRITE, READ ONLY);

    Example 2

    This example shows the use of the LIMIT clauses to set boundaries
    for standard database users.

    SQL> create profile STANDARD_USER
    cont>    limit rows 10000
    cont>    limit time 10 minutes
    cont>    limit cpu time 20 seconds;
    SQL> show profile STANDARD_USER;
         STANDARD_USER
         Limit rows 10000
         Limit time 10 minutes
         Limit CPU time 20 seconds
    SQL> alter profile STANDARD_USER
    cont>    limit time 60 minutes;