Database Administrator

Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations 1. Introduction to GoldenGate Oracle Golden Gate is a log-based copy and backup software for structured data. It parses online logs of the source database or archive logs to

Problems and Solutions of impdp ORA-39002, ORA-39166 and ORA-39164 During performance tests on imp and impdp, we found that if the table contains a lob field, loading is really slow, and there are about 1000 entries per second. At this speed,

An example of DB2 data recovery: SQL0928N The environment is AIX 6.1 and DB2 9.7.0.7.First, check whether the db2 master process exists. Ps-ef | grep db2sys If the database does not exist, use db2start to open the database. The backup media is a

Mysql INNODB Engine lock principle test, mysqlinnodb engine lock How does mysql INNODB Engine lock work? Let's test it. Mysql> select version ();+ ----------- + | VERSION () | + ----------- + | 5.5.20 | + ----------- + 1 row in set (0.00

SQL generates n-bit random strings and SQL generates n -- 1. Use newid () go -- to create a view (because newid () cannot be directly used in the function) create view vnewid as select newid () N 'macoid '; go -- create function getrandstr (@ n int)

Step 1 of kettle's User Defined Java Class, kettledefinedZookeeper Step 1 of User Defined Java Class)   The "user-defined java class" step in kettle, also known as the UDJC step, is available in version 4.0 and has powerful functions and is

Export and Import mysql Data in linux Export all data in the entire database 1. Enter the following in the linux Command Line: mysqldump -u userName -p dabaseName > fileName.sql FileName. It is best to add the path name to SQL. Export the data

The student table sid, sname, and student table cid, cname, and student transcript table sid, cid, and cscore. The name of the course with the highest score required for the student, snamecscore -- 1. Table creation SQL: -- Student table: --

Data room charging system checkout BUG, charging system checkoutDisclaimer: the following content only applies to those who put the card table and the return table in the same table!Recently, we have started to rebuild the charging system of the VB.

Data room charging system-use of stored procedures and charging system storage process In the "checkout" section of the data center billing system, You must select an operator and click the "checkout" button to change the registration, recharge, and

SQL commands for regularly deleting historical data from databases and SQL commands for historical data Create a job,Used to regularly clear historical database data Delete the data of the first quarter of the table before gps_comm, as

Restore table accidentally deleted records, and delete table records by mistakeRestore table accidentally deleted records  I recently handled a user's accidental deletion of the delete table. Here I made a simple summary. The content of this article

Queries the average number of transactions per second and the average number of transactions per second1. Directly query the view select * from DBA_HIST_SYSMETRIC_SUMMARY where metric_unit = 'transactions Per second'METRIC_NAME metric indicator

Use stored procedures and stored proceduresWhat is a stored procedure is simply a set of one or more MySQL statements for future use. It can be considered as a batch file, although their role is not limited to batch processing. Like defining a

Integrity constraints (Chapter Summary), integrity constraints Chapter Summary1. The Integrity Constraint of the database is a check measure for data updating. One or more constraints exist on a data table.2. constraints are divided into five types:

Transformers (SqlHelper) and transformers sqlhelper 1. Basic Introduction SqlHelper is a database operation component based on · NET Framework. The component contains the database operation method. SqlHelper is used to simplify the repeated

Part 1 Database SQL language Begin and end in database scripts   In database scripts, begin and end are a strange word. Without them, some code looks confusing; adding them makes the structure of the Code instantly clearer. Indeed, begin and end are

Redis-cli command summary, redis-cli Summary Redis provides a variety of commands to operate databases and data types. These commands can be used on Linux terminals. Redis-cli command Summary 1. Connection operation-related commands Quit: disconnect)

MySQL full-angle conversion to half-angle, mysql full-angle conversion to half-AnglePreface:When a user entered a fullwidth mobile phone number during registration, the text message system failed to send the text message based on the mobile phone

Conventional-path insert (traditional path insert), sys. path. insert We have already mentioned Direct-path.INSERTNow let's talk about Conventional.INSERT. Source: "Oracle Database Administrator's Guide11GRelease 2 (11.2 )" Conventional and