Database Administrator

How to enable or disable Oracle ARCHIVELOG Mode How to enable or disable Oracle ARCHIVELOG Mode 1. Connect to the database as an administrator C: \ Users \ Administrator> sqlplus sys/sys @ prjdb as sysdba SQL * Plus: Release 11.2.0.1.0 Production on

Principle test of MySQL InnoDB Engine lock How does MySQL INNODB Engine lock work? Let's test it. Mysql> select version (); + ----------- +| VERSION () |+ ----------- +| 5.5.20 |+ ----------- +1 row in set (0.00 sec) Create table test(A INT (5 ),B

MySQL 5.5.40 automated installation script After learning the Linux Shell script for two weeks, I finally wrote a MySQL automated installation script. With the full-day test today, MySQL 5.5.40 can be installed normally. Other versions have not been

Use RMAN to migrate the file system to ASM 1. Full backup database PROD Run {Allocate channel c1 device type disk;Allocate channel c2 device type disk;Backup tag 'sh _ db' as compressed backupset format'/home/Oracle/full _ % U. Bak' databaseInclude

Migrate Oracle databases across OS platforms Port existing Oracle databases (non-binary executable program files/) from one operating system platform to another operating system platform (for example, from Windows to Solaris)This requirement may

Oracle 11gR2 RAC environment DBCA create database error ORA-15055 ORA-15001 Symptom: After installing the Oracle 11gR2 GridInfrastructure and Database software, run DBCA to create a Database to 30% and report the following error. Click OK to ignore

The period for changing the Oracle password is unlimited. Oracle error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle 11g User Creation is 180 days (6 months ), if the

Permission handling for installing Oracle 11g OS in Win7 64bit In general, we choose to install Oracle databases in traditional server operating systems such as Linux and AIX. Even in Windows, server versions such as 2008 and 2012 are used as the

MySQL multi-instance configuration (2), mysql instance Configuration For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is

MySQL multi-instance configuration (1), mysql instance Configuration For centralized O & M of MySQL databases, you can deploy multiple MySQL instances on one MySQL database server. This function is implemented through mysqld_multi. Mysqld_multi is

Wang Liping-simple application of SQLite, SQLiteOpenHelper, and sqliteopenhelper The Android platform provides a database helper class to create or open a database. This helper class inherits from the SQLiteOpenHelper class. In the constructor of

SQL Left, Right Join, and other operators.1. query all the data in tableA and tableB and the data in tableA in tableB.Select * from tableA A left join tableB B on A. key = B. key2. query and exclude the data in tableB and the remaining data in

Left to right: InnoDB or MyISAM, innodbmyisam Welcome to my original Website: http://www.phpthinking.com/archives/456 MyISAM is the default storage engine in MySQL. Generally, not many people care about this. It is a tricky thing to decide what

Inheritance ing of Hibernate association relationship ing and hibernate Association First, an Article class (Article) contains attributes such as id, title, content, and postTime. package entity;import java.util.Date;public class Article {private

Dbms_xplan.display_awr method to obtain the experiment of the Execution Plan and the previous misleading, dbmsxplan. display This blog article "view several common methods of Oracle execution plans-Series 1"

Oracle installation and configuration process I had to install oracle myself for the first time. I had no idea about oracle installation and configuration before, and finally finished it. 1. Install the oracle10g Server 2. Install the oracle10g

First understanding of MySQL stored procedures, mysql stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name

A simple cursor deletes an SQL SERVER table. Use databaseNameDeclare @ tblname char (100)Declare @ SQL char (5000)Declare table_cursor cursor for select name from sysobjects where name like 'tb _ card [_] % 'and name <> 'tb _ card_regist' and name <>

Oracle scheduled task and oracle task # Su-oracleOracle> sqlplus "/as sysdba"SQL> exec dbms_scheduler.disable ('Monday _ window ');SQL> exec dbms_scheduler.disable ('tuesday _ window ');SQL> exec dbms_scheduler.disable ('wednesday _ window ');SQL>

Analyze the usage of the oracle index space and whether the index needs to be rebuilt.Analyze the index space usage and whether the index needs to be rebuiltThe analyze any permission is required to analyze indexes of other users.Check the table