Database Administrator

Oracle 11g update PSU detailed steps Oracle releases the latest patches every quarter. For production O & M personnel, regular system upgrade and patching are indispensable in daily work. Compared with the previous versions, Oracle patching has

Use local indexes to improve PostgreSQL Performance You may not know that PostgreSQL supports partial indexing of table data? Its advantage is that it can accelerate the reading speed of the indexed data without additional overhead. the best way is

PL/SQL Developer log on to Oracle 12c After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note: 1) install Oracle 12c 64-bit :

MongoDB query, index and aggregation, MongoDB, and index aggregation Initialize the mongodb Database > Use dengswitched to db deng> db. createCollection ("jingdong") # No parameter {"OK": 1}> show collectionsjingdongsystem. indexes> userdoc1 =

Convert data in Excel into SQL statements and convert data into SQL statementsIf the excel table contains three columns of data: A, B, and C, and you want to import the data to the users table of the database, the corresponding fields are name, sex,

Oracle Database migration-basic and oracle database migrationOracle Database migration-Basics As a developer, We must master database knowledge. However, the company's database is maintained by a dedicated DBA. Generally, we provide an environment

Possible MySQL server UUID duplication for server, uuidduplication This event occurs during mysql enterprise monitor monitoring. The Topic: Possible MySQL server UUID duplication for server event appears. From the description of this prompt, it

Redhat 6.4 install ORACLE11R2 and run root. sh to report the following error: "libcap. so.1: cannot open shared object file", oracle11r2root. sh 1. system environment: Redhat 6.4 Enterprise Edition Oracle11.2.0.2 RAC + ASM 2. error

SQL is required. Note: Chapter 1 Join a table. SQL is required.12.1 connections One of the most powerful functions of SQL is to join a table during execution of data queries.12.1.1 relational table The appearance of the same data multiple times is

Correctly install the SQL server database and SQL server database-IIS function requirements (warning)MessageIIS functional requirementsMicrosoft Internet Information Service (IIS) is not installed or disabled. Some SQL Server functions require IIS.

Path to mathematics-sas memo (9), path to mathematics-sas memo View Libname saslib "k: \ sas "; DataSaslib. testview4/view = saslib. testview4; Set saslib. test4; Run; Proc printData = saslib. test4 noobs label; Run; Proc SQL; Select testview4.id

[Translated from mos] How To restore database and mosrestore when backup of control files is lost How can I restore the database when the backup of the control file is lost? Source:How to restore database when controlfile backup missing (Doc ID 14387

Stored Procedure-[Niuke news publishing system], News Publishing System1. What is a stored procedure? Definition: Stored Procedures (Stored Procedure) are used in large databases to store commonly used or complex tasks in advance with SQL statements

An access troubleshooting-TNS-03505, ORA-12154, TNS-12560, dynamic registration, firewall, tnsping tracking, tns-03505tnsping To access the database through Oracle Net, You need to configure the listener and tnsnames. ora. Next, you will encounter a

Mongo/mysql, field Add "-00", mongo-00========================================================== ================================= Phil-PROD-20141212, add "-00" ========You need to modify problematic data (batch) of online dianfu Bao data and easily

Parallel Computing of relational algebra and parallel computing of relational algebra The parallel execution of SQL queries has been extended from the learning of Dremel and Impala, so I took this opportunity to learn more about the parallel

Explore Oracle Database Upgrade 5 PSU11.2.0.4.3 rollback 11.2.0.4.0 and oracle Database UpgradeExplore Oracle Database Upgrade 5 PSU11.2.0.4.3 rollback 11.2.0.4.0   1. Enter the PSU directory and run opatch rollback.   [root@db01~]# su -

Solve a deadlock problem in mysql, and solve a deadlock in mysql Here we are talking about innodb deadlocks! I have found a lot of other commands on the Internet to view the deadlock information. This can be used later: Show engine innodb status;

SQL statement of one of the IT Ninja Turtles-connecting all values of the same field, Ninja Turtles SQL Oracle can use SYS_CONNECT_BY_PATH string to aggregate functions: select ltrim (MAX (SYS_CONNECT_BY_PATH (productname, ','), ',') AS

Expanded group by for report development and expanded group by for reports In practical use, for example, in a data warehouse, multi-dimensional analysis of data is often required, not only the results of standard grouping (equivalent Group by), you