ops$tkyte@ORA10G> create profile one_session limit sessions_per_user 1;
Profile created.
ops$tkyte@ORA10G> alter user username profile one_session;
User altered.
ops$tkyte@ORA10G> alter system set resource_limit=true;
System altered.
ops$tkyte@ORA10G> connect username/password@servicename
Connected.
scott@ORA10G> host sqlplus scott/tiger
SQL*Plus: Release 10.1.0.2.0 - Production on Sun Nov 28 12:49:49 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
ERROR:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Enter user-name: