Database Administrator

ORA-00904 scn_to_timestamp In Oracle, the scn and time can be converted to each other, and the friend's database is 10.2.0.5. Previously, it was normal to convert the scn to the corresponding time through scn_to_timestamp, but an error was reported

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,

Use Redis for pre-stock Cache Recently, in my work, I gradually switched the cache of one of the PHP projects from the previous APC cache to Redis, and implemented inventory maintenance based on the data structure supported by Redis. The cache is

MySQL undo log and redo log In the database system, there are both data files and log files. Logs also contain cached Log buffer and disk file log files in the memory. This document describes the files that store logs.There are two types of log

Redo log, undo log, and binlog of MySQL) There are six types of log files in MySQL: redo log, undo log, binlog, and errorlog) slow query log, general query log, and relay log ).The redo log and rollback log are closely related to transaction

Use IBM Data Studio to create and manage DB2 federated database objects In the latest version 4.1, IBM Data Studio (DS) provides more comprehensive support for federated databases than earlier DS3.x versions. This article describes how to create and

Install the open source database PostgreSQL 9.4 and phpPgAdmin on UbuntuIntroduction PostgreSQL is a powerful, open-source, and Object-based relational database system. It supports all mainstream operating systems, including Linux, Unix (AIX, BSD,

MySQL Slow Query Log (Slow Query Log), mysqlslow Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These

Oracle Database Operations (10)-logical backup and recovery of databases (tables), oracle backup and recovery Logical backup and recovery of databases (tables)-export System can export any scheme, for example: Exp system/manager @ myoral owner

Rails connection postgresql error: psql: Fatal error: User "s" Ident authentication failed, psqlpostgresPsql: Fatal error: User "s" Ident authentication failed 1. After the postgresql database is installed, you must initialize and configure some

The top 10 SQL and NoSQL databases in the latest statistics, and nosql databases in the latest statistics This ranking is based on the ranking of DB Engines, which analyzes the popularity of 200 different databases on the market. The Top 10

How to solve the problem of forgetting the root password in Mysql and forgetting the root password in mysqlMethod 1:MySQL provides command line parameters for skipping access control and starts the MySQL server by running the following

How to Use substring in oracle Database CONVERT (varchar (12), getdate (), 112), substringgetdate SqlserverI often need to perform some time-type field conversions, but I don't quite remember it. So I collected the following

Oracle remote connection (PLSQL, SQL developement + Oracle database + client + remote connection settings, plsqldevelopement Server Configuration: oracle11g R2 x64 1. Set the listener A. Launch bar-> Start-> Program-> Oracle-OraDb11g_home1->

PLSQL automatic login, remember the user name and password & daily use skills, plsql Automatic Login Https://www.cnblogs.com/Chary/p/No00008F.html Configure the login username and password at startup This is a controversial feature, Because

Install and configure the Mysql database under centos, import the database, authorize a remote ip address, and centos Mysql Uninstall the original mysql Because mysql databases are too popular on Linux, the mainstream Linux system versions currently

PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7, download from Windows 7 PL/SQL Developer's experience in connecting to Oaracle11g64-bit System in 64-bit Windows 7I. Problem phenomena and SolutionsSymptom:1.

Oracle Chinese Character occupies byte length, oracle Chinese Character byte 1. When investigating an oracle database problem today, we found that one Chinese Character occupies 2 bytes in 11G and 3 in 10g, as a result, the data in the 11g Database

Oracle waits for the DFS lock handle event and implements ledfs When performing a performance stress test, the test results cannot pass. The AWR Report of an hour on site is obtained and a large number of waiting events are found. The database is

When our DB2 database suffers database corruption due to some serious errors (such as storage corruption), we usually need to fix the related errors, use the Restore command to Restore the database (DB2 also supports high system availability through