Database Administrator

Oracle 11g statistics collection-collecting multi-column statistics When writing an SQL statement, we may encounter multiple conditions following the where clause, that is, we can filter the data based on the conditions of multiple columns. By

How to handle EM key garbled characters in Oracle 11g Today, I used a Mac to connect to the VMware Fusion virtual machine database. I suddenly wanted to use EM and suddenly found that the buttons were garbled. For example: Analysis: To solve the

Access the Oracle server through SQL J of DB2 Today I saw a book about Oracle SQLJ, so I want to give it a try. However, I only installed the Oracle thin client on Ubuntu 14.04. There is no SQLJ, so the sqlj thought of using the IBM-db2, it was

PostgreSQL log classification and management PostgreSQL has three types of logs: pg_log (database operation log), pg_xlog (WAL log, that is, redo log), and pg_clog (transaction commit log, which records the transaction metadata) Pg_log is disabled

Inconsistency of master-slave replication data in MySQL In the master-slave replication architecture, the default replication method of mysql5.6 is SBR (SQL statement-based replication ), if the context of the Master/Slave database is inconsistent

Manual cleaning of Oracle audit records Oracle Database Audit is very powerful, usually including standard audit (including user-level audit and system-level audit) and fine-grained audit. Even so, it is easy to cause performance problems if you are

Accelerate mydumper and myloader Export and Import Mydumper and myloader are excellent third-party mysql database logical backup and recovery tools that use multi-thread export and import. Makes up for the insufficiency of mysqldump single thread.

Mysql create database specifies UTF-8 encoding, databaseutf-8The following script creates the DATABASE yourdbname and specifies the DEFAULT Character Set utf8CREATE database if not exists yourdbname default charset utf8 COLLATE utf8_general_ci. To

Change the method from Flash Recovery Area (FRA) to a new path, recoveryfra Change the Flash Recovery Area (FRA) to a new path. Source:How to change Flash Recovery Area to a new location? (Documentation ID 305651.1) Objectives:This article describes

The Oracle Database knows a table and queries a table with a primary foreign key relationship. The oracle Database -- Check whether the foreign key table NC56.CSCI has a corresponding primary key table SELECT. owner,. TABLE_NAME primary_table_name,.

Oracle (4) --> advanced subquery (it is difficult to explain multiple examples, but I really don't believe it ~), Oracle Introduction This section will discuss the more complex application of instant queries, mainly to simplify SQL and improve

Mongodb installation and simple useMongodb installation and simple use First install mongodb 1.: http://www.mongodb.org/downloads 2. decompress the package to the directory you want to install, such as d: \ mongodb. 3. Configure the environment

MySQL uses the bat command to back up the mysql database in windows, batmysql Preface: My friend said that the backup failed with the bat command under windows. He could not find the problem at the moment, so he asked me for help. In fact, I have

Use date type in PL/SQL, plsql date type Use the date type in PL/SQL Previous articles introduced the use of strings and numbers in PL/SQL. There is no doubt that strings and numbers are important, but it can be determined that no application

Set remote login and new users for mysql Simple mysql management commands: Start mysql sudo start mysqlStop mysql sudo stop mysql Remote access settings: Sudo vi/etc/mysql/my. cnf comment out bind-address = 127.0.0.1 Add new users: GRANT ALL

[] SqlServer uninstall and reinstall all strategy !, 2015 sqlserver Please tell me which software is the most disgusting. After installation, I pasted a layer of mud in my computer, and it was not clean. The trial version of sqlserver2014 was

Use C language to operate MySQL Databases-General edition and general edition of mysql DatabasesUse C to operate MySQL Databases First look at the struct:The following code block is the communication process used to connect to the database. To

Oracle trigger and Oracle trigger In the past, we made projects. All are front-end backend codes. Because the database is written by the Project Manager. I did not have much Optimization on the database. After a long time, I forgot about the

Mongodb installation (window) and java connection test, mongodbwindowFirst download and install Download mongodb official website and select window version Step 2: Install Pay attention to the installation directory. My installation directory is D:

Install and use phpMyAdmin. Set up phpMyAdmin on CentOS and centosphpmyadmin in CentOS Required components: apachephpmysqlphpmyadminapache0.yum install httpd1. confirm the version $ httpd-v2. start apache $ sudo service httpd start