Oracle中如何保证用户只有一个session登录
Oracle中如何保证用户只有一个session登录SQL> create profile one_session limit sessions_per_user 1;SQL> create user test identified by test;User created. www.zzzyk.comSQL> grant connect,resource to test;Grant succeeded.SQL> alter user test profile one_session;SQL> alter system set resource_limit=true;sqlplus test/testhost sqlplus test/testERROR:ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit但有个条件是如果是RAC, 则在其他instance还可以登录