Database Administrator

Startup alter. log spfile. ora, startupspfileSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release

Mysql replication delay monitoring script and mysql delay script #! /Bin/sh # ocpyang@126.com # repdelay. sh # view the specific number of replication delays ##### 1. juede the rep slave status export black = '\ 033 [0m' export boldblack =' \ 033 [1;

Database review 3-database integrity, review database integrityDatabase review CH5 integrity 5.1 integrity constraints Database integrityIt refers to the logical consistency, correctness, validity, and compatibility of data in the database.Integrity

An oracle bug discovered by using dblink in XA, xadblink A new error message was found in the recent monitoring system logs, which is strange and has not been found before. As follows: ORA-24777: do not allow use of database links that are not

Simulation and Problem Analysis of library cache pin in case of a single Oracle instance, oraclepin Simulation and Analysis of library cache pin problems with a single Oracle instance Reference: WAITEVENT: "library cache pin" Reference Note (Doc ID 3

Com. mongodb. MongoException $ CursorNotFound: cursor not found on server Exception Handling, servernotfound The exception of cursor not found is often encountered when java links MongoDB to process a large amount of data, which is actually caused

A small problem encountered in oracle paging Query Order table, which has the same order id as the order information table (Multiple order information columns)Find all orders and their information, and page them by order select * from(select a. * ,

Fault case: Insufficient disk space may cause mysql problems. Case: mysql During work, due to the customer's disk space alarm, insufficient space caused the following possible mysql problems. 1. mysql process cannot start 2. mysql cannot be

For XML Path, forxmlpathTable data created by using For XML PathFirst, let's take a look at the initial usage of for xml path: select ClassID, Sex, Age, Name from # PersonInfo for xml path ('personinfo'). The usage can be seen from the Name, for xml

SQLyog keyboard shortcuts and sqlyog shortcuts SQLyog keyboard shortcut ConnectionCtrl + M create new connectionCtrl + N create a new connection with the current connection PropertyCtrl + F4/Ctrl + W disconnect the current connectionCtrl + Tab

Oracle dblink causes too many remote database sessions. oracledblink The database of the on-site reporting network company could not be connected. I checked the database processes = 1500 and session = 2200 first. I think it is very big. Few people

Datazen configuration, datazenZookeeper Datazen is a full-platform data presentation solution for mobile terminals acquired by Microsoft. This article mainly introduces the configuration process of the server.   After the previous basic installation

The old mysql table is deduplicated and the new table is imported with a new value of the primary key id. Business Requirements: Table A has the id, n1, n2, and n3 fields to create an empty table, Table B has fields such as id, n1, n2, n3, n4,

Datazen installation, datazenZookeeper Datazen is a full-platform data presentation solution for mobile terminals acquired by Microsoft. This article mainly introduces the installation process.   On the download page, please note that there is no

Datazen introduction, datazenZookeeper Datazen is a mobile platform-wide Chart solution. Based on HTML5 applications, Datazen integrates the entire platform. This article mainly introduces its functions. This platform has just been acquired by

How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the oracle database, oracleplsql How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the

MHA routine management and mha ManagementMHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication

Basic use of mongoDB (II), use of mongodbConnect to the mongoDB server for basic database operations./bin/mongo 127.0.0.1: 12345View the current database> show dbsadmin (empty) local 0.078GBut change the database (it will be automatically created if

Troubleshooting of inconsistent data query results in ORACLE databases I. Problem Description In a software development project, you need to create ten identical employee information tables in the ORACLE database tb_employeeinfo0 ~ Tb_employeeinfo9

How many bytes does VARCHAR2 occupy? NLS_LENGTH_SEMANTICS, nls_language, nlslengthsemanticsORACLE initialization parameter: NLS_LENGTH_SEMANTICS The initialization parameter NLS_LENGTH_SEMANTICS is used to specify the length definition method for