Database Administrator

Keep these three things in mind and never put them in the database. I have already said in many speeches that the best way to improve your system is to avoid "stupid things" first ". I am not saying that you or the things you develop are "stupid",

An Application of MySQL to compress tables 1. Set server ParametersInnodb_file_per_table = ONInnodb_file_format = Barracuda 2. Create or modify table parametersAlter table sod_song_log_2014_10_12 row_format = compressed key_block_size = 8; The

A bug about database restart in Oracle The drop database operation is a fatal operation in Oracle. This operation has been experienced in the test environment and will completely delete data files. Therefore, this operation is very sensitive but not

Oracle 11 GB is imported from instance 1 full database to instance 2 on the same Linux Server Export command in the early stage: [root@powerlong4 ~]# su - Oracle[oracle@powerlong4 ~]$ export ORACLE_SID=pt1;[oracle@powerlong4 ~]$ expdp

PostgreSQL date calculation function usage PostgreSQL date calculation function usage I. connector in each data SqlServer connector: + (plus sign) Sqlite connector:. (point) PostgreSQL connector: | (OR) II: Today, when I was computing data in

MySQL Horizontal Split (Reading Notes)1. Introduction to horizontal split In general, a simple horizontal split mainly refers to distributing a table with extremely ordinary access to multiple tables according to certain rules of a field. Each table

Merge fields with the same mysql content into one method. mysql Fields The data taken from the two tables inline. The category_name field has the same content. to merge fields with the same content, add the amount field to the following table.

Use API to create an AR credit notification and an apiar credit notification DECLARE -- 8000000063 l_dummy varchar2 (240); l_customer_trx_id percent % type; l_line_credits_flag percent % type; l_line_amount number; l_freight_amount number: = 0;

Oracle converts numbers to formatted strings, oracle strings Problem description If oracle stores number (0.00) data, the value 0 indicates 2.1, the value 2.10 indicates 3.88, and the value 3.88 indicates,If the corresponding information is taken

MySql char and varchar, mysqlvarcharDifferences between char and varchar in MySql Char is a fixed-length type, and varchar is a variable-length type. Their differences are as follows:1. in a char (M) data column, each value occupies M bytes. If the

Oracle obtains the year, month, and date list of a certain period of time, and oracle year. Get date list: SELECT TO_CHAR (TO_DATE ('2017-10-01 ', 'yyyy-MM-dd') + ROWNUM-1, 'yyyymmdd ') as daylist from dualconnect by rownum Obtain the month

Oracle Learning (13): Data Dictionary, oracle dictionaryThe data dictionary structure includes:-basic table: Description of database information, which can only be modified by the database server-User table: User-Defined tableData Dictionary naming

Static synchronization configuration process of OGG "Loading data from file to Replicat" table data, loadingreplicat Static synchronization configuration process of OGG "Loading data from file to Replicat" table data 1. mgr Process GGSCI (lei1) 3>

[Solution] solve the Mysql Character Set Problem and solve the mysql Character Set Problem. [Author]: kwu Solve Mysql Character Set Problems 1. Add the following content to vi/etc/my. cnf: [Client] port = 3306 socket =/var/lib/mysql. sock

Mysql user permission management and mysql permission management [Author]: kwu Mysql user permission management 1. Modify the root user name and password Set password for 'root' @ '%' = password ('123 ');% Indicates all IP addresses. The

Data cleansing Note: determines whether it is a numeric function. Note Function Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to

Note the following when using the OGG "Loading data from file to Replicat" method: The replicat process is a front-end process and the oggreplicat Note the following when using the "Loading data from file to Replicat" method of OGG: The replicat

Mysql time operation functions and stored procedures, mysql function stored procedures Because the business needs to collect a batch of data, mysql time operation functions and stored procedures are used, and the problem has been basically solved.

Oracle EBS R12.2 how to change the APPS password, r12.2apps Whenever you use FNDCPASS or AFPASSWD to change the APPLSYS password, youMust also perform the following actions. Important: These steps must be carried out on the run file system. Shut

Principles and cases of gc buffer busy acquire and gc buffer busy release, acquirerelease Yesterday, there was a database CPU 100% problem in the official environment. The database had 128 CPUs, GB of memory, and the power series. The database was