Database Administrator

Zookeeper AIX6.1 notes on installing oracle 11204 1. Check the memory size. #/Usr/sbin/lsattr-E-l sys0-a realmem Minimum 1 GB, 2 GB or more   2. Check the size of swap space. #/Usr/sbin/lsps-   3. Check whether the operating system structure can run

Reprinted please indicate the source: http://blog.csdn.net/jmppok/article/details/18085181 Redis is a memory-type key-value database that provides extremely fast access and is easy to use and supports multiple languages. This article provides a

    SQL GROUP BY instance We have the following "Orders" table: O_Id OrderDate OrderPrice Customer 1 2008/12/29 1000 Bush 2 2008/11/23 1600 Carter 3 2008/10/05 700

EXPLAIN PLAN-This command is used to generate an SQL statement execution plan, but the statement is not actually executed. Dictionary View-In the oracle dictionary view, we can query the execution plans of SQL statements that have been executed

There is no formal Sleep for calling after a good batch processing. Sometimes, it is really boring. 1. Method 1: Ping 1.1.1.1 to simulateIt is difficult to find an answer (called an answer because it is labeled as answer) from stackoverflow: Ping 1.1

Copy codeThe Code is as follows:# Define SQLITE_ OK 0/* success | Successful result *//* Error code start */# Define SQLITE_ERROR 1/* SQL errors or database loss | SQL error or missing database */# Define SQLITE_INTERNAL 2/* Internal SQLite logic

1. Use EXPLAINThe EXPLAIN command can view the execution plan, which has been introduced in the previous blog. This method is our most important debugging tool.2. update statistics used in the execution plan in a timely manner Statistics are not

To create a table partition, follow these steps:1. Create a master tableCreate table users (uid int not null primary key, name varchar (20 ));2. Create a partition table (the primary table above must be inherited) Create table users_0 (check (uid> =

First, let's talk about ms server. Because I am a newbie, I first chose to use the Enterprise Manager for task settings and then export the designed task script, in this way, you can directly execute scripts in other databases to create a task (you

Mysql supports multiple storage engines. When processing different types of applications, you can use different storage engines to improve application efficiency or provide flexible storage. Mysql storage engines include MyISAM, InnoDB, BDB, MEMORY,

For more blog posts, please note: Children without umbrellas must keep running.(Www.xuchanggang.cn) I. Brief description of Amoeba: [from Baidu encyclopedia]Amoeba is a proxy that uses MySQL as the underlying data storage and provides MySQL protocol

In addition to using DBCA to delete the Oracle 12C database, we can also use the drop database Command to delete it.This deletion method is very simple, but must meet the following two requirements:1. The database must be in the mount State and

1 )*.LoginMysqlDatabase master server and set authorized users for slave server. # Mysql-uroot-p123456 test Mysql> grantall (slave) on *. * to user1_zc@192.168.10.2identified by "456 "; Or Mysql> grantreplication (slave) on *. * user1_zc@192.168.10.

My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what shoshould be tuned in MySQL Server straight after installation, assuming it was installed with default

I have been on vacation recently. I have not written a blog, but I still have the last day in my eye. The time is really fast. Today I want to talk about database security. For database security issues, first of all, important generated databases

Followed by the above article: http://ixdba.blog.51cto.com/2895551/880511 14. Install Oracle Clusterware 1) decompress the Software PackageAssume that all the database software is in the/rac directory. First, extract the two Oracle software packages

This is a real oracleORA-19815 solution) case, hope to help everyone.Today, the platform of a friend company encountered slow login and slow data query, and the failure to log on to oracle monitored through spotlight. No problems were found by

I recently carefully read the Clean Code Clean path when I was busy with public transportation. I once again admire Uncle Bob's humorous essays and his unique views and perspectives. What impressed me most was Uncle Bob's explanation of the data

SCN: System Change Number SCN is a logical internal timestamp of the Oracle database, used to identify the version submitted by the database at a specific time. When a transaction is committed or rolled back, it is assigned a unique SCN that

When I tested the SQL Server 2014 memory database some time ago, I found that if the database size exceeds the configured maximum memory size, SQL Server encountered Error: 701. Error message: Error: 701, Severity: 17, State: 123. There is