Java reflection -- Reflection and class operation

Content learned in: edu.aliyun.com 1. Reflection acquisition class structure                              .    if you suddenly find that you need ...

Posted by osram on Thu, 06 Feb 2020 05:25:58 -0800

CommVault common Oracle backup commands

In the process of configuration, initiation and recovery of Oracle database backup, many Oracle database commands are needed. In this chapter, I will sort out the commands for your reference. Oracle user and instance related commands Linux/Unix platform # ps -ef | grep [p]mon orauxdb 18751 1 ...

Posted by n8r0x on Sun, 02 Feb 2020 01:09:46 -0800

Oracle stored PROCEDURE

Stored procedure A set of SQL statements used to complete specific database functions, which are compiled and stored in the database system. In use, the user calls and executes the stored procedure by specifying the defined stored procedure name and giving the corresponding stored procedure parameters, thus completing one or a series of databas ...

Posted by excessnet on Fri, 31 Jan 2020 01:19:42 -0800

Test, data pump export during DML operation

The main test is what happens to expdp when a table has DML action. This test mainly opens three windows, one is to insert data, about 100W pieces will be inserted for a long time. The second window queries the inserted data, of course, it does not query 100W pieces. In the third window, when inserting data, perform data pump e ...

Posted by danville on Wed, 29 Jan 2020 08:02:52 -0800

Spring Boot Integrates MyBatis to Connect to Oracle Database

1. Spring Boot project adds MyBatis dependencies and Oracle drivers: <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>com.oracle</groupId> <a ...

Posted by mtimdog on Sat, 25 Jan 2020 08:22:24 -0800

Backup database using cp command

cp command backup is a warm, full backup, the backup process needs to maintain a global read lock, this lock is more lethal to the database, it is likely to make the database hang in production environment, so it is not recommended to use in production environment. 1. Backup 1. Add a global read lock to the backup library: fl ...

Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800

linux redhat6 Oracle11g rac +lvm +asm installation process summary experience

linux redhat6 Oracle11g rac +lvm +asm installation process summary experience Installation environment Main operating system: windows 10 Virtual machine VMware 15: Two Red Hat Enterprise linux 6.10 Package: Oracle Database software: Oracle11gR2 Cluster software: Oracle grid infrastructure 11gR2(11.2. ...

Posted by Heywood on Thu, 16 Jan 2020 01:37:19 -0800

How do I view all foreign keys for a table or column?

stay MySQL How to get a list of all foreign key constraints to a specific table? Specific columns? This and The Oracle problem Same, but for MySQL. #1 building Post old answers to add some useful information. I have a similar problem, but I also want to look at constraint'u type and referred t ...

Posted by Bike Racer on Mon, 13 Jan 2020 18:04:15 -0800

Install JDK under centos 7.x for Tool Man Series, summarizing in more detail

Step 1: Check the JDK View the JDK version and type: java-version on the command line [root@test ~]# java -version bash: java: command not found As above, prove that your linux is very clean, go directly to Step 2 Or the following [root@test ~]# java -version openjdk version "1.8.0_102" OpenJDK Runtime Environment (build 1.8.0_102-b14) OpenJD ...

Posted by Cruzado_Mainfrm on Sun, 12 Jan 2020 09:33:43 -0800

Fuzzy query (LIKE) concat (string join function)

1. If you need to find the records with "three" and "cat" in U ﹣ name, please use and condition Select * from [user] where u name like '% 3%' and u name like '% cat%' If you use select * from [user] where u name like '% 3% cat% Although we can search for "tripods", we can't search for "Zhang ...

Posted by Mr_Mako on Mon, 06 Jan 2020 04:06:35 -0800