NAV: SLTechnology News&Howtos > Database >

• 

  Summary of DG daily management commands

  1. To start / stop the MRP process, you need to create a standby redolog when log_archive_dest is LGWR, and you do not need to set standby redolog-- when arch. You must set standby redolo.

  2022-06-01 06:29:02 Views: 308
• 

  What are the advantages of Huawei mobile phone? Inventory of six aspects, no wonder so many people use Huawei mobile phones

  Huawei mobile phones currently occupy a very high share of the domestic smartphone market, and many people will choose to become Huawei mobile phone users. So why do so many people choose to use Huawei mobile phones? What are the advantages of Huawei mobile phone? As a Huawei user, Xiong has summed up the following advantages.

  2022-06-01 06:28:57 Views: 265
• 

  [MySQL] 5.6Compact 5.7 failure caused by parallel replication of bug ERROR 1755Univer 1756

  Recently, many groups of master and slave based on parallel replication (MTS) have been done, most of which are 5.6-> 5.7structure, and a few of them are 5.6-> 5.6parallel replication. The structure of each group is similar, and there is a certain probability that the following errors will occur, but not all of them: 0 ERROR 175

  2022-06-01 06:28:57 Views: 236
• 

  View the permissions or roles of the Oracle user

  A few days ago, I was asked some questions about permissions and roles. Today, I took time to summarize how to view the permissions or roles of Oracle users. In the previous blog post, I wrote about the differences and connections of SYS,SYSTEM,DBA,SYSDBA,SYSOPER and Ora.

  2022-06-01 06:28:56 Views: 260
• 

  Is MySQL ambitious to be the next Oracle?

  As one of the most active vendors in the open source database field, is MySQL ambitious? "Don't think you can kill Oracle, we need to think about how to develop and serve a new market." The remark of MySQL's current CEO Mickos seems polite.

  2022-06-01 06:28:56 Views: 249
• 

  A summary of new features in MySQL version 5.6,5.7,8.0

  MySQL 5.61). Support for GTID replication 2). Support lossless copy 3). Support for delayed replication 4). Support for library-based parallel replication 5). Mysqlbinlog command supports remote backup binlog6). To TIME, DATETIME and

  2022-06-01 06:28:56 Views: 247
• 

  11.2.0.4 psu to 11.2.0.4.4 auto mode

  2.1 Patch Installation Prerequisites2.1.1 OPatch Utility Information gi home and db home execution for each node, version 1

  2022-06-01 06:28:55 Views: 270
• 

  Group submission for MySQL binlog and redo

  Overall overview: group submission (group commit) is an optimized way for MYSQL to deal with logs, mainly to solve the problem of frequent disk scrubbing when writing logs. Group submission has been continuously optimized with the development of MYSQL, from the initial support for only redo log group submission to the present

  2022-06-01 06:28:55 Views: 289
• 

  Recording to text assistant, a good helper for meeting minutes, students can also easily complete notes!

  Recording to text assistant, a good helper for meeting minutes, students can also easily complete notes! With the rapid development of science and technology, more and more functions can be accomplished on mobile phones. In our daily work, it is said that many troublesome things in life can be solved on mobile phones. For example, during the meeting, you want to put the meeting

  2022-06-01 06:28:50 Views: 208
• 

  Some problems encountered in data migration

  The unit has a set of Oracle 9i ancient test database, because the computer room moved, so the need to migrate data, the new library is Oracle 11g, a relatively simple requirement, but encountered some problems in the process, seems to be relatively trivial, worthy of summary. Because the source library is 9i,

  2022-06-01 06:28:50 Views: 227
• 

  Analytical testing of a document omission in MySQL (R13 notes, day 3)

  Recently, I saw that August í n, an engineer at Percona, wrote a blog about MySQL triggers and updatable views. For more links, please see https://www.percona.com/blog/2017/06/14.

  2022-06-01 06:28:48 Views: 222
• 

  Automatic backup scripts for windows and linux environments

  @ echo offecho = = automatic backup script for Oracle database in echo Windows environment echo 1.

  2022-06-01 06:28:48 Views: 252
• 

  Bettertouchtool for Mac (touchpad Enhancement tool) v3.397 (1622) Chinese version

  BetterTouchTool is a powerful touchpad enhancement tool that allows you to customize all kinds of input devices on the Mac. It can operate without clicking but touching. It supports multiple gestures, one, two, three fingers, and zooms.

  2022-06-01 06:28:45 Views: 299
• 

  PostgreSQL DBA (28)-Backup&Recovery#1 (basic operation)

  PostgreSQL Backup and Recovery operation is relatively simple, through a few simple commands and configuration to achieve backup and recovery. The following is a simple example to illustrate the basic operations of PG backup and recovery. Scenario 1. Perform backup 2. Create a datasheet and perform an insert

  2022-06-01 06:28:45 Views: 297
• 

  Three kinds of judgment in mysql database whether to include summary or not

  Application scenario: 1: when using mysql database to store data, sometimes a field needs to store multiple data separated by commas. When querying, a keyword is passed, and you need to query in comma-separated fields. How to handle this situation? such as

  2022-06-01 06:28:44 Views: 228
• 

  Online DDL of MySQL5.7 's new features will not lock the table.

  The varchar field modified by MySQL5.7 online is not in the lock table. The test process is as follows: click (here) to collapse or open mysql > select version (); +-+ | version () | +

  2022-06-01 06:28:44 Views: 280
• 

  [RMAN] whether to use RMAN to restore the directory

  1. Summary of recovery directory when there is no recovery directory, RMAN-related backup information, such as archive file path, backup set path, etc. are stored in the control files of the target database, but considering that the control files can not grow indefinitely, and the control files are not only used to store backup-related files.

  2022-06-01 06:28:44 Views: 225
• 

  How does MongoDB check the operation log in the oplog.rs collection

  First of all, we need to introduce the function of the mongodb local library. The local library is a system library of MongoDB, recording timestamps and information such as indexes and replication sets, test:PRIMARY > use localswitched to db lo.

  2022-06-01 06:28:43 Views: 232
• 

  Adaptive hash Index for key Features of InnoDB

  First, the resource consumption analysis of the index 1, the three major characteristics of the index 1, small: index only in one or more columns 2, ordered: can quickly locate the end point 3, there is a tree: can locate the starting point, the tree height is generally less than or equal to 32, the resource consumption point of the index 1, the height of the tree, sequential access to the data pages of the index, the index

  2022-06-01 06:28:41 Views: 206
• 

  Row links and row migration

  First, Overview: if your Oracle database performance is poor, row links and row migration may be one of the reasons. We can prevent this phenomenon by reasonably designing or adjusting the database. Row linking and row migration are two potential problems that can be avoided. We can make reasonable adjustments.

  2022-06-01 06:28:41 Views: 266