NAV: SLTechnology News&Howtos > Database >

• 

  Oracle11g_dataguard building

  First make sure that the primary library is in archive mode SQL > archive log list; forced archive SQL > alter database force logging;ALTER DATABASE ADD LOG

  2022-06-01 07:48:10 Views: 293
• 

  MySQL 5.7Role function

  MySQL 5.7Role function: create and grant user role function: mysql > create user 'junior'@'127.0.0.1' identified by' 123 roles query OK, 0

  2022-06-01 07:48:10 Views: 249
• 

  Prerequisites for mysql source code source installation requirement

  Contact information Wechat official account (welcome students to follow, get more database skills) Wechat preface mysql source code installation official manual mysql source code installation prerequisites mysql source code installation official manual training courseware mysql source code installation official manual 2 Installin

  2022-06-01 07:47:59 Views: 212
• 

  Win7 mongodb C++ driver

  SCRAM-SHA-1 mechanism support not compiled into client library. (Some mechanisms require the driver

  2022-06-01 07:47:59 Views: 204
• 

  Pt-online-schema-change 's notebook

  Demand: according to the request of big data department, we need to add the create_time field to the specified table and give the current time a default value. Environment: DB: Aliyun RDS MySQL5.6OS: centos7 has several large tables, over 100 million, the largest 700 million, consider using

  2022-06-01 07:47:58 Views: 266
• 

  MySQL Visualization tool recommendation

  In order to facilitate the use of MySQL, this article lists several visualization tools of MySQL, you can take what you need! 1. MyDB Studio this tool contains a complete set of tools for MySQL service management, which is more powerful, but it is charged for a fee, and the table is loaded when selecting table data.

  2022-06-01 07:47:54 Views: 243
• 

  9 techniques for minimalism and more efficient Mac experience

  Mac's interface is already clean and beautiful, but by making some visual and functional adjustments here and here, you can further refine it and speed up the process. The tweaks we focus on today will provide you with a minimalist Mac experience. We are talking about using the "less is more" approach to define exercises.

  2022-06-01 07:47:46 Views: 220
• 

  Oracle.Performance.Tuning notes

  Oracle.Performance.Tuning Notes Chapter 2 The Method Behind the Madness when there is a performance problem, investigate the vandalism, systematics, eventuality, and session events

  2022-06-01 07:47:46 Views: 248
• 

  PostgreSQL Source Code interpretation (215)-query # 122 (varstrfastcmp_locale)

  This section describes the implementation logic of PostgreSQL when specifying the execution of collation collate. When collate is specified as zh_CN, the collation is inconsistent with the default C [local]: 5432 pg12@testdb=# SELE

  2022-06-01 07:47:45 Views: 297
• 

  Redis data manipulation-string

  | | Save text, store numbers (integer, floating point), binary number | string operation-set the string set key value # if the string key key already exists, overwrite the old value with the new value-get the word |

  2022-06-01 07:47:45 Views: 213
• 

  Mongodb rights management

  You have to work overtime tonight, just sort out the permission context configuration of mongodb. After installing and configuring a set of mongodb, you need to create a corresponding database and user password for the developer, so how to set the permission? 1. The first step is to create the database use chunqiu2. Chuang

  2022-06-01 07:47:45 Views: 289
• 

  DB2 HADR takeover question SQL1387W

  I encountered a problem when I was doing DB2 HADR takeover today. SQL1387W A DB2 High Availability Disaster Recovery (HADR) takeover compl

  2022-06-01 07:47:45 Views: 216
• 

  Design and implementation of TPS Limit in dubbo-go

  Preface Apache Dubbo is an open source RPC framework by Ali, which not only provides basic RPC functions, but also provides a set of service governance related functions. At present, it is a top-level project under the Apache Foundation. And dubbo-go is.

  2022-06-01 07:47:44 Views: 288
• 

  The difference of sec_case_sensitive_logon parameters between 11g and 12c

  Due to the needs of the project, we encountered the need to modify the sec_case_sensitive_logon parameter of oracle today, so I would like to summarize it here. (1) in 11g, sec_case_sensitive_logon defaults to t

  2022-06-01 07:47:44 Views: 233
• 

  Modify redo_logfile group membership and size

  1.SYS@ORCL > select GROUP#, BYTES/1024/1024 size_M,STATUS,ARCHIVED from vault SIZE_M STATUS ARC

  2022-06-01 07:47:44 Views: 250
• 

  . / ggsci: error while loading shared libraries: libnnz11.so

  View by command: [oracle@eam_db ogg] $ldd ggscilinux-vdso.so.1 = > (0x00007ffc4a17d000) librt.so.1 = > / lib64/lib

  2022-06-01 07:47:44 Views: 294
• 

  How to analyze and deal with Flink backpressure?

  Reverse pressure (backpressure) is a very common problem in the development of real-time computing applications, especially in streaming computing. Reverse pressure means that a node in the data pipeline becomes a bottleneck, and the processing rate can not keep up with the upstream data transmission rate, so it is necessary to limit the upstream speed. Due to the application of real-time computing

  2022-06-01 07:47:44 Views: 280
• 

  Migrate oracle user password

  How to migrate the password of oracle user to the new environment is listed below: select name,spare4 | |';'| | password pwd from sys.user$ where name ='u

  2022-06-01 07:47:43 Views: 265
• 

  Do you know all these simple little tricks?

  With the development of science and technology, mobile phones are becoming more and more important in life. Wechat has gradually become an important medium of communication in our lives. Now a lot of middle-aged and elderly people also start to use Wechat, but there are many functions on Wechat, they will not use, if we are not around them, and they want to use Wechat, then

  2022-06-01 07:47:36 Views: 269
• 

  Oracle Index Monitoring-unused indexes

  Oracle Index Monitoring-unused indexes oracle indexes are used to optimize DML processing speed, but indexes take up table space, sometimes more table space than indexed tables. Therefore, it is important for indexes to monitor unused indexes. Open an index monitor

  2022-06-01 07:47:35 Views: 291