NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11gR2 RAC installation Grid Infrastructure error

  Oracle 11gR2 RAC installation Grid Infrastructure error system environment: operating system: RedHat EL5Cluster: Oracle GI (Grid Infrastructure) O

  2022-06-01 15:32:32 Views: 229
• 

  SQL Optimization: explain the correct posture of Oracle Hint

  1. Hint Overview 1. Why the introduction of Hint?Hint is a unique function in Oracle database, and it is a means often used in many DBA optimization. So why would Oracle consider introducing an optimizer? The optimizer based on cost is very smart.

  2022-06-01 15:32:26 Views: 264
• 

  MongoDB introduction

  MongoDB, written by C++, is an open source database system based on distributed file storage, which belongs to NoSQL. Under high load, more nodes can be added to ensure server performance. MongoDB is designed to provide scalable, high-performance data storage solutions for WEB applications.

  2022-06-01 15:32:26 Views: 219
• 

  [Oracle Database] Database snooping and connection

  Service name-modify [oracle@wallet01 ~] $sqlplus / as sysdbaSQL > show parameter service_names;NAME according to business requirements

  2022-06-01 15:32:25 Views: 278
• 

  Introduction of nodes in Redis Cluster

  The editor in this issue will bring you an introduction about the nodes in the Redis cluster, analyze and describe it from a professional point of view. I hope you can get something after reading this article. The nodes in the Redis cluster are divided into master node (master) and slave node (slave)

  2022-06-01 15:32:25 Views: 256
• 

  Hadoop Sqoop

  First, Overview: Sqoop is an open source tool, mainly used in Hadoop (such as Hive, HDFS) and traditional databases (mysql, Oracle.) The data can be transferred between a relational database (such as MySQL, Ora)

  2022-06-01 15:32:18 Views: 230
• 

  Oracle LOOP loop control statement

  In PL/SQL, the loop statement can be used to loop the data, which can be used to loop through the specified sequence of statements. Commonly used LOOP loop statements come in three forms: basic LOOP, WHILE...LOOP, and FOR...LOOP. LOO

  2022-06-01 15:32:18 Views: 230
• 

  Nine younger sisters will introduce you to oracle.

  1. Oracle architecture the architecture of Oracle is the composition of the database, the working process, and the organization and management mechanism of the data in the database. In order to understand the architecture of oracle database, we must understand the main components and important concepts of oracle. Orac

  2022-06-01 15:32:18 Views: 261
• 

  Golang: the problem of idle disconnection of connecting database

  Golang is doing database operations. Generally speaking, we use the Open function to create a database (operation) handle: func Open (driverName, dataSourceName string) (* DB, error)

  2022-06-01 15:32:17 Views: 256
• 

  The difference between get and load in hibernate

  1. Get executes the sql statement immediately, and load executes the sql statement only if the non-id attribute of the object is accessed. 2. When get gets an object, if it cannot find it, it returns null. When load gets the object, if it cannot find it, it throws an ObjectNo.

  2022-06-01 15:32:17 Views: 278
• 

  Linux Monitoring system _ Zabbix concept (2)

  Official site http://www.zabbix.com/Zabbix version LTS:long time support long-term maintenance version 2.2 3.0 feature: data acquisition: snmp ssh/telnet agent ip

  2022-06-01 15:31:59 Views: 260
• 

  How to build a highly available Redis Service Architecture

  This article will explain in detail how to build a highly available Redis service architecture. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article. Redis is an open source language written in ANSI C, supports the network, and can

  2022-06-01 15:31:41 Views: 285
• 

  Oracle Bad Block handling

  Oracle bad block problem handling 1, it shows that the bad block problem often occurs in the database system, if there is no appropriate processing method, it will often lead to bad block objects not available or data loss. This paper starts with the generation of bad blocks, focusing on the treatment of different situations after the occurrence of bad blocks. 2 、

  2022-06-01 15:31:40 Views: 233
• 

  What are the ACID features in MySQL transactions

  What is the ACID feature in MySQL transactions? 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. I. basic Conceptual transaction (Transaction) refers to access and possible

  2022-06-01 15:31:10 Views: 219
• 

  What is the memory model of Redis

  What is the memory model of Redis? 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. Redis has five object types: string, hash, list, collection, ordered collection, rich

  2022-06-01 15:31:05 Views: 233
• 

  Introduction to Analysis of Hive (4)

  10 Hive architecture 10.1Conceptual user interface: user access to Hive entry metadata: Hive user information and table MetaData interpreter: component compiler for analyzing and translating HQL: component optimizer for compiling HQL: component 10.2 for optimizing HQL

  2022-06-01 15:30:48 Views: 281
• 

  MariaDB-10.1yum installation method

  MariaDB-yum warehouse building method: related reference website: http://yum.mariadb.org/https://mariadb.com/kb/en/mariadb/yum/MariaDB 10.Xce

  2022-06-01 15:30:47 Views: 262
• 

  Wordpress database structure and table description

  Data table structure: wp_commentmeta: metadata for storing comments wp_comments: storing comments wp_links: storing friendly links (Blogroll) wp_options: storing WordPress system options and plug-ins,

  2022-06-01 15:30:47 Views: 243
• 

  Oracle 11.2.0.4 disable HAIP

  Phenomenon: after the node is down, it can not be restarted, and the heartbeat network card needs to be dialed several times before it can start automatically. It is preliminarily determined that due to the inexplicable failure of HAIP, a node cannot start CRS1 to check the network [grid@gmdb1 trace] $oifcfg iflist-

  2022-06-01 15:30:38 Views: 310
• 

  Oracle Database tutorial (RAC+DataGuard+GoldenGate) Cluster disaster recovery implementation and maintenance V3.0

  Fengge Oracle database cluster disaster recovery implementation and maintenance V3.0 (RAC+DataGuard+GoldenGate) Learning address (2019 latest): http://edu.51cto.com/topic/1943.html No.

  2022-06-01 15:30:29 Views: 296