NAV: SLTechnology News&Howtos > Database >

• 

  The role of various files in oracle

  one。 Control file 1. The role of control file in database startup for dna, oracle database control file is a very important file. It is a binary file automatically generated when the database is created, in which the status information of the database is recorded. No other user can modify the control text

  2022-06-01 15:22:03 Views: 260
• 

  How to configure two Redis to work independently without conflict

  What this article shares to you is about the method of configuring two Redis to work independently without conflict. 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. To start two on the same server

  2022-06-01 15:22:02 Views: 264
• 

  The method of adding redis cache

  In this issue, the editor will bring you ways to add redis cache. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article. Redis is often used as a cache server. The advantage of caching is to reduce the pressure on the server

  2022-06-01 15:22:02 Views: 237
• 

  UniDAC usage tutorial (5): data encryption

  Download the latest version of UniDAC Universal Data Access Components (UniDAC) is a general database access component that provides direct access to multiple databases, such as Delphi for Windows, C

  2022-06-01 15:22:02 Views: 235
• 

  Problems encountered during the installation of Oracle11G R2 under Linux

  There are several problems encountered in the process of installing Oracle11G R2 under Linux. I hope it will be helpful to you. 1. How to install oracle?? graphically in linux Solutions and ideas: 1) you can install the VNC service. 2) if you are close to you on the server

  2022-06-01 15:21:59 Views: 242
• 

  Create a mysq database and create an administrative user

  Case: create a user of a library, such as create a user for a yii2basic library: create a library first, and then create a user / / create a database drop schema if exists' yii2basic';create schema if

  2022-06-01 15:21:56 Views: 229
• 

  Innodb Storage engine Monitoring

  Innodb storage engine monitoring is divided into four types, table monitoring, tablespace monitoring, lock monitoring, status monitoring. You can turn on the monitoring option in the mysql client, and then the information will be output in the error log of mysql. Innodb_monitor and innodb_loc

  2022-06-01 15:21:55 Views: 249
• 

  The execution process of SQL statement

  1. Syntax check if there is no corresponding execution plan in the SQL plan cache, the server will first validate the SQL statement requested by the user. If there is a syntax error, the server will end the query operation and return the corresponding error message to the calling application. Note: the error returned at this time

  2022-06-01 15:21:55 Views: 213
• 

  Centos7 compile and install mysql script

  #! / bin/bash# mysqld install scripts# display ProgressProgress () {baked goods' iTunes 0 while [$I-le

  2022-06-01 15:21:55 Views: 295
• 

  11g R2 rac linstener snooping configuration

  Information of host,ipvip and scan of two nodes # eth0-Public IP162.12.0.1 cqltjcpt1162.12.0.3 cqltjcpt2#eth2 PRIVATE IP

  2022-06-01 15:21:55 Views: 289
• 

  Building tables with PL/SQL

  First of all, before you build a table, be sure to be clear about the use of the table you are about to build. What I want to say is to operate on pl/sql. The table SQL in oracle is as follows: the name of the table to be created by create table (the type of field 1, field 1, for example, var

  2022-06-01 15:21:54 Views: 284
• 

  Tree structure and hierarchical query in oracle Table

  1. Here, take the emp table as an example. There is a subordinate-superior relationship between the empno field and the mgr field in this table. 2 look up the top-level boss from top to bottom, where the level is one of the three pseudo columns, level select level,empno,ename.

  2022-06-01 15:21:42 Views: 222
• 

  MySQL5.6 installation

  1. Download the Mysql official website by yourself (binary package). 2. Decompress cd / optmkdir mysqlcd mysqltar zxvf / path/mysql-5.6.ln-s / opt/mysql

  2022-06-01 15:21:42 Views: 290
• 

  Linux silently installs oracle11g

  Linux silently installs oracle 11linux version [root@oracle ~] # cat / etc/issueCentOS release 6.5 (Final) Kernel\ r on an

  2022-06-01 15:21:41 Views: 215
• 

  Postgres_XL brief installation configuration instructions

  1. System requirements CentOS 7.2 X64postgres-xl-9.5r1.4.tar.gz# yum install-y gcc-c++# yum install-y readline-deve

  2022-06-01 15:21:41 Views: 256
• 

  Change the storage location of zabbix's MariaDB database

  # create mkdir / company acronym / mysql# stop database service systemctl status mariadb.servicesystemctl stop mariadb.service# move database files to

  2022-06-01 15:21:41 Views: 233
• 

  Java basic Day 23 _ Database connection Pool\ reflection

  1. Attribute assignment-1.Man {50 +} Man man = new Man (); man.setXxx1 (...); man.setXxx2 (...);... 50Man copy =

  2022-06-01 15:21:40 Views: 225
• 

  Db file parallel read of Oracle waiting for event

  Db file parallel read official website explains: This happens during recovery. It can also happen during buffer prefetching

  2022-06-01 15:21:37 Views: 216
• 

  Separate LNMP3 hosts for deployment

  LNMP 3 hosts separate deployment first virtual host deployment nginx second virtual host deployment php-fpm third virtual host deployment mariadb-server first host deployment nginx installation: realization of static network

  2022-06-01 15:21:27 Views: 209
• 

  About the installation and configuration of the httpd 2.x module modulated authentic MySQL and the support for aes encryption

  The preface mentioned that the mod_auth_mysql.so module was used in the protocol authentication in the experiment 2 of the previous blog post "Apache httpd2.2 version and some experiments of version 2.4". This article will describe the installation and configuration of this module, as well as the addition of aes.

  2022-06-01 15:21:24 Views: 245