Profiles

From DBArtisan
Jump to: navigation, search

Go Up to Supported Objects

Profiles are a mechanism for allocating system and database resources to users. Profiles let you specify limits on:

  • Number of sessions
  • CPU time
  • Connect time
  • Idle time
  • Logical reads and space in the SGA's shared pool

You can assign profiles to one or more users. The database's default profile and all of its resource limits are assigned to users without a specific profile assignment.

Creating and editing

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

ORCL

Drop

Extract

Migrate

Report