Database Administrator

Example of Incomplete recovery based on time points When it comes to Incomplete recovery, there are generally three scenarios: Incomplete recovery based on time points, Incomplete recovery based on scn, and incomplete recovery based on cancel.In all

Use the date type in PL/SQL Use the date type in PL/SQL Previous articles introduced the use of strings and numbers in PL/SQL. There is no doubt that strings and numbers are important, but it can be determined that no application depends on the date.

Oracle Database physical file backup/recovery I have written a similar article before. Although it is not a problem to restore the physical files of the Oracle database, I always feel that something is wrong. I learned later that I had some

Oracle background processes background process Oracle process type:For the database process, the database instance contains or interacts with it.ORACLE processes are divided into client processes (ORACLE processes), background, server, and slave

Oracle 11g Database Password Expiration ORA-28002 Problem Solution Problem description and analysis: the user returns an error ORA-28002 upon logon, for example, prompting that the data will expire in 1 day. This is because the 11g password

How to Use the MySQL event Scheduler The Event sched feature has been added since MySQL5.1.0. It can be used for scheduled execution of certain tasks and can be seen as a time-based trigger. 1. Enable By default, event scheduling is disabled and

Oracle partition table data migration and Management Automation Process The following process is centered on the company's Oracle Database runtime environment. It is mainly written to achieve automation.Process completion tasks include1.

Analysis of SQL statement execution time and resource consumption using profilessql Open profiling, which is disabled by default. mysql> set profiling=1; Execute the SQL statement to be analyzed mysql> select count(1) from wechat_employee,Employee;

Mybatis performance optimization: reducing database connections and mybatis Performance Optimization The most important function for performance optimization is to reduce the interaction between databases. Many programmers generally only consider

Mybatis + Oracle batch processing, mybatisoracle 1. Batch insert In many cases, data insertion is involved. The MySQL dynamic SQL statement can solve this problem well. Of course, oracle has provided the batch insert statement: insert into students

MySQL Common commands -- create command use, mysql -- create Create Database create database db_test;create database if not exists db_test;drop databases if exists db_test; Create Table create table if not exists t_user( uid varchar(50)

Note for processing NULL values in Mysql integer operations: mysqlnull When CleverCode was recently exporting a report, it was found that the integer was null after the integer was subtracted. This is a matter of detail. I hope you will pay

MySQL multi-Table query, MySQLI. Use the SELECT clause for multi-table queries SELECT field name FROM table 1, Table 2... WHERE table 1. Field = TABLE 2. Field AND other query ConditionsSELECT. id,. name,. address,. date, B. math, B. english, B.

SqlServer obtains the latest full backup time of the database, and sqlserver obtains In application scenarios, SqlServer Incremental backup is performed on the basis of full backup. If you need to recover, you also need to restore the full backup

Install mysql on centos7 and centos7mysql From centos7, to maintain a better open source, the default database of the minimal version of the system is changed to mariadb, I decided to install mysql (after all, there is a difference between the two

Some useful SQLite commands are summarized, and sqlite commands are useful. Display table structure:Copy codeThe Code is as follows:Sqlite>. schema [table]Obtain all tables and views:Copy codeThe Code is as follows:Sqlite>. tablesObtain the index

SQL learning uses order by to sort by specified order or custom order, sqlorder We usually need to provide the customer with a custom sorting method for the query results based on the customer's needs. What are the implementation methods of SQL, the

Research on MySQL auto-growth primary key and MySQL growth primary key The keyword used for automatic MySQL growth isAUTO_INCREMENTBecause it is DDL, It is case insensitive. Columns used must be defined as keys, such as primary keys and unique keys.

Modify the logon authentication method in oracle and perform oracle logon authentication. By configuring the sqlnet. ora file, we can modify the oracle login authentication method.SQLNET. AUTHENTICATION_SERVICES = (CNT); operating system-based

Oracle study -- "ORA-00845: MEMORY_TARGET not supported on this system" error, oraclememorytarget Oracle study -- "ORA-00845: MEMORY_TARGET not supported on this system" error System Environment: Operating System: RedHat EL6 (64) Oracle: Oracle 11g