Database Administrator

Recovery Process of rm-rf misoperations Many DBAs must hate rm-rf. Maybe the database will be wiped out one day when they make a mistake, and then there will be no more ...... In case ...... Is it true that there is no medicine to save this

WAS cluster series (8): cluster creation: Step 6: create a profile, cluster Overview(1) host resolution address Modification WAS Node 1, WAS Node 2, modify the hosts file under the Database Server Map the IP addresses of all hosts to various hosts

SQL advanced (10) function, sql10 FunctionSQL advanced (10) function the SQL GROUP BY statement is used in combination with the aggregate function to GROUP the result set based on one or more columns.SQL GROUP BY syntax SELECT column_name, aggregate_

UDE-00008 ORA-31626 ORA-06512 ORA-25254, ude-00008ora-31626 When exporting a mode today, it is about 140 GB and the following error occurs: UDE-00008: operation generated ORACLE error 31626ORA-31626: job does not existORA-06512: at "SYS. KUPC $

Oracle cluster heartbeat and Its Parameter misscount/disktimeout/reboottime, oracle Cluster In Oracle RAC, you can check the health status of RAC from multiple levels and different mechanisms, that is, you can isolate faults through the heartbeat

Oracle Stored Procedure + cursor processing select data, oracle Stored Procedure Create or replacePROCEDURE UPDATE_RECORDCODE is cursor location_data is select * from location where remark in ('20160301', '20160301', '20160301'); -- declare the

Backup mysql for xtrabackup with xbstream and lz4, xtrabackupxbstream You need to temporarily add an instance for mysql. Using xtrabackup is the easiest and quickest. On an existing data node: /Home/work/app/xtrabackup-2.2.3/innobackupex --

Oracle merge into... USING two table join operations (high efficiency), mergeinto... using When the data volume is small, you can use subqueries to associate two tables. However, when the data volume is large, the subquery efficiency is too low

Mybatis batch inserts a large number of oracle data records to solve the performance problem. mybatisoracle Environment: mybatis + oracle11g r2 1. Use "direct path insertion" ("/* + append_values */" in the following SQL statement), and use the

Oracle connection tests and Oracle connection tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table( Id

Oracle Development Series (1): Crazy errors: null value and no value (no result), too lenull Recently, I encountered some problems when I was doing development and writing operations. I found the cause for a long time and did not know it before. In

052 -- drop profile app_user, ocp052 -- 133. You created a profile APP_USER and assigned it to the users. After a month, you decide to dropProfile. Some user sessions are currently connected to the database instance and are usingAPP_USER

Jmeter JDBC Request -- sqlserver JDBC driver configuration, sqlserverjdbc driver 1. Make a JDBC requestFirst, you need to know what the JDBC object is. Now SQL Server is used as an example to describe it. First, download the corresponding database

Oracle: dump File Import error: only DBA can import files exported by other DBAs, dumpdba Export the dump file of a table from schepaa (DBA permission) and import it to scheab (non-DBA permission). An error is returned. Use the OB tool to set

The solution for delayed loading of common hibernate fields is invalid. We don't need to talk about the delayed loading of associated objects. Delayed loading of common fields, especially lob fields, has a great impact on performance if there is no

First known SQLITE3 database, first known sqlite3 DataBase, we have never touched the DataBase. What is the DataBase? It is a structured, integrated, and shareable unified data collection! Structured means that data is organized according to a

Mysql id starts from 1 and mysqlid1Truncate table rectContent (data table)How can I reset the ID auto-increment from 1 when clearing the MySQL table ?? The truncate statement clears the table content, including the information of the

Oracle Performance Analysis 1: Enabling SQL tracking and obtaining trace files, oracletrace When there is an issue with Oracle query efficiency, we often need to understand the problem so that we can provide a solution to the problem. Oracle

Sqlite learning notes 8: Using sqlite to create a table in C language, sqlite learning notes We have already discussed how to open and close the database, and how to execute SQL statements to create a table. Functions to be

Web permission database design, web permission Database CREATE TABLE account ( accid INT DEFAULT '0' NOT NULL, accCode CHAR(20), accName VARCHAR(30), PRIMARY KEY (accid) ) ENGINE=InnoDB DEFAULT