Database Administrator

Generate AWR reports in batches in Oracle In daily work, we need to monitor AWR reports every day to eliminate potential risks. The following is an automatic O & M script. The ADDM of Oracle also provides some optimization suggestions. For the

Oracle RMAN archive deletion policy RMAN> show all; Configure archivelog deletion policy to none; By default, the archive deletion policy is not configured in Oracle10g 11g; In this case, how does one Delete archive logs that have not been

Use XtraBackup to back up the MySQL database Xtrabackup is an open source backup tool developed by percona, which is different from ibbackup. Ibbackup is a paid backup tool. In terms of its backup performance, ibbackup is inferior to Xtrabackup.

MySQL uses string as the query Condition Today, I encountered a problem when querying MySQL. The scenario is like this. Assume that one of my tables has a field scode (indicating the product number ), then there is a string that stores multiple

[Mysql] The SQL _mode configuration associated with Data truncated for column, truncatedsql_mode System Logs Ata truncated for column 'agent' at row 1 The reason for this problem in mysql is nothing more than Character Set setting or a too long

Mysql uses the federated engine to remotely access the database (operate tables in both databases across the network), and mysqlfederatedProblem: Assume that I need to access table 2 in the database of IP2 on database1 on IP1.Method: Here, as a

Hibernate ing mechanism and Hibernate ing mechanismHibernate ing mechanismObject Relation Mapping (ORM) is a technology designed to solve the mismatch between object-oriented and relational databases. In shortBy using metadata that describes ing

Performance Comparison of Redis and MongoDB paging/ranking at large offset, redismongodb In fact, the questions are not very accurate, because the database does not provide paging, ranking, and other functions. It only provides data access, and

How to connect Oracle 12c to CDB and PDB, 12 ccdb      1 connect to CDB   Same as a normal instance. After specifying ORACLE_SID, you can use OS authentication or password for connection.   [Oracle @ Ora12c/] $ echo $ ORACLE_SID Cndba [Oracle @

[MongoDB] massive storage mechanism of MongoDB database, massive storage of mongodb GridFS is a file specification that stores large files in Mongodb databases.I. How to implement massive storage Because the size of bson objects in Mongodb is

Myeclipse database Browser connection error: OPTION SQL _SELECT_LIMIT = DEFAULT, myeclipse (1) because the latest mysql version was updated to mysql5.6 some time ago, the following error occurs when editing data using myeclipse's DB Browser: (2

Debugging is also an attitude and an attitude. Today, when debugging the Excel report display, there was a big error because I didn't know what it was at the beginning? It was a little because I had been entangled with it for half a day and suddenly

Distributed Database HBase and hbase HBase-Hadoop Database is a highly reliable, high-performance, column-oriented, and Scalable Distributed Storage System. HBase technology can be used to build large-scale structured storage clusters on low-cost PC

Oracle AVDF configuration, Next: Introduction to Oracle audit and database firewall (AVDF) Oracle AVDF Installation 1. OracleAVDF Application Experiment in HIS Next, we will use the configuration to demonstrate an application case of Oracle AVDF

The database system can check performance bottlenecks, but the small components written by itself cannot ., Database bottleneck After receiving the company's task, the three standalone databases of the same user must be merged. Therefore, the

Steps for connecting jdbc to the databaseCreate a program to connect to the database using JDBC, which contains seven steps:1. Load the JDBC driver:Before connecting to the database, load the driver of the database to be connected to the JVM (Java

Oracle 11g histogram row-to-column, 11 gpivot I have written a line-to-column article: Oracle simple column-to-row SQL> select * from v $ version;BANNER -------------------------------------------------------------------------------- Oracle Database

[Monogdb] MongoDB log system, monogdbmongodb I remember a friend who was checking mongodb logs a few days ago may not be able to locate the problem. Today, the system will talk about mongodb's log system. Mongodb has four types of logs. These are

Shell batch import mysql database, shellmysql Database Due to project collaborative development, my colleague sent an SQL file of the project and opened it in a directory containing hundreds of databases. Each database is used as a separate

[Practice] install maridb 10.0.15 on centos 6.5, maridbcentos Maridb 10.0.15 on centos 6.5 installation ********************************** **************************************** * *** 1. system ************************************** ***************