NAV: SLTechnology News&Howtos > Database >

• 

  ORA-12801

  ORA-12801: error signaled in parallel query server P007, instance dgdgORA-01722: invalid numberORA-1

  2022-06-01 16:38:06 Views: 299
• 

  MongoDB-Map&Reduce

  Simulate big data search scene-he Xudong please use a script to insert the student form of the Map&Reduce example in this course into the 1000W section file. The field remains the same. Use Map&Reduce to calculate 10db.users.count (); 1000

  2022-06-01 16:38:06 Views: 272
• 

  Environment configuration of oracle-snooping Service and access connection principle

  Monitoring service and access connection principle port number range: 102506500 [oracle@oracle3 ~] $lsnrctl-- enter the monitoring management tool LSNRCTL for Linux: Version 10.2.0.1.

  2022-06-01 16:38:06 Views: 262
• 

  How to create a trigger

  How do I create a trigger? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way. What is a trigger? Triggers are used to perform some actions "automatically" after / before certain actions. (for example, insert

  2022-06-01 16:38:06 Views: 224
• 

  Solution: Reading table information for completion of table and column names

  Mysql-A does not pre-read database information (use dbname is faster)-Reading table information for completion of table and column names Y

  2022-06-01 16:38:02 Views: 237
• 

  The usage of Fuzzy query statement in mysql Database

  The fuzzy query statement is as follows: "SELECT field FROM table WHERE a field Like condition". Mysql provides four matching patterns: 1,% represents any 0 or more characters. The following statement: SELECT * FROM user

  2022-06-01 16:38:02 Views: 231
• 

  Oracle Database Cluster disaster recovery implementation and maintenance 2.0 (RAC+DataGuard+GoldenGate) tutorial

  Oracle database cluster disaster recovery implementation and maintenance (RAC+DataGuard+GoldenGate) training package introduction: Fengge Oracle database cluster disaster recovery 2.0 (RAC+DataGuard+GoldenGate) implementation and

  2022-06-01 16:37:59 Views: 304
• 

  SQL Server AlwaysOn log shrinking

  At present, many projects are gradually adopting SQL Server AlwaysOn architecture as a high-availability cluster technology for databases. And most of Microsoft's current products, Citrix XenDesktop, XenApp, PVS, XenMobile

  2022-06-01 16:37:32 Views: 259
• 

  Resolve the problem that json strings cannot be parsed by mysql5.7 and below

  # spell key- > value (json string) into sql statement DELIMITER / / DROP FUNCTION kvJsonData//CREATE FUNCTION kvJsonData (tableNa

  2022-06-01 16:37:32 Views: 228
• 

  Monitoring cacti zabbix (2)

  Monitoring (1): (cactizabbix) premise: cacti configuration completes cacti monitoring other hosts (collect data: crontab timing call (poller.php) snmp collect and store data: rrdtool-- > r under rra

  2022-06-01 16:37:32 Views: 298
• 

  The principle, Construction and configuration of redis Cluster

  Understand and build redis clusters from scratch some developers only use redis in their applications, such as caching for data results. And there are a lot of good redis client tools (redisson) that basically don't have to pay attention to the redis command.

  2022-06-01 16:37:26 Views: 217
• 

  Linux_MySQL (mariadb) Database (2) V1.0

  MySQL AB-- > MySQLSolaris: binary version; www.mysql.comMariaDB: www.mariadb.orgMariaDB features: plug-in storage engine: storage manager has multiple implementation versions

  2022-06-01 16:37:25 Views: 300
• 

  Oracle Study-AIX6.1 to build Oracle 10gR2 RAC (5)

  Oracle Study-AIX6.1 build Oracle 10gR2 RAC (5) I. install Oracle software install as Oracle: after the installation of Oracle software, run the "root.sh" script to complete the Oracl

  2022-06-01 16:37:24 Views: 268
• 

  What is the mystery of the major upgrade of Citic banking system on October 25?

  The author went on a trip to Las Vegas in October and started the buy mode by the way, and the Citic Bank credit card in his hand was almost maxed out. Last night, my wife ran over and said, "have you paid back the credit card of CITIC Bank?" I heard that the business system was upgraded on October 25, and all related business was suspended for one day. " Since

  2022-06-01 16:37:15 Views: 205
• 

  Transaction management using @ Transactional annotation of Spring in SSM framework

  It is very important to protect the integrity of data in enterprise applications. Therefore, no matter how high the performance of the application is and how beautiful the interface is, if there is an unexpected error in the amount of the user's account during the transfer process, then such an application is also unacceptable data.

  2022-06-01 16:37:06 Views: 269
• 

  Separate use of AlwaysOn Service IP and High availability IP (1)

  Technical background A log database is very large, and the bandwidth of Direct Connect is limited. It takes 2 hours to build an AlwaysOn AG. Later, it is considered to separate the business IP from the high-availability IP. The business IP is dedicated to the business application access database service, and the high-availability IP is dedicated to providing AG communication. When doing the customs clearance test

  2022-06-01 16:37:06 Views: 221
• 

  SQLAdvisor Meituan SQL Index Optimization recommendation tool

  SQLAdvisor Meituan SQL Index Optimization suggestion tool Preface Part1: written in the forefront SQLAdvisor is an open source SQL index optimization recommendation tool by Meituan, which is an analytical SQL developed and maintained by the DBA team (Beijing) of the Technical Engineering Department of Meituan Dianping Company.

  2022-06-01 16:37:03 Views: 247
• 

  SQLite compilation (How To Compile SQLit

  Excerpt from: http://www.sqlite.org/howtocompile.htmlAmalgamation Versus Individual Source Files merges with a single source file SQLite is

  2022-06-01 16:37:03 Views: 224
• 

  Talk about the process ID and MongoDB _ id primary key of the operating system

  Talk about the process of the operating system ID and MongoDB _ id primary key in the distributed system, the merging of data becomes normal, and the database in the stand-alone system can use self-increasing ID as the primary key, which is simple and easy. However, in distributed systems, there are great difficulties in data merging. Data primary key

  2022-06-01 16:36:58 Views: 255
• 

  Linux operation and maintenance learning process-day 10-file search tool

  Summary: this article mainly explains locate command and find command to help us find files in linux and facilitate us to locate files quickly. First, file lookup is to find files that meet the criteria on the file system. Common workers have locate, find1 and loca.

  2022-06-01 16:36:58 Views: 319