NAV: SLTechnology News&Howtos > Database >

• 

  Create an update trigger

  Purpose: update the fields in a table, automatically trigger the trigger, the trigger will change the value of the added field, and then determine which tables have been update according to the value of the added field before and after the change, and then add a filter at the business level to filter those updated Table 1. Add fields to the table and add

  2022-06-01 10:00:19 Views: 272
• 

  Free buffer waits of Oracle waiting for event

  Free buffer waits official website explains: This wait event indicates that a server process was unable to find a free buff

  2022-06-01 10:00:19 Views: 290
• 

  An example of database operation script for SQL

  -- execute statement: in the returned result set, restore headeronly from tapedump1 distinguishes each backup (backup number) BackupStartDat by: the location of Position backup set in the volume.

  2022-06-01 10:00:18 Views: 273
• 

  DPM restore Exchange 2013 database

  In this article, we introduce how to restore an Exchange 2013 database after an Exchange 2013 database failure. It is roughly divided into three steps: first, to simulate the database disaster, second, to restore the Exchange 2013 mailbox database, and third, to test and recover successfully.

  2022-06-01 09:59:48 Views: 254
• 

  One / next method on the platform recording component

  Read the previous item and the next item in the data table and record them in the recording unit. Example application: add new functions in the form function management: add data, previous item, and next run effect: we first add a piece of data, and then click the "New data" button to add a second piece of data.

  2022-06-01 09:59:46 Views: 299
• 

  SGA of .ASM instance to view all ASM file sizes

  There is no difference between SGA and RDMBS of ASM, including Buffer Cache, shared pool, Large poor and so on. You need to pay attention to the shared pool share pool, because extent map will be placed in this section

  2022-06-01 09:59:37 Views: 206
• 

  MySQL mysqldump backup database command line

  Mysqldump is the utility that mysql uses to transfer the database. It mainly produces a SQL script that contains commands such as CREATE TABLE INSERT that are necessary to recreate the database from scratch. Mysqldump

  2022-06-01 09:59:37 Views: 210
• 

  Tnsnames.ora configuration

  Method 1: jingtai = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.6.111) (PORT = 1)

  2022-06-01 09:59:37 Views: 253
• 

  MySQL-MMM to achieve High availability of MySQL

  MMM (Master-Master replication manager for MySQL,MySQL Primary Primary replication Manager) is a set of scripts that support dual-master failover and dual-master day-to-day management. MMM uses Perl

  2022-06-01 09:59:37 Views: 261
• 

  The difference between MyISAM and InnoDB in MySQL Database

  First of all, it is important to understand that the storage engine in MySQL database loyalty is based on tables, not databases. Describe the difference between the two: InnoDB storage engine, mainly for OLTP (Online Transaction Processing, online things)

  2022-06-01 09:59:06 Views: 280
• 

  Open source | performance optimization weapon: selection and practice of database audit platform Themis

  Author: Han Feng Origin: DBAplus Community sharing Themis Open Source address: https://github.com/CreditEaseDBA extension Reading: trustworthy Open Source | Rule resolution and deployment strategy of database audit software Themis [Technology Salon

  2022-06-01 09:59:06 Views: 301
• 

  Monitoring MySQL using Zabbix built-in MySQL template

  Use Zabbix built-in MySQL template to monitor MySQL1. Install zabbix agent [root@szlinux02 ~] # rpm-ivh http://repo.zabbix.com/zabbix/

  2022-06-01 09:59:02 Views: 252
• 

  SQL Server 2005 installer, IIS function requires warning solution

  The IIS feature requires an exclamation point warning when installing MS Sqlserver 2005 to the system configuration check. Detailed description is as follows: Microsoft Internet Information Services (IIS) is not installed or disabled. Some SQL Serv

  2022-06-01 09:58:36 Views: 286
• 

  Phpmyadmin+mysql-5.6.16.tar.gz usage

  The use of Phpmyadmin first requires lamp or lnmp environment: one. First set up the phpmyadmin running environment and now take the lamp environment as an example: install and deploy lamp environment 1. Install Apache download install yum install z

  2022-06-01 09:58:36 Views: 291
• 

  Oracle deletes duplicate records

  1.1 look up redundant duplicate records in the table-query all duplicated data select DETAIL_ID,COMMENT_BODY,count (1) from BBSCOMMENTgroup by DETAIL_ID

  2022-06-01 09:58:35 Views: 214
• 

  Skills of using PSQL tools

  Psql is powerful, skills can only be added later, look at a tool first see how to use help, here are some common things, such as how to view the directory, how to use variables, very useful $psql # connect to the database server, you can enter the corresponding SQ

  2022-06-01 09:58:35 Views: 203
• 

  View invalid objects, constraints, triggers, and indexes in Oracle

  1. Check for invalid database objects: SELECT owner, object_name, object_type,statusFROM dba_objectsWHERE status = 'INVALID';2

  2022-06-01 09:58:35 Views: 214
• 

  Arithmetic operators in MySQL Database

  Arithmetic operators in MySQL database I. Overview of operators: operators are also very important knowledge bodies in MySQL databases, and they are very helpful to manipulate data when executing sql statements. The use of operators can help you save a lot of time, and it is easier to operate than

  2022-06-01 09:58:20 Views: 287
• 

  Upgrade oracle 10g rac environment to 10.2.0.5

  Upgrade the oracle rac environment, oracle used to be version 10.2.0.1, now version 10.2.0.5. You must first install the oracle cluster cluster software, and then download the oracle 10.2.0.5 software package

  2022-06-01 09:57:50 Views: 213
• 

  Innodb_data_file_path Settin

  Innodb_data_file_path is used to specify the innodb tablespace file, if we do not specify innodb_data_home_dir and innodb_data_file_ in the My.cnf file

  2022-06-01 09:57:49 Views: 301