Database Administrator

In the actual production environment where multiple users access data concurrently, we often try to maintain data consistency as much as possible. The most typical example is to read data from the table, check and verify the data, and then write it

The DB2 UDB Security Model consists of authentication and authorization ). Figure 1. DB2 UDB Security Model 1 2 3 4 5 6 7 8 9 Next Page [Content

When interviewing MySQL DBA or those who intend to optimize MySQL performance, my favorite question is: what adjustments should I make after the MySQL server is installed according to the default settings?I was surprised how many people could not

To learn about Oracle, we 'd better first understand the Oracle framework. In this way, we have an overall understanding of Oracle, which has the role of creating a high-level architecture.1. Physical Structure(Composed of control files, data files,

The system crontab is used to regularly execute Backup files and save the backup results by date to achieve the purpose of backup.1. Create the path to save the backup file/mysqldata# Mkdir/mysqldata2. Create the/usr/sbin/bakmysql file.# Vi/usr/sbin/

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances.1. DatabaseA database is a collection of data.Whether the database adopts a relational structure or an object-oriented structure, the oracle

1. Download the MySQL Linux Installation File To install MySQL in Linux, the following two files are required: MySQL-server-5.1.7-0.i386.rpm To download the above two RPM files, locate the "Server" and "Client programs" items and find the items

I installed MySQL in Linux yesterday and made a note. # Wget http://mysql.ntu.edu.tw/Downloads/MySQL-5.0/mysql-5.0.45.tar.gzBytesInstall# Tar zxvf mysql-5.0.45.tar.gz# Cd mysql-5.0.45#./Configure -- prefix =/usr/ali/mysql --

Oracle DBLINK Role: the oracle database logic of servers in different locations is regarded as a database, that is, objects in another remote database can be operated in one database. Syntax:CREATE [PUBLIC] database link dblink connect to user

Hello everyone! Today, we have compiled examples of how to create 10g 11g all partition tables. Here we will share with you: Partitions supported by 1.1 9i, 10g, 11gR1, and 11gR2 Interval list hash Interval 11gR1 9iR2 9iR2   List 11gR1 11gR1 11gR1  

Today, another colleague encountered an Oracle database bug: -- This problem exists on all platforms in Oracle 10.1 OR 10.2. This error occurs when you perform complex multi-table join queries.ORA-00600: Internal error code, parameter: [19004], [], [

When it comes to tracking SQL statements, some people may ask about this function. Some may think of using the audit function. To track SQL statements and enable the audit function, it will become a waste, maybe the user just wants to track all the

When using sqlplus to execute an SQL script, parameters are often passed to the script. Similar to passing parameters in shell scripts, we can also pass parameters to SQL scripts by directly following multiple consecutive parameters and separating

MongoDB is the most easy-to-use NoSQL and is suitable for replacing MySQL for some storage, but it is not highly consistent. This article introduces various MongoDB deployment methods and shares some experiences. The first two parts, "single-host

-- Collect Oracle statisticsBEGINDBMS_STATS.GATHER_TABLE_STATS (OWNNAME => 'owner _ name', -- database usernameTABNAME => 'table _ name', -- TABLE NAMEPARTNAME => 'partition _ name', -- PARTITION NAMEESTIMATE_PERCENT =>

1. Error The operating system and database are installed by the service provider. After a few months, I remembered that the database was used. The following error occurs during startup. SQL> startupOracle instance started. Total System Global Area 49

Solution to the Problem of Oracle 10g2 connection installation during Solaris 10 u10 Problem description: Exception String: Error in invoking target 'client _ sharedlib 'of makefile'/u01/app/oracle/product/10.2.0/db_1/network/lib/ins_net_client.mk'.

Today we found that indexes are not used in an SQL query, and classid is used to create indexes, as shown below:Select * from infobase where classid in (10005 );It is strange to find that no index is used for the classid in (,) value or more, and

When CentOS 5 is upgraded to mysql5.1 to start the service, the following ERROR occurs: [Error] error message file '/usr/share/mysql/english/errmsg. sys 'had only 481 ERROR messages, But it shoshould contain at least 641 error messages. Solution:

Oracle uses user_constraints to obtain the foreign key. For example, to obtain all foreign keys: Select CONSTRAINT_NAME constraint name, TABLE_NAME tableFrom user_constraints t where1 = 1-- T. table_name in ('tbl _ step ')And CONSTRAINT_TYPE =