Database Administrator

How to delete a database in Oracle 11 without using DBCA This short tutorial will show you how to delete a database in Oracle 11 without using the DBCA Database Configuration assistant. 1-SID of the imported database, if not defined export

In Linux, MySQL is configured with master-slave nodes. Linux: CentOS 6.5Master1: 192.168.100.204Master2: 192.168.100.205Mysql version: mysql-5.6.19Note: The configuration methods for versions earlier than mysql 5.5 and later are different. Install

SQL Server C # connection and object existence judgment This article provides a comprehensive overview of C # database connection. For C # connection to ms SQL Server, sqlconnection is primarily used. The authentication mode is windows integrated

Database Table migration and replication SQL operations In projects, if we want to back up the table data, copy the original table to another table. Of course, the fields must be consistent. The following are the test SQL statements. Insert

Timesten upgrade, timesten TtIsql "DSN = ttwind; UID = cacheuser; PWD = cacheuser; OraclePWD = cacheuser ;" -- 1. view the current version Command> versionTimesTen Release 11.2.2.7.0 Command> cachegroups; Cache Group CACHEUSER. CACHETBLORDERS: Cache

Mysql Master never synchronizes processing-database initialization, mysql -- Learn from online content for troubleshooting Re-master, full synchronization After creating a new table in the master database, the data in the slave segment is not

Oracle archiving operations, oracle archiving logsOracle uses redo log files to record database operations, But redo log file groups are used cyclically. When all log files are filled up, the system automatically switches to the first log file, of

Basic MySql operation statementsDATABASE:CreateCREATTE {DATABASE | SCHEMA} [if not exists] db_name [DEFAULT] character set [=] charset_name;Delete:DROP {DATABASE | SCHEMA} [if exists] db_name;Display:SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' |

Oracle select into prevents failure to report an error, oracleselect As follows: Begin select name into v_name FROM t_student WHERE id = '000000' exception when NO_DATA_FOUND THEN v_name: = ''; END; In this way, you do not need to select count (1)

MySQL multi-version concurrency control analysis, mysql version concurrency When the read is not committed, the read transaction reads the master record directly, regardless of whether the update transaction is complete. READ_COMMITTEDWhen a read

My MYSQL Study Notes (4) -- functions and mysql Study Notes Functions Numeric Functions 1. Evaluate the remainder function MOD (X, Y) MOD (X, Y) returns the remainder of x after division by y. MOD () also applies to values with decimals. It returns

Understanding the storage structure 2, understanding the Storage Structure Next http://blog.csdn.net/ashic/article/details/44117867In the previous article, we dumped L1 L2 L3 blocks. Now let's take a look at the information they contain.

Oracle implicit conversion, Oracle implicit conversionIt is said that Oracle has implicit conversions of the NUMBER and VARCHAR2 types, which must be avoided in a strict sense, but why should we avoid them? We will verify it from the following

The Oracle Instant Client facilitates the use of the PLSQL Developer method, plsqldeveloperBackground: Oracle-32bit clients are not installed in 64-bit operating systems for ease of use of PLSQL Developer (64bit Oracle clients not supported) 1.

SQL statement fuzzy query review and tips: SQL statement fuzzy query General Fuzzy statements are as follows: SELECT field FROM table WHERE a field Like Condition SQL provides four matching modes for conditions:1.%: Represents any 0

Db file async I/O submit waiting for event optimization, asyncsubmit Db file async I/O submit wait for event Optimization   I. Data Generation db file async I/O submit We often see Wait events for high db file async I/O submit from the database awr

Optimization is not just an index, but an index optimization. After graduation, I got into contact with optimization problems. I have been doing professional Optimization for at least five years. But now I still often hear many people think that

Use Goldengate Initial Data Load, goldengateinitial When building ogg, we usually need to initialize the target Library first, so there are many initialization methods. Now we will introduce ogg's own initialization method. Test environment: Souce

Detailed description of db file sequential read wait event, dbsequential Db file sequential read (this article is translated by thomaswoo_dba. For more information, see the source) The db file sequential read event has three parameters: file #,

Hardware performance tuning of open-source PostgreSQL (1) POSTGRESQL is an object relational database developed by a group of network developers around the world. It is an open-source version that can replace commercial databases such as Oracle and