NAV: SLTechnology News&Howtos > Database >

• 

  Oracle standalone migration to Oracle RAC cluster _ Oracle RAC migration _ database migration and backup recovery 13

  Feng GE this set of learning Oracle stand-alone migration to Oracle RAC cluster process Oracle stand-alone migration to Oracle RAC cluster _ Oracle backup recovery and data migration 13 course address: https://edu.51cto.com/c

  2022-06-01 09:19:23 Views: 260
• 

  12c broker fast-start failover-ORA-16820 solution

  Get up early in the morning to test a wave of fsfl, encounter a small problem and record it. DGMGRL > DGMGRL > show configuration;Configuration-dg_config Protection M

  2022-06-01 09:19:17 Views: 237
• 

  Principle and configuration of Oracle 11g RAC SCAN ip

  The principle and configuration of Oracle 11g RAC SCAN ip Oracle 11g RAC Grid plug and play (GPnP) working principle: SCAN concept: first introduce what is SCAN,SCAN (Single Client Ac)

  2022-06-01 09:19:17 Views: 252
• 

  What is the difference between innodb and myisam in mysql

  In this issue, the editor will bring you about the difference between innodb and myisam 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. Differences: 1. MyISAM does not support transactions, but

  2022-06-01 09:19:16 Views: 216
• 

  What are the common interview questions in Redis?

  Today, I will talk to you about the common interview questions about Redis, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. Introduction: Redis is an open source program using ANSI C.

  2022-06-01 09:18:58 Views: 296
• 

  CentOS7.4 builds three sections of MongoDB4.0 based on user authentication

  MongoDB officials have not recommended the use of master-slave mode, the alternative is to use the replica set mode, click, as shown in the figure: what is a replica set? Playing World of Warcraft is always about making copies, but in fact, these two concepts have almost the same meaning. The copy in the game means that players focus on going to a scene during rush hour.

  2022-06-01 09:18:46 Views: 292
• 

  Oracle Study-- enq:SQ contention wait event

  Oracle Study-- enq:SQ contention wait event found through AWR Report "enq:SQ contention" wait event: application environment: transferred from: http://www.xuebuy

  2022-06-01 09:18:43 Views: 277
• 

  Sql statement writing of fields of Oracle clob type as query conditions

  Select × from INFORMATIONWHERE dbms_lob.instr (CONTENT,'$ {content}') > 0

  2022-06-01 09:18:42 Views: 247
• 

  Oracle 12C impdp permission problem

  In many cases, we use data pumps to migrate small batches of data, but at 12C we need to configure TNS to specify PDB imports, while Volkswagen's service is created through clusters using srvctl. At this time, there may be too many preferred instances.

  2022-06-01 09:18:42 Views: 273
• 

  Install oracle under linux [CentOS 6.5]

  First, install the oracle dependency package # yum install binutils compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf elf

  2022-06-01 09:18:42 Views: 236
• 

  Quick wit ~ use Spark core to complete & quotswitch ETLTIX quotswitch!

  Background: today, I received a small task assigned by my boss: to develop a program to extract data from the database and generate reports (this is a function of our database audit platform ready to go online). Since you want to generate a report, you must first have data, so you think of the test environment of the business system.

  2022-06-01 09:18:36 Views: 226
• 

  Windowing function of oracle

  Original select * from (select province,commodity,sum (price), ROW_NUMBER () OVER (PARTITION BY province order b)

  2022-06-01 09:18:35 Views: 299
• 

  Standby disk IO performance is poor, affecting Primary performance

  1. Recently, due to the poor performance of standby disk IO, the performance of Primary has been affected. The main library is mainly waiting for "log file switch completion". Through ASH dump analysis, we finally find out the actual situation.

  2022-06-01 09:18:35 Views: 298
• 

  Expdp uses tables to export irregular tables and other information

  For example, you need to import the following tables: EX_ARC_EMPEEX_ARC_LOC_PTYEX_ARC_LOC_PTY_CHGEX_ARC_LOC_PTY_CHG_DTLEX_ARC_POSTEX_ARC_STOR

  2022-06-01 09:18:35 Views: 276
• 

  Global self-increasing primary key test of mycat sharding table

  Mycat sharding table global self-increment primary key test mycat sharding table global self-increment primary key test 1. Global sequence number introduction in the case of implementing sub-library and sub-table, the database self-increasing primary key can no longer guarantee the global uniqueness of the self-increment primary key. To do this, MyCat provides a global sequence, and

  2022-06-01 09:18:34 Views: 236
• 

  Oracle View Tablespace creation statement

  SELECT dbms_lob.substr (DBMS_METADATA.GET_DDL ('TABLESPACE', TS.tablespace_name)) FROM DBA_TABLESPACES

  2022-06-01 09:18:34 Views: 272
• 

  Summary of Linux File and Directory Management commands

  The operation of files and directories under Linux is the basis of learning linux, and the operation of files is nothing more than adding, deleting, changing and checking, and so on. The operation of the directory is also the addition, deletion, modification and modification of the directory and other operations. Before you understand directory management, you need to understand the structure of the directory. Directory under linux

  2022-06-01 09:18:34 Views: 229
• 

  MGR variable group_replication_primary

  There is only one status variable for group replication, which still exists in version 8.0.17 and will be discarded in the future. We can use it to see which node is a read-write node in single-master mode. Mysql: [Warning] Using a password

  2022-06-01 09:18:34 Views: 278
• 

  Checkpoint of oracle (Checkpoint)

  A checkpoint is a database event that writes modified data from the cache to disk and updates control files and data files. Checkpoints are divided into three categories: 1) Local checkpoints: a single instance performs a checkpoint operation of all data files in the database, and all dirty caches belonging to this instance are written to data files.

  2022-06-01 09:18:12 Views: 239
• 

  Scott account and Table problems in oracle 12c

  Previously installed version 12c, I recently did some exercises to find out why there are no tables for scott users, 11g's own emp,dept, and so on. So I tried to unlock the user and found that there was no SQL > alter user scott account unloc for the user.

  2022-06-01 09:18:12 Views: 286