NAV: SLTechnology News&Howtos > Database >

• 

  Mongodb Replica Configure

  Mongodb Replica Configure when I configure replica, some important explanations of the official website are also included in the document, but there are no necessary explanations in Chinese, but they are easy to understand. Talking about the environment, the environment here is:

  2022-06-01 15:53:39 Views: 227
• 

  Operation and maintenance blueprint

  After a period of time for simple collation and monitoring: ZABBIX Nagios Cacti relational database: MySql postgresql Oracle SQLserver common scripts and languages: shell python p

  2022-06-01 15:53:39 Views: 211
• 

  Red hat 6.264-bit installation oracle11g

  Linux6.2 64-bit installation oracle11g directory 1, installation environment. 1. System requirements. 3. Installation preparation. 1. Software environment configuration. 21. Oracle essential development tools. 22. Modify the operating system core.

  2022-06-01 15:53:08 Views: 293
• 

  SP2-0667/SP2-0750 error

  Error: [oracle@ocmb 11.2.0] $sqlplus / as sysdbaError 6 initializing SQL*PlusSP2-0667: Message file sp1.

  2022-06-01 15:53:08 Views: 262
• 

  Oracle 11g R2 ADG Monitoring

  -- = Monitoring the recovery process of DG at standby = v$managed_standbyv$archived_standbyv$archive_des

  2022-06-01 15:53:08 Views: 224
• 

  How does oracle randomly fetch n records in the table?

  1. Use dbms_random.value to sort the execution results as follows: the first execution result, the second execution result, the third execution result, after three experiments, the number taken is random.

  2022-06-01 15:53:07 Views: 285
• 

  Dealing with the problem of full space in the flash area of Oracle database

  Dealing with the problem of full space in the flashback area of Oracle database author: Zhao full text net name: guestart arrived at work this morning and found a * * alarm on the overview page of a database server on EMCC. Query alert_orcl13.log found the following error report

  2022-06-01 15:52:54 Views: 251
• 

  [Java Framework] comparison between Hibernate and Mybatis

  Comparison between Hibernate and Mybatis Today my colleague told me that today's small companies rarely use hibernate, and most of them use mybatis. Usually also often contact these two aspects, just not very busy recently, check other relevant technical documents on the Internet, sort out the My

  2022-06-01 15:52:54 Views: 296
• 

  MySQL Index Extensions

  Index Extensions meaning MySQL5.6 begins the function that InnoDB can automatically extend the secondary index through the primary key is called Index Extensions, that is, the secondary index stores not only the key value of the index of this column, but also the primary key column ke.

  2022-06-01 15:52:54 Views: 236
• 

  Awk command (1)

  1. Advantages and disadvantages of awk: advantages: 1.awk is used to fetch columns, it is simple and convenient to pick columns alone, 2.awk supports regular expressions, 3.awk supports variables 4.awk supports & & and | | 5.awk supports flow control statements, such as if and if/else conditional control 6.a

  2022-06-01 15:52:50 Views: 260
• 

  MyFlash MySQL flashback tool

  Installation: environmental requirements: 1, binlog format must be row, and binlog_row_image=full2, only support 5.6and 5.73,only roll back DML (add, delete, modify) download address: https://github.com/M

  2022-06-01 15:52:50 Views: 290
• 

  Oracle Exadata all-in-one shutdown process (virtual machine environment)

  Edit the cell,db node information file all_group,dbs_group,cell_ group [root @ idc-dns1 exatest] # pwd/root/exatest [root@idc-dns

  2022-06-01 15:52:50 Views: 207
• 

  Summary of T-SQL query statement

  T-SQL query sentence summary security code: where there is a will, there is a way, burn the boat, hundred Qin Guan end belongs to Chu Note: the table and grammar are numerous, so summed up as the sql server sentence, friends can refer to if necessary, thank you! Case 1: the experimental requirements are shown in the following figure: 1. In pr

  2022-06-01 15:52:21 Views: 204
• 

  Basic knowledge of Oracle database

  First, what is a relational database at the beginning of learning Oracle database, let's first understand. What is a relational database. Relational database is a database relational system (Relational DataBase Management) based on relational database model.

  2022-06-01 15:52:19 Views: 287
• 

  Basic HBase operations, including table additions, deletions, queries, filters, etc.

  Package com.snglw.basic;import java.io.IOException;import java.util.ArrayList;import java.util.List

  2022-06-01 15:52:18 Views: 295
• 

  Mysql index is too long 1071-max key length is 767 byte

  Problem create table: Specified key was too long; max key length is 767bytes reason database table is encoded by utf8, in which varchar

  2022-06-01 15:52:18 Views: 212
• 

  The problem of garbled sqlplus display in oracle terminal

  Sqlplus login Oracle server query table shows in Chinese? Garbled SQL > select * from test11;ID-NAME--

  2022-06-01 15:52:18 Views: 276
• 

  Removal of db2 residue process

  Residual process removal: / opt/ebay/db2/V9.7 # ps aux | grep db2db2das1 3790 0.1 0.3 105280 7644? S 11:00 0:00 / opt/eb

  2022-06-01 15:52:18 Views: 264
• 

  An example of Oracle AWR performance Optimization

  There is a batch program running for more than 24 hours still can not be completed, collected during the program running AWR report is as follows. As can be seen above, the system is a single instance database of AIX, with a sampling time of 1319.96 minutes and a DB time of 1532.15 minutes. Take a look at T

  2022-06-01 15:52:00 Views: 234
• 

  Stored procedure + cursor

  Delimiter / / drop procedure if exists `test` / / CREATE PROCEDURE `test` () comment 'test stored procedure' BEGINdeclare

  2022-06-01 15:51:59 Views: 286