yang738

0 积分	0 好友	5 主题

发消息

[SQL调优] toad 连接十分钟左右自动断开

1^#

发表于 2013-4-29 14:25:44 | 查看: 5378| 回复: 4

toad 9 连接oracle 10g 时，每空闲十分钟左右就断开。现在希望TOAD一直连接着数据库，除非手动断开。

1:首先确认用户的PROFILE是DEFAULT 且RESOURCE_LIMIT=TRUE.

2:select * from dba_profiles WHERE PROFILE='DEFAULT'
DEFAULT,COMPOSITE_LIMIT,KERNEL,UNLIMITED
DEFAULT,SESSIONS_PER_USER,KERNEL,UNLIMITED
DEFAULT,CPU_PER_SESSION,KERNEL,UNLIMITED
DEFAULT,CPU_PER_CALL,KERNEL,UNLIMITED
DEFAULT,LOGICAL_READS_PER_SESSION,KERNEL,UNLIMITED
DEFAULT,LOGICAL_READS_PER_CALL,KERNEL,UNLIMITED
DEFAULT,IDLE_TIME,KERNEL,UNLIMITED
DEFAULT,CONNECT_TIME,KERNEL,UNLIMITED
DEFAULT,PRIVATE_SGA,KERNEL,UNLIMITED
DEFAULT,FAILED_LOGIN_ATTEMPTS,PASSWORD,10
DEFAULT,PASSWORD_LIFE_TIME,PASSWORD,UNLIMITED
DEFAULT,PASSWORD_REUSE_TIME,PASSWORD,UNLIMITED
DEFAULT,PASSWORD_REUSE_MAX,PASSWORD,UNLIMITED
DEFAULT,PASSWORD_VERIFY_FUNCTION,PASSWORD,NULL
DEFAULT,PASSWORD_LOCK_TIME,PASSWORD,UNLIMITED
DEFAULT,PASSWORD_GRACE_TIME,PASSWORD,UNLIMITED

3:尝试查找TOAD的TIMEOUT 设置，未果。

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-4-30 13:39:09

sqlnet.ora
listener.ora

呢？

回复只看该作者道具举报

yang738

3^#

发表于 2013-5-2 12:35:54

以下是sqlnet.ora 及 listener.ora文件的内容。请帮忙诊断。多谢

oracle@pgdwh001$ cd $ORACLE_HOME
oracle@pgdwh001$ cd network
oracle@pgdwh001$ cd admin
oracle@pgdwh001$ ls
listener.ora       samples             shrept.lst          sqlnet.ora          tnsnames.backup.ora  tnsnames.ora
oracle@pgdwh001$ more sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

oracle@pgdwh001$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (PROGRAM = extproc)
)
(SID_DESC =
   (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
   (SID_NAME = DWH)
)

  )

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   (ADDRESS = (PROTOCOL = TCP)(HOST = pgdwh001)(PORT = 1521))
)
  )

oracle@pgdwh001$ hostname
pgdwh001
oracle@pgdwh001$ pwd
/u01/app/oracle/product/10.2.0/db_1/network/admin
oracle@pgdwh001$

回复只看该作者道具举报