-
编辑 删除
oracle和sqlserver互访(转)
oracle和sqlserver互訪! 前几天由於工作的原因查找了oracle中查找sqlserver數据的資料,現測試成功,整理一下貼出!要求:從Oracle中能取SqlServer的數据環境:OracleDb: Linux + Oracle9i Enterprise Edition Release 9....
-
编辑 删除
ORACLE锁
0：none 1：null 空2：Row-S 行共享(RS)：共享表锁，sub share 3：Row-X 行独占(RX)：用于行的修改，sub exclusive 4：Share 共享锁(S)：阻止其他DML操作，share5：S/Row-X 共享行独占(SRX)：阻止其他事务操作，shar...
-
编辑 删除
oracle不同版本之间exp/imp规则
moving data between different releases of the Oracle database server, the following basic rules apply:The Import utility and the database to which data is being imported (the target database) must be ...
-
编辑 删除
Whats the difference between the v$sql* views(转)
What is the diff between:v$sql v$sqlarea v$sqltext v$sqltext_with_newlines when I query v$sql joining with v$session and filter by a SID I get more than one SQL (expected) but if I join v$sqlt...
-
编辑 删除
查看Oracle各组成部份(如数据块头)的大小
SQL>select * from v$type_size; COMPONEN TYPE DESCRIPTION TYPE_SIZE-------- -------- -------------------------------- ----------S EWORD EITHER WORD ...
-
编辑 删除
CMake的安装和使用
1. cmake安装（1）从源码安装下载cmake源码cmake-2.6.2.tar.gzhttp://www.cmake.org/cmake/resources/software.html编译安装tar xvf cmake-2.6.2.tar.gzcd cmake-2.6.2/如果本机上不存在...
-
编辑 删除
What is OPAQUE_TRANSFORM Hint and how to Control it [ID 780503.1]
What is OPAQUE_TRANSFORM. Hint and how to Control it [ID 780503.1] 修改时间 12-SEP-2010 类型 HOWTO 状态 PUBLISHED In thi...
-
编辑 删除
Automatic Storage Management (ASM)(转)
Automatic Storage Management (ASM) in Oracle Database 10gAutomatic Storage Management (ASM) is a new feature that has be introduced in Oracle 10g to simplify the storage of Oracle datafiles, controlfi...
-
编辑 删除
DRM --- RAC object remastering ( Dynamic remastering )
RAC object remastering ( Dynamic remastering ) In RAC, every data block is mastered by an instance. Mastering a block simply means that master instance keeps track of the state of the bloc...
-
编辑 删除
oracle数据加密
create or replace function encrypt_data(p_text varchar2, p_key varchar2) return varchar2 isv_text varchar2(4000);v_enc varchar2(4000);beginif p_text is null thenreturn null;elsev_text := rpad(p_text, ...
-
编辑 删除
Oracle Tables
GeneralTable Related Data Dictionary Objectstab$col$DBAALLUSERdba_col_commentsall_col_commentsuser_col_commentsdba_external_tablesall_external_tablesuser_external_tablesdba_external_locationsall_exter...
-
编辑 删除
Use SYS_CONTEXT to Obtain Session Information
select SYS_CONTEXT('USERENV','TERMINAL') terminal,SYS_CONTEXT('USERENV','LANGUAGE') language,SYS_CONTEXT('USERENV','SESSIONID') sessionid,SYS_CONTEXT('USERENV','INSTANCE') instance,SYS_CONTEXT('USEREN...
-
编辑 删除
ORACLE数据加密(转)
ops$tkyte@DEV816> variable x varchar2(25)ops$tkyte@DEV816> ops$tkyte@DEV816> exec :x := 'How Now Brown Cow';PL/SQL procedure successfully completed.ops$tkyte@DEV816> ops$tkyte@DEV816> declare2 l_data ...
-
编辑 删除
goldengate + asm + rac
add extract ext1,tranlog,threads 2,begin nowTRANLOGOPTIONS DBLOGREADER2012-01-10 10:49:52 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, ext1.prm: Getting attribu...
-
编辑 删除
软解析、硬解析的一个小测试
看到这个帖子http://www.itpub.net/744933.html 的提问，做两个简单测试，由于近期较忙，文中解释内容比较少，希望抛砖引玉，大家讨论。SQL> SELECT NAME,VALUE FROM V$MYSTAT A,V$STATNAME B WHERE A.STATISTIC#=B....
-
编辑 删除
oracle10g自动分析任务
oracle10g利用scheduler自动执行分析任务。。。。。。dbms_schedulerselect owner,job_name,program_name from dba_scheduler_jobs;停止启动分析：exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');exec dbms_s...
-
编辑 删除
forall在10g新功能
In Oracle Database 10g, PL/SQL now offers two new clauses in the FORALL statement, INDICES OF and VALUES OF, which allow you to choose very selectively which rows from the driving array should be proc...
-
编辑 删除
lsof(zt)
lsof: 一般root用户才能执行lsof命令，普通用户可以看见/usr/sbin/lsof命令，但是普通用户执行会显示“permission denied” 总结一下lsof指令的用法： lsof abc.txt 显示开启文件abc.txt的进程 lsof -i :22 知道22端...
-
编辑 删除
TUXEDO超时控制全功略(zt)
背景： 解决客户以下问题：数据库版本9206，中间件BEA tuxedu。客户反映在业务中有分布式事务的时候，查询dba_pending_transactions视图会被hang住，直到分布式事务处理完成，这样造成数据库连接堵塞，影响...
-
编辑 删除
Microsoft SQL Server 2005中查询优化器使用的统计信息三(zt)
Microsoft SQL Server 2005中查询优化器使用的统计信息三(zt)SQL Server 2005在数据库、表、索引或者统计信息对象级别维护自动更新统计信息的设置。当某人使用sp_autostats命令修改了某张表上所有对象的该项设置时，...
