Database Administrator

Summary of the process of building physical DG using RMAN remote replication This document only records the setup process. For detailed parameter meanings and configuration principles, refer to the previous summary. Configure the tns of the master

OGG-03510 troubleshooting OGG migration, the target end has been upgraded to 12C, so with the 12 version of OGG, the parameter is still using the previous 11g, but when starting the application process prompts OGG-03510 error, as follows: The source

Overall physical migration of Oracle databases on Linux platforms Overall physical migration of databases on Linux platformsRequirement: machine A is no longer in use. You need to migrate the Oracle of machine A to machine B.I have previously

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux 1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or

MySQL query optimization: profile function MySQL query optimization: profile function. Note that you need to install the profile module. 1. The version is later than 5.0.37. (Show profiles and show profile were added in MySQL 5.0.37 .) SELECT @

How to deal with slow update ?, Slow update Processing? Slow update:1. What are the pctfree parameter settings of the table?2. Is the execution plan indexed or full table scan?3. How to Write SQL statements?4. Is update slow or is commit slow?5.

Common SQL Server statements and SQL Server statements Select * into A -- automatically generate Table A. The structure data of Table A is the same as that of Table B.From BInsert into A -- A must be created in advanceSelect * from B Insert

Use Jasper report to calculate opening balance and jasperopening Source: http://community.jaspersoft.com/questions/850400/how-create-report-opening-balance-using-jasper-reports. When calculating the balance at the initial stage based on the access

Mongodb distributed cluster (2. Replica set) and mongodb cluster copyOverview Replica set is a type of master-slave replication. It is a master-slave replication that comes with the Failover function. It solves the disadvantages of the master-slave

Oracle uses a string-indexed two-dimensional array and an oracle two-dimensional array -Reference: http://www.oracle.com/technetwork/issue-archive/2014/14-sep/o54plsql-2245345.html-SAMPLE DATAStore name product salesA apple 3000A banana 2000B APPLE

Mongodb Study Notes 02 and mongodb Study NotesMongodb Study Notes 02-CURD operations CURD indicates Create, Update, Read, and Delete operations. Create a database Directly use the database name and create a collection to create a database. Create

Use the Hive regular parser RegexSerDe to analyze nginx logs and regexserdenginx 1. Environment: Hadoop-2.6.0 & apache-hive-1.2.0-bin 2. Use Hive to analyze nginx logs. The website access logs are as follows: Cat/home/hadoop/hivetestdata/nginx.txt 1

Oracle Learning (11): PLSQL programming, oracleplsqlWhat is the structure and composition of PL/SQL? • PL/SQL (Procedure Language/SQL) • PLSQL is an Oracle procedural extension of the SQL Language • It adds process processing statements (such as

Some suggestions for Mysql to write high-quality SQL statements: mysqlsql CleverCode has written some inefficient SQL statements in actual work. These statements put a lot of pressure on the database. The most important manifestation is that SQL

Rhel5.8 ISO yum source configuration, rhel5.8isoyum Source [Root @ lei1 mnt] # mkdir/mnt/iso [root @ lei1 mnt] # mkdir/mnt/cdrom [root @ lei1 ~] # Mv rhel-server-5.8-x86_64-dvd.iso/mnt/iso [root @ lei1 ~] # Cd/mnt/iso [root @ lei1 iso] # lltotal 4032

Question 7: MySQL ---------- Duplicate Emails, email Write a SQL query to find all duplicate emails in a table namedPerson. + ---- + --------- + | Id | Email | + ---- + --------- + | 1 | a@ B .com | 2 | c@d.com | 3 | a@ B .com | + ---- + --------

C # key points of reading and writing excel tables through OleDb, 1. connection string of OleDbConnection: 0 ffice 97-2003: StrConnection = string. format ("Provider = Microsoft. jet. OLEDB.4.0; Data Source = {0}; Extended Properties = \ "Excel 8.0;

Use sqlplus return output "^ H" in X-manager to solve the problem. x-managersqlplus Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will

ERROR 1366 (HY000): Incorrect string value: '\ xC6 \ xF4 \ xD3 \ xc3' for column 'name' at row 1, hy000xc6ERROR 1366 (HY000): Incorrect string value: '\ xC6 \ xF4 \ xD3 \ xc3' for column 'name' at row 1Mysql> statusD: \ mysql6.0 \ bin \ mysql.exe

[Blog recommendations] use shell scripts to automate Database Backup This blog post is from the Bkjia blogger Lemon. If you have any questions, go to the blog page for an interactive discussion!Blog: http://maomaostyle.blog.51cto.com/222