Database Administrator

Redis database (Elementary) Redis is an open-source non-relational database. It is written in C language and is a key-value storage system. It stores many value types, including string, list ), set, zset, and hash ). For example, we insert a data

Oracle constraints (constraints) affect the query plan, oracleconstraintsOriginal article: http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39asktom-096149.htmlHow constraints in oracle affect the query planIt is generally considered

Jdbc connects to the mysql database and executes the insert statement to obtain the self-increasing primary key value. jdbcmysql Package cn. baokx; import java. SQL. connection; import java. SQL. preparedStatement; import java. SQL. resultSet;

Oracle modifies session, processes, and oracleprocesses1. Check the values of the two parameters sqlplus/nologsql> conn/as sysdbasql> select count (*) from v $ session; here we can see the current session count SQL> select count (*) from v $ process;

Windows 7 64-bit installation of oracle 11g R2 process, windows711g1. Download Oracle 11g R2 for Windows: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.htmlThe package contains two packages:

Test System maintenance-different versions of SQL data import and export, SQL Import and Export During the maintenance of the examination system, the examination system (Backup) needs to be built on multiple servers to ensure the smooth conduct of

SQL Server --- process Deadlock Detection and removal, SQL Server ---SQLServer --- process Deadlock Detection and Removal Recently, I encountered such a situation in the evaluation system of a college. When the number of data centers reaches the

Oracle tips: drop table and purge, droppurge When operating on Oracle, we often delete a table. When a deletion error occurs, we want to restore the table and sometimes release the table space immediately after the table is deleted. The following

SequoiaDB notes, sequoiadb notesSequoiaDB notes In the past few days, I flipped through the SequoiaDB code and took notes. The correctness of the following content is not guaranteed (there must be something wrong)Personal View advantages The code

Oracle11g + CentOS6 + DG installation record, oracle11gcentos6Based on a practical operation record, this article describes how to use rman for Hot Standby to create a physical Active standby database of dataguard. In this way, the master database

MFC printing and mfc Printing Although more and more people are turning to C # For interface development, for a person who is used to the semi-object-oriented language C ++, the existence of MFC is still difficult. Recently, I am doing some database-

Oracle11gR2 + CentOS6.3 database installation, centos6.3 installation tutorial1. install necessary OS installation packagesWe recommend that you install the operating system to the maximum extent, because the impact of current hardware on the

MongoDB log rotation and mongodb RotationOverView MongoDB can use a standard method to rotate logs, that is, to obtain the current log and enable a new one. To achieve this, the mongod instance renames the current log file by adding a UTC (GMT)

SQL Server Query Optimization (test 02) parameter sniffing-Execution Plan Selection, sniffing execution plan Recently, I often see the word "parameter sniffing" and read several articles, so I tried to make a test to help my impression! Go to the

Question library of university platforms-no longer "dead", no dynamic Questions Library The university platform includes the examination system, permission system, basic system, evaluation system, and new student admission system. You are lucky to

ORACLE-007: Search for deleted data, oracle007 search for deleted data There are two types of table data to be deleted: delete and trunc. Trunc makes the data unrecoverable, while delete can also be searched and restored. If the data is deleted

[Oracle] export ledba27 add new tempfiles to the temporary tablespaces after recovery, oracletemporary In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored Control file by

Add 23 common MySQL query statements to favorites1. query numeric data:SELECT * FROM tb_name WHERE sum> 100;Query predicate:>, =, ,! =,!> ,! =,  2. query stringsSELECT * FROM tb_stu WHERE sname = 'Liu'SELECT * FROM tb_stu WHERE sname like 'Liu

In Oracle, how does one determine whether SQL is actually sorted? In Oracle, sometimes when you see the sort keyword in the execution plan, some people think that the sorting is actually not necessarily. You can experiment with the following method:

After the select any table permission is granted, the TABLE of the sys user cannot be accessed.SQL> show parameter dictNAME TYPE VALUE------------------------------------------------------------------------O7_DICTIONARY_ACCESSIBILITY boolean FALSE --