Oracle Server Manager User's Guide

Contents Index Home Previous Next

The Profiles Folder

When you click the Profiles folder tab, the Profiles folder opens and the Profile object list and menu appear. The following figure illustrates the Profile object list.

Figure 4 - 22. Profile Object List

Profile Object List

The Profile object list displays the names of all profiles defined for your database. A profile is a set of limits on database resources. When you assign a profile to a user, that user cannot exceed the limits set in the profile.

Oracle automatically creates a default profile named DEFAULT. The DEFAULT profile initially defines unlimited resources. You can alter the DEFAULT profile to change any of its resource limits.

Any user who is not explicitly assigned a profile is subject to the limits defined in the DEFAULT profile. Also, if the profile that is explicitly assigned to a user omits a limit for a resource or specifies the value DEFAULT for a limit, then the user is subject to the limit on that resource as defined in the DEFAULT profile.

Attention: The initialization parameter RESOURCE_LIMIT must be set to TRUE to enforce the limits set in database profiles. For more information, see the Oracle7 Server Reference.

For information about profiles, see the Oracle7 Server Concepts, the Oracle7 Server Administrator's Guide, and the Oracle7 Server SQL Reference.

Creating a Profile

To create a profile, choose Create from the Profile menu. The Create Profile property sheet appears.

The Create Profile property sheet consists of the following pages:

The following figure illustrates the Session and CPU page.

Figure 4 - 23. Session and CPU Page of the Create Profile Property Sheet

Create Profile: Session and CPU Page

The Session and CPU page is described below:

Profile Name Name of the new profile.
Enter the name of the profile to be created.
When you complete the CPU per Session, CPU per Call, Connect Time, and Idle Time fields, a pop-menu provides the following choices:

Default Use the limit specified for this resource in the DEFAULT profile.
Unlimited The user's access to this resource is unlimited.
Value Enter a value for the limit. The text entry fields are unavailable until you choose Value from the pop-up menu.
CPU per Session Total amount of CPU time allowed in a session.
Use the pop-up menu to choose a limit for total CPU time used in a session. The limit is expressed in hundredths of a second.
CPU per Call Maximum amount of CPU time allowed for a call (a parse, execute, or fetch).
Use the pop-up menu to choose a limit for the CPU time used for a call. The limit is expressed in hundredths of a second.
Connect Time Maximum elapsed time allowed for a session.
Use the pop-up menu to choose a limit for the total time for a session. The limit is expressed in minutes.
Idle Time Maximum idle time allowed in a session.
Idle time is a continuous period of inactive time during a session. Long-running queries and other operations are not subject to this limit.
Use the pop-up menu to specify a limit for idle time in a session. The limit is expressed in minutes.

Create Profile: Database Services Page

The following figure illustrates the Database Services page of the Create Profile property sheet.

Figure 4 - 24. Database Services Page of the Create Profile Property Sheet

The Database Services page is described below:

When you complete the Sessions per User, Reads per Session, and Reads per Call, a pop-menu provides the following choices:

Default Use the limit specified for this resource in the DEFAULT profile.
Unlimited The user's access to this resource is unlimited.
Value Enter a value for the limit. The text entry fields are unavailable until you choose Value from the pop-up menu.
Sessions per User Maximum number of concurrent sessions allowed for a user.
Use the pop-up menu to choose a limit for the number of concurrent sessions a user can have.
Reads per Session Total number of data block reads allowed in a session.
Use the pop-up menu to choose a limit for the number of data blocks read in a session, including blocks read from memory and disk.
Reads per Call Maximum number of data block reads allowed for a call (a parse, execute, or fetch).
Use the pop-up menu to choose a limit for the number of data blocks read for a call to process a SQL statement.
Private SGA Maximum amount of private space a session can allocate.
Use the pop-up menu to choose a limit for the amount of private space a session can allocate in the shared pool of the System Global Area (SGA). Use the pop-up menu to specify the limit in bytes, kilobytes, or megabytes. The Private SGA limit applies only if you are using the multi-threaded server architecture.
Composite Limit Total resource cost for a session.
The resource cost for a session is the weighted sum of the CPU time used in the session, the connect time, the number of reads made in the session, and the amount of private SGA space allocated.
Use the pop-up menu to choose a limit for the total resource cost for a session. The limit is expressed in service units.
Attention: In the SQL Worksheet, you can use the SQL command ALTER RESOURCE COST to specify the weights for the resources in the Composite Limit. For information about the ALTER RESOURCE COST command, see the Oracle7 Server SQL Reference.

Create Profile: Users Page

On the Users page of the Create Profile property sheet you can assign the profile to users. The following figure illustrates the Users page.

Figure 4 - 25. Users Page of the Create Profile Property Sheet

The Users page is described below:

