Database Administrator

RedHat build physical Data Guard My environment: Both machines are Red Hat Enterprise Linux Server release 5.4 Database Version: Oracle10g10.2.0 Install oracle software on the primary machine and create the database orcl Only the oralce software is

SQL database Problems and Solutions in OneMap configuration in Oracle Error ORA-00900: Invalid SQL statement, error: ORA--00942: Table or view does not exist after clicking OK Analysis: prompt is a printing function in Oracle. If you want to

Oracle Monitoring System Error Log Process -- Create a temporary table to store system error informationCreate table superflow (cust_id number (10), cust_name varchar2 (100), d varchar (50), error_info varchar2 (500), client_ip varchar2 (50),

Xtrabackup stream backup, incremental and compression Summary [Problem background] 1. databases with large MySQL files that need to be compressed. For example, in a 500 GB database, the xtrabackup backup file is GB, and then compressed and packaged

Changes in MYSQL source code compilation and MYSQL source code compilation For Mysql installation, the source code compilation method for mysql of different versions is different. 5.6.2 has changed from configure to cmake, related to the new

Unable to start MYSQL service "1067 unexpected Process Termination" solution-Summary and ultimate method, mysql1067 In the first step, follow the methods in Baidu's experience-MySQL download, installation, configuration, and use (win7x64) to install

Mysql timer and mysql scheduled task Mysql timer is a mysql event. In actual development, we sometimes need to perform some operations on a regular basis. Most people create a timer using the ScheduledExecutorService class. In this case, when big

Difference and advantages of timestamp, datetime, int type in mysql, timestampdatetime The difference between timestamp, datetime, and int types in mysql and int1. 4 bytes are occupied. after an index is created, the query speed is high. 3.

Ora-29250 small case, spfileora-29250 after modifying spfile in rac Environment Original Works are from the "Deep Blue blog" blog. Be sure to indicate the source when reprinting. Otherwise, you have the right to pursue legal liability for copyright.

How to deal with slow update ?, Slow update Processing? Slow update:1. What are the pctfree parameter settings of the table?2. Is the execution plan indexed or full table scan?3. How to Write SQL statements?4. Is update slow or is commit slow?5.

SQL split string, SQL split string /* The Delimiter is ',' */declare @ depid varchar (100) declare @ location intdeclare @ length int -- Sample string set @ depid = '2017, 13434, 34, 567,12, 9998, 'set @ location = 1 set @ length = 0 while @

Mysql technology insider InnoDB Insert (Insert) operation, mysqlinnodb What is the internal reaction of an innodb table after the client sends an insert command? This article will reveal this story to everyone. Of course, I am not very easy to

Common SQL Server statements and SQL Server statements Select * into A -- automatically generate Table A. The structure data of Table A is the same as that of Table B.From BInsert into A -- A must be created in advanceSelect * from B Insert

MySQL (8) ---------- MySQL thread pool summary (2), mysql Thread PoolThis article is a supplement to the previous article. It focuses on the following two aspects: one-connection-per-thread implementation and epoll usage in the thread pool.

Oracle uses a string-indexed two-dimensional array and an oracle two-dimensional array -Reference: http://www.oracle.com/technetwork/issue-archive/2014/14-sep/o54plsql-2245345.html-SAMPLE DATAStore name product salesA apple 3000A banana 2000B APPLE

Add, delete, modify, query, and modify objects associated with hibernate ------ add, hibernate ------This article serves as the study notes for the hibernate course for Ma soldiers at Beijing shangxue.com.In this section, we will look at the

Tracking exp with 10046 AND exp with 10046 I wrote a blog about why Oracle expdp is faster than exp. What is the principle? I learned from the official documentation. Now I am going to analyze the exp process through 10046. C: \ Users \

Hive Join and hivejoin Https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins LanguageManualJoins Join Syntax Hive supports the following table join syntax structure: Join_table: Table_reference JOIN table_factor [join_condition] |

Datazen Map Chart custom data and datazenchart Custom DataZookeeper This article describes how to associate data with Datazen map charts. We map the data in the database to the map.   First, view the data bound to the default map chart. The

A small problem with the auto-scaling feature of Oracle 11g partitions, oracle11g It is very convenient to use the automatic partition Extension function in Oracle 11g, but it also brings about a problem, that is, after the export and import, the