NAV: SLTechnology News&Howtos > Database >

• 

  (to) commonly used views in Oracle

  -DBA-DBA_2PC_NEIGHBORS contains information about pending transactions entering and exiting the connection. DBA_2PC_PENDING contains information about distributed transactions waiting to be recovered. D

  2022-06-01 07:03:16 Views: 218
• 

  SequoiaDB Giant Sequoia Database

  Today, the application platforms of large enterprises are transforming to micro-service architecture. Under the micro-service architecture, the relationship between applications and databases and other underlying platforms will be reconstructed. The new generation of distributed databases must support flexible expansion, resource isolation, multi-tenancy, configurable consistency, and multi-mode (support all kinds of SQ.

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

  DB_FILES parameter

  [preface] the default parameters for Oracle database creation are generally enough for most databases, but in some cases there are write parameters that need to be changed. [problem background] the company has an Oracle database warehouse, the whole database size is 5TB, but the whole space is also fast.

  2022-06-01 07:03:15 Views: 214
• 

  EXCLUDE/INCLUDE

  Usage 1. Single-valued INCLUDE=TABLE: "= 'EMP'" INCLUDE=TABLE: "=' DEPT'" 2, multi-valued INCLUDE=TABLE: "IN ('EMP',' DEPT')" 3, fuzzy matching I.

  2022-06-01 07:03:15 Views: 262
• 

  Real-time risk Control solution based on Flink and Rule engine

  Summary page of cases and solutions: Aliyun real-time computing product case & solution summary for an Internet product, typical risk control scenarios include: registration risk control, login risk control, transaction risk control, activity risk control, etc., and the best effect of risk control is to prevent it before it happens, so there are three kinds of implementation before and after the event.

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

  Oracle incarnation

  One. Official illustration this picture involves three versions of the avatar Incarnation. Incarnation 1: the lowest black horizontal line starts with SCN1, goes through SCN1000, and ends with SCN2000, which is the first avatar of the database, called

  2022-06-01 07:03:04 Views: 258
• 

  How to quickly find big things in MYSQL binlog and generate volume distribution (infobin tool)

  Original note source: 1, the problem leads to: sometimes it is necessary to judge whether there is a big thing in binlog, such as in the case of high delay in solving master-slave. Usually we use mysqlbinlog to find it, but there is a problem. We use mysqb

  2022-06-01 07:03:01 Views: 277
• 

  Physical Storage Analysis of PG wal Log

  Original link: http://www.postgres.cn/v2/news/viewone/1/385?tdsourcetag=s_pcqq_aiomsg I am very kind. You have to leave a link. Thank the original author for sharing.

  2022-06-01 07:02:54 Views: 222
• 

  ORACLE NBU fetches oracle rman script backup archive does not delete archive automatically

  Recently, there is a problem that ORACLE 11G RAC FOR LINUX calls the rman backup script through NBU. The problem is that the backup script clearly says that the archive is deleted when there is a backup, but the archive is not deleted automatically, resulting in frequent exposure of the archive space and database tamping.

  2022-06-01 07:02:48 Views: 300
• 

  Mysql on the difference between ib_logfile transaction logs and binary log binary logs

  Summary 1. Ib_logfile similar to oracle online redo log, containing commit and uncommit data 2, binary log similar to oracle online redo log and arch

  2022-06-01 07:02:47 Views: 273
• 

  Problems with stored procedures accessing other users' tables

  Today, I wrote a stored procedure that needs to copy the data of the tables under other users to the target table through dblink. As a result, when I visit the tables of other systems, there are always problems in the stored procedure and the answer is found in Stack Overflow. In stor

  2022-06-01 07:02:47 Views: 258
• 

  Ora-01017 error occurred when windows oracle11g database logged in using sqlplus

  Today, the customer said that there was an error ora-01017 error when a single instance 11g database of windows system logged in using sqlplus. I did find such an error when I logged in. I searched a lot of articles on the Internet, but it didn't work even if I tried it. Finally, it was because

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

  Introduction and overall architecture of TiDB

  -A brief introduction to TiDB needs to be verified. TiDB is an open source distributed NewSQL database inspired by Google Spanner / F1 papers by PingCAP. TiDB has the following NewSQ

  2022-06-01 07:02:45 Views: 207
• 

  Conversion from oracle json to Damien json

  Oracle side: CREATE VIEW "FJMP". "MP_ATTEND_APPLY_ALL_VIEW" ("ATTEND_ID", "ATTEND_TYPE", "ATTEND_NAME", "PERS"

  2022-06-01 07:02:43 Views: 293
• 

  Sqlserver 2014 master and slave nodes use scripts to complete alwayson construction

  Environment: Sqlserver two nodes have completed the construction of the failover cluster: node 01: hereinafter referred to as 01, and primary node 02: hereinafter referred to as 02. The startup account for the database service for the secondary node must be established in the database user. 01: create EndPoint and

  2022-06-01 07:02:42 Views: 271
• 

  Safety specification for production environment of MySQL database

  1. MySQL server security specification 1. It is forbidden to apply directly connected DB, which is generally accessed through proxies. Access to the DB public network is prohibited. 3. Interworking between production and office is prohibited, and the production environment and office environment should be separated. 4. Linux system initialization security options: 1), some alias

  2022-06-01 07:02:42 Views: 258
• 

  ORACLE partition table carding series

  ORACLE partition table carding series (1)-partition table overview, classification, usage and matters needing attention https://www.cnblogs.com/yumiko/p/6095036.htmlORACLE partition table carding series (2)-points

  2022-06-01 07:02:42 Views: 220
• 

  Record a recovery misoperation and delete the production server data

  Original: https://www.enmotech.com/web/detail/1/790/1.html introduction: after two days of unremitting efforts, finally recovered a misoperation deleted production server data. Record the process and solution of the accident

  2022-06-01 07:02:39 Views: 226
• 

  ICollections for Mac (Desktop cleaning tool)

  Desktop icons are too messy and messy? Want an easy-to-use desktop cleaning tool? The editor recommends the iCollections Mac version for you. Through the iCollections Mac version, to help you create photo frames and view pictures, browse desktop favorite websites, find schedules, Jane

  2022-06-01 07:02:16 Views: 249
• 

  How to solve the industry performance problem of fast and sometimes slow programs-- the 29th issue of the Technology Life Series-- the story of me and the data center.

  A common classic problem, but also a difficult industry problem, Oracle-based programs are sometimes fast and sometimes slow, many experienced DBA face this problem is also helpless, there is not an optimal solution. If your database is experiencing various performance problems, you might as well contact Zhongyi Technology to give it a try.

  2022-06-01 07:02:12 Views: 260