Database Administrator

PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial databases. This

Heap table Storage: In the Oracle database system, the most common is heap tables. The data storage mode of the heap table is unordered, that is, any DML operation may make the current data block available free space. In consideration of space

This DB2 script is very good. When exporting data, you just need to add the table name. In fact, you can refer to the same method for import or load data: #! /Usr/bin/sh Db2 connect to webList ="DB2INST1. ACCESS_IDDB2INST1. ACCESS_ID_HISTDB2INST1.

Lab requirements: 1. Configure two MySQL servers (192.168.100.2, 192.168.100.3) and one proxy server (192.168.100.1) to implement read/write splitting of the MySQL proxy. 2. You only need to access the MySQL proxy server. The actual SQL query and

Lab requirement: deploy a MySQL cluster to reduce single point of failure (spof) of the database. Tutorial solution: prepare five servers, mgmd (192.168.100.1) as the management node, sqlA (192.168.100.2) and sqlB (192.168.100.3) as the SQL node,

ORA-32690: insufficient hash infrastructure memory [Oracle @ sdw0 ~] $ Oerr ora 1, 3269032690,000 00, "Hash Table Infrastructure ran out of memory"// * Cause: Not enough memory.// * Action: Increase memory.  This is a known bug on database version 10

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

To diagnose the slow running of Oracle, you must first determine which diagnostic information to collect. You can use the following diagnostic methods:1. Is the problem of slow database operation common or occurs at a specific time?If the database

Install a Windows 2008 Server 64 and Oracle, and then migrate the database to the Linux environmentWindows Server 2008-192.168.182.128 Oracle 11.2.0.3.0 ORACLE_SID = orclOracle Enterprise Linux 5.8-192.168.182.131 Oracle 11.2.0.1.0 ORACLE_SID = ORCL

I. Experiment 1 A) lab requirements: I. move the table under the vip user to the DATA tablespace to partition the table fragments. -- I think it should be to check the usage of one or some tablespaces, to fragment the table in the tablespace,

My php environment is WAMP, which has been configured and used for a while. Yesterday I saw an article about setting a password under the permission in phpMyAdmin. I changed the original NO passwor (default) to 1234 with the permission, click the

Oracle data export: Create a path file: create_dir. SQL Create or replace directory dmpdir as 'e: \ app \ tmp ';Grant read, write on directory dmpdir to test;Exit Write and execute export Bat file: export. bat Sqlplus system/root123 @ MYTEST @

Prepare an SQL script demo. SQL Set serveroutput onDeclareV_name dept. dname % type;BeginSelect dname into v_name from dept where deptno = & 1;Dbms_output.put_line ('department name is: '| v_name );End;/Exit; Then run the following command on the

Diagnose and resolve ORA-04031 errors When we try to allocate large blocks of continuous memory in the Shared Pool, Oracle first clears all the objects currently not used in the pool to merge idle memory blocks. A ORA-04031 error occurs if the

-- Instance demo--- System user ExportC: \ Users \ ZML> exp system/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml. log' tables = (zml) Export: Release 11.2.0.1.0-Production on Monday April 21 21:39:12 2014 Copyright (c) 1982,200 9, Oracle and/or its

There are two tables t1 and t2 Table t1 is structured Id, name, age Table t2 is structured Id The join statement is select t1. * from t1, t2 where t1.id = t2.id; We now need to retrieve the data after the association query. We recommend that

Run the stored procedure, which contains a temporary table. After running, you want to delete the temporary table report ORA-14452: An attempt was made to create, alter or drop an index on temporary table which is already in use Solution: In fact,

As the version continues to increase, the role of RMAN as a standard backup tool is constantly enhanced. From the traditional backup and restoration tools in the past to the new environment migration and building of DG, we can see the enhancement of

SQL statements are a convenient and confusing language. This is mainly reflected in its set operation features. Update statements are identical regardless of whether the data volume is one or 0.1 billion. However, the actual execution results (or

Oracle is now evolving towards intelligence. If we are looking for Oracle books in the 8i/9i era, it is very important to configure appropriate database memory pools. However, after entering 10 Gb, automatic memory pool adjustment becomes an