Database Administrator

RMAN backup encountered a ORA-600 Error It was normal that the backup encountered an OR-600 error last night. The specific error is: RMAN-03002: failure of backup command at 12/30/2012 04:00:06 ORA-00600: internal error code, arguments: [525], [0x700

Analysis of MySQL High Availability For most applications, MySQL is the most critical data storage center. Therefore, we have to deal with the problem of how to make MySQL provide the HA service. When the master is running, we need to think about

The process of reading and modifying data blocks in Oracle Oracle databases process SQL statements in three steps: parsing (parse), executing (exec), and returning results (fetch ). For ease of understanding, we first omit the SQL processing process

Oracle stored procedure returns (N) working days based on the specified date I have never written any Oracle stored procedures. Today I have a sudden demand: Calculate the first N working days of the specified date or the next N working days

Oracle Data Dictionary Oracle uses data dictionaries to manage and display database information. data dictionaries usually store database metadata, which is the "Database" of databases ". Generally, a data dictionary consists of four parts: an

Reset the startup time after the GoldenGate process is disconnected. After the system is restarted, the operator does not restart the goldengate process, resulting in the disconnection of the replication link.In addition, some archiving logs have

SQL programming-advanced queries and precautions 1. What is a subquery? When one query is a condition of another query, it is called a subquery. For subquery, you can use several simple commands to Construct Powerful composite commands. Subqueries

ORA-00911 error resolution instance ORA-00911, "911" looked very domineering error number, although I am still a beginner of Oracle, but every time I encounter a not seen ORA error number, there is a kind of catch-up, based on the error code, OERR,

MySQL lock mechanism details and deadlock Handling Methods To optimize MySQL in high concurrency, it is necessary to understand the lock table mechanism when MySQL queries an update. I. OverviewMySQL has three levels of locks: Page, table, and

Data structure, data structure and AlgorithmApplication background Student electivesVertex -- indicates the courseDirected arc -- indicates a prerequisite. If course I is a prerequisite for course j, an arc (I, j) is shown in the figure)In what

Functions of mysql view and mysql View A view is a virtual table that is exported from one or more tables in the database. A view can also be defined based on an existing view. In the database, only view definitions are stored, and no data in views

MySQL understands the indexing and indexing principles, and mysql understands the indexing principles. [Understanding indexes] To understand indexes, you must first understand how data is stored on the hard disk. Different storage engines may adopt

Haproxy performs Load Balancing for mysql and haproxymysql1. First install haproxywget http://haproxy.1wt.eu/download/1.4/src/haproxy-1.4.24.tar.gztar zcvf haproxy-1.4.24.tar.gzcd haproxy-1.4.24Make TARGET = linux26 PREFIX =/usr/local/haproxy #

Modify tables, add columns, delete columns, and modify columns in oracle1. Add ColumnsAlter table table_name ADD (column datatype [default expr] [, column datatype...]);For example:SQL> ALTER TABLE emp01 ADD eno NUMBER (4 ); 2. Modify column

Active Report export function, activereport I checked a lot of information on the Internet and provided a complete solution. I tried it in the system and found it was not easy to use. When using the export function, I must reference several

Locale: facet: _ S_create_c_locale name not valid solution, isnotavaliddate Among many shell scripts, we often see the previous sentence "LC_ALL = C" SAR_CMD = "LC_ALL = C sar-u-B 1 5 | grep-I average" in front of a command. meaning? LC_ALL = C is

Database and database LearningCode Set K to the attribute or Attribute combination in R . If k u is used, K is called the R Candidate code or the Candidate Key ). If there are more than one candidate code, select one of them as the master code or

Jedis slice (cluster) Non-slice (single-host) instance, jedis Cluster Package testRedis; Importjava. util. ArrayList; Importjava. util. Iterator; Importjava. util. List; Importjava. util. Set; Importredis. clients. jedis. Jedis; Importredis. clients.

Oracle timer and oracle scheduled task Declare Jobno number; Begin dbms_job.submit ( Jobno, -- timer ID, automatically obtained by the System 'Prc _ INSERT; ', -- what is the name of the execution process Sysdate, -- next_date, the time when the

SQLite tutorial (8): command line tool introduction, sqlite command line To do well, you must first sharpen your tools. Learning SQLite's command line tool is very helpful for us to learn SQLite itself. The most basic one is that it makes learning