NAV: SLTechnology News&Howtos > Database >

• 

  Table space of oracle

  1. Create a tablespace sqlplus / as sysdba / / enter the library as dba startup / / Open the database create tablespace db_work / / create a tablespace data named db_work

  2022-06-01 17:04:17 Views: 256
• 

  Oracle grouping function

  Grouping function: acts on a set of values and returns a value for a set of data; use of grouping functions: Avg (average), sum (summation), min (minimum), max (maximum), count (total number), wm_concat

  2022-06-01 17:04:16 Views: 283
• 

  Basic Operation and Optimization of MySQL Database

  Preface MySQL is a relational database management system, in which relational databases store data in different tables instead of all data in a large warehouse, which increases speed and flexibility. The SQL language used by MySQL is the most commonly used standard for accessing databases.

  2022-06-01 17:04:16 Views: 243
• 

  RAC (11gR2) OCR BACKUP & RESTORE

  First check the OCR disk [grid@rac1 cdata] $ocrcheckStatus of OracleCluster Registry is as follows: Version: 3Total

  2022-06-01 17:04:16 Views: 265
• 

  Mariadb utility function 3 modify table structure to display progress

  In the work need to modify a table structure do not know the progress, waiting is also a very painful thing. Mariadb intimate small function, let people shine in front of the eyes, produced a temporary watch, and the progress can be seen, good,good. For direct operation, see the result MariaDB [tes]

  2022-06-01 17:04:16 Views: 201
• 

  ORACLE LOB large object processing

  LOB large object processing: database fields that are mainly used to store large amounts of data, up to 4G bytes of unstructured data. This paper mainly introduces the storage of character type and binary file type LOB data, and introduces the storage of binary type LOB data separately. one。 L in Oracle

  2022-06-01 17:04:15 Views: 292
• 

  Centos 6.8 install Percona Xtrabackup

  1. Get the xtrabackup tool https://www.percona.com/. 2. Install rpm-ivh percona-xtrabackup-24-2.4.6-2.el6.x of rpm installed here.

  2022-06-01 17:04:15 Views: 224
• 

  ERROR OGG-01161 Bad column index (15) specified for table

  Error message: GGSCI (haitaonode01) 02 > info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNN

  2022-06-01 17:04:15 Views: 205
• 

  11g production database crsctl start has cannot start fault handling

  The following is a simulation operation, because the customer's core database is not allowed to take out the log. But the process and thinking are almost the same. 1. Fault description 11G RAC-stand-alone ADG, the backup HAS service cannot be started. Second, the phenomenon has checked all kinds of logs of the cluster, and there are no any

  2022-06-01 17:04:15 Views: 213
• 

  Naming Design Specification for MongoDB

  MongoDB is a database based on distributed file storage. Written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. MongoDB is a product between relational database and non-relational database, which is one of non-relational databases.

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

  Source code compilation and installation of mysql5.7.18

  # yum install-y gcc-c++ cmake vim ncurses-devel wget#useradd mysql-s / home/nologin#mkdir / soft/mysq

  2022-06-01 17:04:14 Views: 205
• 

  LINUX oracle modifies the default listening port number 1521

  The default listening port number for ORACLE is 1521, and changing the default port number helps to increase the security of the ORACLE database server. Here, we change the port number of oracle from port 1521 to 99991, and check the listening status $lsnrctl st

  2022-06-01 17:04:10 Views: 219
• 

  Lock mechanism in Oracle

  Lock: the mechanism used to implement concurrent access control in oracle; classification: table-level lock, row-level lock; application of lock: when executing insert, delete, update, oracle automatically applies row-level lock; when executing select, it does not add lock; sele

  2022-06-01 17:04:10 Views: 217
• 

  Install MongoDB on Windows

  1. Download the appropriate mongodb official website download address: http://www.mongodb.org/downloads there are three versions of MongoDB for Windows: MongoDB for Windows

  2022-06-01 17:04:07 Views: 245
• 

  RHCS Cluster Suite uses Luci/Ricci to realize the detailed configuration of Web Cluster

  For an introduction to RHCS clusters, see http://11107124.blog.51cto.com/11097124/1884048. In RHCS clusters, each cluster must have a unique cluster name and at least one fence device (not really

  2022-06-01 17:03:49 Views: 218
• 

  RedHat 6.7 install Mysql 5.7.18

  Environment preparation: operating system: RedHat 6.7Database: Mysql 5.7.181. Download mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz from the official website address: http://dev

  2022-06-01 17:03:49 Views: 244
• 

  Xtrabackup backup mysql database

  Xtrabackup provided by percona percona Xtrabackup is a free, open source, complete online backup tool that supports mysql, perconna server, mariadb to the official website https://w

  2022-06-01 17:03:49 Views: 295
• 

  SSDB high availability scheme

  About SSDB SSDB is a high-performance NoSQL database developed by Champact + language, which supports data structures such as KV, list, map (hash), zset (sorted set), etc., to replace or work with Red.

  2022-06-01 17:03:48 Views: 269
• 

  Oracle 12cR2 RAC installation configuration and some pits

  The Oracle 12cR2 version has been released for some time and has been trying to test the installation of RAC. It took two weekends and one day to install RAC from last weekend to today. Here is a record of the configuration of the operating system during installation, as well as some pits encountered during installation. one

  2022-06-01 17:03:45 Views: 295
• 

  The third wave of saltstack "remote execution"

  Chapter 3 SaltStack remote execution 3. 1 destination (Targeting) specifies the target, which is used to match minion. By default, minion ID is used as the target to match minion. Match the target, very important, because the match is wrong, the execution of the command is wrong

  2022-06-01 17:03:37 Views: 288