NAV: SLTechnology News&Howtos > Database >

• 

  Generate Script to kill multiple Oracle sessions

  $cd / data/oracle/SHRARS/backup/export/ITSK0004746383 $sqlplus-s / as sysdba < killsession.sqlset h

  2022-06-01 07:35:00 Views: 275
• 

  Cloning of oracle

  When installing multiple servers in oracle on linux, you can install multiple clones at a time, which is simple and fast. *

  2022-06-01 07:35:00 Views: 262
• 

  The latest application choreography practice based on kubernetes in August

  The prospect of 123456791011121314151617181920 includes the following parts: startup item management, which is a strong demand for applications with sequential dependencies on startup. Currently, docker compose supports de.

  2022-06-01 07:34:42 Views: 238
• 

  The response to the mandatory upgrade of AWS RDS-- the Best practice of version upgrade

  AWS RDS is forced to upgrade is a helpless thing, the version does not support, and be forced to upgrade will affect business availability. Instead of passively forcing to upgrade, it is better to develop an active upgrade strategy. This article introduces the best practices of AWS RDS version upgrade, which is a painstaking work for the author.

  2022-06-01 07:34:34 Views: 205
• 

  [Mysql] Construction of multi-source replication of Mysql5.7

  one。 Basic environment master library 1: 10.24.65.30 3306 MySQL 5.7.14 Master library 2: 10.24.65.30 3307 mysql 5.7.14 slave library: 10.24.65.33 3306 mysql

  2022-06-01 07:34:33 Views: 242
• 

  Xtrbackup of MySQL incremental backup

  Software version Click (here) fold or Open platform: Centos 7 Database version: MySQL 5.7xtrabackup version: xtrabackup version 2.4.8 II, installation method: binary decompression installation click (here

  2022-06-01 07:34:33 Views: 295
• 

  Using SQL_TRACE for database diagnostics

  The http://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm package dbms_system is defined as follows: SQL > desc dbms_syst

  2022-06-01 07:34:33 Views: 270
• 

  The lack of indexing of the associated fields in the Mysql table leads to slow query, and the query efficiency is significantly improved after optimization.

  I received feedback from users today that the front-end page opened very slowly. The database server load is also alarmed. Login server query Mysql takes up too much CPU. Open show full process directly and find that many of the following sql are above 10s # User.

  2022-06-01 07:34:33 Views: 232
• 

  How does Mysql handle duplicate data? Make your efficiency more efficient.

  Sometimes, the same record exists in the data table. When getting a record in a table, it is obviously more meaningful to obtain a unique record than to obtain a duplicate record. So about how to deal with duplicate data in mysql database, let's explain this problem. [dl] 15-2273 [

  2022-06-01 07:34:28 Views: 285
• 

  Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)

  The article from: http://m.blog.itpub.net/31393455/viewspace-2130875/Script to Collect Log File Sync

  2022-06-01 07:34:27 Views: 294
• 

  How to use the report tool FineReport to realize the dynamic display of report columns

  I believe that the implementation of dynamic columns has perplexed many people, a large amount of data, multi-field loading will be very time-consuming, and the data can not be truly dynamic and flexible. The existing ways are realized by hiding the change of direction and so on. So how to solve it? Here we share the implementation of the sail soft report designer FineReport

  2022-06-01 07:34:26 Views: 266
• 

  Slave's relay log relay-log is corrupted

  When slave goes down unexpectedly, it is possible to damage the relay log relay-log, and when synchronous replication is turned on again, an error occurs. Solution: find the synchronized binlog log and POS point, and then synchronize again so that you can have a new relay log. Let's look at the case.

  2022-06-01 07:34:25 Views: 285
• 

  How much do you know about mysqldump and innobackupex backup process (3)

  Is there any hole in Luo Xiaobo mysqldump of Walker Technology? As you all know, mysqldump backups can be performed using the two options-- single-transaction +-- master-data (to be honest, for convenience

  2022-06-01 07:34:25 Views: 293
• 

  Database structure comparison and structure migration tool

  Supported databases include MySql, MSSql, and Postgresql databases. Supported functions: 1, database structure comparison, structural differences to generate update scripts, and can directly run to change the target database structure. Supports tables, views, stored procedures, functions, and so on. 2. Database

  2022-06-01 07:34:25 Views: 238
• 

  MYSQL memory error Use & # 39 * * mysqld-- thread_stack=#' to specify a bigger stack.

  MYSQL memory error Use 'mysqld-- thread_stack=#' to specify a bigger stack. Today, in the process of using mysql, it is always impossible to connect to the database and finally find that it is the data.

  2022-06-01 07:34:25 Views: 287
• 

  MySQL 5.5Executes SQL in script

  SQL format recovery [root@localhost backup] # / software/bin/mysql-usystem-paired MySQL 2015-S / data/mysql.sock fire

  2022-06-01 07:34:24 Views: 268
• 

  Oracle em can not log in, account password expired

  The screenshot that you cannot log in to oracle em is as follows: changing the user's password is invalid: check the backend log:2015-06-27 10 Thread-1080228448 WARN collector 11 Thread-1080228448 WARN collector: Err

  2022-06-01 07:34:16 Views: 247
• 

  [RMAN] Oracle11g uses rman migration to upgrade database (win_to_linux)

  In the process of migrating Oracle database, we will encounter many situations, such as the database under 32-bit operating system is migrated to 64-bit, and the migration between different operating system platforms, so how to choose the migration tool? first of all, we need to confirm the environment of the source side and target side of the migration, and again.

  2022-06-01 07:34:12 Views: 277
• 

  Draw.io for Mac (flowchart drawing tool) v13.5.7 Chinese version

  Draw.io Mac is a flow chart drawing tool on Mac platform. Draw.io Mac version is a very easy-to-use tool for drawing flowcharts, providing rich interfaces such as flowcharts, UML diagrams and so on. It also supports third-party cloud storage, which can easily divide these blueprints.

  2022-06-01 07:34:09 Views: 229
• 

  Linux server-apache configuration file

  The default path of the Apache configuration file Apache is "/ etc/httpd/conf/httpd.conf". By editing this file, you can modify the configuration 1 of Apache, set the home directory of the web page, and the parameter DocumentR.

  2022-06-01 07:34:08 Views: 250