Database Administrator

1.1 error ORA-600 [kcratr_nab_less_than_odr], cannot start 1. symptom Description: The server storage is powered off, causing the database to go down and start the database again. The database cannot be started normally. The database reports the

Obtain the new data table from multiple tables, and then calculate and evaluate the fields of the new data table. Select (Number01.N1/Number02.N2) -- get tow table_fieldsfrom (select count (. field01) as N1 from Table01 A, Table02 Bwhere. field01

The PoC testing and implementation of the development and production environments in the virtualized environment has been completed for the product. I. Development Environment 1. VMware Server 2.0.2 2. Windows Server 2003 With SP2 32bit 3.

Thinking in BigDate (iii) mechanism and trend of big data operation. This article talks about the challenges of structured data. With the increasing volume of data,NoSqlIt came into being. In this article, we will unveil the secrets of NoSql and

The 14th tip of DB Query Analyzer Ma Genfeng (Guangdong Unitoll Services ininitialized ated, Guangzhou 510300)   AbstractIn this essay I will demonstrate how to display the content of a certain function in DB2 by DB Query Analyzer. Key wordsDB Query

We often use the exp/imp command for import and export, which is indeed convenient, but also limited. For example, the tablespace names to be imported and exported must be the same, and the schema names must be the same. Recently I encountered such

Check the latest slow log and check whether slow log is enabled. Mysql> show variables like '% slow % ';+ --------------------- + ------------------------------------------ + | Variable_name | Value | + --------------------- + ----------------------

During lunch break today, I received a request. The system is very slow. From the top view, most processes are zombie processes. Oracle version 11.2.3.x Linux5.6 x86-64 First, we suspect the problems in cron. Use crontab-l, crontab-u oracle-l No

PDM (Physical DataModel) is the Physical data model, which describes the Physical implementation of the database. Here we will take into account the details of the Physical implementation, including the data storage structure, you can modify PDM to

What is the problem caused by the absence of an index on the foreign key? Let's do an experiment below:SQL> drop table t_primary purge; SQL> drop table t_foreign purge; SQL> create table t_primary (id number (10) primary key ); SQL> create table

To connect to mysql through the command window in cmd, you only need to input mysql-uroot-p123456 in the command line. The prompt "mysql is not an internal or external command" appears ". The solution is to add C: \ Program Files \ MySQL Server 5.6 \

Problem descriptionSQL> select dbms_metadata.get_ddl ('tablespace', 'test') from dual;ERROR:ORA-39212: Installation Error: incorrect loading of XSL style sheetORA-06512: In "SYS. DBMS_SYS_ERROR", line 79ORA-06512: In "SYS. DBMS_METADATA_INT", line 73

The Endeca product system contains a lot of content. Previously, we introduced the most ignored but important content of IAS. This article mainly introduces the installation process of the EndecaETL tool: 1. Install the EndecaETL client on the

crs_stat -tName Type Target State Host ------------------------------------------------------------ora.DATA.dg ora....up.type ONLINE ONLINE node1 ora....ER.lsnr ora....er.type ONLINE ONLINE node1

The partition index is a global partition index and a local partition index, and a global non-partition index (that is, a common index) is added. A total of three types of indexes are added. The organizational structure and application scenarios of

Use MySQL Migration Toolkit to quickly import Oracle Data to MySQLLet's talk nonsense first.I have recently learned some database knowledge. I have been familiar with Oracle and MySQL before, and recently I am very popular with MongoDB

PLSQL Skills 1. PL/SQL Developer remember Login PasswordWhen PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for ease of work;Setting Method: PL/SQL Developer 7.1.2-> tools->

The root cause of the garbled problem is that the encoding is not uniform. Since the project had no Chinese garbled characters before the database was reloaded, the problem must have occurred in the database encoding. After running mysql, enter the

In Redis commands, the commands used to process keys Take a large part, and Type (hereinafter referred to as "Key type"), and the commands that can be executed by the key are different. For example, LPUSH and LLEN can only be used for list keys,

Netizen Huang Hua Liang released an SQL Execution Plan 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/140212/22261W124-0.jpg "title =" 5.5.jpg "alt =" wkiol1l50mwdh3pu%7wzstzm0173.jpg "/> Q: The field TOP_TITLE_ID in table t is