NAV: SLTechnology News&Howtos > Database >

• 

  2_Oracle_Admin_PFILE and SID

  There can be multiple initialization parameter files, and specific files can be specified at startup; parameterized files can be modified. Through v$parameter, you can query the value of a specific parameter SQL > desc

  2022-06-01 10:54:37 Views: 225
• 

  OPatch Version: 11.2.0.3.13 version and OPatch Version: 11.2.0.3.10 version upgrade patch difference

  Patch (11.2.0.4.8) on RHEL6.6+11gR2RAC platform and Patch 22646198-Oracle Grid Infrastructure Patch Set Update 11.2.

  2022-06-01 10:54:36 Views: 228
• 

  Briefly introduce the data model of MongoDB

  MongoDB data is particularly flexible, and compared with SQL databases, it does not need to define the structure of the table before inserting the data. The collection of MongoDB does not emphasize a fixed document structure. This flexibility makes it easy to map the document structure. Each document can map the object it wants to express.

  2022-06-01 10:54:29 Views: 258
• 

  Basic operation of mongoDB

  MongdoDB instance-"Database -" Collection-"documents -" Field (key/value pair) bin executes. / mongod starts & background starts. / mongo enters mongoDB shell, many of which are similar to my.

  2022-06-01 10:54:28 Views: 217
• 

  CentOS 6.8 Cmake compilation and installation of MySQL (1)

  Before deployment, let's talk about several installation methods of MySQL: compile and install: the advantage is that it can be customized and customized according to the company's requirements; disadvantages: the compilation is complex and the dependency problem is solved; binary installation: the advantages do not need to compile and decompress; the disadvantages of large yum installation package: a combination of the above two

  2022-06-01 10:54:27 Views: 214
• 

  Zabbix-3.2 installation practice

  ZABBIX installation brief instructions Blue is what you need to pay attention to, and red is basically the cat part of the command line that you need to enter will be edited by VIM and the key part will also be identified by color. First install the zabbix installation database mysql to import the zabbix database initial file. Match

  2022-06-01 10:54:27 Views: 289
• 

  The first five functions in JavaScriptES6 are worth mastering.

  JavaScriptES6 adds a series of new features to the JavaScript language, some of which are more groundbreaking and more applicable than others. Like the ES6 class, for example, although it is novel, it adds to the existing JavaScript class creation method

  2022-06-01 10:54:27 Views: 277
• 

  Several methods of Oracle Recursive query

  Oracle's start with connect by prior is a conditional recursive query of "tree", which is divided into four usage cases: first: start with child node ID='...' Connect by prior

  2022-06-01 10:54:26 Views: 237
• 

  MySQL Chinese garbled code handling _ character set conversion processing

  -- Chinese garbled repair-- View MySQL service parameter settings mysql > show variables like'% character%';+--+-

  2022-06-01 10:53:56 Views: 229
• 

  Questions about installing oracle 11G R2 for Windows X64

  Download address: http://www.oracle.com/technetwork/cn/articles/112010-win64soft-094461.html#* Special instructions * # about the use of download tools: thousands of thousands

  2022-06-01 10:53:56 Views: 206
• 

  Detailed steps for oracle 11g R2 64-bit installation

  (oracle 11g R2 64 bit + PLSQLDeveloper installation instructions and PLSQLDeveloper + ORCALE11-instantclient-basic-win32-11.2.0.

  2022-06-01 10:53:56 Views: 239
• 

  Let the process of sleeping in mysql die quietly.

  The company rented Aliyun machine in Japan with network delay and a Linux server specially used to run game services. due to historical reasons, coupled with the sharp increase in the number of players, there are often a large number of sleep processes; touch a script to kill the sleep process: while

  2022-06-01 10:53:50 Views: 290
• 

  Instr () function in Oracle

  1. Format of instr () function (commonly known as character search function) format 1: instr (string1, string2) / instr (source string, target string) format 2: instr (string1, string)

  2022-06-01 10:53:33 Views: 289
• 

  Add Nth Slave Library to mysql Database Master-Slave replication

  Add mysql slave library mysql master slave replication server 1 master slave. Now add a mysql slave server, which requires that the master database cannot stop service. Previously, because it is not an online server, you can execute flush tables with on the master server.

  2022-06-01 10:53:32 Views: 261
• 

  Db2 parameter master-slave configuration parameter

  Master-slave parameters: modify date:ntpdate asia.pool.ntp.org master-slave configuration communication port: db2h_erpinst1 70000/tcp master library configuration: db2 update db cfg for erpd

  2022-06-01 10:53:27 Views: 254
• 

  MySQL primary key, index creation

  Create test table create table t1.t (an int,b varchar);-- add primary key, index alter table t1.t add primary key (a); alter t

  2022-06-01 10:53:27 Views: 215
• 

  Principle and practice of master-slave replication

  Mysql master-slave copy principle and configuration command input blue font: note × × background: important subtitle: blue background white word 1. Overview of replication Mysql built-in replication is the foundation for building large, high-performance applications. Distribute Mysql data to multiple systems, this distribution

  2022-06-01 10:53:27 Views: 288
• 

  Mysql incremental backup breakpoint recovery

  Misoperation in mysql in a production environment is quite normal, so incremental backup recovery of mysql is required. Incremental backup is often used, it can specify a certain misoperation time and location for data recovery, more accurate recovery of the data we want to restore. The following is true

  2022-06-01 10:52:57 Views: 210
• 

  Pt-stalk diagnosing MySQL problems pt-sift

  When a problem occurs, pt-stalk collects on-site data and triggers under certain conditions, and some monitoring data are collected to facilitate the analysis of the problem. Root permission is required to run this feature. It can be used as a real-time acquisition function, or the trigger condition pt-stalk-disk- can be set.

  2022-06-01 10:52:56 Views: 269
• 

  Try to insert data with Oracle in your spare time

  The first kind: beginfor R1 in 1.. 3000000 loopinsert into oracle_study (id,name) values (R1 camera ABC'| | R1); commit;end

  2022-06-01 10:52:50 Views: 246