-
编辑 删除
关于exp和imp
EXP、IMP命令语句可以说是Oracle数据库管理员的利器，用好这两个命令会使数据库管理工作事半功倍。先来看看EXP、IMP命令的用途： 一、用途： 1、在不同的系统平台间移植数据。 2、数据库的备份和恢复手段之一。 3、用于用户间的数据移动。二、基本语法和实例： 1、EXP: 有三种主要的方式（完全、用户、表） 1、完全： EXP SYSTEM/MANAGER BUFFER=64000 FILE=C:FULL.DMP FULL=Y 如果要执行完全导出，必须具有特殊的权限 2、用户模式： EXP SONIC/SONIC BUFFER=64000
-
编辑 删除
ORACLE的RESUMABLE特性
In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective? A.AFTER CREATE B.AFTER SUSPEND C.BEFORE CREA
-
编辑 删除
not exists 与 not in的效率差异
select *from t_cs_personcust twhere (is_new = '001' or is_new = '011' or is_new = '101' oris_new = '111')and not exists (select distinct cust_idfrom t_cs_personcust_appwhere (is_new = '001' or is_new = '011' oris_new = '101' or is_new = '111')and message_no = '初始导入'and cust_id = t.cust_id); 检索数据2796条，检索时间 3.516 秒 select *from t_cs_personcust twhere (is_new = '001' or is_new = '011' or is_new = '101' oris_new = '111')and cust_id not in (select distinct cust_idfrom t_cs_personcust_a
-
编辑 删除
一次死锁问题的排查过程
问题描述：[Gaia2.5] DEBUG 2011-02-09 13:28:01,338 [java.sql.Connection:42] - {conn-100213} Connection[Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:48] - {pstm-100214} PreparedStatement: {call pac_ac_center.pro_precount (?,?,?)}[Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:49] - {pstm-100214} Parameters: [2011-02-01, li_xiang][Gaia2.5] DEBUG 2011-02-09 13:28:01,352 [java.sql.PreparedStatement:50] - {pstm-100214} Types: [java.sql.Date, java.lang.String]=
