NAV: SLTechnology News&Howtos > Database >

• 

  Oracle common commands

  Change the password alter user DBUSER identified by 123456; query the specific location of the data file in the table space select name from vault data; query the specific location of the data file in the table space and

  2022-06-01 12:35:44 Views: 277
• 

  [MongoDB] TTL aging set

  An TTL index (time to live index, an index with a lifecycle), which allows you to set a timeout for each document. A document is deleted when it reaches the preset aging level. This type of index is useful for caching problems (such as session preservation)

  2022-06-01 12:35:44 Views: 218
• 

  View v$asm_disk, v$asm_diskgroup, and asm logs

  [oracle@TestXLink dbs] $sqlplus / nologSQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 14 23:17:54

  2022-06-01 12:35:44 Views: 295
• 

  Introduction to semi-synchronous replication

  Introduction to semi-synchronous replication: by default, the replication functions of MySQL 5.5 and MariaDB 10.10 are asynchronous, asynchronous replication can provide the best performance, and the master library sends the Binlog logs to the slave library, this action ends, and

  2022-06-01 12:35:44 Views: 296
• 

  Mysql5.6 High availability Architecture based on GTID pattern-MHA (mha0.56)

  1. Environmental deployment: mysql1:192.168.110.131 as mastermysql2:192.168.110.132 as slavemysql3:192.168.110.130 as slave, same as

  2022-06-01 12:35:43 Views: 294
• 

  Centos7 install mongoDB

  1. Download the installation package download the installation file of mongoDB address: https://www.mongodb.org/downloads#production select Linux 64-bit legacy version, download to the target service

  2022-06-01 12:35:43 Views: 215
• 

  MySQL query statement SELECT and data condition filtering

  MySQL query statement SELECT, mainly using * to represent any field, can also write id,name,content, etc., data condition filtering is mainly between,and,or, WHERE,in,like,limit,n

  2022-06-01 12:35:31 Views: 207
• 

  Detailed explanation of SQL data types

  The data table consists of multiple columns of fields, each of which specifies a different data type. Once the data type is specified, the data content inserted into the field is determined. Different data types also determine how MySQL stores them and how they are used.

  2022-06-01 12:35:31 Views: 278
• 

  Bin-log files are not written on the mysql host

  The mysql master does not write bin-log files: there are three mysqlA B C in which An and B have already become masters and slaves, and B has become the master of C, and then the problem is that B says nothing to record bin-log, so C just can't synchronize data from B, and B can be smooth from A.

  2022-06-01 12:35:24 Views: 246
• 

  10g RAC manually registers listening service

  The following test comes from an experiment of adding and deleting instances. In 10G RAC, we know that monitoring is managed through netca, which is different from the mechanism of 11G. When adding nodes, you need to manually execute netca to register the listening service. In fact, we can also use crs_prof

  2022-06-01 12:35:24 Views: 264
• 

  RMAN of Oracle Learning (6) backup set backup film

  Let's go back to the files generated during the database backup. RMAN > backup database; Starting backup at 2015-07-08 00:58:27using channel ORA

  2022-06-01 12:35:24 Views: 269
• 

  Oracle basic query of Oracle topic 4

  1. Basic query statement query Overview of Oracle: query is the most frequently used operation, which can query data from one table or multiple tables. This section mainly focuses on the operation of single table query. Syntax format of basic query: SELECT * | {[DIST]

  2022-06-01 12:35:07 Views: 230
• 

  Introduction to DBCP connection Pool

  # initialization connections: number of initialization connections created when connection pool starts initialSize=1# minimum idle connections: the minimum number of connections allowed to remain idle in the connection pool. Below this number, new connections will be created. If set to 0, no minIdle=1# will be created.

  2022-06-01 12:35:07 Views: 281
• 

  Mysql query and Database Management of Relational Database (2)

  In the Mysql compilation and installation of relational database and database foundation (1) We have a general understanding of the basic application of the database. Let's talk about the daily life of MySQL. In the actual production work, I need to know which way I should choose in the database field. This is the way for us to go to the database of Light.

  2022-06-01 12:35:07 Views: 208
• 

  Plsql connection Oracle11g 64-bit database export dmp file flash by

  Contents of the log: Export started on 2016-10-28 9 Administrator 4315 42D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ BIN\ exp.exe pa

  2022-06-01 12:35:07 Views: 252
• 

  Regularly log off the electronic signature user

  USE [EFNETSYS] GO/* Object: StoredProcedure [dbo]. [SP_Dz] Script Date: 05gamma 26max 16:14:10 *

  2022-06-01 12:35:06 Views: 283
• 

  MYSQL lists all information functions and usage

  MYSQL records the mysql version information, the user information, the last inserted id, the database name, and the id of the database connection, which are described in detail below. 1According to id select connection_id ()

  2022-06-01 12:35:06 Views: 286
• 

  Weblogic installation notes

  # create a BEA user group account [root@oracledb ~] # groupadd-g 600 bea# create a Weblogic user account userhome represents the home directory of the user, and GID is the group I created in the previous step

  2022-06-01 12:35:06 Views: 221
• 

  RMAN of Oracle Learning (10) RMAN maintenance

  We have done so many backups before, how can I query what I have done through RMAN? RMAN provides us with the LIST command. The LIST command displays information about backup sets, proxy copy, and mirror copy. RMAN > list;RMAN-0

  2022-06-01 12:35:06 Views: 245
• 

  Mongodb OPS Manager installation and use

  Mongo ops manager defaults to the monitoring and management tools provided with the enterprise version. If you use the community version and want to use ops manager, you need to install it manually. Download the mongo ops manager package (url:http

  2022-06-01 12:35:06 Views: 291