NAV: SLTechnology News&Howtos > Database >

• 

  HADR replication operations and non-replication operations

  (HADR) replication operations: high availability disaster recovery (HADR) uses database logs to copy data from the primary database to the standby database. When replaying the logs on the standby database, some activities may cause the standby database to lag behind the primary database. Some activities require a large number of records

  2022-06-01 11:41:58 Views: 234
• 

  The method of refreshing materialized view

  DBMS_MVIEW provides three different types of refresh operations.DBMS_MVIEW.REFRESHRefresh one or mor

  2022-06-01 11:41:58 Views: 250
• 

  Oracle 10g RAC upgrade (CPU Update)-upgrade CRS

  Oracle 10g RAC upgrade (CPU Update)-upgrade CRS system environment: operating system: RedHat EL5Cluster: Oracle CRS 10.2.0.1.0Oracle: Oracl

  2022-06-01 11:41:37 Views: 222
• 

  Resynchronization of MongoDB replication set members

  Resynchronization of replication set members when replication fails and falls behind the maximum tolerable range of oplog in primary, replica set members become "stale". The node becomes "obsolete" when it can't catch up with the master node. When the hair

  2022-06-01 11:41:22 Views: 258
• 

  The business Transaction thing.

  Transaction is the so-called business, popular understanding is one thing. From an early age, our parents taught us to do things from the beginning to the end, not to give up halfway. The same is true of affairs. If you don't do it, you can either finish it or don't do it. In other words, the transaction must be a

  2022-06-01 11:41:22 Views: 245
• 

  What is transaction consistency?

  What is transaction consistency? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. The consistency of a transaction means that a transaction must change the database from one consistency state to another.

  2022-06-01 11:41:21 Views: 211
• 

  The ASM disk was not found when DBCA built the library.

  Experimental environment: operating system: RedHat 6.4Database version: Oracle 11.2.0.2.0 when using DBCA to create a database, we found that the ASM disk group could not be found: error troubleshooting: 1, execute: / usr/sbin/oracleasm

  2022-06-01 11:41:15 Views: 277
• 

  Daily maintenance of Oracle 12c

  1. Start the CDB and PDB database SQL > select con_id,dbid,name,open_mode from vested pdbsmitConfigID DBID NAME OPEN_MODE-

  2022-06-01 11:41:07 Views: 244
• 

  How to write delete statements in mysql

  In this issue, the editor will bring you about how to write delete sentences in mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. Delete statements in mysql are written as follows: [DELETE FROM t

  2022-06-01 11:41:07 Views: 278
• 

  Install the sample database of oracle11gR2 under centos6.7

  The installation file for # oracle11GR2 and the installation file for the sample database are downloaded and installed separately. 1. Download the sample database from the official website 2, decompress and upload it to the server 3, and switch to ORACLE user $cd $ORACLE_HOME/oui/bin$

  2022-06-01 11:41:07 Views: 300
• 

  Introduction to PLSQL of Oracle topic 11

  1. Brief introduction of PLSQL tool PL/SQL Developer: PL/SQL Developer is not only a tool for developing, testing, debugging and optimizing Oracle PL/SQL, but also a very useful Oracle management.

  2022-06-01 11:41:07 Views: 254
• 

  Example of using ProxySQL Query Rewrite

  In this article, I will re-explore the Query Rewrite functionality in ProxySQL, because query rewriting is the most fundamental reason for creating ProxySQL. Why do we need to rewrite the query? You have identified a trigger performance bottleneck

  2022-06-01 11:41:06 Views: 272
• 

  How to create a database

  Today, I will talk to you about how to create a database, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article. You can create a database by using cre after logging in to the mysql service

  2022-06-01 11:41:06 Views: 263
• 

  Node Mysql transaction encapsulation

  Node callback function makes database transactions do not seem to be as simple as java and php. Find some transaction packages on the Internet that are not as simple as you expected, so let's package one yourself. The general idea of encapsulation is simple: the function accepts a transaction.

  2022-06-01 11:41:06 Views: 297
• 

  MySQL sort number

  For example: SELECT (@ i:=@i+1) AS PM,A.*,U.TNAME,U.ID_NUM,U.ORG_NAME,CASE WHEN U.SEXFLAG=1 THEN 'male' WHEN U.SEX

  2022-06-01 11:41:06 Views: 274
• 

  Simple use of MongoDB updates

  The update function seems to be a little more difficult to use than insert,remove and find, with a lot of arguments. However, simple to write some less used skills, general updates are generally relatively simple. About the $inc operation: an atomic operation that can be incremented by integers, long integers, or floating-point numbers

  2022-06-01 11:41:05 Views: 202
• 

  Sql examples of commonly used additions, deletions, modifications and queries

  Insert data (1) INSERT INTO Persons VALUES ('Gates',' Bill', 'Xuanwumen 10),' Beijing') (2) INSERT INTO Perso

  2022-06-01 11:41:05 Views: 259
• 

  EM tool

  The following error occurred while starting listening: [oracle@wt ~] $lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0-Production on 25-DE

  2022-06-01 11:41:05 Views: 221
• 

  Mycat starter deployment installation

  Mycat is a relatively simple middleware product, which can help mysql to divide the library and unify it in a logical library. Hardware environment: system: centos 7.6Database version: download myc on 5.7.19mycat:1.6..6.1github

  2022-06-01 11:41:04 Views: 254
• 

  Detailed explanation of xtrabackup usage

  Principle: a redo log file, which we can also call a transaction log file, is maintained within InnoDB. The transaction log stores recorded changes to each InnoDB table data. When InnoDB starts, InnoDB examines the data file and transaction log and executes two

  2022-06-01 11:41:04 Views: 262