Create a new user and modify the maximum number of connections at oracle11g, and create at oracle11g
Create user test identified by root; grant create session, resource to root; alter user test account unlock; grant create view to test; grant any sequece to test; grant create synonym to ich; -- the permission to create an alias is drop user test cascade. During connection, the user is case-insensitive. alter system set sec_case_sensitive_logon = false scope = both; commit; alter user Password alter user system identified by system;
Sequece test_seq created in user 1. If you want to use (select test_seq.nextval from dual) in user 2, select test_seq.nextval from dual must be executed in user 2; oracle is a complete process of creating users, creating tablespaces, authorizing, and creating tables. 1. log on to SQL plus: usename: sys as sysdba password: ***** 2. view the maximum number of connections: select value from V $ parameter where name = "processes"; 3. view current connections: select count (*) from V $ process; 4. change the maximum number of connections to 300: alter system set processes = 300 scope = spfile5. restart DB: shutdown immediate; startup;
How can I change the number of user connections in the oracle database?
Modify initSID. ora, increase process, and restart the database.
How does one increase the number of oracle user connections?
In your oracle installation directory, for example:
Oracle \ admin \ xxx \ pfile \ init. ora
Find
Processes = zzz
Change zzz to the value you want. xxx indicates your database name.
Note that the maximum number of user connections is related to your hardware configuration, so be careful.