Database Administrator

Goodbye to MongoDB, hello PostgreSQL Olery was founded almost five years ago. It started with the single product (Olery Reputation) developed by Ruby proxy. Over time, we began to work on a series of different products and applications. Today, our

Oracle 11g two nodes RAC build a single instance DG Process Problems and Solutions I used to build a single-instance database of DG, and it was quite simple. Later I came to the company's first project to build a DG for RAC. I was confident that I

MySQL 5.7 new feature: Generated Column (function index) MySQL 5.7 introduces Generated Column. This article briefly introduces the usage and precautions of Generated Column, and provides a quick and complete tutorial for readers to understand MySQL

How to handle archived log files and RMAN log files when using rman backupI went to a customer yesterday to deploy RMAN backup. when I ran the shell script, I was prompted that I could not find the archive log, because the customer only performed

Application of Naive Bayes algorithm in spam filtering, Bayesian Spam I recently wrote a paper on Big Data Classification (SPAM: My tutor reminds me every day), so I borrowed several books on big data from the library. Today, I read spam in "New

The listener. ora, sqlnet. ora, and tnsnames. ora configuration files are stored in the $ ORACLE_HOME \ network \ admin directory. 1. sqlnet. ora ----- is similar to the nsswitch. conf file of linux or other unix. It is used to determine how to find

1. The control file contains the data to be loaded. First, create a test table. SQL> showUser USERIs"ING" SQL>Create TableDept 2 (deptno number (10)ConstraintDept_pkPrimary Key, 3 dname varchar2 (20 ), 4 loc varchar2 (20 )); The table has

VBA: Introduction and examples of dictionaries, and examples of vba dictionariesBasic statement Sub dictest () 'Other detailed explanations for reference: http://club.excelhome.net/thread-868892-1-1.html' dictionary introduction' dictionary object

Environment Settings...First, check your physical memory size. We recommend that you increase the memory size by 1 GB.# Grep MemTotal/proc/meminfo Check whether your swap partition size meets the requirements. Generally, it is twice the physical

Use of the ios CoreData framework, add, delete, modify, and query context data, association between tables, 1-to-many, 1-to-1, predicate query, multi-table join, ioscoredata Here is just code, because the effect of inserting images into a blog is

Oracle 11g audit file and oracle11g audit file Audit: The audit option enabled by default for 11g. The default value of the AUDIT_TRAIL parameter is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in

Description of PK, NN, UQ, BIN, UN, ZF, and AI fields in mysql workbench, and workbenchuq When using mysql workbench to create a table, the fields include PK, NN, UQ, BIN, UN, ZF, and AI basic field type identifiers. They respectively mean: PK:

Can't connect to local MySQL server through socket '/var/run/mysqld. sock' (2), mysqldmysqld. sock I encountered a small problem connecting to the mysql database on ubuntu today. Can't connect to local MySQL server through socket '/var/run/mysqld.

What should I do if SQL Server executes dynamic SQL statements? The following describes the two correct ways for SQL Server to execute dynamic SQL. We hope that you can have a better understanding of SQL Server to execute dynamic SQL. Dynamic SQL:

Use Cases I remember when I was tuning for a company, the person in charge sent me a bunch of business T-SQL scripts, I am still calm in the face of massive scripts, although I do not understand the internal complex business, however, we have to

Typical use cases of MySQL MHA and typical use cases of mysqlmha1 Management node deployment location 1.1. Dedicated Manager server and multiple MySQL (master, slaves) servers Use a dedicated management server to manage multiple groups of MySQL

Mysql-related log summary and mysql Log Summary As an important means of querying problems, log should be recorded as much as possible for you to query some problems. MySQL has the following types of logs:Error log:-log-err Query log:-log Slow query

Oracle Database 10 Gb provides a secure and scalable foundation for Oracle Identity Management. The Oracle Internet Directory (OID) is implemented as an application running on the Oracle database at 10 Gb, this allows the OID to support several

In the process of using the iwms system, we often encounter data content replacement operations. Before telling you how to replace the data content, I suggest you first understand the data storage type of the SQL Server database: SQL Server Data

First, create a table emp1 with the same structure and insert some data for it. create table emp1asselect * from emp where deptno = 20; Update part of emp1 data update emp1set sal = sal + 100,comm = nvl(comm,0) + 50