Database Administrator

When writing a database program, we often need to obtain the maximum number of numbers in a table,Generally, you can obtain the id of the inserted data by using select max (id) from table.But in the case of multiple threads, it won't work. The

If the following error occurs during compilation:Checking for tgetent in-ltermcap... NoChecking for termcap functions library... Configure: error: No curses/termcap library foundIt indicates that the curses/termcap library is not installed. For this

In the morning, I tested MySQL and wrote 240000 pieces of data. In the afternoon, I couldn't find the database file, but I found only one size of 9 KB. frm file, but frm file is not a database file, and the file size is too outrageous, Baidu

Single-instance Environment Vmware Server 1.0.6 + CentOS 5.2 + Oracle 10g 1. Stop the process 2. Install patches 3. Upgrade the database 1> stop all Oracle-related processes [Oracle @ node2 Disk1] $ emctl stop dbconsole [Oracle @ node2 Disk1] $

In the case of php5.3, The dblib driver of pdo cannot connect to mssql. According to the official description, 5.2 has modified this bug, but 5.3 does not. You can use the mssql function that comes with php. Compile freetds, php_mssql, and pdo_dblib

Early Stage 1: Download Oracle for linux (x86) and upload it to Linux 2. Preparations before installation:1. Hardware requirements. Test the idle space of the installation directory as long as 5 GB is left empty. The memory is above MB, and the CPU

Q: What are the initialization parameters related to Oracle performance?A: The initialization parameters that affect Oracle system performance are as follows: SGA (system global zone)The system global zone (SGA) is a memory segment allocated to the

My system is RedHat 5.5 64-bit, Oracle is 11G R2 Oracle 11g uses jdk1.5. After jdk1.5, a simple solution is provided to solve this problem. You only need to create a fallback directory under $ JAVA_HOME/jre/lib/fonts, copy the font you want to use

I. Log transmission problems 1. Generally, use the following statement to check whether the sequence of the archive logs of the primary database and standby database is the same. Run the following command in the primary database: SQL> alter system

So far, Oracle databases are the most difficult to install among the many software I have installed in linux. Fortunately, I just successfully installed oracle database on linux OS. In retrospect, it is not difficult to install an oracle database.

AIX6.1 install Oracle 11g R2 1. Check the server status before installation(1) view memory size# The/usr/sbin/lsattr-E-l sys0-a realmem command is long. If you forget it, you can use man lsattr.(2) view swap space# Lsps-Page Space Physical Volume

Symptoms:An error is reported when RMAN copy is executed.ORA-01276: Cannot add file + TESTDG/rac/datafile/system.416.8333820.5. File has an Oracle Managed Files file name.As follows:RMAN> copy datafile 1 to '+ TESTDG/rac/datafile/system.416.833384105

Concepts of partition and table sharding Partitions split rows in the data table into smaller Datasets Based on the specified rules and then distributed in multiple directories and disks. MySQL supports Partition from 5.1.3. Table shards are

Preface: Table Compression should be supported from 10 Gb. Oracle 11g exadata used this feature to the extreme and vigorously promoted the compression technology. In the condition that the cpu performance of modern machines is blowout, the reduction

ORA-29283 solution (impdp) The impdp error message is as follows: ORA-39002: invalid operation.ORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS. UTL_FILE", line 475ORA-29283: invalid file operation

Xtrabackup is widely known. If xtrabackup is used for remote backup, most of the time is spent on network transmission. Inspired by orzhou master tar + lz4/pigz + ssh for faster data transmission, edge compression and edge transmission can be used:

Reset the MySQL password: Stop the MySQL service and start it with the skip-grant-tables parameter. Service mysqld stop;Mysqld_safe -- skip-grant-tables -- user = mysql & In this case, you can access the MySQL command line without

1. Prepare the environment1.1. Software InformationVirtual Machine: VirtualBox 4.2Operating System: Oracle Linux Server release 5.9OCFS2: ocfs2-2.6.18-348.el5-1.4.10-1.el5.x86_64.rpm 1.2. Host Configuration1.2.1. Hosts file[Root @ skynode1 ~] # More/

When using the Innodb engine, Innodb has two ways to manage and select two types of tablespaces. Shared tablespace: it can also be split into multiple small tablespaces. Independent tablespace: Each table has an independent tablespace. In terms

ORA-03113 error occurs when Oracle database is shut down: SQL> shutdown immediateORA-03113: end-of-file on communication channelProcess ID: 3437The Session ID is 125 Serial number: 5. SQL> startupThe ORA-24324: service handle not initialized.ORA-0104