Database Administrator

Oracle Database faults Common Oracle Database faults: 1. system faults: sudden power outages and system restarts caused by operating system errors during server operation. Problems: memory data loss and database data inconsistency. Database data

GoldenGate supports the lowest MySQL version 5.1.5 GoldenGate's official documentation clearly states that GoldenGate needs to set the MySQL Log format (binlog_format) to ROW, and the other two formats (MIXED or STATEMENT) are not supported. ########

Oracle dynamic server parameter fileThe Oracle dynamic server parameter file (SPFILE) SPFILE is a binary file that is automatically maintained by the Oralce server process. This file cannot be manually modified. Once it is manually modified, it

Oracle static parameter file Oracle static parameter file) A static parameter file is a text file. The Oralce instance reads the content of this file at startup, So if you modify the content of this file, you must restart the Oracle instance to

MySQL enables audit for common users (without super) Recently, it was found that the bad guy deleted the data and could not find the user and host. It was found that mysql was able to enable the audit function for users without the super permission,

Oracle random generation date When developing an Oracle testing environment, companies sometimes need fake data to test the functions and performance of applications. It is really troublesome to manually enter a bunch of SQL statements every time.

About the three date types in MySQL After two insert date types recently, the value is 0000-00-00 00:00:00, so I checked the official documentation and found the reason. In Mysql, we often use three data types to store dates: Date, Datetime, and

How to calculate the automatically managed UNDO tablespace size AUTO UNDO Automatic undo Management (AUM) requires almost no configuration. Basically, you only need to define the time needed to keep the previous image available. This is controlled

How to Use AWR reports to diagnose database performance problems How to proactively avoid problems and collect diagnostic information Some problems are unpredictable, but most other problems can be avoided if some signs are discovered early. At the

ORA-21561, ORA-15055, ORA-25253 causes the DG slave database to be unable to apply ArchiveYesterday I went to a customer to do inspection, by the way, to see whether the last build of the RAC-DG environment is normal, the last DG was run in August 20

PL/SQL Developer Practical Skills 1. PL/SQL Developer remember the Login Password When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for ease of work; Setting Method: PL/SQL Developer

Batch create log table information scripts in MySQL The script for creating log tables in batches in MySQL is as follows: Drop PROCEDURE if EXISTS reqSp;DELIMITER //Create procedure reqSp (sTime varchar (32), eTime varchar (32), tchema varchar (32 ))

MySQL system variables) MySQL system variables are actually some system parameters used to initialize or set the database's occupation of system resources and file storage location. These System variables can be modified at the global and session

Environment configuration of MyBatis I wanted to learn about mybatis a long time ago. It is said that many companies use this framework. In the past, I used DBCP, Which is outdated. Hibernate felt too big. Now I want to learn this neutral framework.

MySQL changes user password and resets root Password Changing the password for a database user is one of the common tasks of DBA. There are several different ways to change the password of a MySQL user account. We recommend that you use the

ORA-00904: "T1". "AREA_ID": Invalid identifier, ora-00904area_id 1. Error description ORA-00904: "T1". "AREA_ID": Invalid identifier 00904. 00000-"% s: invalid identifier" * Cause * Action An error occurred while listing 45 columns and 8

Index statistics collected bug, collectedThe SQL Execution engine obtains the data that generates the optimal execution plan from the dictionary tables and views of related systems, such as pg_stats and pg_class. If the data in the dictionary view

Lock (lower), lock ( (2) Unlock MethodAlter system kill session '2010 3';/* 878,177 is SID, 878 is SERIAL #*/ Select/* + rule */s. username,Decode (l. type, 'Tm ', 'table lock', 'tx', 'row lock', null) lock_level,O. owner, o. object_name, o.

Full-text index-comparison of two Chinese lexical analyzers (chinese_vgram_lexer chinese_lexer ),First, let's compare the Chinese Lexical analyzer. the test process is as follows:Create a table create table test (str varchar2(100)) ;create table

How can my son query their call records when he has a girlfriend? QQ1622863529, qq call recordsQuery serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries, delete QQ chat records,