Simply talk about Oracle's profile.

1. Query the profile information: SELECT * from SYS. Dba_profiles;

SELECT * from SYS. Dba_profiles where profile= ' DEFAULT ';

2.

An example of creating a profile:

1. CREATE profile "TEST"

2. LIMIT

3. Cpu_per_session 1000

4. Cpu_per_call 6000

5. Connect_time 60

6. Idle_time 15

7. Sessions_per_user 1

8. Logical_reads_per_session 1000

9. Logical_reads_per_call 1000

Ten. Private_sga 4K

Composite_limit 1000000

Failed_login_attempts 3

10. Password_lock_time

Password_grace_time 30

30. Password_life_time

Password_reuse_max UNLIMITED

60. Password_reuse_time

Password_verify_function DEFAULT

Explanation:

1. Create a profile named TEST .

2. keyword limit(limited)

3.       cpu_per_session indicates occupancy cpu time (session-based), which is consumed by any session cpu ( 1/100 seconds ) 。

4. Cpu_per_call represents CPU time (based on calling SQL statements), which is consumed by any single database call in any session CPU amount of Time ( The amount of time is 1/100 seconds ) .

5. Connect_time means that the connection time is allowed and any session connection time is limited to a specified time in minutes.

6. Idle_time indicates the allowable idle time, in minutes, for any one session to be allowed.

7. Sessions_per_user represents the maximum number of concurrent sessions for a user ( Specifies the number of sessions for a user ).

8. Logical_reads_per_session Read number / session, a limit on the number of logical blocks that a session allows to read and write ( in blocks ) .

9. Logical_reads_per_call Read number / Call, the number of logical blocks allowed to read and write during a single invocation of SQL ( Unit as Block ).

PRIVATE_SGA represents a dedicated SGA, (units can specify K or M).

Composite_limit represents the combination limit, a composite limit based on the preceding limitations, including:cpu_per_session, Connect_time, logical_reads_per_session and PRIVATE_SGA ( Unit of service Unit ).

Failed_login_attempts indicates that the user is locked out ( in units of times )after several unsuccessful logons.

Password_lock_time indicates the number of days that an account will be locked if it exceeds the Failed_login_attempts setting value ).

Password_grace_time indicates the number of days after which the password has been locked, allowing the password to be changed ( in days )during this period.

Password_life_time indicates the validity period (in days) of a user's password .

Password_reuse_max indicates how many times the original password needs to be modified before it is allowed to be reused ( in units of time ).

Password_reuse_time indicates how many days before a password is modified to be reused ( in days ).

Password_verify_function represents the enabled password complexity function (null,default , or one of the function names )todetermine the complexity of the password.

added: The above parameters, in addition Password_verify_function , the values for other parameters are numeric,UNLIMITED(Unrestricted), or default(system default).

Other:

Modify content of Profie:

1,ALTER profile Name parameter new value ;

2, for the current connection modification does not take effect

To delete a profile:

Drop Profile file name ;

assign to a specific user Summary File

ALTER USER name profile name ;

Change user's profile to default

Alter user username profile default;

View information about a profile

SELECT * from user name . Summary File ;

Simply talk about Oracle's profile.