Database Administrator

Concurrent execution of Oracle RMAN backup of a single file If a file is a file of several gigabytes or tens of thousands of megabytes, You Need To parallelize the backup of the file. Generally, one channel can only read one file, however, you can

CRS-0184/PRCR-1070 when Oracle 11g RAC executes root. sh Oracle 11g RAC installation, the first node to execute root. sh encountered a CRS-0184/PRCR-1070, Google a lot of posts have not found a solution. Hey, let's calm down and look at the log !!

Oracle 11g tablespace dbf File migration When the disk space of the Oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2. shutdown

Hive optimization tips-How to Write HQL I. Hive join Optimization 1. try to place the small table on the left of join. The hive-0.12.0 we use here is automatically converted. This means that the small table is automatically loaded into the memory

Use Oracle AMDU to extract data files from the ASM disk group Amdu-diskstring ''-extract '. ' The data file number can be obtained based on the MySQL instance query v $ asm_file view. You can also query v $ datafile. If an alias is used, you can use

[MongoDB] The high query operation of MongoDB (2), mongodboperation In the last blog, there are three query condition to be described. In the blog, we will continue to what we have leaned in the last blog.1 $ mod '$ Mod' operation is able to make us

GCS shadows traversed, 4001 replayed, traversedreplayed The following error is found in the log of the first node of the rac set in the inspection instrument today:LMS 8: 7888 GCS shadows traversed, 4001 replayedLMS 2: 7957 GCS shadows traversed, 40

Oracle connection method: oracle connection In general, Join methods include: Nested Loops, Hash-Join, Sort Merge Join, and Cartesian Join (Merge Join Cartesian ). 1. Nested loop join (Nested Loops) Nested loops include the concepts of External

Practice: mysql 5.6 replication latency monitoring, mysql5.6 # Repdelay. sh #! /Bin/sh # ocpyang@126.com # view the replication delay specific event # set mysql slave = root MYSQL_PASS_MASTER = 'Password' MYSQL_HOST_MASTER = 192.168.2.188MYSQL _

Mysql Stored Procedure error debugging records, mysql Stored ProcedureZookeeper mysql Stored Procedure error debugging records The company's Platform runs on the mysql database. Some stored procedures report errors, the debugging process is painful,

Summary of oracle psu upgrade, oraclepsu SummaryFirst, go to psu. first, let's take a look at readme.html. From this, we can know the detailed upgrade steps that have been rolled back. And avoids many pitfalls.Before executing the PSU, you must

Oracle review, oracle After I got back, I recorded several sets of videos, but I didn't know how to record them when I started recording them. If I recorded a few sets, I had nothing to do. I could record each set for dozens of minutes, in the

Mysql decompression and authorization, mysql authorizationDecompress mysql compressed version to a root directory Note the content configuration of the INI File Basedir = D: \ mysql-5.6.17-winx64Datadir = D: \ mysql-5.6.17-winx64Port = 3306Server_id

MySQL password change methods, yc sorting, mysqlyc Reprinted please indicate the source http://blog.csdn.net/yc7369 MySQL password change methods I have sorted out the following four methods to change the root password in MySQL, which may be helpful

Oracle 11G direct path read is very beautiful and hurtful, oracle11gDirect path read In 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through gc buffer, so

Mysql database copy, mysql databaseWe often have this requirement to copy the mysql database on a server to another machine, such as database migration. To do this, use the ready-made mysql tool mysqldump. When using mysqldump, you must specify the

Dynamic SQL (Chapter Summary), dynamic SQL Chapter Summary1. You can use dynamic SQL to create a subroutine when the dependent object does not exist.2. dynamic SQL mainly uses EXECUTE IMMEDIATE statements to EXECUTE DML, DDL, DCL, and other

CentOS6.5 Oracle11G-R2 installation, uninstall, linuxoracle11gr2 CentOS6.5 Oracle11G-R2 installation, uninstallResources (including all my installation processes, system backup files): http://download.csdn.net/detail/attagain/7700437 I. Hardware

Grouping statistics query (Chapter Summary) and grouping statistics chapter summary1. Five grouping functions are provided in SQL: COUNT (), AVG (), SUM (), MIN (), and MAX.2. The group by clause can be used to GROUP data, while the HAVING clause

An error is reported when an expression is inserted into mysql. mysql inserts table information. Today, I made a function to get fans and found that an error is returned when I insert a nickname into the database. The length must be