Database Administrator

PL/SQL enhancements in Oracle 12c Oracle 12c enhances a series of methods for defining and executing PL/SQL program units. This article covers several new features of Oracle 12c: 1. optimized the caller permission function for the result cache

MariaDB Galera Cluster deployment (how to quickly deploy MariaDB Cluster) MariaDB, as a branch of Mysql, is widely used in open-source projects, such as the Popular openstack. To ensure the high availability of services and improve the load capacity

Use Windows performance monitor to monitor common SQL Server metrics As mentioned in the above article, Win's Performance Monitor is an essential tool for monitoring database performance. Next I will introduce some common monitoring metrics, which

New SQL syntax support for window functions and CTE in MySQL 8.0 I tried some new features of MySQL 8.0. If you have used MSSQL or window functions in Oracle (called analysis functions in Oracle), and then before using MySQL 8.0, you will understand

PostgreSQL 9.5.1 official document Study Notes This document is applicable to the latest version of PostgreSQL 9.5.1. I am new to PostgreSQL and may not miss this article. please correct me. With more understanding, this article [may] will be

Commonly used SQLite database statements and SQLite visualization tool on MAC MeasSQLlite SQLite is an open-source embedded relational database. Its compact, concise, and fast features are very easy to use in mobile application data management. I.

MySQL advanced technology-storage engine, mysql storage engine The MySQL function is divided into two parts. The outer part is mainly used to connect to the client and investigate SQL statements beforehand. The inner part is the so-called storage

Different databases: oracle mysql SQL Server DB2 infomix sybase paging query statement, infomixsybase Paging query statements used in different databases: Current page: currentpagePage size: pagesize 1. Oracle Database Select * from (select A. *,

An unhandled exception occurs in System. Data. dll. Other information: A non-Boolean expression is specified in the context where conditions should be used (near ., System. data. dll In the data room charging system, some people use the stored

The difference between the python keyword parameter and the named keyword parameter, and the python keywordKeyword Parameter Variable parameters allow you to input 0 or any parameter. These variable parameters are automatically assembled into a

How to Use ZOL one-click installer to download the Zhongguancun online source installation package, zol Zhongguancun online How to Use the ZOL one-click installer to download the Zhongguancun online source installation package Magenfeng(Guangdong

When the SQL database is restored, the structure of the media cluster is incorrect, and SQL Server cannot process one of the solutions for this media cluster ., Sqlserver Problem: SQL Server cannot process the media cluster because the structure of

Then I went to the Internet to search for "How to Write website SEO optimization solutions, online seoThis time is part of the Website planning stage, website positioning, website layout, and keyword selection.First, you need to determine what kind

EBS concurrency manager table CMCLEAN. SQL, ebs concurrent cmclean. SQL Concurrent Processing-CMCLEAN. SQL-Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1]   Modification

Database review 5-security and database review securityDatabase review CH7 Security 7.1 database security Introduction If integrity is a database protection measure for authorized users, security is a database protection measure for unauthorized

Problem description: A session has been active for more than 20 hours, waiting for the event SQL * Net more data from client One session was logged on from eleven o'clock A.M. yesterday (v $ session. login_time), which has been ACTIVE till now,

47 common Oracle PL/SQL Toolkit, oracleplsql47 Oracle PL/SQL Utility Library Common PL/SQL Toolkit code, including: PDF file generation Toolkit: Excel file generation, RTF file generation, Zip file compression and decompression, JSON file

15 required MySQL management tools for DBAs and 15 required mysql for DBAs Original article: http://www.techxue.com/techxue-11898-1.html Today, the response speed of Web applications is one of the keys to success. It is closely related to user

Debug oracle stored procedures in PL/SQL Developer.Author: iamlaosong Alas, in the real world, I used Toad and used dbms_output.put_line to debug the stored procedure. I only thought it was inconvenient. After PL/SQL Developer was used, I still used

As one of the mainstream databases in the current market, Oracle databases are developed on many applications. Due to the reasons for upgrading Oracle databases and different application providers, several Oracle versions may exist in an application