NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Quick Platoon

  DECLARETYPE num_tt IS TABLE OF INT;num_t num_tt:=num_tt (); PROCEDURE quick_sort (arr_t IN OUT num_tt

  2022-06-01 09:00:46 Views: 257
• 

  Mysql-5.7.21 binary installation | Jemalloc memory Optimization | backup recovery | change password

  Introduction # Database directory / usr/local/mysql# data directory / data/mysql# slow log directory / data/slowlog##

  2022-06-01 09:00:46 Views: 234
• 

  MongoDB Notes X-Spatial Index

  Add 2D index db.map.ensureIndex ({gis: "2d"}, {min:-1,max:201}) default or create a 2D index query between [- 180180] call (70180) the nearest 3 points db.map

  2022-06-01 09:00:45 Views: 232
• 

  Oracle to view the character set and the handling of Chinese garbled

  Col VALUE format a20select PARAMETER,VALUE from nls_database_parameters where PARAMETER like'% CHARA

  2022-06-01 09:00:45 Views: 211
• 

  How to view the contents of stored procedures in oracle

  Select * from all_object a where a. Objectfully typewritten objective 'and a.object_name like'% XXX%';select * f

  2022-06-01 09:00:45 Views: 294
• 

  Centos7 installs mongodb using yum

  Installation software: yum-y install mongodb mongodb-devel mongodb-server modified configuration file: vim / etc/mongod.conffork = truep

  2022-06-01 09:00:42 Views: 206
• 

  MongoDB4.0 installation

  Environmental operating system installation package installation method Ubuntu18.04mongodb4.0apt installation Ubuntu18.04mongodb4.0docker installation II, apt installation sudo apt-key adv-- keys

  2022-06-01 09:00:41 Views: 260
• 

  The principle of startup and shutdown of oracle-parameter file management

  two。 Modify the parameter ORCL.__db_cache_size=373293056ORCL.__java_pool_size=33554432ORCL.__large_p in the parameter spfile and pfile file

  2022-06-01 09:00:41 Views: 235
• 

  MySQL Database (2)

  # # Mysql- index type index is similar to the "book of contents" index; the advantages of the index speed up the query speed; the disadvantage of the index slows down the writing speed (occupies physics

  2022-06-01 09:00:41 Views: 219
• 

  HBase error: org.apache.hadoop.hbas

  After setting up the distributed environment of HBase environment, it was found that two nodes could not get up after startup. The error report is as follows: 2016-04-27 03VO5VERV 32824 FATAL [regionserver60020] regionserver

  2022-06-01 09:00:41 Views: 273
• 

  Sqlplus editing command usage

  Sqlplus editing command line usage keywords: oracle sqlplus command line usage oracle database has many query tools, such as the famous PLSQL, after getting used to the graphical interface, it is really torture to face the sqlplus of the character interface.

  2022-06-01 09:00:41 Views: 207
• 

  Xtrabackup series: source code installation

  1. Check the dependency package rpm-q cmake gcc gcc-c++ libaio libaio-devel automake autoconf bison libtool ncurses-devel li

  2022-06-01 09:00:40 Views: 229
• 

  Rpm of package Management in Linux system

  Rpm==== overview of package management for Linux systems: in this chapter

  2022-06-01 09:00:39 Views: 231
• 

  Create table spaces and temporary table spaces

  View the data file storage path select FILE_ID,FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files order by file_

  2022-06-01 09:00:39 Views: 292
• 

  Character set in MySQL 5.6

  This article introduces the character set in MySQL 5.6.It is basically compiled when I was studying the MySQL 5.6manual. Introduction basic Conceptual character set (character set) is a mapping set of codes and character symbols. Collation rules (collation

  2022-06-01 09:00:36 Views: 288
• 

  Mysql deletes the database from the command line

  Mysql deletes database 1. 0 from the command line. Syntax: DROP DATABASE IF EXISTS database name; 2. Syntax parsing: IF EXISTS: judge whether the database exists. If so, delete the corresponding database. If not, avoid giving birth.

  2022-06-01 09:00:21 Views: 205
• 

  Summary of LAMP Environment Construction

  1. Why do you need to go to the official website to download the source package? To put it simply, it is for security. If it is an unofficial downloaded source package, it may be tampered with by people with ulterior motives. After all, it is source code, and anyone can modify the code. 2. Can 32-bit rpm packages be installed on 64-bit machines? six

  2022-06-01 09:00:21 Views: 287
• 

  Mysql5.7 migration and upgrade from library to master library

  CHANGE MASTER TOMASTER_HOST='10.10.30.34', MASTER_PORT=3306,MASTER_USER='slave',MASTER_PASSWORD='sla

  2022-06-01 09:00:21 Views: 301
• 

  Oracle rac changes the archive directory

  SQL > alter system set log_archive_dest='+LWK/archivelog' scope=spfile sid='*'; then close the two instances, start the instance, and change the database to archive mode

  2022-06-01 09:00:20 Views: 289
• 

  Navicat Link Database report 80070007

  Navicat uses ssh to jump in to mysql to connect Times: 80070007: SSH Tunnel: Server does not support diffie-hellman-group1-sha1 fo

  2022-06-01 09:00:20 Views: 219