Database Administrator

MySQL master-slave replication case Working principle diagram: Principle of master-slave replication:It can be divided into synchronous replication and asynchronous replication. In the actual replication architecture, most of them are asynchronous

Mysql. h cannot be found in linux (mysql. h cannot be connected), and linuxmysql. hWrite a C language program connect1.c to establish a connection with the MySQL database. On the command line, enter: gcc connect1.c-o connect1.exe-I/usr/include/mysql-

Oracle442 Application Instances ---------- initialize parameter files and oracle initialize parameter files ---------------- Initialize the parameter file --------------------Before 9i, the initialization parameter file used by oracle is pfile. 9i

Impdp when encountering ORA-31693 & ORA-31640 & ORA-19505 & ORA-27037, impdpora-31693ORA-31693 & ORA-31640 & ORA-19505 & ORA-27037An error occurred during impdp:Additional information: 3.. Imported "HQ_X1". "T_XX130901": "SP15" 13.99 KB 0 rows..

Oracle SQL optimization 2 and OracleSQL optimization 2After receiving an SQL statement submitted by the developer, it is slow in high concurrency and can be optimized:This SQL statement is used to perform Left join on another table. First, let's

Linux lsb_release command, linuxlsb_release About the lsb_release command in linux [root@lei1 ~]# lsb_release -aLSB Version: :core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarchDistributor

Scenario and processing method of ora-01653 tablespace expansion failure, ora-01653 Processing Method Process of generating ora-01653 tablespace expansion failure: DBF is placed on the E disk and the E disk has only 200 M remaining. -- 1. Create a

MySQL (1) ---------- data type, mysql ----------Data Type Note: The following content is applicable to MySQL and later versions. MySQL has many data types. Selecting the correct data type is crucial for achieving high performance. This article is

MySQL (2) ---------- storage engine, mysql ---------- What is the storage engine?Data in MySQL is stored in files (or memory) using different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking

Understanding of listening for static registration configuration, listening for static Configuration   Global_dbname In the Listener. ora configuration file can be configured at will; SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora1

One SQL Optimization for Mysql (2) and one SQL Optimization for mysqlAfter development, I checked my adjustments and found that the index I created was actually created in another test database (Test Database 2). Why is the test database 2 still

[Translated from mos] Which linker and compiler are used when relink Oracle software is used ?, Relinklinker Which linker and compiler are used when relink Oracle software is used? Reference:Required linker and compiler locations (Document ID 1012798

Use MySQL in Linux -- forget the root password and modify the default MySQL encoding, mysqlroot Overview: This blog will not explain or explain MySQL syntax any more. If you want to know or be familiar with MySQL, Please study it on your own Baidu

Implementation of WEBSERVICE and ebsdbws through DBWS package in Oracle EBS interface developmentIntroduction In the 9i era, Oracle released an extended package to support PL/SQL access to Web Services. In Oracle 10 Gb, this feature became more

[Oracle] First Trial of Oracle and first trial of oracle I don't know how much you know about Oracle? Is it just to the extent that it can be used. In this case, I will follow my steps to learn more about Oracle and unveil the secrets of

MySQL programming on linux (V): MySQL permission management and mysql permission management[Copyright statement: respect originality. For reprinted content, Please retain the Source: blog.csdn.net/shallnet. this document is only intended for study

MySQL uses cmd to query Chinese garbled characters and mysqlcmd to query garbled characters When viewing the MYSQL database table, CMD finds that Chinese data cannot be inserted and the Chinese characters are garbled. Method: Find the my. ini file

Create the PSU 11.2.0.3.8, and then the database, 11.2.0.3.8psu. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24: mi: ss'; Session altered. SQL> select created from v $ database; CREATED --------------------------------------- -------------

RecycleBin, oraclerecyclebinSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionSQL>!

How can we find the 'library cache pin' In the RAC environment to wait for the Blocker of the event )?, Racblocker How to find the 'library cache pin' In the RAC environment and wait for the Blocker of the event) ReferenceHow to Find the Blocker of