Database Administrator

PostgreSQL module-pg_stat_statements detailed explanation and installation test In fact, it is very simple. Recently, postgresql may need to be monitored, so I have been exposed to many related monitoring commands and tools. This article mainly

Solution to Oracle dbstart failure Solution to Oracle dbstart failure [Oracle @ CentOS-1 ~] $ DbstartORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net ListenerUsage:/u01/app/oracle/product/12.1.0/dbhome_1/bin/dbstart ORACLE_HOMEModify

Oracle 11gR2 RAC node crash Fault Analysis Environment: AIX 7100Oracle 11gR2 RACDetailed version: 11.2.0.4 Symptom:Node 2 crs hang is down. The CRSCTL command does not respond at all. After the CRS process host is restarted, the VIP is not migrated

Detailed description of ROWID in Oracle 10g First use select * from v $ version; to query the current version of the Oracle database SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle

Oracle multi-database data is updated at the same time 1. Create dblink Create database link test connect to mall identified by test using'(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP) (HOST = 113.116.216.60) (PORT = 1521 )))(CONNECT_DATA

Handle irregular Oracle listening exceptions Environment:Operating System: SunOS 5.10Database Version: Oracle RAC 11.2.0.3.0There are two databases on the host, with node 1 of a RAC located on the host, and another database. The reason why the

Application of cursor and recursion in Oracle Functions Most programmers may be familiar with recursion in code, but it is rare to write a recursive estimate in a stored procedure or function. Today, we have encountered an example of using recursion

Another example of ORA-02030 Solution Give normal users the query permission on the v $ view and result in a ORA-02030 ErrorORA-02030: only queries from fixed tables/views (ORA-02030: can only select from fixed tables/views) Problem Background:You

Oracle Table Connection Method Analysis Basic table join knowledge: 1. Which table will drive the query (that is, the first table accessed )? When will no table be accessed during query based on the specified path? What are the optional driver paths?

MYSQL table errors when writing Chinese characters or assigning values to fields. mysql assigns values. -- When modifying the field value or writing it directly, Chinese characters become garbled. [Note the Database Name and remember to modify it.] -

[Translated from mos] Note: ASMB process exiting due to lack of ASM file activity, asmbexiting Note: ASMB process exiting due to lack of ASM file activity Reference Original:NOTE: ASMB process exiting due to lack of ASM file activity (Doc ID 754110.1

[Translated from mos] place the dmp file of expdp from the asm disk to the local file system, expdpasmPlace the dmp file of expdp from the asm disk to the local file system.Reference Original:How To Extract Datapump File From ASM Diskgroup To Local

All oracle queries and tablespaces, and their relationships, oracle Space Select * from dba_users; view all users in the database, provided that you have the dba permission account, such as sys, systemSelect * from all_users; view all users you can

Memcached: several commands that are easy to ignore but are very useful. I recently read the source code of memcached. In this process, I found many memcached commands that are not frequently used at ordinary times, however, memcached often needs to

Linux mysql uninstallation, installation, test process, linuxmysqlMysql uninstallYum remove mysql-server mysql-libs compat-mysql51Rm-rf/var/lib/mysqlRm/etc/my. cnfCheck whether there is any mysql software:Rpm-qa | grep mysqlIf yes, continue to

Practice of installing Oracle 12c under Oracle Linux6, linux612c After N installation attempts to vomit blood, I hope to help you and keep a note: Conclusion: preparations before installation are critical !!! Check and recheck! Reference:

User Logon Failed. This user is not associated with a trusted SQL Server connection. Error: 18452, sql18452 After installing SQLServer2005 (or the SQLServer2005 that comes with Visual Studio 2008), you can use SQL Server authentication to log on to

SQL Server blocks access to the STATEMENT 'openrowset/OpenDatasource 'of the 'ad Hoc Distributed Queries' component. OpenRowset Cause: It appears when the data is copied from the remote server to the local "SQL Server has blocked access to the

SQL Server Performance Tuning 4: Writing efficient queries, SQL Server TuningRestrict query rows and columns to improve performance This rule is very simple and will not be detailed here.Use search to optimize the performance by parametric judgment (

An invalid column is inserted when MySQL inserts data. 1. Error description Com. mysql. jdbc. exception: jdbc4.MySQLSyntaxErrorException: Unknown column 'man' in 'field list' 2. Error cause Field in the database table: sno sname sage ssex