Database Administrator

How to Use RMAN to identify corrupted objects in the database How to Use RMAN to identify corrupted segments in the database. Solution: Step 1: identify bad Blocks Run the following RMAN command to record all bad block information in the v $

Test data of PostgreSQL running on FreeBSD and Linux This afternoon I wanted to test DragonFly dports. I suddenly wondered why I didn't compare the performance difference between PostgreSQL in BSD and Linux. For this reason, I set some standards to

[MonogDB] The description of index (2) Embedded and document Index, monogdbembedded In this blog, we will talk about another the index which was called "The embedded". First we init 1 w the records as follows: 2.2 The embedded Index The compare

MySQL character encoding problem, Incorrect string value, mysqlincorrectAn error is reported when inserting Chinese Characters in MySQL. For details, refer to the analysis below.Incorrect string value: '\ xD0 \ xC2 \ xC8A \ xbew' for column 'ctnr'

Explain the differences between DELETE, TRUNCATE, and DROP in Oracle. oracletruncatePrefaceIn the past, when I was working on a project, I seldom paid attention to the details in the knowledge point. Today, I have the opportunity to differentiate

Difference between the four ranking functions of SQL and the four ranking functions of SQL /* The difference between the four ranking functions: RANK () returns the ranking of each row in the partition of the result set. The row ranking is the plus

Find the current maximum id and Database id of all tables in the database. Today, we need to count the current maximum IDs of all tables in the database. It is too difficult to query each table one by one, so we can write a stored procedure for

Mac_MySQL installation, mysql 1. Download and install Go to the MySQL official website at http://dev.mysql.com/downloads/mysql/, and download about 164 MB of Community Server. On the following page, select No thanks, just start my download] The

NorthWind database, northwind databaseNorthWind database Categories: product category; MERs: customer; Employees: Employee Employees Territories: employee Fields Order Details: Order Details Orders: Order Products: Product Region: Region

Postgresql9 PPAS9 stream replication configuration, postgresql9ppas9 Set up a stream replication cluster for PostgreSQL. Host:PPAS1 PPAS2 1 Install PPAS 9.0 [Root @ ppas1 ~] # Setenforce 0 [Root @ ppas1 ~] # Ppasmeta-9.0.4.14-linux-x64.run-All

How to view the inv rup version and ebsrup In the EBS Environment select 'Application Environment: '|| i.instance_name || ', Host: '|| i.host_name ||', Application Release: ' || f.release_name || ', DB Version: '|| i.version from v$instance

ERROR OGG-01161 Bad column index (88), ogg-01161column after table schema change09:38:31 ERROR OGG-01668 PROCESS ABENDING.2014-07-31 09:38:31 ERROR OGG-01161 Bad column index (88) specified for table WIP. WIP_PARAMETERS, max columns = 88. The net

Dbca create database ORA-01034 ORACLE not available, dbcaora-01034 SYMPTOMS When using dbca to create a database, when all the parameters are set up, the ORA-01034 ORACLE not available, For example CAUSE There's a script in

Chapter 1 Securing Your Server and Network (8): Stop unused services, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not responsible for

Summary of several memory data and several memory data MemSQL Principle: combines unlocked data structures with real-time compilers to handle large workloads, lock-free hashtable and lock-free skiplists (a hierarchical linked list structure) are

H2 memory databases support file storage,Zookeeper Preparations 1. Download JDK (my downloaded version is JDK 1.7), set the environment variable JAVA_HOME, and set PATH (% JAVA_HOME % \ bin % ).2, download and unzip: h2-2014-07-13.zip Official

The SQL Server user can only access the specified view. The SQL Server View Use crm-- Create a role for the current databaseExec sp_addrole 'rapp'-- Assign view permission grant select on veiw TO [role] -- Specify the View listGrant select on v_city

Percona-xtrbackup for multiple instances (), perconaserver Background Percona-xtrabackup is a backup tool developed by percona. It mainly has two tools: xtrabackup and innobackupex. Innobackupex encapsulates xtrabackup and is a perl script. This

Java calls the kettle conversion file, and java calls the kettle Conversion Call kettle to convert files in java   You can also call the command line code through the command line, and then call the command line code in java. In this way, it is not

How to speed up database query and speed up database1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid null value determination on the field in the