Database Administrator

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

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

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

Tips for SQL Server to detect database connection Sometimes you may need to check whether the services of a machine are up, or whether a database of a machine can be connected, cannot open ssms, and do not want to log on to the server. 1.

Oracle start command The start command can read the content in the file to the buffer, and then run the content in SQL * PLUS. the syntax of the start command is as follows:Start {url | file_name}The url is used to specify a url address, such as

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 "

DB2 view execution plan In DB2, it is not convenient to view the SQL Execution Plan for other databases. Several steps are required. Here I organize the steps into shell scripts for ease of use, as shown below: #! /Bin/sh Db2 connect to Db2-tvf $

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 segmented Query For example, you can use the LAG and LEAD statistical functions to query segments in Oracle on the Internet, the Lag and Lead functions can retrieve the data of the first N rows and the value of the last N rows of the same

Exploration of MySQL MMM data inconsistency The slave points to the key log output of the new master. Through the log output, we can roughly understand the execution process of MMM automatic failover or online switching. -- Automatic failover and

Install MongoDB 2.6.5 in CentOS 6/Linux MongoDB is a non-relational database (NoSql) that is very popular in the IT industry. Its flexible data storage method is favored by current IT practitioners. MongoDB implements the object-oriented idea. In

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,

Rman command line, directly startup db, rmanstartup I forgot where I saw it. It seems like this is a new feature of 11 GB.   [oracle@rhel63single ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Thu Feb 19 00:39:14 2015Copyright

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),

JDBC: Use the DBUtils tool class, jdbcdbutils Jar package: commons-dbutils-1.6.jar DbUtils class 1. DbUtils: Provides tools such as shutting down connections and loading JDBC drivers. All the methods in the tool are static. The main method is as

Database Operations -- get the returned values of stored procedures and returned values of Stored Procedures Write a stored procedure using the SQL Server database. The Code is as follows: create procedure proc_select @id intasbeginif exists(select

Mysql-one of slow query logs, Mysql-one of slow logsSlow query log1. When no results are returned after a certain period of time, the slow query log is recorded.2. Slow query logs can help DBAs find SQL statements with slow execution efficiency and

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