NAV: SLTechnology News&Howtos > Database >

• 

  Use OpenFiler to simulate the test of ASM shared disk and multipath (multipath) in storage configuration RAC

  The first chapter, an overview of this article, released a "Oracle_lhr_RAC 12cR1 installation", but the storage in it does not use multipathing, but uses the storage provided by VMware itself. So, the last thing before the year is to learn multi-path, this article introduces

  2022-06-01 06:55:37 Views: 210
• 

  Oracle database upgrade (documentation) to 10.2.0.4 from 10.2.0.1

  Oracle database upgrade (documentation) documentation directory: 1, backup ORACLE_BASE (as a DBA, no matter what work do not forget to backup) 2, upgrade Opatch (① / opt/Disk1/runInstalle)

  2022-06-01 06:55:37 Views: 253
• 

  ORACLE11GR2 RAC uninstall ASM instance steps

  1. Stop all node ASM instances $srvctl stop asm-n testdb1-f $srvctl stop asm-n testdb2-f $srvctl stop asm-n test

  2022-06-01 06:55:31 Views: 253
• 

  Data pump exports the solution to the problems of ORA-31623 and ORA-06512 in the Times

  Problem description colleague response database when using data pump to export, export to UDE-31623, ORA-31623, ORA-06512, roughly as follows: alarm log information is roughly as follows: processing (1) the first step, I thought it was streams pool s

  2022-06-01 06:55:31 Views: 254
• 

  Problems with abdti host dgyt library cause slow work order system

  The application of feedback ticket system is slow, log on to the host to query the number of LOCAL=NO and v$session, and find that the number of connections is indeed more than 50% higher than usual. Later, I consulted the business and found that this was a normal business phenomenon at the end of the month. 1. View the SunOS operating system: 1) memory: click (

  2022-06-01 06:55:31 Views: 284
• 

  Introduction of transaction control statements in MySQL 5.7s

  START TRANSACTION or BEGIN statement starts a transaction COMMIT statement commits a transaction, making changes to the data permanent ROLLBACK statement rolls back the transaction and cancels the SET autocommit statement for changes to the data

  2022-06-01 06:55:31 Views: 202
• 

  PostgreSQL DBA (136)-Develop (Common Mistakes)

  This section provides a brief introduction to the details that are error-prone but easily overlooked in PostgreSQL. Division operation when division is performed between an integer and an integer, the result is an integer, but in fact we want to keep the decimal places. [local:/data/pg12]: 5432 p

  2022-06-01 06:55:30 Views: 249
• 

  Mysql basic command learning notes

  I will not cover some knowledge such as mysql database installation, but I will summarize some of the most commonly used mysql statements I have learned and used in mysql into this article as my own learning notes and notes. The basic environment is CentOS 6.5.The database is mysq

  2022-06-01 06:55:30 Views: 246
• 

  In those years, we saw the Java server "problems"

  Mr. Wang Yangming, a famous master of the study of mind in the Ming Dynasty, has a saying in the Biography: Tao is not refined and rough, but what people see is fine and rough. Such as this room, when people first came in, they only saw a large scale like this. For a long time, the pillar wall and so on, one by one can see clearly. No matter how long it takes, if there are some words on the column, you can see it in detail. But it's just one.

  2022-06-01 06:55:30 Views: 292
• 

  GoldenGate configuration

  Preparation: two virtual machines that already have databases are now closed-the operation of the source-side database [root@localhost ~] # su-oracle [oracle@localhost ~] $sqlplus "/ as sy

  2022-06-01 06:55:29 Views: 290
• 

  Batch management of server management software vps

  Remote Desktop is a service launched by Microsoft to facilitate network administrators to manage and maintain the server. Introduced with the windows 2000 server version, the remote Desktop Connector is connected to any computer on the network where remote Desktop Control is enabled.

  2022-06-01 06:55:15 Views: 236
• 

  Deadlock Analysis of MySQL physical backup

  Background this paper analyzes the case that encountered deadlock when making a physical backup in the slave database under the 5.6 master / slave scenario. I hope it will be helpful to you. The physical backup tool used here is Percona-XtraBackup (PXB), and some students may not know its backup process.

  2022-06-01 06:55:14 Views: 202
• 

  [Enmo College] data Architecture: a case study of Oracle Sharding Architecture of China Telecom

  [Enmo College] data Architecture: application case study of Oracle Sharding Architecture of China Telecom Gai Guoqiang Oracle has launched the distributed architecture of Sharding since version 12.2, which divides the original centralized architecture by extending the characteristics of partition tables.

  2022-06-01 06:55:11 Views: 265
• 

  Performance comparison between TIDB and MySQL

  Recently, compared with TiDB and MySQL, TiDB is much faster than MySQL in large table and complex join, which should be due to the distributed architecture of TiDB, which pushes logical computing down to various data nodes to execute in parallel. Because TiDB has a very good level score.

  2022-06-01 06:55:06 Views: 214
• 

  Oracle uses backup filesets to restore archive logs

  In a DG environment, manual synchronization is temporarily used because of insufficient network bandwidth, that is, archived log files are copied from the main database to the standby database every day for application, but today it is found that several archived log files are missing, and the archived log files in the main database have been automatically deleted

  2022-06-01 06:55:03 Views: 258
• 

  Why is the enterprise CIO generally not bullish on Oracle, but in love with Microsoft?

  Recently, JPMorgan Chase conducted a survey of 154large corporate CIO, and the results show that many corporate CIO do not like Oracle very much. And this is not the most powerful news. JPMorgan Chase changed its rating on Oracle shares from overweight to neutral, and said it was in the process of moving to the cloud.

  2022-06-01 06:55:03 Views: 242
• 

  Multi-table Association query optimized by SQL-case 1

  You can see an associated query of three tables in the slow SQL log, as follows: SELECT COUNT (1) FROM refund_order_item I, artisan a, user u WHERE u.userid =

  2022-06-01 06:55:00 Views: 244
• 

  Free DNG format picture converter ​ Adobe DNG Converter for Mac v12.3.0.493 Chinese version

  Adobe DNG Converter is a free DNG format image converter that helps photographers solve the lack of open standards for raw files created by a single camera model and ensures that photographers can easily access their files. Adobe DNG Conve

  2022-06-01 06:55:00 Views: 262
• 

  Redis: Can't save in background: fork: Cannot allocate memory

  Redis: Can't save in background: fork: Cannot allocate memoryJAVA program error message: MISCONF Redis is configured

  2022-06-01 06:55:00 Views: 252
• 

  Using fnd_flex_keyval package to easily obtain key elastic domain combination description fields

  Transferred from: https://blog.csdn.net/rfb0204421/article/details/8204103 in Oracle Forms custom development, if you encounter a key elastic domain provided on Form (

  2022-06-01 06:54:59 Views: 255