Database Administrator

Use RMAN to copy RAC + ASM to a single instance + ASM This test copies the dual-node RAC deployed on ASM to the ASM of a single instance. This test is also based on the needs of a project. The drill operations on the virtual machine are hereby

MySQL Performance Testing Tool-mysqlslap Mysqlslap is a benchmark tool provided by mysql. It has the following advantages: Data Query, simple syntax, and flexible and easy to use. this tool can simulate multiple clients to concurrently send query

Permission handling for installing Oracle 11g OS in Win7 64bit In general, we choose to install Oracle databases in traditional server operating systems such as Linux and AIX. Even in Windows, server versions such as 2008 and 2012 are used as the

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 !!

Build a MySQL cluster in Linux I. Objectives 1. Install MySQL-Cluster software packages. 2. configure management/data/SQL nodes in sequence. 3. Start and test the MySQL-Cluster architecture. Ii. Solution Use six RHEL 6.5 virtual machines ,. Among

MySQL does not support subquery optimization. 1. Create a table Create table tt1 (id int primary key, c1 INT );Create table tt2 (id int primary key, c2 INT );Insert into tt1 values );Insert into tt2 values (1, 2), (2, 2 ); 2. Execution Plan and

Generate awr report and awr report References: Http://343766868.blog.163.com/blog/static/48314056201110124513396/Overview Oracle stores critical system statistics and load information at a certain frequency to generate snapshots. All snapshots are

What are linear tables? I will take my own test next month. I have been introducing data structures in the past few days. This book contains two parts: the storage structure (table, tree, and graph) and the operations (search and sorting) on data ).

Hibernate and hibernateIn this example, the relationship between students and teachers is a typical multi-to-many relationship. A teacher can have multiple students, A student can have multiple teachers. A student table is required to store student

Java statements for database operations are prone to errors. java statements are prone to errors. Let's first look at the following statement String sqlString = "select * from petMessage where petName = '" + pet. getPetName () + "';"; The preceding

ORA-21561, ORA-15055, ORA-25253 lead to DG slave database cannot apply archive, ora-21561ora-15055Yesterday I went to a customer to do inspection, by the way, to see whether the last build of the RAC-DG environment is normal, do not see do not know,

Practice: Create shell scripts for tablespace in oracle, oracleshell #! /Bin/bash # ocpyang@126.com # create tablespaceif [$ #-ne 2]; then echo "Usage: $0 TABLESPACE_NAME TABLESPACE_SIZE" exit 1fi # configure oracle env: about oracle envs, username

[MonogoDB] The high update operation of MongoDB, monogodbmongodb In the last four blog, we talked about the high query operation of mongodb. Now in this blog let's know about the high update operation about monodb.1. Saveas for save (), whose

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

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 _

Rman compatibility overview, rman OverviewIs Microsoft keyboard compatible? Key-bit conflict!Changing the key position. However, some keyboards still conflict with each other. There is no way to change the keyboard.We recommend that you do not buy a

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

Soft initial experience and initial experience Software Engineering is the design concept, the mainIt is necessary to use modern scientific and technical knowledge to develop documents and materials related to engineering. Starting from the

One of the most comprehensive oracle tablespace query and maintenance commands (data table space) in history A tablespace is the logical division of a database. A tablespace can belong to only one database. All database objects are stored in the

Is it true that Select * does not go through the Index ?, Select Index The index indicates that the execution plan of the SQL statement uses 1. Clustered index search 2. index search, and the where clause must be included in the query