Database Administrator

Restrictions on InnoDB table objects Restrictions on InnoDB table objects: Maximum and minimum InnoDB log files cannot exceed 512 GB InnoDB system tablespace requires at least 10 MB Space The default data page size in the database is 16 kb.

Oracle instance hang is occupied by NFS mount points disconnected on AIX. Oracle instance hang is occupied by NFS mount points disconnected on AIX.From mos: Disconnected NFS Mount Point Causes Instance to Hang on AIX (Document ID

Define the package and usage of stored procedures in Oracle Define the package and usage of stored procedures in Oracle Use the dept table under the scott account; Select * from dept order by deptno; 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30

Trace in SQL Server Preface When talking about tracking, many people think of scenes in the Police film. Similarly, "tracking" is everywhere in our SQL Server database. If we make good use of tracking techniques, in this way, you can perform

Oracle linesize command You can use the linesize command to set the number of characters that a row can accommodate. The default value is 80. If the value of linesize is small, one row of data in the table will be displayed in multiple rows on the

Restore an offline drop datafile in Oracle archive Mode Reference:How to recover offline dropped datafile in archivelog mode (Document ID 286355.1) The following experiment is completed based on Oracle 11.2.0.4 linux x86-64bit. [Oracle @

SQL Server Remote Backup Database Regular backup of SQL Server databases is often required. It is quite easy to back up data to the local machine on a regular basis and the task can be completed. However, if the entire machine crashes, it makes no

DBD: mysql: dr: imp_data_size unexpectedly error Solution The latest MHA verification encountered the error DBD: mysql: dr: imp_data_size unexpectedly. The DBD package has been installed. The following describes the problem and solutions. 1. fault

SQL Server database startup process details and analysis and solutions to problems that cannot be started Currently, as an excellent RDBMS of Microsoft, the SQL Server database has very few problems when it is started. When we use it at ordinary

Oracle merge into usage 1. Use of merge Merge is a very useful feature. It is similar to merge into in DB2 and insert into on duplicate key in Mysql. Merge into is a new feature that appears after Oracle 9i. In simple terms, it can be a function of "

Spring MVC link PostgreSQL The previous article has shared the following steps to build Spring MVC: This article links to the database PostgreSQL 1. Add several dependencies in pom. xml org. postgresql postgresql 9.3-1102-jdbc4 org. apache.

Oracle cursor Introduction Oracle cursor Introduction The PL/SQL cursor in Oracle stores the data queried in the database in the memory as a temporary table. The cursor can operate on the data stored in the memory, one or a group of data is returned,

Oracle 11g detailed steps for building a standuard (physical standby all operations) Preface: DataGuard establishes a reference relationship by establishing a PRIMARY and STANDBY group. Once STANDBY is created, DataGuard passes the REDO of the

MongoDB uses replica set backup to add new secondary replica members Problem description: In the production environment, when the read Pressure on secondary replica members is high, you can relieve the pressure by adding new secondary replica

[Translated from mos] file # = 0 is damaged in V $ BACKUP_DATAFILE, Source:V $ BACKUP_DATAFILE Shows before uptions for File #0 (Document ID 399113.1) Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to

Case study of incomplete log records of RAC split-brain due to not configured diagwait, diagwaitrac1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log

ORA-38301, ORA-00604, purge dba_recyclebin is not good, ora-38301ora-00604 An error ORA-38301, ORA-00604, purge dba_recyclebin is encountered during alter/drop tablespace Applicable:Oracle Database-Enterprise Edition-Version 10.2.0.1 and

Atitit. disadvantages of orm and market share of orm framework, selection attilax summary, ormattilax Atitit. disadvantages of orm and market share of orm framework, selection attilax Summary   1. Requirements of the attilax orm framework 1 2. orm

The Oracle database server uses an aix midrange computer and is used as the level-1 mount point of the nfs client. You must master one knowledge point: In the aix operating system (this problem occurs only in aix, but not in other operating systems),

SQL Server's C # connection and object existence judgment,C # connect to SQL Server This article provides a comprehensive overview of C # database connection. Http://blog.csdn.net/candy1232009/article/details/7654927 For C # connection to ms SQL