Database Administrator

Problems caused by Online usage of index creation in Oracle In the local test database, the original space is insufficient. As a result, a table is created with more than 6 million records and you want to create an index. The physical segment has

In Linux, Python calls MySQL (1) first install and start mysql to determine the location of mysql/lib. (2) install the setuptool (online or offline ). (3) install the Mysqldb module. MySQLdb is a Python connection module to MySQL. The following

Oracle job automatic task Practical Guide As a scheduled Oracle task, Oracle jobs are between crontab at the server level and applications (such as scheduled tasks of java spring). The database layer has important value for data processing.The

Oracle performance optimization is sometimes so simple _ index Performance optimization is sometimes so simple I. Overview Recently, the CPU of a system (aix6.1 + Oracle10.2.0.5 RAC) reaches every five minutes. This system is a monitoring system and

Troubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart) The following three methods are used to handle abnormal shutdown of MySQL Slave.You can also use the pt-slave-restart command of percona-toolkit.The

Oracle Database RAC 11.2.0.3 for AIX6.1TL7 installation records Installing Oracle RAC on the AIX platform is a pitfall. I verified this again today because there are too many bugs! Record the problem because there are too many bugs! We strongly

Building a high-performance database cache for redis master-slave Replication 1. What is redis master-slave replication? Master-Slave replication. When a user writes data to the Master, the data file is sent to Slave through the Redis Sync mechanism,

Adjusting the size of oracle sga causes ORA-00851 and ORA-00844 errors, sgaora-00844Today, I adjusted the sga size. As a result, the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope =

How to obtain the variable value bound to an oracle SQL statement, oraclesql When diagnosing SQL Performance problems, we sometimes need to obtain the actual value of the variable it binds, and then bring the actual value into the SQL statement, use

Simple use of mybatis and simple use of mybatis Package to be used: (here is only one version, other Baidu) Mysql-connector-java-5.1.6-bin Mybatis-3.2.2 First look at the project directory: Configuration File mybatisconfig. xml: -->

MySQL group data, mysql GroupFor Grouping comprehension groups, see the next example. First, we print the products table as follows:From the table above, we can see that each vendor has several products. How can we count the number of products in

[Translated from mos] despite specifying a destination, the asmcmd cp command still creates a file under + DATA/ASM, mosasmcmdDespite specifying the destination, the asmcmd cp command still creates a file under + DATA/ASMReference Original:ASMCMD Cp

[Translated from mos] use the asmcmd cp command to move the datafile from the file system to the asm disk group-for 11gR2, asmcmd11gr2Use the asmcmd cp command to move the datafile from the file system to the asm disk group-for 11gR2Reference

Analysis of slow expdp backup and expdp backup -- Export Problem Analysis-- Two time Statement Analysis: This statement exports only 4,059,292 of the Data. After 10 minutes, the data does not continue to be exported.Snap Id Snap Time Sessions

[Translated from mos] The asm archive path is full, mosasm The asm archiving path is full. Reference Original:ASM Archive destination is full. (Doc ID 351547.1) Applicable:Oracle Server-Enterprise Edition-Version: 10.1.0.2 to 11.1.0.7This problem

MySQL summary data and mysql SummarySummary data sometimes operations on a data table are not the data itself, but the summary of the data in the table, such as the average, maximum, and minimum values of a column of data. MySQL provides functions

Common SET commands in ORACLE and common SET commands in ORACLEZookeeper 1 SET TIMING ON Description: displays the SQL statement running time. The default value is OFF. It is used in SQLPLUS and the time is accurate to 0.01 seconds. That is, 10 ms.

Nested use of insert and select in mysql, mysqlinsert How to combine fields from multiple tables in mysql and insert them into a new table using an SQL statement. The specific situation is: There are three tables a, B, and c. Now we need to query

Thoroughly understand oracle Standard Quantum queries and oracle Standard Quantum queries Oracle scalar quantum queries and user-defined functions are sometimes more convenient to use, and developers often use them. It doesn't matter if the data

DRP Oracle_11g database installation, drporacle_11g I don't know if you are confused like this or that when installing the Oracle database. Today, I will take a look at the installation process of the Oracle database as a summary to facilitate