NAV: SLTechnology News&Howtos > Database >

• 

  RMAN of Oracle Learning (5) Mirror copy

  We mentioned last time that RMAN can provide full library backup, tablespace backup, data file backup, archive log backup, control file and parameter file backup. The files backed up by RMAN are called backup sets. In the process of backup, RMAN only backs up the data blocks that have been used. RMAN

  2022-06-01 14:25:51 Views: 290
• 

  Description of mysql pid parameters in my.cnf configuration file

  The mysql pid parameter in the my.cnf configuration file states that when the MySQL instance starts, its own process ID is written to a file-- that is, the pid file. This file can be controlled by the parameter pid_file. It is located in the database directory by default, and the file name is host.

  2022-06-01 14:25:48 Views: 292
• 

  Greenplum database python custom function

  The greenplum database (hereinafter referred to as the gp database) supports custom functions. The following is a description of the custom simple functions written by python. The clustering function is more complex, and I feel that it is not suitable to be written in gp database. The python custom function states that as long as pytho

  2022-06-01 14:25:48 Views: 287
• 

  SQL Server timeout analysis and summary

  From the point of view of the database instance, it will receive access from the web side, direct access from the user, and it may also access other database instances at the same time. Then, the connection is divided into incoming connection (Incoming connection) access and outgoing connection (Outgoin)

  2022-06-01 14:25:48 Views: 280
• 

  Mysqldump: Error 2020: Got packet bigger than 'max

  Today, I found an error [root@confluence mysqldump] # mysqldump-- max_allowed_packet=1 during the mysqldump backup of the company's confluence.

  2022-06-01 14:25:47 Views: 295
• 

  MongoDB database reference

  1. Check the database show dbs2. Create runoob database use runoob3. View the collection show collections4 in runoob. Create a collection of addresses (address_home,address_off

  2022-06-01 14:25:40 Views: 224
• 

  Mysql sets double 1s to ensure database consistency

  In MySQL, after a transaction is committed, you need to write undo, write redo, write binlog, write data files, and so on. In this process, crash may occur at some step, which may lead to inconsistency between master and slave data. In order to avoid this situation, we need to adjust the master and slave.

  2022-06-01 14:25:39 Views: 250
• 

  The relationship between Oracle and / etc/hosts is ambiguous.

  I dealt with a small case yesterday, but later I found that I don't know which dear friend modified the / etc/hosts file, causing the database to get down. Record [root@padb ~] # su-oracle$$ps-ef | grep ora_

  2022-06-01 14:25:39 Views: 221
• 

  The one-line function of Oracle in Oracle topic 5

  What is the SQL function? The SQL function is a built-in function in the Oracle database and can be used in a variety of SQL statements. The SQL function contains single-line functions and multiple-line functions. 1. The input of a character function is a character type, and its return value is a character type or a numeric type. Character function

  2022-06-01 14:25:39 Views: 282
• 

  SQL SERVER

  1. Data type create table nnnn (column_char char (10), / / character column_varchar varchar (10), / / variable length character column_text t

  2022-06-01 14:25:38 Views: 232
• 

  Lamp discuz+wordpress+phpmyadmin

  Experimental topic: set up LAMP, install Nginx, as an agent, install MySQL on a separate machine, apache is responsible for dynamic, nginx is responsible for static requirements as follows: 1. Prepare two centos 6s, one of which runs mysql, and the other

  2022-06-01 14:25:29 Views: 207
• 

  NetEase's separation of reading and writing in cetus

  1. Cetus is the middleware of relational database MySQL developed by C language, which mainly provides a comprehensive database access agent function. The Cetus connection mode is basically compatible with MySQL, and the application can access the database through Cetus almost without modification.

  2022-06-01 14:25:26 Views: 222
• 

  Oracle series: (7) order by clause

  Query employee information (number, name, monthly salary, annual salary), sort by monthly salary ascending order, default ascending order, if monthly salary is the same, sort select empno,ename,sal,sal*12 from emp order by oracle built-in check rules

  2022-06-01 14:25:04 Views: 295
• 

  How to restore the root account after mysql mistakenly deleted root

  System: CentOS release 6. 5 (Final) kernel: 2. 6. 32-431.el6.x86_64MySQL version: 5.5.28-log Source distribution procedure: 1. Stop it

  2022-06-01 14:25:04 Views: 297
• 

  Implement MySQL read-write separation deployment cluster basic environment (figure)

  Implement MySQL read-write separation deployment cluster basic environment 1 implement MySQL read-write separation 1.1 this case requires the configuration of 2 MySQL servers + 1 proxy server to achieve read-write separation of MySQL proxy: users only need to access MySQL proxy server, but actually

  2022-06-01 14:24:59 Views: 257
• 

  Oracle client installation configuration

  Vi / home/oracle/.bashrcumask 022ORACLE_BASE=/usr/lib/oracleORACLE_HOME=$ORACLE_BASE/11.2/client64PAT

  2022-06-01 14:24:58 Views: 301
• 

  There is nothing wrong with lower_case_table_names=0

  Recently, I have found that I have encountered a lot of things. I clearly know that I am wrong, but I still ask others to make changes. It is so strange ~ ~ it is still good to write a small document quietly ~ mysql > show tables; outline | t_txn_net

  2022-06-01 14:24:58 Views: 212
• 

  Oracle modifies the eligible records according to several conditions.

  Declare i number; temp_sum number; temp_hfmpcode temptable.pubname%type;-temptable.pu

  2022-06-01 14:24:58 Views: 231
• 

  Timesten architecture

  The diagram on the Timesten architecture shows the architecture diagram of Oracle Timesten 11g shown in the official documentation. In order to make it easier to understand, let me explain the parts one by one. First of all, the shared library (Shared Libraries): mainly includes the implementation of S

  2022-06-01 14:24:40 Views: 288
• 

  The solution of changing user password and forgetting administrator password in database

  1 when the user's password is changed normally and remember the password, there are three ways to modify the user's password: (1) SET PASSWORD [FOR 'user'@'host'] = PASSWORD (' cleartext password

  2022-06-01 14:24:39 Views: 241