Database Administrator

CSS initialization in non-ASM of a single instance is waiting for event resolution Environment Description: Oracle 11.2.0.4 Single Instance Operating System: Microsoft (R) Windows (R) Server 2003 Enterprise x64 Edition The TOP wait events in the

Comparison of PostgreSQL database backup and recovery technologies There are three completely different methods to back up PostgreSQL data: SQL dump File System-level backup Online backup I. SQL dump The pg_dump application tool is used to

Oracle 11g password expired locked reporting ORA-28000 the account is locked I. Reasons for triggering this error and Related Factors It is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle 11g by default. in Oracle 11g,

Summary of the new features of Oracle 12c on business impact (1) 1. invisible fields In Oracle 11g R1, Oracle introduces some good enhancement features in the form of invisible indexes and virtual fields. Inherit and develop the former, and

Deploying MariaDB Galera Cluster architecture in CentOS 7.4 Mariadb galera Cluster installation:Operating System: CentOS 7.4Number of clusters: 3 nodesHost information: 192.168.153.142 node1 selinux = disabled firewalld disabled192.168.153.143 node2

Upgrade _ Oracle graphical upgrade (dbca database creation after upgrade)-upgrade 10.2.0.1.0 to 10.2.0.5.0 and dbca10.2.0.5.0 **************************************** ******************************** ************** Original Works are from the blog

Implement RowNumber () Over (Partition by) and qlikviewrownumber in SQL Server in QlikView This is often the case when field A has many duplicate values, but the values in field B are unique After grouping by field A. Therefore, SELECT, when field B

Summary of Oracle database architecture, oracle Architecture   Oracle DB Architecture An Oracle DB server consists of one Oracle DB and one or more database instances. An instance consists of a memory structure and background processes. Whenever an

Kettle series tutorials 1. kettle series tutorialsIntroduction to kettle Kettle is an ETL (Extract, Transform and Load extraction, conversion, and loading) tool. It is frequently used in data warehouse projects. kettle can also be used in the

Repeat the library cache lock wait event in Oracle 11 GB, 11 glibrary From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during

Sequoiadb test experience Series 6-Java Development 3 and sequoiadb 6 In the previous note, operations such as delete, update, and query in the set are updated. Try SequoiaDB's cluster operation this time. This includes the creation and deletion of

PostgreSQL code analysis, query optimization, canonicalize_qual, postgresql Here, we have finished sorting out the part of the regular expression. The reading order is as follows: I. PostgreSQL code analysis, query optimization,

SQL server trigger, stored procedure operation remote database insertion data, solve the existing problems on the server, server trigger I recently created a small project, which is not very complicated. I need to back up some data of a database to

Using PLSql to connect to Oracle Reports error ORA-12541: TNS: No listener, plsqlora-12541 Many times oracle services are disabled to optimize our startup items. However, when we use PLSQL to log on to oracle after restart, no listening program will

1. Create groups and users In linux, open the terminal and log on as the root user. Enter the following command: Groupadd dba // Add the dba group useradd-g dba-m oracle // Add the username as oracle and add the user to the dba group passwd oracle /

Database review 10--PL/SQL, database review plsqlDatabase review CH10 PL/SQL10.1 PL/SQL Introduction PL/SQLIt is an Oracle procedural extension of SQL. PL/SQL can implement SQL-related procedural programs andStored ProcedureAndFunctionAllows SQL

What is data quality? Recently, data analysis is a hot topic. Traditionally, Data Analysis is divided into two types: EDA (Exploratory Data Analysis) and CDA (Confirmatory Data Analysis, validation Data Analysis ). EDA focuses on making data speak

Use of the ios CoreData framework, add, delete, modify, and query context data, association between tables, 1-to-many, 1-to-1, predicate query, multi-table join, ioscoredata Here is just code, because the effect of inserting images into a blog is

MySQL common index, unique index, primary index, foreign key index, composite index, full-text index usage, mysql full-text index1. Common Index The only task of a common INDEX (INDEX defined by the KEY or INDEX keyword) is to speed up data access.

Computer Management-database system principles-database management and database system principles Definition: DBMS monitoring of databases is called database management or database protection. **************************************** ** The