Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ PLSQL often lose resolution process automatically disconnect the connection     - Articles do not resolve after opening under Ubuntu WordPress setting a fixed link (Server)

- Linux commands to access the cheat sheet (Linux)

- To install Docker under Ubuntu 15.04 (Linux)

- Linux Mint brightness adjustment --xrandr command learning (Linux)

- Linux / Centos anti CC attack script (Linux)

- About ORA-02391 solution (Database)

- Linux Getting Started Tutorial: How to set up a static MAC address on VMware ESXi virtual machine (Mobile)

- 20 Advanced Java interview questions summary (Programming)

- Oracle 11g forget approach SYS and SYSTEM password (Database)

- Linux Security Setup Guide (Linux)

- Oracle ORA-01089 failure analysis (Database)

- Mhddfs: multiple smaller partitions into one large virtual storage (Linux)

- Java multi-threaded in a three way (inheritance, implementation, anonymous inner classes) (Programming)

- JDK tools jstat (Linux)

- Ubuntu / Fedora / CentOS system how to install Plex Media Server 0.9.9 (Linux)

- How to force Linux users to change the initial password the first time you log in (Linux)

- Linux dynamic libraries and Guide (Programming)

- RHEL7 Apache MPM configuration (Server)

- Linux system find command Detailed (Linux)

- Ubuntu 14.10 Install Ubuntu Touch Music App 2.0 (Linux)

 
         
  PLSQL often lose resolution process automatically disconnect the connection
     
  Add Date : 2018-11-21      
         
         
         
  Background to the issue:

This is the case, many developers time to work colleagues PLSQL drove eight hours, sometimes after they went out to smoke or noon meal, come back on the implementation of the above in PLSQL given no response, then stuck for a long time could not move, you have to re Login plsql to take effect, I guess for the sake of joint failure, often encounter this situation has not affected the work efficiency and mood.

1, to review the following CONNECT_TIME connection time

SQL> select * from dba_profiles t wheret.resource_name = 'CONNECT_TIME';

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT

-------------------------------------------------- -------------------------------------- ------------ ---------------

DEFAULT CONNECT_TIME KERNEL UNLIMITED

MONITORING_PROFILE CONNECT_TIME KERNEL DEFAULT

TMPOPT CONNECT_TIME KERNEL DEFAULT

MYPROFILE CONNECT_TIME KERNEL DEFAULT

SQL>

See 4, then how to find the user profile powerdesk it belongs? To view the current user CONNECT_TIME

SQL> select * from user_resource_limits;

RESOURCE_NAME LIMIT

-------------------------------------------------- ----------------------

COMPOSITE_LIMIT UNLIMITED

SESSIONS_PER_USER UNLIMITED

CPU_PER_SESSION UNLIMITED

CPU_PER_CALL UNLIMITED

LOGICAL_READS_PER_SESSION UNLIMITED

LOGICAL_READS_PER_CALL UNLIMITED

IDLE_TIME UNLIMITED

CONNECT_TIME UNLIMITED

PRIVATE_SGA UNLIMITED

9 rows selected

SQL>

See CONNECT_TIME is UNLIMITED, no limits, so why plsql connection will appear unresponsive phenomenon?

2, cmd to go inside with sqlplus connection verification

sqlplus connection, the last 30 minutes of operation, the operator db connection again, normal use, and it seems that this has nothing to do Oracledb should go and see plsql is provided

3, which is set to plsql

Plsql enter the Tools, then enter Preferences, then select the Connection selection on the left, select Check connection

It would be more stable, of course you may not PLSQL open one day, and then go will be delayed for a while, but a short time there will not be out of order.

PS: follow-up questions, PLSQL not disconnect, but you closed the previously opened files or execute sql window or get stuck, report the situation is not responding, so long as such forced to re-open closed PLSQL logged.
     
         
         
         
  More:      
 
- Inxi: Get Linux system and hardware information (Linux)
- Firewall Configuration Red Hat Enterprise Linux 4 (Linux)
- Linux Mint brightness adjustment --xrandr command learning (Linux)
- Setup Qt development environment under Linux (Linux)
- Using Linux strace command trace / debug a program commonly used options (Linux)
- How to use SVN to manage our source code (Server)
- Use Python automatically cleared Android Engineering excess resources (Programming)
- How screenshots from the Linux command line (Linux)
- Several start-up mode of Tomcat (Server)
- Try debugfs restore the deleted files ext3 file system (Linux)
- Tsung first test installation (Linux)
- Use IP address spoofing Intrusion Prevention Firewall (Linux)
- How to forcibly change the Linux system password on a regular basis (Linux)
- impdp error ORA-39001, ORA-39000, ORA-31619 (Database)
- CentOS minimal network is unavailable resolved (Linux)
- ssh using scp: / directory: Permission denied (Server)
- VMware installed Linux system and JDK deployment (Linux)
- Java multi-threaded in a three way (inheritance, implementation, anonymous inner classes) (Programming)
- MySQL 5.6 master-slave replication configuration (Database)
- Linux system on how to use rsync to synchronize data (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.