Users Scrolling list of users who have been assigned the profile.
Assign Displays the Assign Profile dialog box. The Assign Profile dialog box is described in "Assign Profile Dialog Box" [*].
Remove Removes the user selected in the Users scrolling list.

Assign Profile Dialog Box

The Assign Profile dialog box allows you to assign a profile to a user. The following figure illustrates the Assign Profile dialog box.

Figure 4 - 26. Assign Profile Dialog Box

The Assign Profile dialog box is described below:

Users Scrolling list of users.
Assign Assigns the profile to the user selected in the Users scrolling list.

Altering a Profile

To alter the resource limits for an existing profile, select the profile to be altered from the Profile object list and choose Alter from the Profile menu. The Alter Profile property sheet appears. You can also bring up the Alter Profile property sheet by double-clicking on the profile in the Profile object list.

The Alter Profile property sheet consists of the following pages:

The following figure illustrates the Session and CPU page.

Figure 4 - 27. Session and CPU Page of the Alter Profile Property Sheet

Alter Profile: Session and CPU Page

The Session and CPU page is described below:

Profile Name Name of the new profile.
When you complete the CPU per Session, CPU per Call, Connect Time, and Idle Time fields, a pop-menu provides the following choices:

Default Use the limit specified for this resource in the DEFAULT profile.
Unlimited The user's access to this resource is unlimited.
Value Enter a value for the limit. The text entry fields are unavailable until you choose Value from the pop-up menu.
CPU per Session Total amount of CPU time allowed in a session.
Use the pop-up menu to choose a limit for total CPU time used in a session. The limit is expressed in hundredths of a second.
CPU per Call Maximum amount of CPU time allowed for a call (a parse, execute, or fetch).
Use the pop-up menu to choose a limit for the CPU time used for a call. The limit is expressed in hundredths of a second.
Connect Time Maximum elapsed time allowed for a session.
Use the pop-up menu to choose a limit for the total time for a session. The limit is expressed in minutes.
Idle Time Maximum idle time allowed in a session.
Idle time is a continuous period of inactive time during a session. Long-running queries and other operations are not subject to this limit.
Use the pop-up menu to specify a limit for idle time in a session. The limit is expressed in minutes.

Alter Profile: Database Services Page

The following figure illustrates the Database Services page of the Alter Profile property sheet.

Figure 4 - 28. Database Services Page of the Alter Profile Property Sheet

The Database Services page is described below:

When you complete the Sessions per User, Reads per Session, and Reads per Call, a pop-menu provides the following choices:

Default Use the limit specified for this resource in the DEFAULT profile.
Unlimited The user's access to this resource is unlimited.
Value Enter a value for the limit. The text entry fields are unavailable until you choose Value from the pop-up menu.
Sessions per User Maximum number of concurrent sessions allowed for a user.
Use the pop-up menu to choose a limit for the number of concurrent sessions a user can have.
Reads per Session Total number of data block reads allowed in a session.
Use the pop-up menu to choose a limit for the number of data blocks read in a session, including blocks read from memory and disk.
Reads per Call Maximum number of data block reads allowed for a call (a parse, execute, or fetch).
Use the pop-up menu to choose a limit for the number of data blocks read for a call to process a SQL statement.
Private SGA Maximum amount of private space a session can allocate.
Use the pop-up menu to choose a limit for the amount of private space a session can allocate in the shared pool of the System Global Area (SGA). Use the pop-up menu to specify the limit in bytes, kilobytes, or megabytes. The Private SGA limit applies only if you are using the multi-threaded server architecture.
Composite Limit Total resource cost for a session.
The resource cost for a session is the weighted sum of the CPU time used in the session, the connect time, the number of reads made in the session, and the amount of private SGA space allocated.
Use the pop-up menu to choose a limit for the total resource cost for a session. The limit is expressed in service units.
Attention: In the SQL Worksheet, you can use the SQL command ALTER RESOURCE COST to specify the weights for the resources in the Composite Limit. For information about the ALTER RESOURCE COST command, see the Oracle7 Server SQL Reference.

Alter Profile: Users Page

On the Users page of the Alter Profile property sheet you can view the users who are assigned the profile. The following figure illustrates the Users page.

Figure 4 - 29. Users Page of the Alter Profile Property Sheet

Dropping a Profile

If a profile is no longer needed, you can drop it. To drop a profile, select the profile to be dropped from the Profile object list and choose Drop from the Profile menu. The Drop Profile alert box appears.

The following figure illustrates the Drop Profile alert box.

Figure 4 - 30. Drop Profile Alert Box

The Drop Profile alert box indicates if the profile you wish to drop is assigned to any users. If you drop a profile that is assigned to users, Server Manager assigns the DEFAULT profile to them.

Attention: You cannot drop the DEFAULT profile.

Contents Index Home Previous Next