Database Administrator

Oracle proposes to use G1 as the default Garbage Collector for Java 9 Oracle is considering including JEP 248 in Java 9's JEP list, that is, using G1 as the default Garbage Collector in server configuration. This decision has sparked some debate in

Oracle 11g rac crs disk recovery after loss I. Overview In order to facilitate the test of related problems, I set up a RAC environment on the local machine. However, after opening the environment yesterday, I found that RAC could not be started.

Impdp gets stuck, DW waits for library cache lock, impdplibraryMy colleagues reported that impdp was stuck in the SCHEMA_REPORT/TYPE/TYPE_SPEC step and did not respond after more than one hour,Check the v $ session:Select program, sid, event,

Mysql transaction on the third day, mysql transaction on the third dayACID A: atomicity: either full submission successful or full failure rollback C: consistency is from one consistent state to another. This means conservation of energy.Some

What is the difference between indexes in MyISAM and InnoDB? myisaminnodbTwo small tables, item and category: CREATE TABLE `item` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `category_id` mediumint(8)

How to apply a key-value storage database or an embedded key-value storage database in embedded products [Disclaimer: All Rights Reserved. You are welcome to reprint it. Do not use it for commercial purposes. Contact mailbox: armink.ztl@gmail.com]1.

NoSQL database overview and its comparison with SQL syntax, nosql overview SQL syntax Abstr:] HBase is a highly reliable, high-performance, column-oriented, and Scalable Distributed Storage System. It is also one of the well-known NoSQL databases.

Mongodb distributed cluster (4. Integration of shards and replica sets) and mongodb ClusterOverview The previous three blogs talked about mongodb's distribution and clusters. The first type of master-slave replication is almost useless, which makes

Database Review 11-relational model and paradigm, and database Review 11 paradigmDatabase review CH11 relational model and paradigm 11.1 Relational Model Design The Schema is the logical structure and feature description of all data in the database.

Beckham _ mysql table creation and column attributes, and Beckham _ mysql column attributesMysql table creation and column attributesBrief:I. Table Creation PrinciplesIi. Detailed column attribute descriptions  I. Table Creation Principles Table

Getting started with oracle database data query: oracle Data Query 1. perform operations on data using arithmetic expressions during the Query ProcessThe student table structure is as follows: The last salary represents the monthly salary of each

Principles and usage of MySql Indexes Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankakaI. Index Introduction An index is a structure that sorts the values of one or more columns in a database

Mongodb Study Notes 05 and mongodb Study NotesEnable authentication Mongod does not have the permission to start by default. You need to specify-auth to start, or set security. authorization to "enabled" in the configuration file"Create user Db.

Oracle sequence reset, oracle Sequence Question 1: How to reset the oracle Sequence After the oracle sequence is created, if you want to reset the sequence from 0 to 1, you can use the following stored procedure: Create or replaceprocedure

Foreign key constraint columns are not indexed, resulting in a large number of library cache pin/library cache locks and librarypinThe foreign key constraint column is not indexed, resulting in a large number of library cache pin/library cache locks.

MySQL starts multiple instances and MySQL starts instances.Database Configuration Generate a database file set in the mysql main directory mkdir data_3307mkdir data_3308mkdir data_3309 Configure the database in the mysql main

Update and redoupdate in redoSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionSQL>! Uname-Linux

Oracle442 Application Instances ---------- overview file, Overview Design Manual instance ------------------------ Brief Description :---------------------------------In order to rationally allocate and use system resources, the Oracle system puts

Normal database hang is disabled. normal database hang To avoid problems caused by abnormal shutdown, we have a test database that uses shutdown normal to stop the database. The result is that the hang is very common. Operation Sequence:1. shutdown

Redis client protocol parsing, redisprotocol On the official website, visit http://redis.io/topics/protocolto describe the rediscommunication agreement.For the following reasons, I want to parse the redis client protocol: 1. Be familiar with