Database Administrator

The Internet has proved to be the most effective way to share information since the first submarine cable laying across the Atlantic Ocean, costing up to $2 million a day in 1866. This cross-Atlantic submarine cable is the world's first network,

(1) privilege: the privilege is the power to execute a special type of SQL statement or access another user's object. There are two types of privileges: SYSTEM privileges and object privileges.System privilege: it is the right to execute a special

Although it may take a long time to back up an Oracle database, this time is negligible compared to the fear of loss of transactions, loss of revenue, and dissatisfaction of customers. Therefore, backing up an Oracle database is becoming the most

Environment: Two HP ML570 Linux AS4.5 Oracle 10g The two servers perform Oracle RAC and connect to HP MSA1000 through SAN Switch Fault symptom: Because the cabinet where one Oracle rac node is located is out of power, two rac nodes are down at

MySQL performance tuning primer script is a simple and easy-to-use mysql optimization tool. In fact, it is a shell script. Download: $ Wget http://www.day32.com/MySQL/tuning-primer.sh Run $ Sh tuning-primer.sh all After running the command, you

What I wrote today is to use Java to implement MySQL backup and recovery. The backup load method is recovery. Import java. io. File;Import java. io. IOException;Import java. io. InputStream;Import java. util. Properties;Public class JavaMysql {/****

Many new changes in Oracle Database (Database) 11g Ensure that this dream is closer to reality. Oracle released Oracle Database 11g Release 2 For Linux. For example, a database replay tool allows you to capture the production database load and

Recently, due to project requirements, shell programs are used to batch Delete business table data, but business history data needs to be retained according to business needs. Because db2 is used in the project, db2 will generate a large number of

Authorized users can access database objects and their contents. Prompt that after a user has the permission to Process Tables of other users, the user must have public or private synonyms of these tables before he can reference tables of other

RMAN backup is easy to use for Oracle database backup and recovery, with low costs. For non-catalog mode, it is undoubtedly the first choice to embed the RMAN script into the shell script and then use crontab to back up small and medium databases.

This article describes the process of installing Oracle 11g on RHEL 6.3. You can download RHEL from many image sites, such as Oracle 11g, note that the version 11.2.0.3 is used in this article. Currently, this version is not available for download

Oracle official documentation: Reserved words and keywordsare identifiers that have special meaning in PL/SQL. You cannot use reserved words as ordinary user-defined identifiers. you can use them as quoted user-defined identifiers, but it is not

Common Data Types of DB2 include: 1. Digital type. 1. SMALLINT --- short integer, range:-32768 ~ + 32767, less than once 2. INT/INTEGER --- INTEGER, 4 bytes in the range of-2147483648 ~ + 2147483647, multiple times for auto-generated sequence or

The 'Log file sync' wait event in the RAC database is more complex than the 'Log file sync' wait event in the Standalone Database, mainly because the RAC database needs to synchronize the SCN to all instances. The 'Log file sync' wait event in the

Html code Android 2.3.3 Eclipse Version: 3.7.0 LogCat LogCat error message:Java code 02-13 09:21:35.030: WARN/dalvikvm (17173): Threadid =19: Thread exiting with uncaught exception (group =Zero x 40015560) 02-13 09:21:35.130:

Temporary table concept A temporary table is a database object used to temporarily save temporary data (or intermediate data). It is similar to a common table, but it is quite different. It can only be stored in temporary tablespaces, not user

I. Backup Type and other description: 1.1 whether the server will continue to provide service points during Backup: Hot Backup: read/write during Backup is not affected Warm backup: only read operations can be performed during Backup Cold backup:

Solutions to incompatibility during MySQL installation on Linux: [Root @ localhost ~] # Rpm-ivh MySQL-server-5.5.24-1.linux2.6.x86_64.rpmPreparing... ######################################## ### [100%]File/usr/share/mysql/charsets/README from

8.3.4Renaming a Datafile in the Primary Database8.3.4 recommand the data file in the master database (that is, manually modify the same changes in the slave database) When you rename one or more datafiles in the primary database, the change is not

MongoDB cluster creation MongoDB replication cluster type: · Master-slave mode (master/slave) · Replica set mode (replica set) The copy and mode have at least three nodes (one master node and two slave nodes). The slave node is responsible for