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
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
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
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
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
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
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
[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
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
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
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.
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
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
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
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,
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,
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
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
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. 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
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