Database Administrator

Implement MySQL database backup in Java In my spare time, I would like to summarize how to back up MySQL databases using Java: Import java. io. BufferedReader;Import java. io. File;Import java. io. FileOutputStream;Import java. io.

Six flashback technologies in Oracle, flashback The Flashback technology is based on the content in the Undo segment, so it is limited by the UNDO_RETENTON parameter.To use the flashback feature, you must enable automatic undo tablespace

Use mysqldump to export a database Mysqldump is a client program used by mysql to store databases. It mainly produces a series of SQL statements that can be encapsulated into a file. This package contains all the SQL commands required to reconstruct

Configure the NIC Bonding for the RAC Private Network In the installation and deployment process of RAC, it is not just a simple installation. The possible single point of failure (spof) should be considered during the installation process. The most

Configure Oracle ASMLib and disk multi-path on Linux Configure Oracle ASMLIB and multi-path Disks The following documents describe how to use Oracle asmlib to access a multi-path disk on the linux platform, no matter which multi-path software you

How to design a MongoDB Data Model Effective data models serve applications. The key issue in the design architecture is whether the document model is applicable to embedded models or references ). Embedded Data Model (Embedded Data Models) In

[Self-examination] database system principles (iii) -- Summary after the examination, the principles of the Database System I feel that the database book is particularly useful. Some of the knowledge is not very understandable before the exam, so

In sqlplus, how does one save all your operations and Result Records to your specified file? [In sqlplus operations, we often want to record the SQL statements we write and modify the log or result information] [First] You must connect to the oralce

Oracle queries and compiles data dictionaries, and oracle compiles dictionaries If you need to write a data dictionary during project delivery, you can use the following method to first run a line-by-line SQL statement. Select. TABLE_NAME AS table

Oracle array, oracle Defines an array of 5 strings. Type str_array is varray (5) of varchar2 (30 ); V_str_array str_array: = expr_key_array ('A', 'bb ', 'cc', 'dd', 'ee '); For I in 1 .. v_str_array. count loopDbms_output.put_line (v_expr_key ); End

Oracle control file multiplexing and oracle control multiplexing 1. Control File multiplexing 1. show parameter control-- View Control File InformationShow parameter spfile-- Check whether spfile exists.Create pfile from spfile;-- Generate

Database Table field data segmentation Sometimes, to reduce the number of stored records, multiple records may be merged into one display. In this case, the other fields recorded in the table are the same, and only one field is changed. For example,

Oracle connection method: oracle connection In general, Join methods include: Nested Loops, Hash-Join, Sort Merge Join, and Cartesian Join (Merge Join Cartesian ). 1. Nested loop join (Nested Loops) Nested loops include the concepts of External

Practice: mysql 5.6 replication latency monitoring, mysql5.6 # Repdelay. sh #! /Bin/sh # ocpyang@126.com # view the replication delay specific event # set mysql slave = root MYSQL_PASS_MASTER = 'Password' MYSQL_HOST_MASTER = 192.168.2.188MYSQL _

Steps and solutions for importing MYSQL database structure in PowerDesigner We are using PowerDesigner today and want to import the MySql table structure to PowerDesginer, Follow these steps: 1, first of all to ensure that the machine installed

Oracle Technical Summary, oracle Summary Http://www.cnblogs.com/jimeper/ Http://blog.csdn.net/dragonxiangfu Http://www.boobooke.com/bbs/thread-272667-1-1.html Summarize the advantages and disadvantages of MySql, Mssql, and Oracle 1. The largest

Mysql installation on linux II (mysql source code installation), mysql source code1. Download the corresponding mysql installation source packageAddress: http://dev.mysql.com/downloads/mysql/5.1.html2. If you have previously installed mysql,

Oracle histogram, Histogram Histogram when the data distribution of a column is uneven, in order to allow CBO to generate the best execution plan, we may need to collect a histogram for the table. The maximum number of buckets in the histogram is 254

SQL Execution time, SQL Execution Enable SQL Execution time statisticsSet timing on;   Check whether SQL statements with long execution time exist.Select a. sid, B. SQL _textFrom v $ session a, v $ sqlarea BWhere a. SQL _hash_value = B.

GoldenGate Lag For Huge Insert, goldengatelagThe customer's ogg was delayed for about 8 hours the other day, so I tracked it with logdump: View the Process status:Send extsa staus EXTRACT ZBDBA (PID 2269368) Current status: Recovery complete: