PHP

The second day of the accident, the alertlog of the database is analyzed. From the log, we can see that after the database is down on instance NODE2, RAC has made the instance switching step, but On the second day of the accident, the alert log of

Describes the process of installing Oracle10201 on AIX. First check whether the system meets the database installation needs: # usrsbinlsattr-E-lsys0-arealmemrealmem Describes the process of installing Oracle10201 on AIX. First, check whether the

ORA-00600: internalerrorcode, arguments: [ktrgcm_3] ORA-00600: internal error code, arguments: [ktrgcm_3] I was planning to conduct an in-depth study on Oracle Data dictionary this evening, but when I was about to finish the research, I

Understanding of Oracle architecture ------- preliminary understanding first, the Oracle architecture has a system diagram, which I also understand. In fact, this figure shows the architecture. Understanding of Oracle architecture -------

Parallel Oracle database operations, especially in the RAC environment, can improve the database performance to a certain extent. Therefore, it is necessary to understand the relevant initialization parameters. Parallel Oracle database operations,

The oraclerealapplicationters ters (RAC) series of best practices and Beginner's guide aims to help customers quickly understand the implementation, upgrade, and maintenance of Oracl The Oracle Real Application Clusters (RAC) series of best

1. mysql encoding: mysqlgt; showvariableslike 1. mysql encoding: mysqlgt; show variables like I. mysql Encoding Mysql> show variables like 'collation _ % ';+ ---------------------- + ------------------- +| Variable_name | Value |+ --------------

After the jar file of the udfudafudtf function of hive is developed, you must put the jar file into the hive environment for use. You can add the following three methods: After the jar file of the hive udf udaf udtf function is developed, you must

In the recent project, you need to copy several dump files (text format, 1 ~ 2 GB) records are imported into the mysql database. Due to the large data volume (millions or tens of millions of records ), In the recent project, you need to copy several

The deduplication technology can provide a larger backup capacity, ensure data retention for a longer period of time, and achieve continuous verification of backup data, improve the level of data recovery service, and facilitate the

Solution to the error when installing the Oracle10g2 link of Solaris10u10 Solution to the Problem of Oracle 10g2 connection installation during Solaris 10 u10 Solution to the Problem of Oracle 10g2 connection installation during Solaris 10

The permission system of Oracle is divided into system permission and object permission. Databasesystemprivilege allows users to execute specific command sets. For example, createta The permission system of Oracle is divided into system permission

The Oracle synonym (synonyms) is literally an alias. Similar to the attempted function, it is a ing relationship. This topic describes how to create and delete a synonym statement. The Oracle synonym (synonyms) is literally an alias. Similar to the

One or several autonomous transactions can be defined in a transaction (outer transaction. An autonomous transaction can be committed independently without affecting the outer transaction. One or several autonomous transactions can be defined in a

Rman (recoverymanager) is used to manage backup, dumping, and recovery operations. When the rman command is executed, oracle resolves these commands Rman (recovery manager) is used to manage backup, dumping, and recovery operations. When the rman

When talking about rman, we need to talk about catalog, that is, restoring the directory. I don't think this stuff is very useful. If the database does not reach the open state, restoring the directory database won't be connected at all. When

According to the sqlite3 api, during subsequent tests, we found that for sqlite3, whether the transaction is enabled or not only inserts pieces of data, and the time gap is very obvious. According to the sqlite3 api, during subsequent tests, we

Oracle online redo log files record all database changes (DML, DDL, or structural changes made to the data by the Administrator) for accidental deletion or downtime Using Log Files Oracle online redo log files record all database changes (DML, DDL,

Hive and HBase integration, query exception, re-execute the Hive statistical command, there may be exceptions, because my MapReduce has been used before, and has already added pro to Hadoop Hive and HBase integration, query exception, re-execute the

The method for updating the current table in the Oralce trigger. This article describes two problems: 1. Differences between the update trigger before and the after. 2. After A field in Table A is updated, the trigger triggers The method for