Database Administrator

1. The relationship between Oracle sessions and processes Modified through SQLPlus is: Sessions = 1.1 * processes + 5 Use sys to log on with sysdba permissions: SQL> show parameter processes; Name type value -------- Aq_tm_processes integer

Grant, view, and manage user permissions in Oracle in Linux. In Oracle databases, user permissions are divided into two types (here we do not discuss the permissions of dba or role, but only the permissions of common users ), system Privilege System

First, go to root mode to download 3 Software Term-Readline-Gnu: http://search.cpan.org/dist/Term-ReadLine-Gnu/ IO-Tty: http://search.cpan.org/dist/IO-Tty/ Uniread: http://sourceforge.net/projects/uniread/ Run tar-xzvf... with the root account

One day, the system is switched from Windows to Linux, and Ubuntu is used. I started to build my web server, php5.2.6, mysql 5.0.45, nginx 0.5.35. Everything is normal, and phpinfo is also displayed. Next, we will start to build a project site. The

Our server uses the server version of Ubuntu 8 and uses mysql as the server. However, every time we manage databases, we use SQL statements, which is very troublesome, especially when we add data, if there are ',; and other symbols in the added data,

MySQL also designed a native driver called mysqlnd for PHP6, which is a MySQL database driver using the PHP open source protocol (PHP license) and avoids any possible copyright problems, so PHP developers can use it with confidence. Mysqlnd becomes

Install MySQL in Ubuntu in three ways: 1. install sudo apt-get install mysql-server from the Internet. After the environment variables have been automatically configured, you can directly use the mysql command. 2. Install the release package. Take

MySQL has built the Replication function since version 3.23. We can configure it to master-slave mode or master-master mode. The method is very simple. Here we will record the configuration of the master-master. Here I test mysql 5.1.31. One is

I. Account and system roles are combined to improve account security. An account is a name defined in the database system. It is the basic access control mechanism of the database. When connecting to the Oracle database, you need to enter the user

As we all know, Oracle database tables are stored in tablespaces. Theoretically, a table can be placed in any tablespace. However, in practice, database engineers tend to be less casual in terms of performance and security. Before creating a

Take scott. emp as an example. Based on the position (MGR) number, find all information about the position number.Create TYPE first: equivalent to the TYPE of each row of record, which can be understood as scott. emp % rowtype1.CREATE or replace

OS: Ubuntu Server 12.10 For two servers, the Intranet IP address of A is 192.168.1.111, the Intranet IP address of B is 192.168.1.222, A is the master, and B is the Slave. 1. Configure Mysql of (1) vim/etc/mysql/my. cnf Remove the # comment for

Before Oracle9i appeared, you can only re-define the table by moving or exporting and importing the table. Therefore, the table redefinition process may be quite long or offline, during this period, the application will fail to operate on the table.

There are a variety of ways to delete duplicate data on the Internet. Oracle has never seen such a method:  Delete from prod_grid_incWhere rowid in (SELECT B. row_id2FROM (select rowid row_id2,A .*,Row_number () over (partition by a. prod_id order

Script Function One-click installation script for a single redis instance Notes 1. Applicable only to Linux/CentOS 64-bit 2. Networking is required during installationStep 1. download and install the libunwind package (TCMalloc dependency package) 2.

Important knowledge points to be mastered in Oracle Learning 1. Basic syntax This is required. select, insert, update, where, and so on. To master this knowledge, you can do some verification and testing work. The target is for O & M or testing. 2

1. scenario: the mysql database is on the slave machine, the slave machine is on the LAN, the ssh host is required, and then the ssh slave machine (the slave machine) is on the client machine) similar to the following Architecture     As a

After I installed Oracle 11g rac, why ??? Garbled characters are as follows:[Oracle @ db ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Thu Dec 20 13:40:46 2012 Copyright (c) 1982,200 9, Oracle. All rights reserved. ??? :Oracle

The Linux script has not been written for a long time. Suddenly there is a need to write a bash shell script to initialize Oracle users and tablespaces. Make a record for future Query Call method:./user. sh

I saw an article: Using instr in the Oracle database instead of like (see). I am very skeptical after seeing it. The following is a simple test I did to compare and verify the original article.1. Before creating an index SQL> select count(1) from t;