Database Administrator

Performance Comparison of Oracle Database date filtering methods Performance Comparison of Oracle Database date filtering methods When developing SQL statements, filtering date segments is a common problem. How can we efficiently filter out date

Solve the Problem of connecting Qt to PostgreSQL in Ubuntu I encountered a problem yesterday and had not solved it for a day. Today, I suddenly solved it. The problem is: in Windows, you need to manually compile the PostgreSQL driver in the Qt

Oracle GoldenGate ctor configuration Manual 1. Introduction to GoldenGate ctor GoldenGate ctor simplifies the monitoring and management of GoldenGate. You can use a graphical interface or a web browser to conveniently and quickly maintain the

Monitor and manage the use of Oracle UNDO tablespace The monitoring and management of Oracle Database UNDO tablespaces is one of our most important tasks in daily life. The UNDO tablespaces are usually managed automatically by Oracle (determined by

Use cursor to convert the format of specified fields in the data table in Oracle (pinyin to numbers) Application Scenario: Convert [sannanyinv] In the NNDP field of the Oracle Data Table TB_USER to [3 male and 1 female] Main Script: A cursor script +

MySQL InnoDB shared tablespace and independent tablespace MySQL is always used to be compared with Oracle databases. When learning the storage structure of MySQL InnoDB, it is inevitable to compare it with Oracle. Oracle Data Storage includes

Build and install 12C RAC Based on Workstation8 and CentOS6.5 Author: HopToadLocation: Binjiang, HangzhouEmail: appdevzw@163.comjPublic Account: HopToadWelcome from all walks of lifeDecember 20141 preparation condition 1.1 hardware version One home

Correct the request for modifying the NLS_LENGTH_SEMANTICS parameter of the database. nlslengthsemantics1. developer error requirements First, let's look at an email that a developer asked a DBA to modify the NLS_LENGTH_SEMANTICS parameter of the

SQL Optimization-logical Optimization-subquery optimization (MySQL) and sqlmysql 1) subquery concept:When a query is a subquery of another query, it is called a subquery (a query statement is nested in the query statement ). Subqueries are located:

Add columns with default values in Oracle tables (including new 12C features) and oracle12c This is a problem that I have been paying attention. 11G has been improved on this issue, and 12C has some new features. For a discussion on the new features

[ORACLE] transaction and consistency (trn tbl and ITL basics), trnitl4 transactions and consistency 4.1 undo segment header transaction table and transaction control table (trn tbl and TRN ctl) -- Undo header contains the transaction table trn tbl

Oracle login uard Error: Error 1017 caught ed logging on to the standby, login uardlogging1. Status description:SQL> SELECT MESSAGE FROM V $ DATAGUARD_STATUS;MESSAGE--------------------------------------------------------------------------------ARC0:

Install and configure MySQL in centOS6.5, centos6.5mysql Install and configure MySQL in centOS6.5 1. SSH Secure Shell Client First, install the SSH Secure Shell Client, a tool for connecting to a remote Linux system, or an SSH Client for

Navicat for MySQL powerful MySQL management tool in Windows, navicatmysql Author: zhanhailiang Date:Introduction Navicat for MySQL [is a powerful MySQL database management and development tool that provides professional developers with a powerful

Restructuring the data room charging system-view and restructuring the data room Charging System During the first knock on the data center charging system, the database directly places these fields in a table based on the table and field used

T-SQL query: CTE, T-SQL: CTE I have seen a simple example of the with as Clause in two books. I have not found any relevant information on the Internet. Summary: [Batch update of large tables] [Batch Delete large tables] [Keep only one row for

KETTLE _ memory overflow error and kettle overflow error 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

Parse xml to initialize the database, parse xml to initialize To facilitate the development or launch of the project, you may need to initialize the database, including users, permissions, or some other basic data. I use the parsing Xml file to

Data Center reconstruction-database design, data center reconstruction Database Database Design-conceptual design stage This phase mainly draws an erdiagram based on requirements, as shown in the following figure. The diagram shows the erdiagram

How to Use RMAN Incremental backup to restore data guard log gap (log disconnection), rmangapThe minimum scn information of the master database:SQL> col current_scn for 999999999999999SQL> SELECT CURRENT_SCN FROM V $ DATABASE; Select min (fhscn)