NAV: SLTechnology News&Howtos > Database >

• 

  Linkage between SOA and API based on CDIF

  For thousands of years, the story of the Tower of Babel has been a core dilemma faced by mankind. In order to communicate and communicate, we humans have created language, but there are still obstacles to communication. There is still a huge gap in the communication between the same language according to the context, and it is even more difficult for people to worry about the communication between different languages. In

  2022-06-01 05:26:58 Views: 214
• 

  Oracle 12c ASM DiskGroup configuration process after the addition of Linux 6.9

  Linux 6.9 Oracle 12c ASM DiskGroup configuration process after adding disk 1. After the storage allocates space (disk), linux recognizes the disk (restart os) after the 2.multi path software recognizes it, the default

  2022-06-01 05:26:50 Views: 270
• 

  ORA-600: [qertbGetPartitionNumber:qesma2], []

  Fault description database version: 11.2.0.4 alarm: fault troubleshooting according to the user query feedback alarm, as well as database version information, query mos that may be Bug:18899974 to ensure that the location is correct, further communicate with customers to confirm that the environment is ADG database PS

  2022-06-01 05:26:50 Views: 245
• 

  The slow commit of mysql big things causes the problem of full database jam.

  Original reprint please indicate the source of this article using the engine INNODB version MYSQL5.7.13sync_binlog = 1innodb_flush_log_at_trx_commit = 1, that is, double 1 setting, this article uses through the my

  2022-06-01 05:26:42 Views: 299
• 

  How to realize dynamic Row and Row transposition in SQL

  There are pivot row and column transpositions in Oracle and the new version of Mysql, but when actually dealing with data, we will encounter some more complex transpositions that pivot can't handle, such as: want to transpose to: the difficulty lies in not knowing in advance how many sources of income there are, and everyone

  2022-06-01 05:26:37 Views: 238
• 

  Introduction to MySql-basic knowledge

  1. Mysql physical file composition (1) log file 1. Error log: Error Log error log records all serious warnings and error messages during the operation of MyQL Server, as well as the details of each startup and shutdown of MySQLServer

  2022-06-01 05:26:36 Views: 309
• 

  Best practices when importing data from a large table in bulk

  Best practices when bulk importing data from a large table: 1. Set all indexes on the table to unusable: alter index unusable;2, do bulk import 3, rebuild index: alter index reb

  2022-06-01 05:26:36 Views: 240
• 

  MySQL case-insufficient disk space & MTS Group recovery failure

  -text-

  2022-06-01 05:26:32 Views: 234
• 

  Some typical Case recently

  Analysis and suggestions of China Merchants Bank in view of the recent problems in my work, I selected some typical cases and added my own analysis. 1. Ftpdbn1-deadlock problem: by opening the data captured by event monitor, it is found that it is executed by a stored procedure in large quantities.

  2022-06-01 05:26:32 Views: 213
• 

  Enq: test and case study of TX-row lock contention

  Reference: http://www.killdb.com/2015/07/13/%E5%85%B3%E4%BA%8Eenq-tx-row-lock-contention%E7%9A%84%E6%B5%8B%E

  2022-06-01 05:26:31 Views: 214
• 

  Data Security solution of online invoice system of xx Taxation Bureau

  With the rapid development of computer network technology, information technology has been integrated into all aspects of social life, profoundly changing people's production and way of life. At the same time, the problem of information security has become increasingly prominent, how to ensure data security has become the most serious challenge for enterprises. X

  2022-06-01 05:26:28 Views: 263
• 

  Sqlldr correlation

  -- DROP SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES;CREATE SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES START WI

  2022-06-01 05:26:04 Views: 266
• 

  Oracle 11G RAC Cluster installation (2)-- install grid

  Oracle grid does not introduce much, just start the installation: first, the preparation before installation: this is a graphical installation of grid, so there are two ways to call the graphical installation interface: 1. The system's own graphical desktop can be accessed through VNC. Such an environment is easy to install, just need

  2022-06-01 05:26:04 Views: 272
• 

  PostgreSQL DBA (13)-A top-down approach to reading the implementation plan

  Generally speaking, the bottom-up method is usually used to read the execution plan, which is like understanding a tree from a certain leaf, then to the branch, then to the trunk and then to the root. The problem with this method is that if the tree is very large, it may be difficult to grasp "only the leaves but not the trunk".

  2022-06-01 05:26:04 Views: 314
• 

  Add a copy of the control file file on asm after Oracle 11g rac installation

  Oracle 11g rac uses ASM storage when building the library, but rac only creates a control file on asm by default when building the library. If you want to add a few more control files, you need to add them manually. Many people may ignore this detail, but we still

  2022-06-01 05:26:01 Views: 291
• 

  SQL custom function function

  Https://blog.csdn.net/qq_23833037/article/details/53170789https://www.cnblogs.com/youring2/p/4916400

  2022-06-01 05:26:01 Views: 238
• 

  A brief introduction to the concept of SAP HANA Delivery Unit

  In the field of SAP HANA application development, we usually use package to store models such as modeler views and XS engineering. These packages should be deployed to the final production server. Delivery Unit is native to SAP HANA.

  2022-06-01 05:26:00 Views: 266
• 

  About the enq: TX-allocate ITL entry wait event

  This wait occurs when the ITL setting of the table does not meet the requirements of concurrent transactions. Data blocks are the smallest iUnix units that oracle can emit. In a data block, whenever a transaction needs to modify a data block, it needs to obtain an available ITL slot in the data block header, which records

  2022-06-01 05:26:00 Views: 254
• 

  Python operates mysql database (hundreds of databases and tables)

  Problem description: this afternoon to run a project db requirements, Baiku Baibai clean up the dirty data, and then write a python script, after the run to inform the project, and then the project to the player a reward, the result is sad, all the mysql operations did not succeed (did not report an error, so I thought the execution was successful

  2022-06-01 05:25:59 Views: 239
• 

  The mongodb replica set adds a slave node step using the consistent snapshot method

  Environment description Master Node 192.168.0.1 purl 27002 two Slave nodes 192.168.0.2 27002192.168.0.3 purge 27002 goal: add a third slave node 192.168.0.3 step summary: 1

  2022-06-01 05:25:59 Views: 244