Shulou(Shulou.com)06/01 Report--

Method 1. Set parameters in sqlnet.ora

If you need to set the client to be idle for 10 minutes, add SQLNET.EXPIRE_TIME = 10 at the end of the sqlnet.ora Note: the path to the sqlnet.ora file is under $ORACLE_HOME/network/admin. Method 2. Setting in Oracle Profile

Do the following on the production library:

SQL > col name format A15

SQL > col value format A10

Query whether resource limit is enabled:

SQL > SELECT name, value FROM gv$parameter WHERE name = 'resource_limit'

NAME VALUE

--

Resource_limit FALSE

If not, enable this parameter:

SQL > ALTER SYSTEM SET RESOURCE_LIMIT=TRUE

System altered.

SQL > SELECT name, value FROM gv$parameter WHERE name = 'resource_limit'

NAME VALUE

--

Resource_limit TRUE

Create a Profile that is idle for 10 minutes to abort idle routines:

SQL > CREATE PROFILE app_user LIMIT IDLE_TIME 10

Profile created.

Set the user's Profile:

SQL > alter user mzh profile app_user

You can also modify the IDLE_TIME in an existing Profile:

SQL > ALTER PROFILE DEFAULT LIMIT IDLE_TIME 10

Access the database through the local connection string (by listening):

C:\ Windows\ SysWOW64 > sqlplus "mzh/mzh" @ LOCAL_11G_localhost

SQL*Plus: Release 11.2.0.1.0 Production on Monday September 5 16:41:43 2011

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

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > select * from dual

D

-

X

Wait 1 minute before execution:

SQL > select * from dual

Select * from dual

*

An error occurred on line 1:

ORA-02396: maximum idle time exceeded, please reconnect

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.