NAV: SLTechnology News&Howtos > Database >

• 

  Silent installation of oracle under linux-personal testing can be installed

  1. Install the package yum install-y yum installyum install-y binutilsyum install-y compat-libstdc++-33yum install

  2022-06-01 06:53:26 Views: 201
• 

  Error: User gpmon is not allowed to login Command Center

  The problem is that both gpadmin and gpmon cannot log in because gpcc has been in the old version since the old version, because the gpmon user is superuser, users who configure the trust project in pg_hba.conf are not allowed to login. User tru needs to be changed

  2022-06-01 06:53:26 Views: 276
• 

  Problems to be considered in importing a large amount of data, such as 300G data and exporting 500G data

  1. Suppose it takes you 8 hours to import to 99%, but in the end, if you don't set up enough tablespace data, what if you report an error when importing? Will the import report an error this time? Will it be rolled back? The lack of space is a fatal mistake. Will roll back. But there is one parameter, resumable,resumabl.

  2022-06-01 06:53:26 Views: 275
• 

  Introduction to key features of Mycat

  Key features: support SQL92 standard support MySQL, Oracle, DB2, SQL Server, PostgreSQL and other common SQL syntax of DB comply with Mysql native protocol, cross-language, cross-platform, cross-database general middleware agent. Based on

  2022-06-01 06:53:23 Views: 254
• 

  19c (19.3) stand-alone database installation

  19C (19.3) stand-alone database installation I. Environment introduction operating system Red Hat Enterprise Linux Server release 7.7database version Oracle database

  2022-06-01 06:53:15 Views: 204
• 

  ORACLE DATAGUARD rebuilds the backup database (using the backup of the master database for recovery)

  Oracle Dataguard repository reconstruction 1. Add oracle directory mkdir / ora_data_1mkdir / ora_data_2mkdir / ora_data_32, modify directory permissions chown ora

  2022-06-01 06:53:15 Views: 207
• 

  Oracle SQL*Loader use cases (2)

  In the previous article, we introduced the use of SQL*Loader and a simple case Oracle SQL*Loader use case (1). This article will interpret the SQL*Loader directory SQL*Loader in a deeper level according to the actual use cases.

  2022-06-01 06:53:11 Views: 228
• 

  Online Redefinition online redefinition (3)-- A case study of multi-table association redefinition

  In the previous two blog posts, I listed two processes of online redefinition of a single table: Online Redefinition online redefinition (1): http://blog.itpub.net/31015730/viewspace-214454

  2022-06-01 06:53:08 Views: 249
• 

  From "the end of the Mountain" to "the Willow and the Flowers"-- the Story of me and the data Center in the 44th issue of the Technical Life Series

  Write in front if your database performance often wobbles, sometimes fast and sometimes slow, how will you start, and how will you solve it step by step? Is it to look at the waiting event first? Or watch AWR or ASH? Next, optimize SQL? Adjust the parameters? Or even replace the hardware? This time, I would like to share a case that I handled at GCS.

  2022-06-01 06:53:08 Views: 274
• 

  IDrive for mac (convenient automatic backup software) v3.5.9.14 free version

  An online file backup tool-iDrive recommended to everyone! IDrive Mac is very easy to use! The iDrive mac version of the interface is very similar to the Windows standard file explorer. The data is classified in a tree structure, and you only need to check the folders to be backed up

  2022-06-01 06:53:04 Views: 279
• 

  Binlog_format of master-slave replication

  There are three main formats of binlog_format: statement, row, and mixedbinlog_format=statement master. Write the executed SQL statements to binlog and read these SQL statements from the library.

  2022-06-01 06:53:04 Views: 237
• 

  How does MYSQL recognize a thing in a binlog

  Original level limited test version 5.7.14 sets GTID_MODE=ONON (3): Both new and replicated transactions must be GTID transactions (

  2022-06-01 06:53:03 Views: 281
• 

  SQL determines whether the field begins with or contains a number

  Whether the # field begins with a number: SELECT EMPLOYEE,DAYS FROM EMPLOYEE WHERE SUBSTR (EMPLOYEE_ID,1,1) BETWEEN'0' AND'9 words

  2022-06-01 06:53:03 Views: 276
• 

  Can Oracle 12c change the table structure field type of a 1.4 billion records within 2 hours?

  Summary: can Oracle 12c complete a table structure field type change of 1.4 billion records within 2 hours original link: https://www.modb.pro/db/22782?cyn overview previously shared online modifications of Oracle large table

  2022-06-01 06:53:02 Views: 218
• 

  MySQL actual combat | 06Compact 07 briefly talk about locks in MySQL

  Lock is a mechanism by which a computer coordinates multiple processes or pure threads to access a resource concurrently. In the database, in addition to the contention of the traditional computing resources (CPU, RAM, Icano), the data is also a kind of resource shared by many users. There are several ways to ensure the consistency and effectiveness of concurrent data access.

  2022-06-01 06:52:49 Views: 276
• 

  How mySql-5.7,root users forget their passwords

  First log in to the server: Linux1. Modify the configuration file vi / etc/my.cnf by adding a sentence skip-grant-tables 2. 0 to the section of [mysqld]. Save restart mysql service mysqld r

  2022-06-01 06:52:48 Views: 211
• 

  Understanding of MYSQL INNODB innodb_thread_concurrency related parameters

  The level of originality is limited. Please understand that although I have studied these parameters before, they have not been proved at the source level, so they have not been written, but today some friends in the group asked. So first according to the official manual plus my own understanding to explain, in the future must be carried out at the source level

  2022-06-01 06:52:43 Views: 206
• 

  PostgreSQL source code interpretation (71)-query statement # 56 (make_one_rel function # 21 muri.

  This section provides a general introduction to join_search_one_level- > make_join_rel- > populate_joinrel_with_p in dynamic programming algorithm implementation (standard_join_search)

  2022-06-01 06:52:43 Views: 238
• 

  Oracle document

  PowerDensigern Shencheng oracle sentence, 2. Build the table: 3. Table-building statement: 3. The table statement is generated.

  2022-06-01 06:52:43 Views: 260
• 

  Oracle_SQL partial _ time conversion (case 1)

  Oracle_SQL part _ time conversion (case 1) question: colleagues reported that the time-consuming recorded in the XXX system is a character type. It is not convenient to calculate each time-consuming statistics through execl. Ask me if I have a good method. Train of thought: the data contains days, hours, minutes and characters.

  2022-06-01 06:52:35 Views: 295