Database Administrator

Oracle PL/SQL Composite data types Composite data types can be roughly divided into two types. The first type is record type, which is suitable for processing single row and multiple columns of data, a bit similar to VO in java; the first type is

MySQL high availability solution Cluster) 1. experiment environment I used three servers to build the mysql cluster environment. The SQL node and the data node are on the same server, and the Management node is a separate one. Cluster node1: 192.168.

Use RMAN to copy RAC + ASM to a single instance + ASM This test copies the dual-node RAC deployed on ASM to the ASM of a single instance. This test is also based on the needs of a project. The drill operations on the virtual machine are hereby

MySQL Performance Testing Tool-mysqlslap Mysqlslap is a benchmark tool provided by mysql. It has the following advantages: Data Query, simple syntax, and flexible and easy to use. this tool can simulate multiple clients to concurrently send query

Use bbed to restore table data and bbed to restore the table ORACLE provides a variety of restoration methods for table-level data recovery: flashback query and logmnr. This example demonstrates how to use the copy command of bbed to restore the

Multi-thread kettle conversion and multi-thread kettle Conversion Kettle multi-thread Conversion   In ETL projects, performance considerations are usually the most important. In particular, the tasks discussed are frequently executed, or some

Virtual Box cannot open a new task for the Virtual machine, virtualbox When you create a shared disk on two nodes today, you can only open one of the two virtual machines. When you open another task, you are prompted that you cannot open a new

Disable Clusterware to automatically start after the system starts. Disable clusterware The following describes how to disable and enable Clusterware to automatically start with system startup.   Use the following method for 10 GB: Disable

SQL Injection and SQL Injection In the past, when I was working on the student information management system and data room charging system, SQL injection was a common problem, but I did not really understand what SQL injection was like. it was not

Temporary table, oracle temporary tableTemporary tables allow users to operate only their own data without interfering with each other, so they do not have to worry about damaging or affecting data of other sessions/transactions. Temporary tables

About file # In v $ datafile and v $ tempfile #, The v $ datafile view stores information about data files, and the v $ tempfile view stores information about temporary files. There are file # Fields in both views. Let's take a look at the

Use of sqlite3 script and sqlite3 script I wanted to find a database-specific tool. Later I found that the script was very simple and I used the script directly. The sqlite3 script allows you to conveniently view the content in the current

BBED marks Bad blocks and fixes bad blocks. Create a test table: ZBDBA@orcl11g>select * from

Difference between truncate table and delete, truncatetable Truncate table requires the drop table permission, which completely clears a table. Logically, the truncate table is the same as the delete table, or the drop table + create table is the

PB + ms SQL + trigger must note that pbsql Note the following before using PB + ms SQL + triggers: If the trigger has more than two returned values, for example, two update statements, it is misjudged that the data has changed and the disk is not

Rac _ report version too high when installing software, rac report 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

Analyze Mysql InnoDB indexes and mysqlinnodb Indexes Abstract: This article introduces the InnoDB Index-related knowledge of Mysql, from various trees to the indexing principle to the details of storage. InnoDB is the default storage engine of Mysql

MySQL trigger learning, mysql triggerTrigger: a special type of thing that can monitor certain data operations and trigger related operations (insert, update, and delete). Some data changes in the table, it is expected that other data changes may

One of the most comprehensive oracle tablespace query and maintenance commands (data table space) in history A tablespace is the logical division of a database. A tablespace can belong to only one database. All database objects are stored in the

C # synchronize SQL Server database Schema,C # synchronize SQL Server database Schema1. write an SQL processing class first: using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Text;namespace