NAV: SLTechnology News&Howtos > Database >

• 

  Oracle archiving error cases

  Oracle archiving error case system environment: operating system: RedHat EL55Oracle: Oracle 11.2.0.1.0 case: the archived log space of the customer database server is full and not found; DBA is switched by ha when finding the log

  2022-06-01 13:05:30 Views: 217
• 

  How to modify the order of fields in a table in Oracle database

  This article is about the Oracle database how to modify the order of fields in the table, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Some time before the preface, someone asked me

  2022-06-01 13:05:27 Views: 228
• 

  / etc/rc.d/rc.local to realize oracle 10g self-startup

  Environment: redhat 5.964-bit, oracle 10g1. Modify the dbstart script: $vi $ORACLE_HOME/bin/dbstart#ORACLE_HOME_LISTNER=/ade/vik

  2022-06-01 13:05:27 Views: 230
• 

  Knowledge of redis distributed Lock

  What this article shares to you is the relevant knowledge about redis distributed locks, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. There are generally three ways to implement distributed locks: 1. Number

  2022-06-01 13:05:27 Views: 277
• 

  [Linux] File lookup: find

  There are several file lookup instructions under Linux: find, whereis, which, and locate. ● which: view executable file location ● whereis: view file location ● locate: cooperate with database to view file ● fin

  2022-06-01 13:04:57 Views: 227
• 

  Principle of writing / querying data in Redis cluster (theory)

  Principle of redis cluster data storage: in redis cluster, if you want to store a key-value, the key will first take the remainder (and 16384) through the CRC16 algorithm, and the result will correspond to the hash slot between 0 and 16383 (ha).

  2022-06-01 13:04:56 Views: 257
• 

  Hadoop 2.2.0 Hot add New Node (including HBASE)

  Environment: 192.168.137.101 hd1192.168.137.102 hd2192.168.137.103 hd3192.168.137.104 hd4 four-node hadoop and hbase1, hd5

  2022-06-01 13:04:26 Views: 276
• 

  Enterprise-mysql read-write Separation (proxy)

  MySQL ProxyMySQL Proxy is a simple program between your client and MySQL server that can monitor, analyze, or change their communications. It is flexible and unlimited, and its common uses include: load balancing, so

  2022-06-01 13:04:26 Views: 279
• 

  Basic syntax of mongodb

  1. Start shell: (select linux when you mainly use crt software, otherwise you can't backspace sometimes.) [root@saltstack mongodb] # mongo > show dbs # View database admi

  2022-06-01 13:04:26 Views: 206
• 

  Oracle 10g performance tuning

  The original http://www.oracle.com/technetwork/articles/schumacher-analysis-099313.html database Oracle 10g, many previously difficult to obtain

  2022-06-01 13:04:26 Views: 272
• 

  The difference between getReadableDatabase and getWritableDatabase

  In Android, you can get an instance that can operate on the database through both getReadableDatabase and getWritableDatabase (). Then you can add, delete, check and change the database. , but both exist

  2022-06-01 13:04:18 Views: 255
• 

  MongoDB installation and multiple instances enabled by MongoDB

  MongoDB installation method 1. Manually compile and install the package Baidu network disk link: https://pan.baidu.com/s/19oPP-3k7MiPsemO2cLsdng password: k86h1, unzip it to the opt directory after mounting the local file

  2022-06-01 13:04:18 Views: 222
• 

  What do translate functions and replace functions mean in Oracle

  In this issue, the editor will bring you about the meaning of the translate function and replace function in Oracle. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article. Translat

  2022-06-01 13:04:17 Views: 256
• 

  Functions and problems of audit_trail parameters in production environment

  1. Audit_trail default value SQL > show parameter audit_trailNAME TYPE VALUEaudit_trail string DBSQL > 2, audit_trai

  2022-06-01 13:04:17 Views: 238
• 

  What version of sql server do you have to learn?

  This article shows you which versions of learning sql server, the code is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something. The more important versions of SQL Server are: 2000, 2005

  2022-06-01 13:04:17 Views: 298
• 

  How to set the appropriate redis expiration time

  This article uses easy-to-understand examples to introduce how to set the appropriate redis expiration time, the code is very detailed, interested friends can refer to, hope to be helpful to you. Expiration time setting Expiration time refers to setting a time on the key so that the key

  2022-06-01 13:04:14 Views: 230
• 

  Create a function that generates cascading superior characters

  Requirements: existing table dw, in which fields bm (coding), sj (superior coding), and new field px are required to add a string to the new field. The string is required to concatenate the superior and itself, and sort from top to bottom, from left to right, with "|" in the middle. For example, the unit code is 005, and the superior order

  2022-06-01 13:04:13 Views: 292
• 

  Script for python to import database

  The script is aimed at bulk importing data sql files, the data directory stores the sql files to be imported, and list.txt stores the list information to be imported. The script is as follows: #! / usr/bin/env python#-*-coding:utf-

  2022-06-01 13:04:13 Views: 230
• 

  Installation of SQL Server 2016

  SQL Server is a relational database management system developed by Microsoft Company. SQL Server is the core part of Microsoft data platform. SQL Server is operating the database management system (ODBMS).

  2022-06-01 13:03:43 Views: 296
• 

  Crossing the gap of database development and talking about the technical trend of distributed database

  With the continuous development of mobility and Internet, the business model and technology system of China's financial industry has gradually embarked on a completely different path from that of the western world. As we all know, the mobile penetration rate in Europe and the United States is far lower than that in China, and the population base is also different by an order of magnitude.

  2022-06-01 13:03:36 Views: 229