Database Administrator

Oracle index Suppression Preface: in many cases of Oracle Database optimization, you can increase the database performance by adding indexes. However, in some cases, DBA cannot do anything about it, because all the indexes have been created, but the

Enable audit for a table in Oracle (audit) Oracle databases enable standard auditing using the audit_trail Parameter Its Parameters include the following: NONE: Audit disabled OS: The audit information is summarized in the system. For Linux, the

Solution to Oracle 11g ORA-00119 ORA-00132 When Oracle 11g is started in Linux, the following error is reported: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address XIANGDE_LISTENER There are

MySQL5.6 master-slave Replication (read/write splitting) configuration full version MySQL5.6 master-slave replication (read/write splitting) Tutorial 1. There are two ways to start master-slave replication from MySQL5.6: Log-based (binlog ); Based

How to view and delete a unique index in mysql How to view and delete a unique index in mysql. View unique indexes: Show index from mytable; // mytable is the table name. The query result is as follows: After a unique index is

MySQL batch SQL statement and mysql batch SQL statement MySQL supports batch processing to execute a batch of SQL statements. The following example shows how MySQL executes SQL statements in windows batch processing. Create table test (id int, name

Dba_hist_ SQL _plan, dbahistsqlstat I would like to express my gratitude for the help of elders who have prepared this article. The applicable oracle database version is oracle 10 Gb or later.   This view is important because one column in this view

Database design, database design toolsDatabase Design ER Model Entity-Relationship, Entity-link model. The graphical representation of this model is an erdiagram. 1. Use a rectangle to represent an object. 2. Use an ellipse to represent object

Differences between left and right connections in the database Differences between left and right connections in Databases Today, someone asked me a question: What is the difference between left and right connections in the database? If there are

[Translated from mos] mosasm How to reclaim the asm disk space Reference Original:How To Reclaim Asm Disk Space? (Docid 351866.1) Applicable:Oracle Database-Enterprise Edition-Version 10.2.0.1 and laterInformation in this document applies to any

[Translated from mos] Use asm to deploy ultra-large databases (10 TB to PB)-for oracle 10 GB and asm10tb Use asm to deploy super-large databases (10 TB to PB) Reference Original:Deployment of very large databases (10 TB to PB range) with Automatic

Using a case study to thoroughly understand 10046 trace-byte-level in-depth cracking, 10046trace -- Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/37840583 PM, 10046-byte-level in-depth cracking   To learn more,

Use resultMap to implement ibatis composite Data Structure Query (1. Multi-attribute query; 2. List query included in the attribute), resultmapibatis Take the order as an example (the order details include the basic information of the Order,

[Translated from mos] the solution for job cannot be automatically executed, mosjobSolution to job failureReference Original:Jobs do not execute automatically (Doc ID 309945.1)Applicable:Oracle Server-Enterprise Edition-Version: 9.2.0.4This problem

Optimize database indexes and database Indexes This article mainly describes how to create and use indexes. We will not go into details about why indexes are used, what benefits are brought about by indexes, and the classification of indexes, for

Install mysql-cluster 7.3.5-linux and mysqlcluster[Cluster Environment]Management node 10.0.0.19Data Node 10.0.0.1210.0.0.17SQL node 10.0.0.18 10.0.0.22 1. Add a mysql user # groupadd mysql# useradd mysql -g mysql 2. Install mysql-cluster

Oracle snapshot management, oraclesnapshotZookeeper ---- Manually create an oracle SnapshotBEGINDBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ --- Delete a snapshotFor more information about snapshots, see

[Data analysis Interview Questions] One interview question, my answer, and the answer to the data analysis interview questions I attended a data analysis interview with a company in Hangzhou this afternoon. I am familiar with some of the questions,

Mysql merges values of the same column. mysql merges values of the same column. I have the following query conditions: I want the final display Effect Merge group_name with the same id into one row. Implementation Method: add the keyword

How to restore the FlashBack Delete table by mistake in PLSQL flash? 1. SCN Concept After the Oracle database is updated, the SCN is automatically maintained by the DBMS to accumulate an increasing number. There are four SCN types in the Oracle