Database Administrator

Oracle knowledge collection: monitoring and checking Oracle databases I sorted out some basic Oracle knowledge and shared it with you. 1. How to monitor and check Oracle databases Sqlplus '/as sysdba' Manually generate an oracle database

Modify Oracle RAC Database Name Briefly record some methods for modifying the name of Oracle RAC. 1. Close an instance [Oracle @ rac11g2 ~] $ Sqlplus/as sysdba SQL> shutdown immediate; 2. Back up the spfile File SQL> create pfile =

Comment lookup in infobright Data Warehouse The infobright Data Warehouse can compress and store a large amount of data in High-strength compression. The process of constant query is to decompress the data, of course, the detailed introduction has

Use SQL statements to query MySQL, SQLServer, all Oracle Database names and table names, field names, and mysqlsqlserver Query all database names and table names in MySQL Query all databases show databases; Queries all table names in a specified

A set of Mybaits result sets, a solution for nested List in Javabean, and a solution for mybaitsjavabean In such a scenario, as a writer, I have written many articles. If I abstract myself into an object, so how can I get my articles written by

Having clause details & execution sequence, having clause 1. The Having clause is used to process the query table structure. It can be used together with group by After grouping and can contain aggregate functions. 2. The Having clause can be used

HP-UNIX installation Oracle PHCO-40381, hp-unixphco-40381First, we need to identify the HP processor.View machinfo The product number of pa-risc is set to rp, and the product number of itanium is set to rx. Different products need to download

Computer Age 7th Journal published "Analysis System of One Network fund settlement of expressway in Guangdong Province Based on star mode of data warehouse", highway map of Guangdong ProvinceToday, I received the 2015 sample journal from the

MySQL entry, mysql entry classic This chapter describes the Relational Database Management System (RDBMS) of MySQL and the Structured Query Language (SQL) used by MySQL ). The basic terms and concepts that should be mastered are listed, and the

SQL string to Int type, SQL string int In general, SQL statements can be implicitly converted without strong conversion. It is really necessary to replace it with int type. Convert (int, @ str) Today we are talking about another situation,First

Redis persistence, redis Web programmer blog: http://blog.csdn.net/thinkercode Redis persistence Mechanism Redis is a memory database that supports persistence. That is to say, redis often needs to synchronize data in the memory to the disk to

ORA-01591: Lock pending Distributed Transaction Processing Solution, ora-01591 Transaction Processing On-site report has a function can not go on, background log error: java. SQL. SQLException: ORA-01591: Lock is pending Distributed Transaction

Error Code: 1318. Incorrect number of arguments for PROCEDURE company. new_procedure; expected 2, got, errorexpected 1. Error description 20: 27: 34 call new_procedure (20150112) Error Code: 1318. Incorrect number of arguments for PROCEDURE

Yesterday, someone asked the QQ group how to design the database structure in an infinitely layered tree structure with a large data volume of more than 10 thousand records. In fact, this is a common issue. The general practice is to have a pid

Installation files: Official Website http://www.mongodb.org/downloads Select the file to download from the system. 1. decompress the file. Decompress the compressed package, create a folder named mongodbon on the d Drive, and copy all the. exe files

OpenStack Trove will change the database management mode from five aspects (1) As a database-as-a-service framework for OpenStack, Trove lays the foundation for automated configuration and management of several major SQL databases and NoSQL

The internal replication function of MySQL is implemented between two or more servers by setting the master-slave relationship between them. One of them serves as the master server and the other as the slave server. I will discuss in detail how to

1. Migration Method Introduction: Exp/imp: This is also the most commonly used and simplest method. It is generally based on the application's owner level for export and import. Operation Method: Create the owner and tablespace in the new database,

When sorting, grouping and summarizing, and indexing are performed in the Oracle database, a lot of temporary data is generated. If there is an employee information table, the database stores the installation record creation time. If you use the

MySQL database performance optimization is the main core of this article, from database optimization design to specific operations. Good optimization can greatly improve the server performance. I hope this article will help you. 1. MySQL performance