OracleRAC series: test the RAC Database Cluster Function

OracleRAC is a cluster database that enables seamless load balancing and failover. How can we know that the RAC database has implemented these functions? We will test the functions below. I. Test OracleRAC is a cluster database that enables seamless

SQLSERVER full-text search

Before reading this article, please first read the MSDN documents that I excerpted below for full-text search, basically, I copied all the information about full-text search on MSDN and carefully read and tested it once, and added some SQL

Getting started with database indexing and basic optimization

Introduction to database indexing and basic optimization I often found that many people have been working for many years in the interview and have a lot of project experience. They have used various databases, however, most users do not know the

Cause of a sudden high transaction volume in one diagnosis

I received a monitoring text message saying that the threshold value was updated and inserted, So I log on to mysql-monitor to view the alarm. In this case, I log on to the mysql server and use the binlog analysis before and after, which table is

Master-slave synchronization of MySQL

MySQL master-slave synchronization is a very mature architecture: Advantages: ① the query can be performed on the slave server (that is, the READ function we often call ), reduce pressure on the primary server ② back up data from the primary server

RAC node startup failed -- ASM cannot connect

A rac problem occurs recently, and a node cannot be started. After analysis, the solution is as follows. In the 11.2.0.3RAC environment, if one node instance fails to start, the following error is displayed: [oracle @ exadbmel04 ~] $ C A rac problem

Compile and install Mysql5.5 on linux

Currently, all major portal websites tend to use mysql to a certain extent. In addition to the IOE campaign advocated by the Alibaba system, the previous views that have been despising mysql must be corrected, as a database practitioner, you must be

Oracle11gR2RAC + ASMForVm9RHEL5.8X64

[Let's take a step forward from oracle] I. experiment environment 1.1, IP address planning Nic naming IP address Nic type alias Eth0ctpdb1172.17.80.11privatectpdb1-privvm2eth1ctpdb1194251.11publ [Let's take a step forward from oracle] I. experiment

Self-reflection triggered by an AWR report

The blood cases caused by AWR arrived at the company early yesterday. Routine inspection of database servers, CRS, instances, ASM, services, background processes, and RMAN backups were normal, I made an AWR Report, which is short of oil. No, The

[Original] New Features of Infobright4.5

Compared with version 4.0, Infobright4.5 adds a series of features. Let me explain several important improvements. 1. The default LOG output level can be dynamically adjusted. If you want to adjust the default level before, you have Compared with

Application of SQL statements in MYSQL Service (1)

I. Language Features of SQL statements 1. Integration: SQL integrates data definition DDL, data manipulation DML, and data control DCL to complete all the work in the database. 2. Flexible usage: it can be used in either of the following ways: I.

Set the database to single-user mode before database recovery

Today, a friend asked him to use a script to automatically restore the database. However, we often encounter the following situation: when trying to restore, the restoration cannot be completed because of active user connections. You can run the

SQL Note: Notes 6 use data processing functions

Unlike SQL statements, SQL functions are not portable. Code written for specific SQL implementations may be abnormal in other implementations. Each DBMS vendor has a big difference in function implementation. Common functions most SQL

Comparison of Methods for writing data from SQLServer memory to Disks

As we all know, adds, deletes, and modifies data first in the memory, which can greatly speed up data operations. When the data in the memory is modified, when the data on the disk has not been modified, the so-called dirty pages are generated. How

Understand the transactions in SQL Server triggers and triggers

First of all, let's talk about the purpose of writing an article. I hope I can share my understanding of the trigger and learn with you. If you have some knowledge about the trigger and transaction concepts, this article will be very simple for you,

SQL requires NOTE 3 to filter data

When both ORDERBY and WHERE clauses are used, ORDERBY should be placed after WHERE; otherwise, the WHERE clause operator range value check will be generated using the BETWEEN operator. Example: SELECTprod_name,

New Feature of 11GR2: SNAPHOST test of mongouradstandby

In the DG Environment of ORACLE11GR2, we can start the slave database to the READONLY State to implement the READ function. However, this state cannot be written or used for some testing work, for example, test PLSQL. ORACLE provides S In the DG

[Original] use of TIPS for temporary tables in replication

As we know, temporary tables have the following features: 1. At the SESSION level, the SESSION will be automatically dropped once it is disconnected. 2. It depends on the default engine. If the default engine is INNODB, And you are crazy about using

Standalone deployment uard

Build Environment: RedHatLinuxEnterprise5.4Oracle10gR2 host operating system main information is 192.168.199.128. Build preparation: the master database (production database) db_namemustangsid1_l already exists to start building DataG Build

The location of newly generated logs when resetlogs opens the database

The location of newly generated logs when resetlogs opens the database. If the system lacks online logs and re-creates the control file using resetlogs, when we open the database using alterdatabaseopenresetlogs The location of newly generated logs

Total Pages: 12780 1 .... 11012 11013 11014 11015 11016 .... 12780 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.