Database Administrator

First, go to the PostgreSQL official website to download the latest version. The author uses Linux x86_64 source code to compile the installation package: postgresql-9.0.1.tar.bz2.The installation process is as follows:-----------------------------

Many of my friends may have encountered this situation. When regularly clearing Oracle log folders on UNIX/Linux, they may delete trace files that are still open by background processes, that is, some background processes keep holding these

Platform: RedHat Linux 9.0MySQL version: MySQL 5.0.4 Install MySQL source code: # Groupadd mysql# Useradd-g mysql# Tar zxvf mysql-5.0.41.tar.gz# Cd mysql-5.0.41#. /Configure -- prefix =/usr/local/mysql -- enable-thread-safe-client --

Delete database link: drop database link linkname;Create database link:Create database link linknameConnect to usernameIdentified by passwordUsing 'Connection string ';If you want to create a global link, you need to use the Keyword: publicCreate

Installation Log [20100707]1. DELL Server2. Install CentOS 5.5 (64-bit)Note that swap is usually 4 GB3. Install Oracle 10.2 (64-bit) Grep MemTotal/proc/meminfo Grep SwapTotal/proc/meminfo Uname-mi4. Check the environment:Rpm-q -- qf' % {NAME}-%

Oracle stores data through algorithm conversion in the database. This article aims to introduce how the value of the NUMBER type is stored. Let's take a look at a simple example: SQL>Select dump (1) from dual;DUMP (1)------------------Typ = 2 Len = 2

Lab environment: One Laptop (2 GB memory, GB hard drive) Vmware Server 1.0.6 Linux Enterprise 5.1 Oracle 10g for linux (10.2.0.1) Preface: This was not the first lab environment. The virtual machine used vmware workstation. After a while, it was

Run the following command to view the MySQL version: [Root@bkjia.com] # mysql-V Display: mysql Ver 14.14 Distrib 5.5.7-rc, for Linux (x86_64) using readline 5.1 Check if there are any mysql commands in rpm: [Root@bkjia.com] # rpm-qa | grep-I

Installing Oracle on openSUSE is a simple task. Generally, you can follow the steps on the openSUSE website to install Oracle more easily, provided orarun. to install and configure the rpm package, follow these steps:Http://en.opensuse.org/Oracle_on_

Environment:OS: CentOS release 5.5 (Final) (64-bit)2.6.18-194. el5 #1 SMP Fri Apr 2 14:58:14 EDT 2010 x86_64 x86_64 x86_64 GNU/LinuxMysql:Mysql-5.5.3-m3.tar.gzMaster: 192.168.0.100Slave: 192.168.0.200 Most configurations are similar to "MySQL master-

Environment CentOS For Mysql 5.1 Prerequisites EPEL is installed. For detailed installation steps, see Http://blog.csdn.net/robinsonmhj/article/details/36184863 Machine list Machine IP Address Machine name 192.168.0.135

Today is. the following error occurs when copying data: RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause The procedure is as follows: [oracle@dg1 dbs]$ rman target sys/root@dg1

-- Create table statement create table wangzstable (idintegernot null, NAMEVARCHAR (20) not null, AGEVARCHAR (20) not null, STATUSVARCHAR (10), createtimestamp, UPDATETIMETIMESTAMP, SENDTIMETIMESTAMP ); select * from wangzsTable; insert into

More and more problems have been found recently. Both in self-learning and software problems have made me feel that there are still many problems that need our efforts, in the near future, we can better solve the problem. Now let me talk about the

Cluster Health Monitor (CHM) is a tool provided by Oracle to automatically collect operating system resources (such as CPU, memory, SWAP, process, I/O, and network). CHM collects data every second, and 11.2.0.3 collects data every 5 seconds. These

This blog briefly introduces several types of queries commonly used in SQL Server and their usage methods. 1. Obtain a single value using the ExecuteScalar Method The ExecuteScalar method is one of the SqlCommand class methods. It executes the query

Redis operations on string and hash data Set name xiaohongyang //Get nameSetnx name xiaohyGet nameSetex name 10 jackxiaoSet email xiaohy@yahoo.comGet emailSetrange email 7 qq.comGet emailMset name xhy sex man age 30 // set multiple key values in

Database: Oracle11.2.0.3 Ora14401 error occurred when deleting the tablespace where the partition table is located: SYS @ vimop01_ B> drop tablespaceUSER_TS_MONI_11B including contents and datafiles; Drop tablespace USER_TS_MONI_11B including

In the performance optimization analysis of Java, JProfiler can be used to analyze information such as CPU consumption, Memory usage, and Thread usage during JVM running. The stored procedures and functions of Oracle called in Java code can also

1. What is the difference between PGA and SGA? SGA is the global area of the system, and PGA is the global area of the process. Oracle is running, and SGA is the memory structure of oracle, such as putting databuf and share pool, allocating at