查询及修改oracle的连接数:
>conn /as sysdba; --sysdba
>select count(*) from v$process; --当前的连接数:
>select value from v$parameter where name = 'processes'; --数据库允许的最大连接数:
>alter system set processes = 3000 scope = spfile; --修改最大连接数:
>shutdown immediate; --重启数据库:
>startup;
创建用户:
> conn / as sysdba;
> create user username identified by password; --创建
> grant dba to username; --授权
> conn username/password;
> select * from user_sys_privs;
>conn /as sysdba; --sysdba
>select count(*) from v$process; --当前的连接数:
>select value from v$parameter where name = 'processes'; --数据库允许的最大连接数:
>alter system set processes = 3000 scope = spfile; --修改最大连接数:
>shutdown immediate; --重启数据库:
>startup;
创建用户:
> conn / as sysdba;
> create user username identified by password; --创建
> grant dba to username; --授权
> conn username/password;
> select * from user_sys_privs;