oracle登录次数限制,我想限制一个机器连接oracle的次数

你可以启用DCD---- Dead Connection Detection

Q: What is Dead Connection Detection?

A: Dead Connection Detection (DCD) allows SQL*Net/Net8 to identify connections    that have been left hanging by the abnormal termination of a client. This    feature minimizes the waste of resources by connections that are no longer    valid.  It also automatically forces a rollback of uncommitted transactions    and locks held by the user of the broken connection.

Q: How does Dead Connection Work?

A: On a connection with DCD enabled, a small probe packet is sent from server    to client at a user defined interval (usually several minutes).  If the    connection is invalid (usually due to the client process or machine being    unreachable), the connection is closed when an error is generated by the send    operation, and the server process terminates the connection.

Q: How do you set the Dead Connection Detection feature?

A: DCD is enabled on the server side of the connection by defining a parameter    in the sqlnet.ora file in $ORACLE_HOME/network/admin called    sqlnet.expire_time. This parameter determines the time period between    successive probe packets across a connection between client and server.

SQLNET.EXPIRE_TIME=

The sqlnet.expire_time parameter is defined in minutes and can have any value    between 1 and an infinite number.  If it is not defined in the sqlnet.ora    file, DCD is not used.  A time of 10 minutes is probably optimum for most    applications.

DCD probe packets originate on the server side, so it must be enabled on the    server side. If you define sqlnet.expire_time on the client side, it will be    ignored.

参考metalink: note 1018160.6