Database Administrator

Configure RMAN RECOVERY CATALOG Oracle's RMAN configuration information is stored in the control file of the target database by default. You can also configure a recovery catalog server to store the information. The following is a comparison between

High-performance Mysql -- Schema and data type optimization; high-performance Mysql Schema Good logical design and the foundation of High Performance for physical designers1. Select an Optimized Data TypeSmaller is usually betterCPU cycle required

Use YEP Voucher through 1z0-050 exam, voucher1z0-050After some twists and turns, I finally found the "Oracle Database 11g Administrator Certified Professional" with the YEP test coupon, that is, the score of the 11g OCP upgrade test. It is true

Convert the PostgreSQL data table to excel and postgresqlexcel COPYExchange data between PostgreSQL tables and standard file system files.COPYTOCopy all contents of a tableToOne file, whileCOPYFROMSlaveCopy data from a file to a table (attach the

Create a postgresql Partition Table. Create a postgresql partition table. In postgresql, there is no partition table creation command. It is created by creating rules such as inherited tables and constraints. The steps are cumbersome and

Navicat for Oracle connection to Oracle 11G operation process, navicat11g Procedure for connecting Navicat for Oracle to Oracle at 11 GB 1. Change the Oracle configuration file After installing Oracle 11g, you need to change the listener. ora and

Navicat imports TXT files to the database and navicat imports txt files. 1. Open the first line of txt and write the column name, otherwise there will be no column, such as username password 2. Select database-table, right-click and select import

Configure the insert of emoji characters and insert of emoji characters An error is reported when a character is inserted in a recently created Project. ERROR 1366: 1366: Incorrect string value: '\xF0\x9D\x8C\x86' for column 'vl' at row 1 After

Database optimization tutorial (3) Slow query of records and database optimization tutorial Query1. Slow query foundIn the previous section, we made data preparation for slow queries. This section allows us to find slow queries and record them to

Org. springframework. transaction. CannotCreateTransactionException: cocould not open Hibernate Session, hibernatesession Problem -- Org. springframework. transaction. CannotCreateTransactionException: cocould not open Hibernate SessionThis is

The transaction log for database 'xx' is full, Error: 9002, Severity: 17, State: severity Check database logs with the following error message: Error: 9002, Severity: 17, State: 4.The transaction log for database 'SharedServices1_Search_DB' is full.

Data warehouse-Logical Data Model and data warehouse logic model In the data warehouse field, there is a concept called the logical data model. Chinese characters are generally translated as "logical data Models ". Logical Data Model Design and

Database Tuning tutorial (5) Roles of indexes and types of indexes, tuning IndexesIii. Index In the previous chapter, we learned how to use explain to generate a query execution plan (QEP), so as to discover problems with the statement. Three

HMaster startup code analysis for source code analysis of HBase1.0.0 (2), hbase1.0.0hmaster In the previous blog, my code analysis is the startup function of the startMaster core. This article mainly analyzes the corresponding components involved in

Navicat connection oracle error: ORA-12737 Instant Client Light: unsupported server character set ZHS16GBK, navicatora-12737 Today I used Navicat to connect to the Oracle database and reported the following error: "ORA-12737 Instant Client Light:

SQL _ write a simple Stored Procedure for deleting employee information, SQL stored procedure Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise,

MongDB basic learning (7) -- [MongoDB for Java] Java operations on MongoDB and mongdbmongodb [MongoDB for Java] Java operations on MongoDB The developed products are constantly revised for financing purposes. From the first version to the latest

RULE-based optimizer (learning notes) and rule learning notesCui Hua's Oracle-based SQL optimization learning notes1.1 RULE-based Optimizer (1) CBO (2) RBO Compared with CBO, RBO has obvious permissions. When RBO is used, once a problem occurs in

Oracle Rac root. sh error: Failed to create keys in the OLR, rc = 127 libcap. so.1, root. sholrEnvironment Description: Linux 6.3 Oracle Rac 11.2.0.4[Root @ web1 grid] #/u01/app/11.2.0/grid/root. shmongoming root user operation for Oracle 11gThe

Redis Research (12)-master-slave replication, redis research master-slave Replication In the previous section, we wrote Redis data persistence. Http://blog.csdn.net/wtyvhreal/article/details/42916503 Through the persistence function, Redis ensures