《Oracle 9i & 10g 编程艺术：深入数据库体系结构》第38页

利用概要文件（profile）方式：

1、创建一个名称为one_session的概要文件
2、为概要文件one_session设置sessions_per_user=1的limit
3、为用户分配one_session概要文件
4、设置数据库参数resource_limit=true

下面演示具体操作过程：

[@more@]

ora_test@oracle[/home/oracle]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 16 10:12:15 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

sys@CNHTM> create profile one_session limit sessions_per_user 1;

Profile created.

sys@CNHTM> alter user scott profile one_session;

User altered.

sys@CNHTM> alter system set resource_limit=true;

System altered.

sys@CNHTM> conn scott/tiger
Connected.
scott@CNHTM> ! sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 16 10:13:26 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Enter user-name:

--end--

ITPub博客

怎么确保最终用户在Oracle数据库中只有一个会话

最新文章