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

Installation of Oracle Database 12C in Linux Install Oracle Database 12C in Linux. After the installation, Oracle Configuration Manager fails to be properly installed, which does not matter. It will be installed later. It must be about environment

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

Process Monitoring Tool Supervisor starts MongoDB 1. What is a supervisor? Superviosr is a process monitoring tool on a UNIX-like system. Supervisor is a Python-developed client/server system that can manage and monitor processes on * nix. However,

Microsoft introduced a new tool to help MySQL users migrate their data to Microsoft's SQL Server database. This tool is called the SQL Server migration assistant (SSMA ). The future of MySQL was unknown due to the Oracle-SUN purchase case. Microsoft

Etl tool, kettle implementation loop, etl Tool kettle implementation Kettle is an open-source ETL Tool written in java. It can be run on Windows, Linux, and Unix. It does not need to be installed green, and data extraction is efficient and stable.  

Oracle function (converts the first letter of each word to uppercase) NLS_INITCAP (x [, y]) [Function] returns a string and converts the first letter of the string to uppercase, And the other letters to lowercase; [Parameter] x struct expression

Today, a netizen asked PostgreSQL 9.0 how to debug functions in the group. I remember there was a plug-in named edb-debugger in 8.3 that could be used. there is no 9.0 database at hand, so I tested it and it could not be used at 9.1. The result is

Chapter 1 Securing Your Server and Network (1): select the SQL Server Running Account and chaptersecuringSource: http://blog.csdn.net/dba_huangzj/article/details/37924127, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349

Database index advantages and disadvantages Why create an index? This is because creating an index can greatly improve the system performance.First, you can create a unique index to ensure the uniqueness of each row of data in the database

Krist ófskács, a software architect and consultant who once worked in a number of major companies, blogs on mainstream NoSQL databases (Cassandra, Mongodb, CouchDB, Redis, Riak, Membase, Neo4j, and HBase)) A comprehensive comparison was

50 SQL Query Techniques, query statement examples, 50 SQL statements Student (S #, Sname, Sage, Ssex) Student tableCourse (C #, Cname, T #) CurriculumSC (S #, C #, score) Orders tableTeacher (T #, Tname) Instructor table Problem:1. query the student

BI business intelligence training series-(3) Introduction to SSAS and business intelligence ssasIntroduction: A client tool provides the ability to design, create, and manage multidimensional datasets from a data warehouse, and access the OLAP data

Install Oracle 12C and linux7centos7 on LINUX7 (CentOS7) Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

Autocommit = {0 | 1} sets whether MySQL transactions are automatically committed. 1 indicates immediate submission, and 0 indicates explicit submission. Global or session is a dynamic variable that can be used in the configuration file (but not in

I. Relational databases are facing the pressure of data access. Generally, the solution steps take MySQL as an example)1. Master-slave replication for read/write splitting or distributed read; 2. There are many read requests. You can add cache

JDBC: database connection pool, jdbc database connection pool Required tools Commons-pool2-2.3.jar: dependency library implemented by connection pool Commons-dbcp2-2.0.1.jar: Implementation of Connection Pool C3p0-0.9.2.1.jar If Method

A pivot table is a method for analyzing data. It contains a powerful data pivot function in Excel. What is data pivoting? It may be easier to give an example. Assume there is a data table: Sales volume of books ---------------------------------------

[Translated from mos] Use config. sh/config. bat to configure or re-configure GI,From How to Configure or Re-configure Grid Infrastructure With config. sh/config. bat (Document ID 1354258.1)Applicable:Oracle Database-Enterprise Edition-Version 11.2.0

Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~), Oracle Core TechnologyOracle Core Technology jump to: navigation, search Directory Start 1 2redo and undo 3. Transactions