Database Administrator

Two Methods for patching Grid Infrastructure are described in detail. Patching is an important task for system administrators. Oracle Grid Infrastructure is currently a complex cluster management middleware. In the case of various strange problems,

Oracle 11 GB is imported from instance 1 full database to instance 2 on the same Linux Server Export command in the early stage: [root@powerlong4 ~]# su - Oracle[oracle@powerlong4 ~]$ export ORACLE_SID=pt1;[oracle@powerlong4 ~]$ expdp

PostgreSQL date calculation function usage PostgreSQL date calculation function usage I. connector in each data SqlServer connector: + (plus sign) Sqlite connector:. (point) PostgreSQL connector: | (OR) II: Today, when I was computing data in

Small files automatically merged and output based on Hive Optimization   1. First set the small file standard in the hive-site.xml.   hive. merge. smallfiles. avgsize 536870912 When the average output file size of a job is less than this number,

PreparedStatement and Statement, preparedstatement PreparedStatement is one of the APIs used to execute SQL query statements. Java provides Statement, PreparedStatement, and CallableStatement to execute query statements. Statement is used for

Standard (important) for mysql Data Types 1. allowed value: the range and type of values in a field are allowed to determine which data type is the most direct factor to add to this field. 2. storage efficiency: it is also important to consider

Centos6.5 install mysql5.6 and centos6.5mysql5.61. Check the version number first. # uname -a2. Download and install Mysql's yum Repository Download the yum repository of Mysql Http://dev.mysql.com/downloads/repo/yum/ Then install the repository

Datazen configuration, datazenZookeeper Datazen is a full-platform data presentation solution for mobile terminals acquired by Microsoft. This article mainly introduces the configuration process of the server.   After the previous basic installation

Mysql innodb insert intention lock, mysqlinnodb Innodb has an insert intention lock, specifically for Insert. If the gap is already locked by the gap before insertion, insert will apply for the Insert intention lock. So what is the role of this

The old mysql table is deduplicated and the new table is imported with a new value of the primary key id. Business Requirements: Table A has the id, n1, n2, and n3 fields to create an empty table, Table B has fields such as id, n1, n2, n3, n4,

Datazen introduction, datazenZookeeper Datazen is a mobile platform-wide Chart solution. Based on HTML5 applications, Datazen integrates the entire platform. This article mainly introduces its functions. This platform has just been acquired by

How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the oracle database, oracleplsql How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the

MHA routine management and mha ManagementMHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication

Merge fields with the same mysql content into one method. mysql Fields The data taken from the two tables inline. The category_name field has the same content. to merge fields with the same content, add the amount field to the following table.

Use API to create an AR credit notification and an apiar credit notification DECLARE -- 8000000063 l_dummy varchar2 (240); l_customer_trx_id percent % type; l_line_credits_flag percent % type; l_line_amount number; l_freight_amount number: = 0;

Troubleshooting of inconsistent data query results in ORACLE databases I. Problem Description In a software development project, you need to create ten identical employee information tables in the ORACLE database tb_employeeinfo0 ~ Tb_employeeinfo9

Clustered and non-clustered indexes, I. An in-depth understanding of the index structureIn fact, you can think of indexes as a special directory. Microsoft's SQL SERVER provides two types of indexes: clustered index (also called clustered index and

Programmer's path to quantitative transaction (17) -- Cointrader's Temporal entity (5); programmer's path to quantitative transaction Reprint need to note: http://blog.csdn.net/minimicall,http://cloudtrader.top/ This section describes a time entity

Difference between truncate and delete: truncatedelete Truncate table players; equivalent to delete from players; or delete players. * from players; 1. truncate is fast. If the rollback command is available, delete will be revoked, but truncate

Mysql function 2 Iv. Conditional judgment functions 1. if (expr, v1, v2): returns the result v1. Otherwise, select id, if (grade> = 60, 'pass', 'fail ') from t; 2. IFNULL (V1, V2) function: If v2 is empty, otherwise v1 is displayed, for example: