NAV: SLTechnology News&Howtos > Database >

• 

  Two oracle goldengate utility documents (all command help and ogg error code interpretation)

  For details, please see the attachment, the download address of the official website is https://www.oracle.com/cn/middleware/technologies/oracle-golden-gate/documentation.html

  2022-06-01 06:57:48 Views: 229
• 

  The global index of Oracle partitioned tables will not fail when adding partitions

  COALESCE PARTITION | SUBPARTITION (hash) DROP PARTITION | SUBPARTITIONEXCHANGE PARTITION | SUBPARTITI

  2022-06-01 06:57:47 Views: 235
• 

  MySQL 5.5pattern matching LIKE

  Mysql > select * from tactile testament painting + | deptno | dname | loc | +-+

  2022-06-01 06:57:47 Views: 289
• 

  MySQL5.6 began to use independent tablespaces, innodb_file_per_table=1

  MySQL5.6 starts with independent tablespaces: MySQL5.6 innodb_file_per_table=1 # uses independent tablespaces with dynamic parameters. (default OFF,5.7 default ON) 1, drop/truncat

  2022-06-01 06:57:47 Views: 231
• 

  MySQL 8.0.20 MGR data migration process and considerations

  1. Background recently, due to business adjustment, the Windows Server 2008 MySQL5.5 database needs to be migrated to the Windows Server 2012 MySQL8.0 cluster MGR, because there is a machine hard disk when it is actually deployed.

  2022-06-01 06:57:37 Views: 217
• 

  The mysql5.7.22 table does not have a primary key and is updated when there is a large amount of data. Experimental verification results in a large number of master-slave delays.

  First, the problem introduction mysql has three kinds of log mode, I summarize as follows: now, I do experiments to verify the last conclusion of master-slave delay: "the table does not have a primary key, it is updated when there is a large amount of data, and the experimental verification leads to a large amount of master-slave delay." The experimental verification is as follows: mysql uses row mode

  2022-06-01 06:57:37 Views: 229
• 

  The types and usage of session cursor

  There are three kinds of session cursor in oracle: explicit cursor (explicit cursor), implicit cursor (implicit cursor), reference cursor (ref cursor), implicit cursor (impl)

  2022-06-01 06:57:37 Views: 300
• 

  Manual creation of emp table and dept table by oracle

  Explanation: sometimes we need general experimental data, emp table and dept table, but are there any in the database? At this point, we can create it manually. -- create table and data CREATE TABLE EMP (EMPNO NUMBER (4) NOT

  2022-06-01 06:57:37 Views: 278
• 

  Oracle add field with default value

  In the oracle 11gR2 version, adding fields with default values to a large table needs to be split into multiple steps, otherwise the table will be locked for a long time. As shown in the following figure: add fields with default values to the table with 2.6 million data for more than 2 minutes. Our standard steps are as follows: (1) add field alte

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

  Oracle Enqueue Waits

  Queues are used to sequentially lock relational and non-relational Oracle structures. The relational structure may be an Oracle data dictionary table or an application table. For example, when Oracle updates the sys.col$ table or an application updates its employee table, the queue will be

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

  Summary of Oracle11g RAC startup and shutdown

  1. [grid@RAC01 ~] $crsctl stop database-d RACwh database shuts down the crs service at this time after the ok is closed. Do not shut down the ASM instance directly. In 11.2.0.2 of 11g

  2022-06-01 06:57:21 Views: 279
• 

  Only select permission can lock the table? Read and select

  A client asked me why I only have select permission, and I can also lock the table with for update. I was confused for a moment. I was not sure. I tested it first, as follows: create user test11 identified by test11

  2022-06-01 06:57:21 Views: 253
• 

  Overview of what's New in MySQL 8.0

  1. Transactional data dictionary, completely separated from the MyISAM storage engine, really put the data dictionary into some tables in InnoDB, and you no longer need FRM, TRG, and PAR files! Information Schema now uses a view of the data dictionary table

  2022-06-01 06:57:20 Views: 220
• 

  IMP-00009: abnormal termination of file export solution

  Original text: introduction to https://www.enmotech.com/web/detail/1/788/1.html: this article comes from the contribution of the reader "cheer for Little Leopard (screen name)". It is mainly about the use of imp to import files to appear IMP-00009.

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

  Mysql forcibly walks the index

  Query is the most commonly used operation in database technology. The process of query operation is relatively simple. First, the SQL statement of the query is issued from the client. After receiving the SQL statement sent by the client, the database server executes the SQL statement, and then returns the query results to the client. Although the process

  2022-06-01 06:57:18 Views: 212
• 

  Oracle DB booting and shutting down

  Refer to http://docs.oracle.com/database/122/UNXAR/stopping-and-starting-oracle-software.htm#UNXAR417 Autom

  2022-06-01 06:57:17 Views: 278
• 

  OGG-01224 error 111:Connection refused-retries exceeded.

  OGG-01224 error 111:Connection refused-retries exceeded. The destination process starts normally, the port opens and listens, and there is no firewall restriction, but the source p process consistently reports Connec.

  2022-06-01 06:57:17 Views: 222
• 

  OGG Operation and maintenance Optimization script (6)-Information Modification Class-batch uncomment

  File name: recomment.sh path: $HOME/ggscript/ggcomment function: this script is used for batch uncomment, used with batch comment script, the basic function is opposite, the operation procedure is exactly the same. Choose to use logs through edit scripts

  2022-06-01 06:57:17 Views: 260
• 

  Sql Server's summary of permissions, roles, login names and user names

  Official document https://docs.microsoft.com/zh-cn/sql/t-sql/statements/grant-transact-sql?view=sql-server-2017 permission

  2022-06-01 06:57:17 Views: 301
• 

  Please use rebuild online with caution.

  Many entry-level DBA like to re-index with reuildonline, and they don't think this will affect the business. There have been several failures, in business use, rebuild online index, resulting in most of the business can not be used, database hang. Actually r

  2022-06-01 06:57:16 Views: 205