Database Administrator

The PL/SQL window is executable, and an error is reported when the execution in the stored procedure is executed. Recently, the test department encountered environment problems. We developed and run a program on our development side, but it was not

Shell script for synchronous update of Hive dataIntroduction: in the previous article Sqoop1.4.4, import incremental data from Oracle10g to Hive0.13.1 and update the master table in Hive describes the principle of incremental update of Hive tables

Oracle uses shell scripts to view package information Sometimes I want to view the information of a package, but I am not sure about the package name. For example, I only know a rough idea and some keywords. In this case, I cannot find the package

Oracle uses shell to test historical data samples Shell has been used to analyze some data for some time, and the data analysis is based on historical data. Today, I wrote a script to perform a simple analysis of historical data, see how accurate it

Move an Oracle Partition Table Moving a partition table is worth further consideration. If the partition table contains the lob field, the difficulty is increased.For normal tables, the move operation room is a matter of course, and Oracle provides

Dependency between Oracle query locks Note: This SQL statement can be used to query multi-session, non-select DML operations, and operate the locks caused by Table A... the relationship between sessions ~ ... Detailed comments of views/fields used

Preliminary understanding of Oracle Partitioning technology I. partition type 1. Range Partitioning) Applicable to continuous/time-based data 2. Hash Partitioning) Suitable for non-continuous/fixed data records 3. Combined partition Range-Hash Range-

MYSQL Study Notes 3: Date and Time Functions, mysql Study Notes MYSQL study Note 3: Date and Time Functions 1. Get the function of the current date and the function of the current time /* Get the current date function and get the current time

MySQL advanced technology-transaction processing and lock, mysql Transaction ProcessingMySQL advanced technology-transaction processing and lockHow does mysql lock a row of data with transactions and locks so that two users are not allowed to read a

Introduction to Oracle instance recovery and flashback, oracleflashback Instance recovery phase:1. data files are not synchronized 2. Roll Forward (redo)3. submitted and unsubmitted data in the file 4. Open the database 5. Roll Back (Restore undo) 6.

Storage layout of databases on disks: HeapFile and heapfile ---- Reading Notes on "large-scale distributed storage system: Principle Analysis and Architecture Practice" This article is still a topic outside of the book "large-scale distributed

Question 7: How to Determine the DBID and rmandbid of the database when RMAN is used Objective: To determine the DBID of a database when RMAN is used You can use the following methods to determine the DBID of the database: 1. If the database is

Data room Charging System Reconstruction-storage process usage and Charging System Reconstruction From the beginning to the end of the computer room charging system, it is nearing the end. Like the fog in winter, it is becoming clearer and clearer

Optimize OLTP system performance by binding variables and variable oltp system performancePreviously, An OLTP database was optimized for a customer in Nanjing. A large number of query statements with very similar structures were executed in the

[Development must read] php and mysql Chinese garbled solutions, Address: http://www.phpthinking.com/archives/320 MySQL still has limited support for Chinese characters, especially for beginners. If Garbled text occurs, it will become a big

PHP displays mysql database content by PAGE and mysql by PAGE "; echo " "; echo " id "; echo " name "; echo " age "; echo " grade "; echo ""; while ($ row = mysql_fetch_array ($ result) {echo " "; echo " $ row [0] "; ec Ho " $ row [1] "; echo " $

MongoDB spatial location (point) and distance retrieval, mongodb Retrieval MongoDB 2.6-based GeoJSON format {"Type": "Point", "coordinates": [lon (longitude), lat (latitude)]} Test Data Db. point. test. insert ({"address": "Nanjing lukou

Practice: mysql 5.6 skips the specified transaction GTID and mysqlgtid   Show slave status \ G; Last_ SQL _Error: Worker 3 failed executing transaction '6c9da32f-handle: 1' at master log mysqldb01-bin.000001, end_log_pos 4541041; cocould not execute

Software Engineering-design, software engineering design A large project must be designed first, but must be designed first. Before design, the requirement analysis is required. Requirement analysis is to understand what users "do". Requirement

Understanding of the deviation of the fromuser parameter in imp, impfromuser There is always a problem when importing dump files in the past two days. Symptom: 1. Run: imp xyz/xxx file = test. dmp log = imp_test.log fromuser = test1 touser =