Database Administrator

Innotop MySQL Monitoring Tool Innotop is a monitoring tool that displays MySQL and InnoDB Storage engines in text mode. Innotop is developed in the perl language. It can be used more flexibly on various operating platforms. It can monitor the

Oracle stored procedure returns (N) working days based on the specified date I have never written any Oracle stored procedures. Today I have a sudden demand: Calculate the first N working days of the specified date or the next N working days

ORA-12545: the connection failed because the target host or object does not exist 1. Problem Description In the Windows XP system, the AX1 application and the upgraded version of AX2 are installed at the same time to connect to the same connection

RMAN-06061 WARNING skipping archivelog compromises -- RMAN-06061 Processing-- During routine database backup check, the backup status of a database is completed with errors.-- So I went to the operating system to check and found the following alarms

Expdp encountered a ORA-39126 Error Problem description:The Oracle database is RAC of 11.2.0.4 and expdp is performed on one of the nodes. the following error is returned: Estimate in progress using BLOCKS method...ORA-39126: Worker unexpected fatal

SQL programming-advanced queries and precautions 1. What is a subquery? When one query is a condition of another query, it is called a subquery. For subquery, you can use several simple commands to Construct Powerful composite commands. Subqueries

The COMPRESSION parameter COMPRESSION ratio of Oracle 11g EXPDP is comparable to that of "gzip-9" This compression ratio can be comparable to the operating system "gzip-9". In some cases, it may be more efficient than gzip. For your reference. 1.

Use flashback database to implement flexible data rollback I wrote an article about using the flashback database feature to avoid repeated import of large amounts of data in the test environment, resulting in a waste of time and storage space.The

MySQL remote connection failure Solution I have encountered the problem that MySQL can be connected locally but cannot be connected remotely. I have not recorded the problem. I encountered this problem on the new ECS instance on the cloud today. I

Modify the default timeout value in phpmyadmin. After logging on to the system, the system automatically exits after being inactive for 1440 seconds. You have to log on multiple times a day. Finally, you have time to solve this problem. It seems

Active Report export function, activereport I checked a lot of information on the Internet and provided a complete solution. I tried it in the system and found it was not easy to use. When using the export function, I must reference several

MongDB start WARNING: soft rlimits too low, mongdbrlimits # MongoMongoDB shell version: 3.0.2Connecting to: testServer has startup warnings:T12: 34: 19.688-0700 I CONTROL [initandlisten]T12: 34: 19.688-0700 I CONTROL [initandlisten] ** WARNING: soft

Database and database LearningRelational system Purpose of this chapter:RDBMS query procedureQuery Optimization conceptsBasic methods and technologies Query Optimization classification:Algebra OptimizationPhysical Optimization RDBMS query processing

RMAN-06061 WARNING skipping archivelog compromises recoverability processing, rmanarchivelog-- RMAN-06061 Processing-- During routine database backup check, the backup status of a database is completed with errors.-- So I went to the operating

For the content of eight Oracle 12.1.0.2 files, oracle12.1.0.2 Source: P17694377_121020_Linux-x86-64_1of8 \ database \ readme.html     Oracle Database (des Oracle Database, Oracle RAC, and Deinstall)Note: you must download both zip files to

Reading schema error: null, readingschema Solution: add dbo The complete hibernate. cfg. xml is as follows: com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:1433;DatabaseName=Lessonra

Java. SQL. BatchUpdateException: ORA-12899, ora-12899 Recently, when I used the JDOM component to parse XML file data and store the data to the oracle database, the following error occurs: Exception in thread "main" java.sql.BatchUpdateException:

Jedis slice (cluster) Non-slice (single-host) instance, jedis Cluster Package testRedis; Importjava. util. ArrayList; Importjava. util. Iterator; Importjava. util. List; Importjava. util. Set; Importredis. clients. jedis. Jedis; Importredis. clients.

The retrieval method after the Oracle11g user password is forgotten. The oracle11g User Password The Oracle11g installed on your computer has a userRootIt was useless for a long time, and the password was forgotten. The following describes how to

PostgreSQL tutorial (11): server configuration, 1. Start and close server processes: The following are the usage and common options of the pg_ctl command. It should be noted that this command is the encapsulation body of the S command, so it is more