Database Administrator

Oracle 11g RAC remote database login time and OS time difference 16 hours solution Help colleagues install the RAC database of Oracle 11.2.0.4 for project stress testing. The operating system is red flag server 3. Today, my colleague suddenly called

Getting started with Linux: Create a MySQL database using the command line Q: On a MySQL server running somewhere, how can I create and install a MySQL database through the command line? To create a MySQL database through the command line, you can

Full and incomplete Oracle database recovery and user management Backup Recovery Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the latest status, including all submitted data changes until the

MongoDB learning notes 01 MongoDB installation and use, mongodb learning notes Recently, due to work needs, I began to contact mongodb, so I began to study mongodb. The first step of the study was naturally from installation and use. there will

SQL server calculates the value of a field in the database, removes duplicate data, and SQL server Sometimes, some duplicate data exists in the database, but we want to calculate the value of a field, and we need to remove the duplicate data ,: In

Clob is saved as a local xml file. After modification, it is uploaded. clobxml I wrote a small program with my friends over the past two days. The functions are as follows: First, save the database clob as a local xml file, modify the xml file, and

Report development instance-dynamic multi-level KPI drilling report (I), multi-level kpi In report projects, there are sometimes dynamic hierarchical reports that require hierarchical drilling, making development more difficult. This document

MySQL loads the JDBC driver and mysql loads the jdbc driver. First, install the MySQL database. MySQL5.5 is installed. The installation steps are not described here. Please note that if the installation process stops at the start service and cannot

PostgreSQL tutorial (16): System View Details, postgresql View I. pg_tables: This view provides access to useful information about each table in the database. Name Type Reference Description Schemaname Name

Database Tuning tutorial (4) Explain performance analysis command, tuning explain In the previous chapter, we learned how to find slow queries and record statements into logs. How can we know where statement problems occur after slow queries are

What is the difference between Redis and Memcached? redismemcached Salvatore Sanfilippo, author of Redis, once compared the two memory-based data storage systems: The specific reason for the above conclusion is as follows: 1. Different data types

MongoDB Web management interface Mongo-express introduction, mongodb Table DesignMongo-express Mongo express is an open-source MongoDB Web Management Interface Based on Node. js and express. Github address:

ORACLE 11G manual database creation, oracle11g manual database creation  Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Stored Procedure-[Niuke news publishing system], News Publishing System1. What is a stored procedure? Definition: Stored Procedures (Stored Procedure) are used in large databases to store commonly used or complex tasks in advance with SQL statements

Test System maintenance-overall & details, test system maintenance overall The preliminary work for exam system maintenance has been completed successfully! What makes people feel most successful is that there is no problem in the entire examination

After mysql is uninstalled, the mysql service is still in progress and the read description fails. Error Code 2 and mysql error code First, I used 360 software manager to uninstall mysql5.5. After I uninstalled mysql, I deleted the mysql

MongoDB collection document creation, modification, deletion, and query command summary, mongodb modification and Deletion Install mongodb in windows. Start it. Previous Article: mongoDB Installation Details 1. log on to view the collection

MySQL series: innodb source code analysis-redo log structure, mysqlinnodb In innodb Engine implementation, a redo log system is built to ensure transaction persistence. Redo log is composed of two parts: the memory log buffer and the redo log file.

Repeat A Critique of ansi SQL Isolation Levels, critiqueisolationA Critique of ansi SQL Isolation Levels1. Published on April 9, 1995.2. SQL defines four isolation levels by symptom (phenomena), but it is too different from the actual system.3. SQL

Mongo/mysql, field Add "-00", mongo-00========================================================== ================================= Phil-PROD-20141212, add "-00" ========You need to modify problematic data (batch) of online dianfu Bao data and easily