Database Administrator

Explanation of the Redis configuration file Parameters of the Redis configuration file: 1. Redis does not run as a daemon by default. You can modify this configuration item and use yes to enable the daemon. Daemonize no 2. When Redis runs as a

GoldenGate dml target table of synchronization process and field processing test -- Experiment: For goldengate processes that only have dml synchronization, if the source end performs the ddl plus field operation, how to deal with the corresponding

Expdp export error ORA-31693 & ORA-39826 The report library logic has an error:ORA-31693: Table data object "BI_ETL". "xxx" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-39826: Direct path

Flash back archive (11G new feature) Stay away from ORA-01555 errors 1.1.1.1 flash back Archiving The previous flash back is implemented based on undo flash back, because our flash back is not sure of time, so it will lead to ORA-01555 (snapshot is

ORA-00494 enqueue [CF] held for too long troubleshooting Today, the application staff responded by phone that an exception occurred after a backup database was added to the tablespace. This problem occurs when the database can be queried, but the

Oracle 11g audit files Audit: The audit option enabled by default for Oracle 11g. The default value of AUDIT_TRAIL is DB, which indicates that audit data will be recorded in the base table of the audit dictionary in the database. In Oracle 10 Gb,

Record Oracle bad block Repair Process The following error was reported during RMAN cold backup yesterday when I received a backup call from my colleague. A tablespace backup failed.RMAN-00571: ========================================================

[Translated from mos] in Oracle db 12c, The alert_sid.log permission is changed every time the log is switched. 12calert_sid.log In 12c, The alert_sid.log permission is changed each time the log is switched. Source:Alert log file's permissions

Data structure, data structure and AlgorithmStack chain Storage 1. chained representation of stackThe stack's chain storage structure is called the chain stack, which is a single-chain table with limited operations. The insert and delete operations

(18) partitions in mysql (after development), 18 mysql Overview Before getting started, I saw the partition, And I squeezed it. Yesterday, I finally learned what partitioning is, but that is also the case. Today, we can sum up that good memory is

In the. Net project, the Oracle database configuration is linked through ODAC, And the odacoracle  In the. Net project, use ODAC to link Oracle Database configurations I. Development Environment 1. ODAC connection method ODAC directly uses Oracle to

Oracle divides a column into multiple columns, while oracle splits one column into multiple columns. Oracle divides a column into multiple columns In Oracle, we can use listparts (Oracle 11g and above) to merge multiple rows into one column. Now we

Mysql Study Notes 2 (Table constraints) and mysql Study NotesOperation table Constraints Integrity is the accuracy and consistency of the index data, and integrity check is to check the data accuracy and consistency. The mysql database management

Common commands for create table and Common commands for table Create table students (stuID integer not null, stuname char (30) not null, sex int not null); create table students (stuID integer not null, stuname char (30) not null, sex int not null,

[LeetCode] Department Highest Salary, solution report, leetcodesalary Question The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. Id Name Salary

Error 1313: RETURN is only allowed in a function SQL Statement, 1313 allowed 1. Error description 14: 07: 26 Apply changes to rand_stringError 1313: RETURN is only allowed in a function SQL Statement: CREATE PROCEDURE 'rand _ string' (n int)

What are the mysql data types? Data Type 1. The calculation principle of signed numbers is as follows: tinyint occupies 1 byte, that is, 8 bits:-2 to the power of 7 =-128 ~ Power 7 of 2-1 = 127 tinyint occupies 1 byte unsigned value range: 0 ~ 255,

Game test-database Statement 1, test database Statement 1Select id, name, energy from db_name where engrgy between '000000' and '000000'To sort the output content once, use order by asc to change from small to large to desc.Select id, name, energy

Purpose: Use bbed to change the scn information of datafile 5 that has been offline to the same as that of other datafiles ., Bbeddatafile Standard Reference self: http://www.xifenfei.com/1527.html   Objective: to change the scn information of

PostgreSQL tutorial (19th): SQL language functions, postgresqlsql I. Basic concepts: SQL functions can contain any number of queries, but the function returns only the results of the last query (which must be SELECT. In simple cases, the first row