Database Administrator

The customer's database uses the cursor_sharing = similar parameter. After testing, it is found that this parameter greatly affects the performance of expdp.The essential reason is that the SQL Execution Plan has changed.Under normal circumstances,

Today, a colleague wrote to me: "I mistakenly dropped a stored procedure: P_IPACCHECK_NC about 10 minutes ago. The source code of this stored procedure is not backed up on my local machine, please recover. Thank you"  This recovery is very easy,The

To change the non-archive mode of an Oracle database, you must restart the database and modify it in mount mode. 1. Shut down the database in shutdown immediate Mode 2. Start the instance to the mount status. 3. Change the non-running mode and open

Single Replication sets design: , 10.9.3.228, only Mongos and config services are started. Pai_^ [root @:/usr/local/mongodb/bin] # cat runServerConfig. sh ./Mongod -- configsvr -- dbpath = ../data/config -- logpath = ../data/config. log -- fork

Description:The source database is the Oracle11gR2 database with two clusters of 64-bit HP-UNIX,The target database is a 64-bit Linux Oracle11gR2 database,Transfers the data of a user in the source database to the target database. 1. Both the source

Run ps-ef | grep ora _ to check that no Oracle process is found.Entering the database boot encountered a ORA-01261: ORA-01262: error. $ Sqlplus "/as sysdba" SQL * Plus: Release 10.2.0.1.0-Production on Tue Dec 15 08:25:22 2009 Copyright (c) 1982,2

After the Oracle process is KILLED, the state is set to "KILLED", but the locked resources are not released for a long time, the following error message will appear: ORA-00030: User session ID does not exist Or ORA-00031: session marked for kill In

1. concurrent to no-concurrent, and importvg through exportvg, which cannot be solved; It should be: Host: Varyonvg-f dbvg // activated in no-concurrent Mode Chvg-l dbvg // forcibly convert to no-concurrent; Varyoffvg dbvg On the slave server:

1. latch free wait event SQL: Select *From v $ session_wait tWhere t. EVENT not in('SQL * Net message from client', 'rdbms ipc message ','SQL * Net more data from client',' SQL * Net more data to client ','SQL * Net message to client', 'jobq slave

1. Download The mongodb-linux-i686-1.8.2.tgz in the directory/home/nh/Downloads/and unzip it to get the mongodb-linux-i686-1.8.2 2. Create the directory data1 under/home/nh/Downloads/mongodb-linux-i686-1.8.2 and create the file log1.log under

There are also a lot of articles about OTL on the Internet, but it seems that it is only official documents. OTL is very easy to use. Combined with some official examples, you can try more to understand it. After about a month of project development,

How to improve query efficiency using Oracle statements1:... where column in (select * from... where ...);2:... where exists (select 'x' from... where ...);The second format is far more efficient than the first one. IN Oracle, almost all IN operator

1. PurposeDefine database design specifications as technical references for database design, planning, development, and maintenance personnel.2. OverviewThis document describes the design specifications for database environment configuration,

1. SQL query Select parameter from v $ option where parameter in ('partitioning '); 2. E: \ Oracle \ product \ 10.2.0 \ db_1 \ oui \ bin \ setup.exe, click Billing module 　 　 　 Product Module Oracle

The Innodb database only marks deleted data and does not actually release the occupied disk space, which leads to the increasing number of InnoDB database files. If you want to completely release the deleted data, you need to export the database,

I. Basic Information OS: RHEL 3 CPU: 4 Intel (R) Xeon (TM) mp cpu 2.70 GHz Mem: 8 GB Swap: 16 GB Disk: 120 GB Oracle Database 10g Enterprise Edition Release 10.1.0.3.0Ii. Backup Mode The database runs in archive mode and supports multi-level

Requirement Analysis:Migrate the entire table structure, table data, and inter-Table constraints of the source database to the target instance;Delete all tables and users in the target database and recreate the users in the target database:Drop user

In Oracle, the management of scheduler is mainly implemented through dbms_scheduler. Previous work: Create a user: create user sched identified by oracle; Grant create session to sched; Grant scheduler_admin to sched; Log on to the database using

Parameter changes:Skip-locking is not recognized in 5.5 and changed to skip-external-locking.Basedir =/usr/local/mysql5.5Datadir =/usr/local/mysql5.5/dataInnodb_data_home_dir =/usr/local/mysql5.5/dataInnodb_log_group_home_dir

1. Create a temporary tablespace Create temporary tablespace TS_TMP TEMPFILE 'd: \ Oracle \ ORADATA \ TMP. dbf' SIZE 32 M AUTOEXTEND ON NEXT 32 m maxsize 2048 M Extent management local;   2. Create a data table space Create tablespace