oracle默认参数文件,oracle更改用户默认参数文件

1、查看用户时候用的参数文件

SELECT username,PROFILE FROM dba_users where username=‘CESHI’;

SQL> SELECT username,PROFILE FROM dba_users where username='CESHI';

USERNAME PROFILE

------------------------------ ------------------------------

CESHI DEFAULT

(2) 创建一个新的profile文件：

SQL>create profile ceshi_profile1

limit connect_time unlimited

idle_time unlimited;

SQL> create profile ceshi_profile1

limit connect_time unlimited

idle_time unlimited; 2 3

Profile created.

(3)查看新的参数文件

SELECT * FROM dba_profiles s WHERE s.profile=‘CESHI_PROFILE1’;

SQL> SELECT * FROM dba_profiles s WHERE s.profile='CESHI_PROFILE1';

PROFILE RESOURCE_NAMERESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

CESHI_PROFILE1 COMPOSITE_LIMITKERNEL DEFAULT

CESHI_PROFILE1 SESSIONS_PER_USERKERNEL DEFAULT

CESHI_PROFILE1 CPU_PER_SESSIONKERNEL DEFAULT

CESHI_PROFILE1 CPU_PER_CALLKERNEL DEFAULT

CESHI_PROFILE1 LOGICAL_READS_PER_SESSIONKERNEL DEFAULT

CESHI_PROFILE1 LOGICAL_READS_PER_CALLKERNEL DEFAULT

CESHI_PROFILE1 IDLE_TIMEKERNEL UNLIMITED

CESHI_PROFILE1 CONNECT_TIMEKERNEL UNLIMITED

CESHI_PROFILE1 PRIVATE_SGAKERNEL DEFAULT

CESHI_PROFILE1 FAILED_LOGIN_ATTEMPTSPASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_LIFE_TIMEPASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_REUSE_TIMEPASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_REUSE_MAXPASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_LOCK_TIMEPASSWORD DEFAULT

CESHI_PROFILE1 PASSWORD_GRACE_TIMEPASSWORD DEFAULT

(4) 将这个新的配置文件分配给该用户：

SQL>alter user ceshi profile ceshi_profile1;

SQL> alter user ceshi profile ceshi_profile1;

User altered.

(5)查看是否分配成功

SQL> SELECT username,PROFILE FROM dba_users where username=‘CESHI’;

SQL> SELECT username,PROFILE FROM dba_users where username='CESHI';

USERNAME PROFILE

------------------------------ ------------------------------

CESHI CESHI_PROFILE1

ps：

更改回默认参数文件：alter user ceshi profile default;