Database Administrator

The PL/SQL window is executable, and an error is reported when the execution in the stored procedure is executed. Recently, the test department encountered environment problems. We developed and run a program on our development side, but it was not

Move an Oracle Partition Table Moving a partition table is worth further consideration. If the partition table contains the lob field, the difficulty is increased.For normal tables, the move operation room is a matter of course, and Oracle provides

Dependency between Oracle query locks Note: This SQL statement can be used to query multi-session, non-select DML operations, and operate the locks caused by Table A... the relationship between sessions ~ ... Detailed comments of views/fields used

MongoDB map reduce, mongoDBmapreduce MongoDB map reduce usage Example: Res = db. runCommand ({Mapreduce: 'liveepguservisits ',Map: function (){Emit ({provice: this. provice}, {"data": [{"mac": this. mac}], visit: this. visitNum, userCount: 0

Install postgresql934 in source code and sql934 in source code0[Root @ pghost ~] # Uname-Linux pghost 2.6.32-431. el6.x86 _ 64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux[Root @ pghost ~] # Cat/etc/issueCentOS release 6.5

Oracle Performance Analysis 10: Re-indexing-common SQL and oraclesql The previous section describes the causes and methods for re-indexing. This section describes several common SQL statements and stored procedures.Query all invalid global

MongoDB permission and mongodb permission settings MongoDB does not set permissions by default, which is essentially different from mysql and oracle. When the parameter -- auth is added during startup, the permissions are started. The biggest

[Mongo] couldn't connect to server 127.0.0.1: 27017 at src/mongo/shell/mongo. js: L112, 201727017 Today, when mongo was started, an error occurred. My environment is Windows 7. E:\server>mongoMongoDB shell version: 2.4.5-pre-connecting to: testMon

GoldenGate performance tuning, goldengatetuning During ogg synchronization, we sometimes encounter very large tables. At this time, we can use multiple replicat processes to split them by the range parameter and apply them to the target database.

The last row of plsql cursor is duplicated.Let's take a closer look at the first Stored Procedure test01. Is there a problem? It seems that there is no problem, but it will actually cause repeated rows. test02 puts the exit when statement in the

Crsd. log: th_select_handler message repeated [ID 338693.1], handlermessage Crsd. log: th_select_handler message repeated [ID 338693.1]---------------------------Modified 29-JUL-2008 Type PROBLEM Status MODERATEDIn this

Docker init started, dockerinit # Yum install WgetHttp://fedora.mirror.nexicom.net/epel/6/x86_64/epel-release-6-8.noarch.rpm Yum-y install epel-release-6-8.noarch.rpm Yum-y install docker-io # Wget install Yum install-y libcgroup lxc Service

Oracle Basic Data Change Principle Analysis (redo and undo) -- oracle Core Technology reader I, redo -- oracle In oracle, we have made some update operations. How does the bottom layer of oracle flow? This is what we will explain in this article.

ORA-01548 in Oracle: active rollback segment '_ SYSSMU1 $' found, ora-01548_syssmu1 ORA-01548 in Oracle: active rollback segment '_ SYSSMU1 $' found Oracle Undo tablespace recovery (no backup) http://www.linuxidc.com/Linux/2014-06/103779.htm Undo

Unless TOP or for xml is also specified, the order by clause is in the view, inline function, derived table, subquery, xmlorder Error: Unless TOP or for xml is also specified, the order by clause is invalid in views, inline functions, derived

Picked Lamport scheme to generate SCNs, lamportscns Fault symptom: Database Node 1 fails to open the database instance after it is suspended and restarted. The warning log has no error. There is only one record: Picked Lamport scheme to generate

[Development must read] php and mysql Chinese garbled solutions, Address: http://www.phpthinking.com/archives/320 MySQL still has limited support for Chinese characters, especially for beginners. If Garbled text occurs, it will become a big

PHP displays mysql database content by PAGE and mysql by PAGE "; echo " "; echo " id "; echo " name "; echo " age "; echo " grade "; echo ""; while ($ row = mysql_fetch_array ($ result) {echo " "; echo " $ row [0] "; ec Ho " $ row [1] "; echo " $

Mysql obtains the current time and compares it with the time in the field a few days ago. mysql current timeDelete from zhongqiu WHERE caretatime The caretatime field is a time field.'Caretatime' timestamp not null default CURRENT_TIMESTAMP,-14 days

Practice: mysql 5.6 skips the specified transaction GTID and mysqlgtid   Show slave status \ G; Last_ SQL _Error: Worker 3 failed executing transaction '6c9da32f-handle: 1' at master log mysqldb01-bin.000001, end_log_pos 4541041; cocould not execute