NAV: SLTechnology News&Howtos > Database >

• 

  New feature of Oracle12.2-Local UNDO

  1. Introduction: ①: in 12C R1 version, undo only supports Global Shared Undo mode, and all container share one UNDO tablespace. At present, this mode is retained only for upgrade transition. ②: P was introduced in 12C R2.

  2022-06-01 21:56:50 Views: 204
• 

  Oracle table field type, which is unreasonable with the business SQL, resulting in implicit conversion

  Today, we encountered a production problem. The business SQL is very simple, a single table query, and the table has only three fields, there is a primary key ID, and through the primary key ID filtering, the business page will send more than 100 ID to call SQL. The data size of this table is more than 1 million, but this SQL execution runs.

  2022-06-01 21:56:50 Views: 214
• 

  RPM installation of MySQL5.7.28 under CentOS7.4

  Linux system version: CentOS7.4MySQL version: 5.7.28 RPM package, binary package and source code package are installed in Linux platform. This article mainly takes RPM package as an example to introduce how to secure MySQL under Linux platform.

  2022-06-01 21:56:46 Views: 252
• 

  Building hbase Secondary Index by Mapreduce

  Import java.io.IOException;import java.util.HashMap;import java.util.Map;import java.util.Set;import

  2022-06-01 21:56:46 Views: 262
• 

  The import tool for sqoop uses

  The sqoop currently in use imports data from oracle into hbase. Sqoop import-connect jdbc:oracle:thin:@192.168.193.37:1521:hispac

  2022-06-01 21:56:46 Views: 202
• 

  Java sql Editor dynamic report Database backup and restore

  Get [download address] [free support update] the three major databases mysql oracle sqlsever are more professional, more powerful, and suitable for different user groups [newly recorded video tutorials for this system, hand-in-hand teaching to develop a module, quick grasp of the system] An integration code

  2022-06-01 21:56:16 Views: 248
• 

  Mongo updates one table based on data from another table

  In business scenarios, there is often a requirement to update a field in Table B according to the information in Table A. in a relational database, this requirement is very simple, and a SQL is done: update B set B.f1=A.a1 where xxxx but in mon

  2022-06-01 21:56:15 Views: 233
• 

  Hbase installation-stand-alone installation

  Website: http://hbase.apache.org/ version correspondence: you can see the appropriate hadoop version hbase-0.98.6-hadoop2 through the hadoop-core-... jar in the lib directory.

  2022-06-01 21:56:15 Views: 210
• 

  Window eclipse develops hbase programs to bind mas

  2011-04-22 16 37 22 22 42 WARN org.apache.hadoop.hbase.master.AssignmentManager: Failed assignment of

  2022-06-01 21:56:15 Views: 222
• 

  Determine whether the temporary table exists and delete it if it exists.

  -- take the temporary table # temp as an example to determine whether it exists or not. Delete it IF OBJECT_ID ('tempdb..#temp') is not nulldrop table # temp-- method-1if exis if it exists

  2022-06-01 21:56:15 Views: 300
• 

  Parallel replication based on WRITESET

  Parallel replication based on COMMIT_ORDER may form a group only under pressure, and the degree of parallelism from the library will not be high when the pressure is low. But the goal of parallel replication based on WRITESET is to do as much as possible on the basis of ORDER_COMMIT

  2022-06-01 21:55:56 Views: 261
• 

  A small problem encountered in Postgresql stream replication switching

  Pg10 builds stream replication master / slave switch configuration master library 10.10.10.13 pghost4 slave library 10.10.10.14 pghost5 test master database. After stopping, the slave database is automatically switched to the new master database. The old master library should be a backup library now. Start it for verification.

  2022-06-01 21:55:56 Views: 281
• 

  Dynamically generate SQL SERVER database partition scripts by time (date)

  -- dynamically generate SQL SERVER database partition script by time (date). After partitioning, you can manually associate with the table-- generate partition script DECLARE @ DataBaseName NVARCHAR (50)-- Database name DECLA

  2022-06-01 21:55:56 Views: 228
• 

  [cloud fusion analysis] from excess storage resources to long-term storage of distributed temporal databases

  Background introduction: as an Infra, the basic construction of the management platform and the basic quality of service are compulsory lessons, and how to measure the stability of the complex and various basic platforms, including the Ops system and business system running above, is to measure the stability of the Infra.

  2022-06-01 21:55:46 Views: 219
• 

  Questions about like query of TiDB SQL Test

  Recently, there is a very core new project on hand, and part of the business is inherited from the old system, which is based on Oracle. Although the usual concurrency is not high compared with Internet business, the complexity of SQL is very high, and it is common to associate 5 or 6 tables. Under the background of the group going to'O', the new

  2022-06-01 21:55:46 Views: 222
• 

  How to call stored procedures in oracle

  Calling stored procedures through pls blocks; declarep_dzno varchar2 (50); p_vchtype VARCHAR2 (50); p_productclass VARCHAR2 (50); p_dptc

  2022-06-01 21:55:46 Views: 212
• 

  Vernier

  Cursor operation what is the cursor cursor? Popularly speaking, cursors are not query results, but query return resources, or interfaces. Through this interface, you can read it one by one. Just like fopen in php opens a file and gets a resource, through the resource, one line at a time

  2022-06-01 21:55:31 Views: 279
• 

  TiDB rpm installation mode

  Rpm/deb or yum/apt has always been the easiest way to install software on Linux. As TiDB officials prefer the installation method of ansible/docker/k8s, for the traditional installation method, the official only gives the binary installation files.

  2022-06-01 21:55:31 Views: 215
• 

  PostgreSQL deploys ODBC driver

  System environment step 1 install ODBC driver 1) download address https://www.postgresql.org/ftp/odbc/versions/msi/2) decompress psqlodbc_11_01_0000.zip

  2022-06-01 21:55:09 Views: 299
• 

  Sybase query statement

  Query the personnel code SELECT * FROM RYXX WHERE DEPTID IN (select DEPTID from XSJLC where SKTNO='049' AND) according to the cashier account number and the pipeline code.

  2022-06-01 21:55:09 Views: 224