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

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

Conditions in Oracle databases where a datafile can be dropped Refer to the mos article:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Document ID 1050261.1) This datafile cannot be dropped because of any of the

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 "

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 creates tablespaces and users Oracle creates tablespaces and users 1. Connect to the database# Su-oracle$ Conn/as sysdba 2. Create a tablespaceSQL> create tablespace doiido datafile '/main/oracle/oradata/doiido. dbf' size 1024 M autoextend

Oracle group statement Inquiry Learning notes 1. The group by statement does not have the sorting function in Oracle. order by must be used to sort the statements according to the predefined results. 2. cube extension of group With test(Select 1 id,

Oracle object-oriented and set This is a summary of my recent learning experience. 1. Oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that reflect the object-oriented thinking.

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

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

Perform an experiment where the initial value is smaller than the uniform size. After the table is created, the extents of minextents uniform size are created., minextentsextents Perform an experiment where the initial is smaller than the uniform

Oracle triggers and Oracle triggersOracle triggers A trigger is a special storage process that is automatically triggered by the Oracle system when a database occurs. Triggers are usually used to enhance database integrity constraints and business

SQL optimization -- Logical optimization -- condition simplification, SQL -- 1) query Conditions Query condition concept: In SQL query statements, the expressions used to filter and connect tuples are expressions in the WHERE/JOIN-ON/HAVING

Oracle fails to get the index result due to an error. oracle does not get the index. There is a script that has been running for a long time and does not produce any results immediately after optimization. The original statement is as follows: SQL>

T_ SQL rowtype, t_sqlrowtype T-SQL formats: Declare Statement Begin Processing End -- complete   Nvl function nvl (string, value ); Returns a string if the string is not empty. Returns the value if the string is null.   Enter a job

An error occurred while uninstalling oracle11g. the file cannot be deleted. The file is in use.When you uninstall oracle11g After the service is stopped, run C: \ myoracle \ think \ product \ 11.2.0 \ dbhome_2 \ deinstall Deinstall. bat in You

Oracle dbms_random.value, dbms_random.value Dbms_random is a package that can generate random values or strings. There are two usage methods for value () in the package:If there is no parameter in the first type, a 38-bit precision value is

Database tree query, database tree During this period of time, I worked with others to develop a new function in my internship company. I am mainly focusing on database operations! One of them is data validation, and this data exists in the database

Thinkphp association model and thinkphp Model Thinkphp comes with the associated model has_plugin. Use: Create ProductModel. class. php In the Model folder. The Code is as follows: use Think \ Model \ RelationModel; class ProductModel extends