Database Administrator

Oracle limits the number of connections and PROFILE of a user Today, a colleague called to limit the number of connections of a user, which can be achieved through the Oracle PROFILE file. 1. View resource_limit parameters: SQL> show parameter

TPCC-MySQL Benchmark Test TPCC-MySQL is a benchmark testing tool developed by Percona.Download TPCC-MySQL Yum install bzr-y Bzr branch lp :~ Percona-dev/perconatools/tpcc-mysql After the download, you can see the tpcc-mysql directoryGo to the

SetWholeKingdeeEAS DatabaseMove to another environment for development and testing: BackupOracle Database: (you can also PL-SQL through external tools) [Oracle @ rcno8 ~] $Sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Tue Nov 23 10:58:56 2010

Oracle functions for processing decimal digits ()1. Take the rounded decimal placesSelect round (1.2345, 3) from dual;Result: 1.2352. retain the two decimal places.Select trunc (1.2345, 2) from dual;Result: 1.23 Select trunc (1.2399, 2) from

For large databases, Oracle occupies a very large disk space, master the database users and tables that occupy a lot of disk space to kill, and increase the situation, you can easily maintain and expand the disk system in the future. The usage of

Oracle Data Guard synchronizes Data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to delete

Rman backup times: ORA-02396: exceeded maximum idle time, rmanora-02396 Rman backup times: ORA-02396: exceeded maximum idle time Reference Original:RMAN backup faling with ORA-02396: exceeded maximum idle time, please connect again (Doc ID 1446182.1)

GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again, ogg00868 GoldenGate process abend, error for OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again Reference

Oracle blocking (blocked), blocking Blocking is a common situation for DBAs. especially poor application design blocking can cause serious performance degradation until the database crashes. For DBA, it is necessary to know how to locate the system

Anyone who has been using MySQL O & M should be clear that online MySQL usually uses source code compilation, because this allows you to select the function to be compiled based on your own needs, although the MySQL source code compilation is quite

1 download the installation package download tar.gzWget http://download.csdn.net/detail/mchdba/75450372. Install the cmake Software PackageYum install cmake-y3 create account of mysqlGroupadd mysqlUseradd-g mysqlAutoreconf -- force --

1. float TypeThe float column type cannot be found by default. The precision must be specified,For example, numFloat,InsertTable (num) values (0.12); select* From table where num = 0.12, empty set.Num float (9, 7 ),InsertTable (num) values (0.12);

The environment used in this article is: win7_64 + Eclipse + mavenI. Preparations Download the java driver package Driver Pack: http://mvnrepository.com/artifact/org.mongodb/mongo-java-driver MongoDB http://www.mongodb.org/ Api:

PrefaceBodyPL/SQL(Procedure Language, Procedural Language) SQL 1999 a structured Language commonly used by major database vendors PL/SQL only supports Oracle databasesBasic syntaxMulti-line comment/**/single-line comment --PLSQL

Introduction to the high availability of a replica set The replica set achieves high availability through automatic failover. When the master node fails, the slave node can be elected as the master node, and this process is automatically performed

One-hot standby In the last two articles (MySQL backup and recovery for cold backup, MySQL backup and recovery for the real environment for cold backup), we mentioned the use of cold backup in the cold backup and real environment. From this article,

Experiments on ORA-60 deadlock   Create a table:SQL> create table tbl_ora_60 ( Id number (5 ), Name varchar2 (5) ); SQL> insert into tbl_ora_60 values (1, 'A '); 1 row created. SQL> insert into tbl_ora_60 values (2, 'B '); 1 row created. SQL>

When I was writing a stored procedure, I used the start time and end time to create a view. So I wrote a process like this: Procedure prc_CreateViewOBookTcert (p_startdate in date, -- start date of statisticsP_enddate in date) -- end date of

The previous article introduced how to extract the SCP transmission speed to the maximum extent. With this foundation, we can further use compression to accelerate the transmission speed. Only scp is used, and the transmission rate is about 90 MB at

In the past, I found that 11 GB of Oracle had this problem and had not been very concerned about it. When I closed the database today, I found that Oracle could not be shut down normally for a long time. The following error message is displayed when