Database Administrator

Oracle view the lock held by the object My colleague added a field to a table in the test database, prompting ORA-00054, resource busy. The table object lock is not released. Use the following SQL statement to check the locking status of related

The control file is successfully restored after the catalog is configured in Oracle. Besides, the configuration of catalog is as follows: 1: catalog Database:Export Oracle_SID = ezhoudg1> Create a tablespace in the catalog Database for

Oracle rman recovery to remote and remote The original Oracle database server uses rman to back up the entire database, and then restores the same database on the remote server. 1.1 original server backup database Step 1: view the database instance

Solve the problem of Chinese garbled characters stored in MySQL 5.5 and hibernate When using hibernate and mysql for data storage, you will find garbled characters in the database if you store Chinese characters. The solution is as follows: Change

Oracle cloud control 12c startup and Shutdown The entire installation of Oracle cloud control 12c is complicated. The installation path, logon password, port number, and many other configurations are confusing. This article describes how to obtain

Oracle left Outer Join tests For more in-depth left outer join, we did some tests. There are several forms of external join writing. We can track the final SQL conversion form through 10053. -- Initialize data Create table (Id number,Age

Use KeepAlived to build a MySQL high-availability environment Use KeepAlived to build a high-availability MySQL environment.First, set up master-slave replication for MySQL.Enable binlog on the Master node and create a replication account,Then

MySQL builds a replication environment with filtering The Organization is preparing to launch some new functions. These functions have nothing to do with the functions of the original production database module and are ready to create a new database

SQL transactions and instance demos Introduction Transaction. The English name is transaction. Is a logical unit in the Process of database management operations, composed of a limited operation sequence. In fact, this concept is well understood. A

MySQL 5.5 Master/Slave Configuration MySQL master-slave replication requires at least two Mysql services. Of course, MySQL services can be distributed on different servers or multiple services can be started on one server. (1) ensure that the MySQL

ORACLE10G is installed on Centos6.4 and oracle10gcentos6.4 Note: This installation is only limited to the installation of ORACLE10G on Centos6. for installation of other versions of the operating system, please refer to the official oracle

Experience 30 -- create a user in sqlserver and create a user in sqlserver When it comes to database security issues, you should create a new user to connect to the database without using sa. 1. log on.2. Security-Logon Name-right-click Create

[MongoDB] Configure a Windows Service for MongoDB, mongodbconfigure In this blog, I will mainly attach great importantance to how to create a windows service for mongodb. The method described in the next is referred from the official website of

Database management system, database Today, I summarized database and drew two diagrams. The following describes the learning knowledge based on my diagram. Figure 1 Figure 2 1. The database lifecycle is divided into three major stages: planning,

DBCP data source usage, dbcp Data SourceDBCP: DataBase Connection Pool1, the need for jar: commons-dbcp.jar commons-pool.jar 2. Copy the DBCP configuration file (dbcpconfig. properties) to the build path. 3. Create a class: DBCPUtil Dbcpconfig.

C3P0 database connection pool, Use the C3P0 database connection pool 1. Copy jar package: c3p0-0.9.1.2.jar c3p0-0.9.1.2-jdk1.3.jar c3p0-oracle-thin-extras-0.9.1.2.jar (oracle required) 2. Write the preparation file under the src directory:

Help! How to batch Delete the same segment of characters in a field in a database table !, Batch Delete How do I batch Delete AN01-1 strings in the Site_A field in a table? How does mysql batch remove the same part of strings under a field in a

WAS cluster series (4): Cluster Construction: Step 2: Install was nd software, cluster nd Click Start Installation Wizard, as prompted: Step by step, click "Next" to install the SDK. Pay attention to the following steps: (1) The sample is not

MySql database connection pool and mysql database connection 1.Traditional links(As shown below) Note: (1). the traditional method of finding DriverManager to connect is limited. (2). the traditional method of close () does not reuse the

ON, WHERE, HAVING, wherehaving ON, WHERE, and HAVING can filter data by limiting conditions, but their usage is different. Next we will analyze the differences among the three.1. ON and WHERE All queries generate an intermediate temporary report.