Python data analysis helps you clearly understand the efficiency and overall satisfaction of the employees

  preface The text and pictures of this article are from the Internet, only for learning and communication, and do not have any commercial use. The copyright belongs to the original author. If you have any questions, please contact us in time for handling. Project background 2018 is known as the winter year of the Internet. Companies, big and ...

Added by amar3d on Mon, 29 Jun 2020 09:51:49 +0300

Finding a few small math problems for ReentrantReadWriteLock is enough

Preface Article Java AQS Queue Synchronizer and ReentrantLock Application This paper introduces the implementation of AQS exclusive acquisition of synchronization state, and illustrates how ReentrantLock customizes synchronizer mutually exclusive lock. Article Java AQS Shared Obtain Synchronization Status and Semaphore Application Analysis In ...

Added by hank9481 on Wed, 24 Jun 2020 05:01:25 +0300

Database idle connection disconnection caused by firewall

catalog 1, Problem description 2, Step by step analysis of problems 1, java.net.SocketException : how is the broken pipe exception generated? What's the impact? 2. Why is the database TCP connection broken? 3. The effect of firewall cutting off database connection 3, Solutions 1. Adjust the cut-of ...

Added by Popcorn on Fri, 05 Jun 2020 10:51:02 +0300

[12c] let you know the collection of Extended Statistics of Oracle 12c database

In the Oracle database, the optimizer needs to rely on the collection of statistical information of related objects in order to generate the optimal execution plan. The database can automatically collect the execution plan or use the package DBMS_STATS is collected manually. This article does not explain the collection of general statistics. It ...

Added by libertyct on Wed, 27 May 2020 15:38:34 +0300

oracle uses stored procedures for row to column conversion (executing dynamic SQL statements)

---------------------------------------------------------------Table building----------------Determine whether the student table exists declare num number; --Declare parameters num type number begin --start select count(1) into num from user_tables where table_name='student'; if num>0 then execute immediate 'drop table st ...

Added by crinkle on Thu, 21 May 2020 18:21:15 +0300

Introduction to Connection-Control for MySQL

In Oracle and SQL Server databases, you can set up some complex account password policies, such as locking an account more than N times after a failed login, so can you do the same in MySQL?The answer is that MySQL has similar capabilities, except in MySQL it delays the response time when its login fails beyond the threshold, instead of locking ...

Added by marco839 on Tue, 19 May 2020 20:23:28 +0300

The method of modifying and listening IP address in oracle

Modifying and listening IP address of oracle Reference and combine these two blogs Modifying and listening IP address of oracle Oracle modify listening IP address In a very simple way, the problem of monitoring is solved. Now let's combine and rearrange it 1. In cmd, enter hostname discovery hostname 2. Modify the ...

Added by ubunken on Tue, 05 May 2020 23:03:59 +0300

HAProxy https configuration, four-tier load balancing, and access control for load balancing services

In the previous section, we talked about the configuration of haproxy's access control ACL. For a review, please refer to https://www.cnblogs.com/qiuhom-1874/p/12817773.html ; Today let's talk about the configuration of haproxy's https, tcp-based four-tier load balancing, and access control. First let's look at the configuration of haproxy's ht ...

Added by amandas on Sun, 03 May 2020 09:12:33 +0300

Oracle advanced query (1)

topN query select * from emp where rownum=1 or rownum=2; select * from (select * from emp order by sal desc) where rownum<5; 1 2 Paging query select * from (select rownum no,e.* from(select * from emp order by sal desc) e where rownum<=5) where no>=3; select * from (select rownum no,e.* from(select * from emp order by ...

Added by infid3l on Sat, 02 May 2020 23:53:05 +0300

11gRAC local data file migration to ASM

Environment related: OS: CentOS release 6.6 RAC: 11.2.0.4.0 dual node ASM Library 1. Cause of failure Today, four data files are added in batches. add datafile '+ DATADG' in the second to fourth data file add SQL misses' + '. After oracle successfully adds the first data file, it is found that the second data fil ...

Added by grahamb314 on Fri, 01 May 2020 22:00:41 +0300