NAV: SLTechnology News&Howtos > Database >

• 

  SPARC-T5 install ORACLE 10G

  SPARC-T5 is a relatively new hardware model, so it is not very friendly to ORACLE 10G support. When installing ORACLE 10G in SPARC-T5, there are some special places that need to be done. 1. In order to actively avoid / prevent and DIS

  2022-06-01 18:01:01 Views: 217
• 

  Make up 12. Multi-table query on mysql

  First of all, prepare two tables. The first is the employee information table, named employee. Create table employee (emp_id int primary key auto_increment not null

  2022-06-01 18:00:57 Views: 209
• 

  Several kinds of common sort

  Quick sort selects an element from a series, called a "pivot", and reorders the series, with all elements smaller than the benchmark placed in front of the benchmark, and all elements larger than the benchmark behind the benchmark (the same number can be on either side). After the partition exits, the benchmark is located

  2022-06-01 18:00:57 Views: 269
• 

  Installation and configuration of OpenLDAP under Ubuntu system

  Preface LDAP (Lightweight Directory Access Protocol) is a lightweight directory access protocol based on X.500 standard. In Unix operating system, like NIS,DNS, it belongs to name service (Nami).

  2022-06-01 18:00:47 Views: 285
• 

  [MongoDB Learning Notes 26] A fixed set of MongoDB

  Ordinary sets in MongoDB are dynamic and can automatically grow to accommodate more data; relatively speaking, there is another set called fixed set. (1) the fixed set needs to be explicitly created and the size of the set is fixed; (2) once the space in the fixed set is used up, the inserted new document will cover the oldest.

  2022-06-01 18:00:47 Views: 224
• 

  Checkpoint in PostgreSQL xlog format

  The PostgreSQL xlog record format is divided into two parts, the first part is XLogRecord as the general xlog header, and the second part is the data part: it is divided into XLogRecordDataHeaderShort as the record checkpo

  2022-06-01 18:00:44 Views: 218
• 

  What should rman duplicate do when he encounters ORA-17628?

  Today, I did a new rman duplicate operation [oracle@ora02 ~] $rman target / auxiliary sys/oracle@PRODRecovery Manager: r

  2022-06-01 18:00:44 Views: 223
• 

  12c DataGuard switchover to 'primary'

  1. Environment description Oracle 12cRHEL 7 2. Operation Note: the switch needs to be performed on the physical standby node because the primary node needs to be restarted. 1. View configuration DGMGRL > show configuration;Configurat

  2022-06-01 18:00:43 Views: 277
• 

  MySQL management-notes-undo log rollback log physical file space recovery

  Undo log rollback log physical file space recovery MySQL5.6 before undo log is in the ibdata1 file, the ibdata1 file will become larger and larger. If you want to recycle, you must export the whole library, delete the data directory, reinitialize the database, and finally reinitialize the whole

  2022-06-01 18:00:43 Views: 287
• 

  Practical practice of mysql sentence writing (combining left company with subquery)

  Selectc.card_number,c.card_name,t.type_name,c.card_discount,t.type_low,c.card_integral, (c.card_recha

  2022-06-01 18:00:43 Views: 284
• 

  New features of MySQL8.0 and project practice (installation configuration, version upgrade, introduction to management)

  MySQL8.0 new features and project practice (installation configuration, version upgrade, introduction to management) video tutorial learning address http://edu.51cto.com/course/14566.htmlOracle/MySQL database learning dedicated QQ group

  2022-06-01 18:00:40 Views: 266
• 

  LINUX server beginner 1

  Ps-ef | grep redis / / View the process root 2266 2250 0 17:23 pts/1 00:00:00. / redis-cliroot 22

  2022-06-01 18:00:39 Views: 255
• 

  Sql determines whether the field contains a string

  CHARINDEX ('wonderful', notes) returns the result = 0 to indicate that it does not contain the start position of the string otherwise the start bit of the lookup mode "wonderful" in a particular row of the notes column in the titles table

  2022-06-01 18:00:39 Views: 276
• 

  A scheme for capacity expansion of zabbix server

  The original author of this article, Bao Guangya, the software development engineer of JD.com Mall basic platform Department, published on my blog with the consent of the author, if you need to reprint it, you need my consent. Introduction with the rapid growth of the amount of monitoring, zabbix administrators will one day find that the hard disk iops has reached tens of thousands, close to the hard disk io.

  2022-06-01 18:00:39 Views: 227
• 

  DBI1131E The user ID ERROR: i

  Upgrade the fixpack on the production machine today. At first, I didn't think it would be a big problem. Of course, the backup had already been done. I never thought that after the installFixPack command was issued, I waited a long time for the execution to step 50, and got stuck for a long time. (this is DB2 V11.1.

  2022-06-01 18:00:38 Views: 230
• 

  SQL statements commonly used in DBA Inspection

  1. Check how many processselect count (1) from vault processors are available in the current database. Check how many session (session=process*1.1) select cou there are in the current database

  2022-06-01 18:00:38 Views: 252
• 

  PostgreSQL inserts data from the terminal and contains Chinese characters, which will cause garbled codes.

  Solution: set the environment variable export PGCLIENTENCODING=UTF8 in the terminal server

  2022-06-01 18:00:38 Views: 208
• 

  Project practice: installation and configuration of zabbix3.04 in Ubuntu system LNMP environment

  Ubuntu 14.04 (LNMP) installation configuration Zabbix 3.0 LNMP installation you can refer to my previous blog article "ubuntu installation configuration LNMP" requirements analysis (1) Zabbix database may require a lot of CPU resources, depending on the number

  2022-06-01 18:00:30 Views: 218
• 

  MongoDB Database Profiling

  MongoDB Database ProfilingMongoDB Profiler is a system that captures database execution activities and helps identify slow queries and operations. The meanings of the capture levels available at the Profiling level are as follows: level setting

  2022-06-01 18:00:22 Views: 217
• 

  Creation of mdadm and lvm for Advanced File system Management

  "configuring quota system disk quota means that administrators can impose quota restrictions on the disk space that users can use. Each user can only use disk space within the maximum quota range. For example, some network disks are based on this function. Allocate fixed space to users, spend money to buy, and set the space to more.

  2022-06-01 18:00:22 Views: 276