NAV: SLTechnology News&Howtos > Database >

• 

  Mysql flashback tool binlog2sql

  Mistakenly deleting and correcting data are often encountered in the production environment. Binlog2sql is a mysql flashback tool, which can quickly roll back data, extract sql from binlog, and generate rollback sql statements. Github address, with detailed

  2022-06-01 06:23:59 Views: 215
• 

  Query the SQL and transactions being executed by oracle

  Query the sql statement being executed by Oracle and the user who executes the statement: SELECT b.sid oracleID,b.username login Oracle user name, b.seriallogon operating system ID,paddr

  2022-06-01 06:23:58 Views: 211
• 

  Is it possible for Flink State to replace the database?

  As a guarantee of fault tolerance and data consistency, stateful computing is one of the essential features of today's real-time computing. Popular real-time computing engines include Google Dataflow, Flink, Spark (Structure) Streaming,

  2022-06-01 06:23:58 Views: 294
• 

  Summary of several problems in data Migration

  To sum up some of the problems encountered in the data migration front last night, although the overall completion is in accordance with the plan, and completed ahead of schedule, but even a little operation will cause some serious impact. In general, what needs to be done is to migrate core business servers from one computer room to another.

  2022-06-01 06:23:58 Views: 277
• 

  Practical case of DB2 V95 database migration and upgrade to V105

  Cbsdb09-JSJKDB V95 migration upgrade to tms01db01sz V105 step 1. Prepare to build the environment of the new machine tms01db01sz, install DB2 media and restore the database. Please refer to the document "HADR Environment Construction of China Merchants Bank"

  2022-06-01 06:23:58 Views: 275
• 

  Modify the sys password in asm

  Directly modify the report ORA-01109: database not open: [oracle@prodb2 admin] $. OraenvORACLE_SID = [prodb2]? + ASM2 [oracl

  2022-06-01 06:23:57 Views: 268
• 

  PostgreSQL Source Code interpretation (75)-query statement # 60 (Review-standard_...

  The implementation logic of this section's Review standard_planner function, which queries the main entry of the optimizer. First, the source code interprets the standard_planner function by exec_simple_query- > pg_plan_qu

  2022-06-01 06:23:57 Views: 241
• 

  Latch: shared pool

  SQL > select name, parameter1, parameter2, parameter3 from v$event_name where name like'& event';Ente

  2022-06-01 06:23:57 Views: 298
• 

  Relearn the transaction isolation level of Mysql database 8:MySQL

  This article is from: https://blog.csdn.net/sinat_27143551/article/details/80876127 this series of articles will be sorted out in my Java interview Guide warehouse on GitHub, and more

  2022-06-01 06:23:57 Views: 213
• 

  Introduction to the advantages and disadvantages of Percona XtraDB Cluster

  Every node in the cluster is a normal MySQL/Percona Server, which means that you can connect the existing MySQL/Percona Server directly to the cluster, or take it out of the cluster as a normal MySQL service. Each node has

  2022-06-01 06:23:56 Views: 272
• 

  SQL add columns, modify columns, delete columns

  SQL statement adds column, modifies column, deletes column 1. Add column: alter table tableName add columnName varchar (30) 2.1. Modify column type: alter table tableNa

  2022-06-01 06:23:56 Views: 275
• 

  [teacher Zhao Qiang] the storage structure of Oracle database

  The storage structure of Oracle is divided into physical storage structure and logical storage structure. 1. Physical storage structure: refers to the file data file (data file) that exists on the hard disk. A database can be composed of multiple data files, and the data file is really used to store database data. A data text

  2022-06-01 06:23:52 Views: 286
• 

  Common methods of listing python

  For more information on how to use the list and API, please refer to the Python document: http://docs.python.org/2/library/functions.htmlappend: used to append new objects to the end of the list: # appen

  2022-06-01 06:23:51 Views: 239
• 

  Set a table to read-only in Oracle

  If a table contains a primary key or has a unique index, you can make the table read-only using the following statement: alter table xxx modify primary key disable validate or alter table x

  2022-06-01 06:23:51 Views: 243
• 

  Installation method of Oracle data access component ODAC

  Oracle data access component ODAC (Oracle Data Access Components) is the Mini Program used to access the Oracle database as its name implies. We can programmatically call these components to implement when Oracle data is not installed

  2022-06-01 06:23:51 Views: 243
• 

  Loss of Oracle archive file causes OGG not to start

  Environment: AIX7.1DB:ORACLE11.2.0.4OGG:12.3.0.1.4 problem: unable to repeatedly synchronize data to the target library, close archiving, unable to start OGG#= after data recovery

  2022-06-01 06:23:51 Views: 204
• 

  Li Feifei, head of Ali database: the next generation of enterprise database system

  Abstract: nowadays, all kinds of innovative technologies of databases are being tested in "no man's land". Whether these technologies can take root and exist for a long time in enterprises is a major challenge for many enterprises. At the 2019 data Technology Carnival, Alibaba Group Vice President, Senior researcher, A

  2022-06-01 06:23:36 Views: 205
• 

  Oracle DG master and backup library is RAC and a master library is used to build an experimental environment for multiple slave libraries.

  Main library RAC: 192.168.1.210 node1192.168.1.211 node2 standby (1) RAC: 192.168.1.247 rac1192.168.1.248 rac2 standby (2) list

  2022-06-01 06:23:35 Views: 292
• 

  Summary of mysql concurrent replication based on group submission

  First: MySQL 5.7 parallel replication initial understanding We know that MySQL 5.7 parallel replication introduces two values last_committed and sequence_number. Last_committed indicates that when the transaction was committed, the last event

  2022-06-01 06:23:34 Views: 261
• 

  Oracle rac problem solving

  Oracle rac problem Resolution 1 View related log [root@rac1 rac1] # pwd/u01/app/grid/11.2.0/log/rac1 [root@rac1 rac1] # lsacfs acf

  2022-06-01 06:23:31 Views: 278