NAV: SLTechnology News&Howtos > Database >

• 

  Recommend a free SQL sever change notification tool from Netwrix

  SQLsever change Notification tool Microsoft SQL Server is a comprehensive database platform that uses integrated business intelligence (BI) tools to provide enterprise-level data management. Microsoft SQL Server database

  2022-06-01 07:01:49 Views: 222
• 

  Two problems of MySQL

  1 | Preface recently collected two interesting questions to share with you when solving problems for development partners. One is to report the error of Duplicate entry when executing the ALTER TABLE ADD COLUMN statement.

  2022-06-01 07:01:38 Views: 278
• 

  After killing the job:job broken being executed by oracle, the total time of job is still growing.

  Original post address http://blog.csdn.net/flower_xixi/article/details/263738711. First, determine the JOB number select * from dba_jobs_r to be stopped.

  2022-06-01 07:01:30 Views: 208
• 

  Renba House: is there this thing in the insulating glass of the house? The effect of small particles is not small.

  The insulating glass molecular sieve can absorb water and residual organic matter in the insulating glass at the same time, making the insulating glass smooth and transparent even at very low temperature. at the same time, it can fully reduce the strong internal and external pressure difference of insulating glass due to the great change of temperature difference between season and day and night. Hollow glass molecular sieve also solves the problem of hollow.

  2022-06-01 07:01:30 Views: 252
• 

  The Choice of "consistency" in the Design of Modern distributed Storage system

  The influence of CAP theorem on the design of modern distributed database system is less than we expected. On the contrary, the trade-off between consistency and latency has a more direct impact on several mainstream DDBS. The new theory PACELC proposed in this paper combines this trade-off with CAP in order to divide.

  2022-06-01 07:01:30 Views: 331
• 

  ORACLE 11G load balancing test

  The feature of SCAN (Single Client Access Name) is introduced in Oracle 11g R2. The advantage of this feature is that a virtual service layer is added between the database and the client, which is the so-called SCAN IP and S.

  2022-06-01 07:01:30 Views: 278
• 

  ORACLE RAC 11.2.0.4 ORA000205&ORA17503&ORA01174 that cannot be started by for RHEL6.8

  Yesterday, a colleague consulted that he patched a node in the rac cluster and the database could not be started after rebooting. At first glance, it looked like the disk group could not mount the error report: ORA17503, careful inspection found that it was the change in db_files parameters that caused the database to start the error ORA01174.

  2022-06-01 07:01:18 Views: 239
• 

  Xtrabackup backup recovery test

  Remote backup: innobackupex-- defaults-file=/usr/my.cnf-- user=backup-- host=127.0.0.1-- port=3306-- password=

  2022-06-01 07:01:18 Views: 266
• 

  Import CLOB and BLOB data use cases using SQL*Loader

  In the previous four articles, introduced the use of SQL*Loader and use cases, this article uses SQL*Loader to import CLOB and BLOB data Oracle SQL*Loader use cases (1) Oracle SQL*Loa

  2022-06-01 07:01:15 Views: 265
• 

  Oracle 12.2 create detached Jobs

  Detach job must point to a program object whose detach property is set to true. The box below is to create a nightly job on Linux and the system to perform a backup of the database. 1. Create a script to invoke the RMAN backup script, named $ORACLE_

  2022-06-01 07:01:14 Views: 210
• 

  Three configuration modes of c3p0

  There are three ways to configure c3p0, which are 1. 5%. Set each configuration item 2. 1 one by one through the setters method. Provide a c3p0.properties file under the classpath. Provide a c3p0-config.xml file under the classpath 1. Through s

  2022-06-01 07:01:14 Views: 280
• 

  What is bid opening and bid evaluation?

  The bid opening of the bidding network http://www.zhaobiao.cn/ shall be carried out in public at the same time as the deadline for the submission of bid documents determined in the tender documents, and the place of bid opening shall be the place specified in the tender documents. Bid opening shall be presided over by the tenderer, and all bidders shall be invited to participate. Open

  2022-06-01 07:01:14 Views: 247
• 

  Informix-online dynamic server monitoring tool

  one。 The main system monitoring tools are SMI, onstat, oncheck. two。 System Monitoring Interface (SMI) 2.1. The function of the system monitoring interface: the system monitoring interface provides a read-only access to the online system information. Provide standard

  2022-06-01 07:01:14 Views: 246
• 

  Mysql master/slave crash_safe replication: I don't blame you if you don't understand.

  Many brothers in the written by Little Cyclone industry are flocking to mysql and like it very much, because it is cute (small and exquisite installation package), simple (easy to install and easy to use), sincere (open source), and considerate (powerful features, continuous improvement). you

  2022-06-01 07:01:13 Views: 230
• 

  Redis (4): persistence-the configuration and principle of AOF persistence

  Configuration of AOF persistence and AOF rewriting: the default AOF mode is disabled, as shown in the following figure: if you want to enable it, rewrite no to yes. As shown below: the default file name is appendonly.aof, and you can also change the file name. The default save directory is also a configuration document

  2022-06-01 07:01:07 Views: 272
• 

  If your system needs to create an index on a large table, what factors would you consider?

  If your system needs to create an index on a large table, what factors would you consider? 1) with regard to the creation of indexes for large tables, if we comprehensively consider multiple dimensions, I will consider: 1. Why do you need to create an index, that is, whether the performance after index creation can be improved by 2. 5%. What to create

  2022-06-01 07:00:52 Views: 241
• 

  In-depth understanding of Oracle ASM (1): basic concepts

  Link to related articles: Asm Instance Parameter Best Practice Why is there no ASMLIB?Unix on RHEL 6 how to view the TRACE file asm_power with the file name beginning with "+ asm"

  2022-06-01 07:00:52 Views: 251
• 

  PostgreSQL Source Code interpretation (204)-query # 117 (data structure SelectStmt&Value)

  This section briefly introduces two important data structures of PostgreSQL in the execution of parse: SelectStmt&Value. Data structure SelectStmt "simple" SELECT can be converted into SelectStmt node

  2022-06-01 07:00:51 Views: 249
• 

  Using AUTO_INCREMENT CASE

  Using AUTO_INCREMENT CASEAUTO_INCREMENT CASE EXPLAIN http://dev.mysql.com/doc/refman/5.6/en/example-a

  2022-06-01 07:00:51 Views: 301
• 

  Differences between tablespaces uniform size and autoallocate

  Take a look at the tests done step by step and database performance tuning and record them. [@ more@] UNIFORM SIZE's test SQL > CREATE TABLESPACE eric DATAFILE2'/ u01/app/orad

  2022-06-01 07:00:51 Views: 214