Database Administrator

Simple Test of forall in PL/SQL I wrote a bulk collect article, but I made a simple example of bulk collect.In fact, it is not only bulk collect, but forall also greatly improves pl/SQL Performance.You can see the two figures below. In pl/SQL, the

Rebuild SCOTT users and SCOTT stories Oracle was first learned from the dept and emp tables under scott, and is still used to testing under scott. Sometimes to facilitate testing, scott users need to be rebuilt to provide a completely new test

Migrate Oracle database files to ASM Read navigation Migrate data files to ASM Migrate log files to ASM Migrate control files to ASM Migrate data files to ASM Database migration in the case of Database Consistency: Start the database to the

Oracle Database software standard edition has one restriction: Only one rman channel can be used, and only Lerman One limitation of Oracle Database Software Standard Edition: Only one rman channel can be used Restrictions in "Standard Edition"

About with (nolock) in SQL and withnolock in SQL What does NOLOCK in SQL Server mean? It is generally used in such statements: select * from t with (NOLOCK)Nolock is a non-lock query that can read the data locked by the transaction, also known as

Concepts of User and Schema in Oracle, oracleschema In database theory, database users and database models are not necessarily related. For detailed explanations of database models, you can find them

Mysql environment configuration query and Mysql environment Configuration Mysql environment Query 1. View All engines A) Show engines or go to information_schama to view the ENGINES table. 2. view the current user A) Select user () can be used

Linux system time synchronization, hardware and system time synchronization, Time Zone settings, linux time zone1. Time Synchronization (manual): date-s "22:13:30" hwclock -- systohc (indicating that the system Synchronizes time to the hardware

Sedna performs xquery query and sedna performs xquery There is a file book. xml: The Call Of WildJack London32.5$2015-7-6Wuthering HeightsEmily Bronte40$2015-7-5 Create a books database: [root@localhost xuzhina]#se_cdb booksCreating a database

Mongodb distributed cluster (3. sharding), mongodb ClusterOverview The above two blogs are about the mongodb cluster configuration and do not involve the distributed architecture. This blog is about the distributed architecture of mongodb, which

Mysql dual-machine Hot Standby Master/Slave configuration, mysql dual-machine Hot Standby Master/Slave ConfigurationReplication on mysql:Master/Slave.Master server is the production MySQL instance.Slave server is the java host (123.57.39 .*).First

Mongodb Study Notes 03. mongodb Study NotesMongodb Study Notes 03-query expression Not equal to, greater than, less ! =: Db. stu. find ({name: {$ ne: 'billvsme '}) name is not 'billvsme' >: Db. stu. find ({age: {$ gt: 18}) older than 18 >=: $

Access postgresql (using sbt) and scalapostgresql in scala Scala and SBT have been installed by default, and have a basic understanding of sbt, know how to build a project with sbt.Add dependency To use a postgresql database in scala, You need to

LIST type of Redis data type, list type of redis Data Type Web programmer blog: http://blog.csdn.net/thinkercode List type-Features List is a linked list structure. The main function is to push, pop, get all values in a range, etc. In the

Manual repair of fields added in the release and subscription for replication of SQL Server against schema changes Due to previous requirements, the replication architecture changes are prohibited, and even adding a field to the release will not be

Analysis of Database Connection Pool (2), analysis of Database Connection Pool In the previous blog, I briefly introduced the connection process and resources consumed by common databases, and briefly discussed the connection pool, in this

How to migrate mysql data files to a new hard disk partition, mysql hard disk partition The system adds a hard disk and mounts the new partition to the/data directory. The mysql data File directory is/var/lib/mysql. 1. Stop the mysql Service

Common Redis commands and redis commands 1 Create-store or not-View-delete Set name maojun; exists name; get name; del name; 2. serialization record Set name maojun; exists name; dump name; the client is logged out, and exists name and name still

Cause of SQL Text "** SQL Text Not Available **" in the Oracle ash Report: oracleash Guess: Why "** SQL Text Not Available **" appears in SQL Text in the Oracle ash report The HVR data synchronization software is being tested today. Due to the large

Troubleshooting of online MySql connection exceptions As a common database, Mysql is widely used in Internet systems. Some faults are their own bugs, and some are not. Here are examples of problems encountered in the past.Problem The problem was