Database Administrator

[Data recovery fault description] An important MySQL database server, 146 gb x 2, RAID1, and about 130 gb data volumes, stores about 200 ~ 300 databases. At ordinary times, the management staff directly compress every data warehouse dumps into A. GZ

Oracle 9.04 is installed on Ubuntu Server 10.2 today. When it is installed to 80%, the all_no_orcl error occurs.Open the log file as prompted and find the following error:Information: Creating/opt/oracle/lib/liborasdkbase. so.10.2 Information:

Oracle tables have nearly 11 million data records. In many cases, we need to perform string matching. in SQL statements, we usually use like to achieve our search goal. However, the actual test shows that the like efficiency is quite different from

-- Found that those SQL statements run a lot of PARSE Select SQL _text, parse_cils, executions from v $ sqlarea order by parse_cils desc; -- Overall PARSE of SYS Select name, value from v $ sysstat where name like 'parse count % '; -- CPU space and

I am wondering how to assign values to Blob objects. Image bb = Bitmap. FromFile (@ "f: \ abc. Gif"); // define the Image positionSystem. IO. MemoryStream MS = new System. IO. MemoryStream ();Bb. Save (MS, System. Drawing. Imaging. ImageFormat. Gif)

1. Index in SQL Server An index is a disk structure associated with a table or view, which can accelerate the speed of retrieving rows from a table or view. An index contains keys generated by one or more columns in a table or view. These keys are

Some small functions in OracleRequirement: A. A string in the database table may contain"+"Example: ORC+001 It may not include"+"B. If the string contains"+", Then"+"Character example: ORC+001ORCC. If the string does not contain"+", The string is

It's easy. First, we need to download and install MSSQL in Linux to support Freetds, and then re-compile (compile) in the PHP installation source folder. -------------------------------------------# Wget

I. A view acts as a virtual table. Views are available in binary releases from 5.0.1 and up.The view is supported from 5.0 and is a virtual table. It is supported in binary 5.0.1 and later versions. 2. Updatable and Insertable Views-update and

1. Download the MySQL 5.5 deb installation packageCd/usr/local/src Sudo wget-O mysql-5.5.22-debian6.0-i686.deb http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.22-debian6.0-i686.deb/from/http://mysql.ntu.edu.tw/ 2. Install the deb package Sudo

Introduction: Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup has two main tools: xtrabackup and innobackupex. (

Requirement: LVS performs read load on MySQL. If the master and slave nodes are not synchronized, the problem may occur, how can I remove the slave database from LVS when the master node is not synchronized? And if I remove the slave database when

1. How to query whether a service is registered with a static listener or a dynamic listener You can run the lsnrctl status Command to check whether a service is registered statically or dynamically. When the instance status is UNKNOWN, it indicates

Currently, there are several popular MySQL automatic backup methods: I. Logical backup: Use the mysqldump tool provided by mysql to back up data. Back up SQL files. Advantage: it can work with running mysql automatically, During the running period,

Environment: Oracle Database 11gR2 (11.2.0.2) on LinuxFault symptom: The ORA-00979 is reported when the Group By statement is executed.The specific SQL statement is as follows:SQL> select a. d1, a. EXIT_type, round (a. cnt1/B. cnt2 * 100,2) from2

In the shutdown status, the database only has the PLSExtProc service and is in an unknown state. The database is in the nomount status and has SID, SIDXDB, SID_XPT, and PLSExtProc services. The SID, SIDXDB, and SID_XPT services are in the

Conversion functions In addition to Oracle data types, you can also use the American National Institute of Standards (ANSI), DB2, and SQL/DS data types to define columns in Oracle DB tables. However, Oracle Server converts these data types to

Theoretical Basis of the experiment: The increment of the sequence of SCN does not change with any database operation, even the RESETLOGS.RESETLOGS clears redo records not applied in all online log files. RESETLOGS only resets the log file's serial

The word "filter" is confusing. a subnode, two subnodes, and three subnodes can be mounted at the next level .... Apply a subnode to filter data. For example, after a full table is scanned, the data that does not meet the conditions is

MySQL 5.5 Command Line Client cannot be opened (disappears in a flash) Solution Solution: 1. Find the bin directory path under the mysql installation directory. 2. Open cmd, enter the path to the bin directory, and enter mysql-u root-p. Problem