Database Administrator

On the linux server running the Oracle database, the load per minute in a certain period of time will suddenly rise to more than 40, and kswapd0 appears in the process queue, resulting in no response to the database, lasting for several minutes.For

Version 11.2.0.1.0Rac1Rac2Linux 5.3U 2.6.18-128. el5Because we need to fix a bug for testing, modify the implicit parameter on a node, and then restart it! During the testModified the parameters on rac1.Sys @ rac1> alter system set "_ gc_read_mostly_

1. Oracle 11g asmPfile parameter file path $ ORACLE_HOME/dbs/init + ORACLE_SID.ora for example ORACLE_SID = + ASMPfile $ ORACLE_HOME/dbs/init + ASM. ora The content is as follows: *. Asm_diskstring = '/dev/sda2'*. Asm_diskgroups = 'dgasm1'*.

If there is a deadlock in the Oracle database, the database will report the error code of the ORA-00060, this deadlock phenomenon is usually caused by the application logic design error, and the oracle database design has nothing to do, now we use

The backup manager RMAN provides the configure retention policy command to set the backup storage POLICY, that is, how long the backup file is retained. RMAN identifies the backup files that have exceeded the time as obsolete (obsolete ). Command

I. Horizontal and vertical tablesHorizontal table: usually refers to the table we create in the database at ordinary times. It is a common table creation method.(Primary Key, Field 1, Field 2...) such as: time, customer ID, basic call fee, roaming

Differences between sys and system users 1) The most important difference is that the importance of stored data is different. Base tables and views of all Oracle data dictionaries in sys are stored in sys users. These base tables and views are

PhpMyAdmin is installed by default and can only be connected to one MySql server. Its configuration information is stored in the phpMyAdmin configuration file. When we need to switch between multiple servers for login, it is very troublesome to

Because highly available database servers may rarely stop, SQL Server's log files will grow very large. In this way, it is difficult for DBA to use error log to find information, and the performance will be affected when the log is large.  We

Common Oracle DBA operations Modify language environment Change Chinese environment to English environment Alter session set als_language = 'American '; Change the English environment to a Chinese Environment Alter session set nls_language =

As a DBA of an Oracle database, deploying an Oracle database is a basic skill. What should be included in the complete deployment of an Oracle database? The following is a brief discussion. 1. Set up the basic environment. The key to this step is to

Steps to solve Oracle undo tablespace explosion: 1. Start SQLPLUS and log on to the database with sys.# Su-oracle$> Sqlplus/as sysdba 2. Find the UNDO tablespace name of the database and determine the UNDO tablespace used by the current routine:Show

The development process has been running on the local mysql Data. After the test is completed, connect to the LINUX Server database. The result is always an error and the table cannot be found! What I wonder about is that the table is clearly

Oracle ORA-28002: the password will expire within 10 days solution: 1. query the perfile file of this user. Select username, profile from dba_users where username = 'Scott '; 2. query values by file name Select * from dba_profiles where profile =

Some people say that the rules of the timestamp field are "weird ". The Manual describes the complex rules of timestamp fields in MySQL. Divided into two parts Define rules: 1. The timestamp field has three attributes: A) whether to allow NULL. The

Symantec NBU backup Oracle 11g Backup log errors under/user/openv/ Recovery Manager: Release 11.2.0.3.0-Production on Mon Sep 17 14:36:11 2012 Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved. Connected to target database:

If you want to restart the listener, you cannot find it. [Oracle @ node1 ~] $ Srvctl stop listener-n node1CRS-0210: cocould not find resource ora. node1.LISTENER _ NODE1.lsnr. View listeners [Oracle @ node1 ~] $ Srvctl config nodeapps-n node1-lThe

Dual is a virtual table used to form the select syntax rule. Oracle ensures that there will always be only one record in dual. We can use it to do a lot of things, as shown below:1. view the current user. You can execute the following statement

Query all sequences in Oracle: Note: 1. You must log on as an administrator; 2. sequence_owner must be in upper case, regardless of whether your user name is in upper case. Only uppercase letters can be recognized. -- View All sequences of current

MySQL Stored Procedure array implementation: DELIMITER $ Drop procedure if exists 'array' $ Create procedure 'array '() BEGIN SET @Array_content="Www mysql com hcymysql blog 51cto com"; SET @I=1; SET @Count=CHAR_LENGTH(@