NAV: SLTechnology News&Howtos > Database >

• 

  A summary of performance optimization

  In the aspect of personal management, 1. Form a systematic thought. When doing a thing (developing a system, solving a problem), you can start according to a certain system, which can be understood as thinking consciousness. There is less process of starting from scratch, so as to improve efficiency. It takes someone to do this.

  2022-06-01 14:45:12 Views: 220
• 

  Centos6.9 installs mysql5.7 using binary packages

  [toc] official documentation: https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html installation steps: 1. Download and decompress the downloaded binary package tar-xv

  2022-06-01 14:45:12 Views: 208
• 

  DBMS_XPLAN: Display Oracle Execution Plans

  The DBMS_XPLAN package is used to format the output of an explain plan. It was introduced in Oracle

  2022-06-01 14:45:11 Views: 201
• 

  MySQL (2)-basic operations of SQL statements and database tables

  One. First acquaintance of SQL language SQL (Structured Quqry Language): structured query language, mainly used to access data, query data, update data and manage relational database systems SQL language is divided into three types

  2022-06-01 14:45:04 Views: 232
• 

  11g rac scan ip unable to connect issu

  Phenomenon description: scan ip is not registered to monitor, remote connection scan ip can not access the database. $lsnrctl status listener_scan1LSNRCTL for Linux: Version 1

  2022-06-01 14:45:03 Views: 208
• 

  Oracle ASM failure data recovery solution

  1. Fault description: the ASM disk group is offline and the ASM instance cannot be mount. The ASM disk group is composed of four 500G disks, and the database and ASM software is 10.2.0.1. It is urgent to restore the oracle database. Fault Analysis and Analysis of the disks that make up the ASM disk Group

  2022-06-01 14:44:51 Views: 212
• 

  Use MySQL Workbench to modify the table character set

  Problem MySQL official website provides many free database operation tools, among which Workbench is a free and excellent visual database management tool, you only need to download the latest version, you can manage many other versions of the database at will, of course, with the appropriate s

  2022-06-01 14:44:48 Views: 201
• 

  SQL Server: a summary of the methods of writing transactions in stored procedures

  / * * 8. Summary of methods for writing transactions in SQLServer stored procedures * / Source: http://www.jb51.net/article/80636.htm in this article we introduce three different methods and give examples of how to use the

  2022-06-01 14:44:48 Views: 290
• 

  Oracle beginner's concept

  The following are some concepts that I first learned about oracle, which may be misunderstood. Under 1.windows, you can build a database with a graphical interface. See Baidu: http://jingyan.baidu.com/article/90bc8fc8

  2022-06-01 14:44:47 Views: 229
• 

  11g automatic collection of statistics

  13Automatic Optimizer Statistics Collection Open: BEGIN DBMS_AUTO_TASK_ADMIN.ENABLE (client_name = >

  2022-06-01 14:44:47 Views: 203
• 

  Monggodb Learning process-- update

  Today, I read the authoritative guide to mongodb. This book gives a detailed explanation of update. Because there are a lot of knowledge points, so record it on the blog. If I just read it, I think I will forget it tomorrow. There are two ways to update a document: 1, document replacement 2, modifier replacement (just modify the order

  2022-06-01 14:44:46 Views: 289
• 

  Redis data operation

  Click "official" to view commands file http://redis.cn/commands.htmlRedis command operation: http://doc.redisfans.com/ data structure redis is the data structure of key-value

  2022-06-01 14:44:46 Views: 257
• 

  Trove mysql replica usage

  1. Trove mysql replica some restrictions trove can support both binlog replica and gtid replicagtid requires mysql5.6 and above newton trove

  2022-06-01 14:44:40 Views: 280
• 

  MySQL log audit helps you find out the inner boy who did bad things.

  MySQL log audit helps you find out who did something wrong. Part1: written in the front, MySQL itself does not provide audit functions like MariaDB and Percona, but if we want to audit the database to see who deleted my database data, we should

  2022-06-01 14:44:40 Views: 209
• 

  Sorting, grouping, and collection operations

  Sorting operation sorting is one of the most basic operations undertaken by computers, especially in the field of database processing, oracle is no exception. Operations that may require oracle to sort data include the following: (1) create an index (2) through group by,unique or di

  2022-06-01 14:44:39 Views: 252
• 

  Mysql database version 5.7 password modification details (centos7)

  Premise: mysql version 5.7 Linux version Red Hat centos7 goal: set up a MYSQL database server and set the local login password of the database administrator to 123456-1. Install slightly-2. Check to install ~ # rpm-qa | gre

  2022-06-01 14:44:39 Views: 257
• 

  V$PROCESS view

  V$PROCESSV$PROCESS shows the active process information of the current database. ColumnDatatypeDescriptionADDRRAW (4 | 8) Address of the process stat

  2022-06-01 14:44:39 Views: 257
• 

  Quick implementation of command recording and deletion keys in oracle, and quick configuration using scripts

  Environment: centos6 1: command record 1. Use yum to install readline-develyum install readline-devel2. Source code compilation and installation of rlwrap# wget http://utopia.

  2022-06-01 14:44:39 Views: 211
• 

  HANA backup file description

  Path data backup path: / usr/sap/SID/HDBnr/backup/data log backup path: / usr/sap/SID/HDBnr/backup/log if you want to change the path, you can use studio's backup c

  2022-06-01 14:44:38 Views: 260
• 

  Query user permissions dba-role_privs

  We all know that the information about each archivelog is recorded in controlfile. Of course, after we drop these physical files delete under OS, we still record these archivelog information in our controlfile.

  2022-06-01 14:44:38 Views: 270