Database Administrator

PostgreSQL Select Source Code Analysis This time sequence diagram is relatively large, but it roughly describes the general process for PostgreSQL to process simple SQL statements. The client initiates an SQL statement. After receiving the Statement

Oracle 11g creates the second instance on Linux The Linux server host is not enough, and the tester needs a new Oracle environment for testing. Therefore, the tester is prepared to create a second instance on the existing Oracle Linux host. This

PostgreSQL source code customization: online global read only Based on a certain functional requirement on the cloud, a function similar to MySQL global read only has been recently implemented. PostgreSQL's read only function does not need to be

In PL/SQL, how does one insert a data entry every several seconds? In compiling Oracle PL/SQL, if you need to pause the execution for a few seconds and continue the execution, you can use dbms_lock.sleep built in Oracle. However, you must install

Details about Reference Partition in Oracle 11g Data Partition is a solution for Big Data Objects proposed by Oracle in the early days. After the evolution of several versions, Partition is still a popular and widely used technical strategy with a

Create split and splitstr functions in Oracle It is recommended that SQL statements be created in sequence. /*************************************** Name: split* Author: sean zhang.* Date: 2012-09-03.* Function: returns the table type after a string

Oracle stored procedures and Java calls I found many bugs for the first time, so I paid a lot of attention. It took me three days to get rid of all the bugs. I will list all the points of attention, and there may be drops, please correct and discuss

How to obtain the SELECT result value in a Shell script Sometimes we may need to execute the SELECT statement in the Shell script and assign the result to a variable. In this case, we can use the following methods to achieve the goal. #! /Bin/ksh##

PL/SQL: Use pragma restrict_references to restrict package permissions and references When looking at other people's code, we found the following compilation instructions,Pragma restrict_references (get_attribute_name, wnds );   Get_attribute_name

SQL query beginner's Guide Reading Notes (5) collection operations and multi-Table query introduction, beginner's Guide Reading Notes Part iii: Thinking in SetsCHAPTER7 Thinking in Sets The three mostcommon set operations are as follows.

Problems with mac XAMPP mysql, xamppmysql After installing XAMPP on Mac, I encountered a series of problems. I sorted out the issues and updated them later. 1. MySQl cannot be started using the client. No reason is found yet. Solution: import the

RMAN and rman backup Original script, zombie Http://blog.csdn.net/ashic/article/details/46311573 -H: View help information [Oracle @ gc1 ~] $ Sh backup. sh-hThe following information teach you how to use this scriptBackup. sh -- fullBackup. sh --

In SQL Server replication, large transactions are divided into small transactions for distribution. In SQL server replication, when a large transaction is executed in the published database, for example, 100,000 or more data is operated at a time.

Show table status like 'table' \ G details, tablestatusMysql> show table status like 'leyangjun' \ G* *************************** 1. row ***************************Name: leyangjun table NameEngine: MyISAM Table Storage EngineVersion: Version

Introduction to memcached and basic commands. Introduction to memcached commands [Introduction ]: Memcached is a high-performance distributed memory object Cache System for dynamic Web applications to reduce database load. It caches data and objects

SQLServer generation time range; sqlserver generation rangeI wrote a similar article earlier, which is used in development. If OBJECT_ID (n'tf _ Data_TimeRange ', n'fn') is not nullddrop function tf_Data_TimeRangegocreate function tf_Data_TimeRange (

Oracle shrink table use case, oracleshrink There is a serious shortage of External table space in the site, and the customer does not want to resize it. To clean up some data, it is a large field blob. the tablespace is 1 TB and 0.99 TB has been

MySQL query optimization and MySQL OptimizationThere are many things to optimize database queries. The following is a summary:Basic Principles: Reduces disk I/O count during Database Query Rational use of Indexes Avoid full table

Do not do this during database update, and do not use database update. Preface: Do not do this during database update. What is this? Please come with me. Earlier in the year, the customer sent the text "XX, XXXXXXXX has a 0.1 million account not

When the database is updated, you will suffer. Do not do this during database update. What is this? Please come with me. Earlier in the year, the customer sent the text "XX, XXXXXXXX has a 0.1 million account not received, help add it ." I