Quick Configuration Guide for Oracle 11g Data Guard physical standby Database

Quick Configuration Guide for Oracle 11g Data Guard physical standby Database OriginI recently conducted a physical standby Database Configuration experiment for Oracle 10g and 11g, and found that Data Guard is actually very easy, but there is a

How to install PostgreSQL 7/6 and phpPgAdmin in CentOS 5/6. 4

How to install PostgreSQL 7/6 and phpPgAdmin in CentOS 5/6. 4 PostgreSQL is a powerful open-source object relational database system that runs on almost all major operating systems, including Linux, Unix (AIX, BSD, HP-UX, sgi irix, Mac OS, Solaris,

Python in Ubuntu accesses the Oracle database through the SQLAlchemy Library

Python in Ubuntu accesses the Oracle database through the SQLAlchemy Library SQLAlchemy is not a database driver. The Python driver for accessing Oracle data is cx_Oracle, but this driver depends on Oracle instant client. Therefore, if you want to

MySQL field content is case sensitive

MySQL field content is case sensitive Data is migrated from Oracle to MySQL. Since Oracle is case-sensitive in the past, the default configuration is used for MySQL configuration, resulting in some data import failures, and some unique keys report

Modify Oracle RAC Database Name

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 =

Oracle Dual table details

Oracle Dual table details 1. Use of DUAL tablesDual is an existing table in Oracle that can be read by any user. It is often used in Select statement blocks without a target table.-- View the current connected userSQL> select user from dual;USER-----

Bind a variable of DATE type in SQL * Plus

Bind a variable of DATE type in SQL * Plus SQL * Plus is an essential tool for DBAs. According to TK, "DBAs that do not use SQL * Plus are not qualified DBAs ." Of course, this is not the case, but it is similar to this. We can see the importance of

Understanding the Checkpoint Technology in MySQL

Understanding the Checkpoint Technology in MySQL 1. Background generated by checkpointWhen the database adds, deletes, queries, and modifies data, it is completed in the buffer pool first. To improve the efficiency of transaction operations, the

Duplicate data read at the REPEATABLE-READ isolation level of MySQL"

Duplicate data read at the REPEATABLE-READ isolation level of MySQL" In MySQL, MVCC is used to implement the REPEATABLE-READ isolation level, because the SELECT operation does not lock the data, other calls can modify the data read by the current

Deep understanding of MySQL Cluster Index

Deep understanding of MySQL Cluster Index Clustered index is not a separate index type, but a data storage method. When a table has a clustered index, its data rows are actually stored in the index's leaf page. The term "clustering" indicates that

How Does Oracle export system tables under sys users?

How Does Oracle export system tables under sys users? Environment: Solaris 10 + Oracle 10.2.0.4 1. Export instances 2. References Reference 1. Export instances ExportHIST_HEAD$AndWRI$_OPTSTAT_HISTHEAD_HISTORYTwo tables:An error occurred while

What if MySQL transactions contain DDL statements?

What if MySQL transactions contain DDL statements? As we all know, MySQL DDL statements are non-transactional, that is, DLL statements cannot be rolled back. What if a transaction contains DDL statements? For example: # Disable automatic

Joint primary key (joint index) Index Analysis in SQL Server (MySQL)

Joint primary key (joint index) Index Analysis in SQL Server (MySQL) Some people have recently asked this question, but they have not studied the specific use logic of the joint index before. They have read many articles and obtained some

MySQL 8.0.4 RC: Be careful when using auth_socket!

MySQL 8.0.4 RC: Be careful when using auth_socket! The news from the latest MySQL 8.0.4 RC (Candidate edition) is indeed exciting. Unfortunately, for auth_socket plug-in users, the danger is waiting! As early as November 2015, it was reported that

Logrotate implements MySQL slow log Segmentation

Logrotate implements MySQL slow log Segmentation MySQL slow log? The slow query log of MySQL is a log record provided by MySQL. It is used to record the statements whose response time exceeds the threshold value in MySQL, specifically the SQL

12 MySQL/MariaDB security best practices for Linux and mariadb Best Practices

12 MySQL/MariaDB security best practices for Linux and mariadb Best Practices MySQL is the most popular open source database system in the world, and MariaDB (a MySQL Branch) is the fastest growing open source database system in the world. After

PostgreSQL database in the year, MySQL score dropped sharply, postgresqlmysql

PostgreSQL database in the year, MySQL score dropped sharply, postgresqlmysql To determine the DBMS for the year 2017, DB-Engines deducts the score for the year January 2018 from the latest score for the year January 2017 to get the score

Implementation of multiple parameters in PrepareStatement SQL statement in,

Implementation of multiple parameters in PrepareStatement SQL statement in, The following is the process of exploring the SQL statement with PrepareStatement pre-compiling where condition as in today. Only the fourth method is implemented in the

Pandas series DataFrame row and column data filtering, pandasdataframe

Pandas series DataFrame row and column data filtering, pandasdataframe I. Cognition of DataFrame DataFrame is essentially a row (index) column index + multiple columns of data. To simplify our understanding, let's change our thinking... In reality,

Key-Value Pair design in Redis and Redis key-Value Design

Key-Value Pair design in Redis and Redis key-Value Design The rich data structure makes redis design very interesting. Unlike relational databases, DEV and DBA need to communicate in depth, and review does not require DBA participation for each row

Total Pages: 1013 1 .... 10 11 12 13 14 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.