zxx2403的专栏

Oracle RMAN 的 show,list,crosscheck,delete命令整理1、SHOW命令：     显示rman配置： RMAN> show all;2、REPORT命令：2.1、RMAN> report schema 报告目标数据库的物理结构;2.2、RMAN>report need backup days=3; 报告最近3天没有被备份的数据文件；

oracle-developer.netHomeArticles11g New Features10g New Features9i New Features8i New FeaturesMiscellaneousUtilitiesLinksSubscribeDisclaimerpivot and unpivot queries in 1

oracle 817 的下载网址ftp.comp.hkbu.edu.hkhttp://download.oracle.com/otn/nt/oracle8i/oracle817ntee.ziphttp://download.oracle.com/otn/nt/oracle8i/oracle817ntee.zip

非归档---->归档方式SVRMGR> connect internal连接成功。SVRMGR> shutdown已关闭数据库。已卸下数据库。已关闭 ORACLE 实例。SVRMGR> startup mount 已启动 ORACLE 实例。系统全局区域合计有 57124108个字节Fixed Size 70924个字节Variable Size 4

# listener.ora Network Configuration File: F:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =

表：  　　select * from cat;  　　select * from tab;  　　select table_name from user_tables;  视图：  　　select text from user_views where view_name=upper('[$view_name')]  索引：  　　select index_name,

My questions are related to dynamic sampling. What does it really do, when would I consider using it, and what are the meanings of all the different levels it can be set to?Dynamic sampling first be

_optimizer_adaptive_cursor_sharing=false disables the feature.There are 2 new columns in V$sql , IS_BIND_SENSITIVE and IS_BIND_AWARE that indicate the status for individual cursors.1.) The paramet

set pages 0 set linesize 300 column plan_table_output format a200SELECT * FROM TABLE(DBMS_XPLAN.display_cursor);

DBAs are always encouraging developers to use bind variables, but when bind variables are used against columns containing skewed data they sometimes lead to less than optimum execution plans. This is

安装Oracle 11g或10g 的过程中在如果出现提示说找不到.../oracle/11g/oc4j/j2ee/oc4j_applications/applications/em.ear这个文件，那就说明文件补齐。    Oracle 11g的下载之后解压出来有两个文件夹，出现这个错误是因为文件copy不齐全，只要将第二部分中的database\stage\Components 与 第一

事件说明例子Event 10013 - Monitor Transaction Recovery在Startup时跟踪事务恢复ALTER SESSION SET EVENTS '10013 trace name context forever, level 1';Event 10015 - Dump Undo

首先说一下思路：在做Oracle各种问题解决的时候，思路必须要清晰，快速定位问题发生点是考核大家能力的很重要的指标。那么如何让自己思路清晰，首先，经验是非常重要，但如果你还没有丰富的经验，那么打好基础，也就是涉及到的技术的原理必须得清楚。如果你不好好理解原理，那么在你想要解决问题的时候思维混乱或者思维固定，老往一个方向去考虑问题，而这个方向往往是错误的或者低效的，我们需要通过理解原理来优化他们。

connect /drop table t;create table t ( x int );alter session set events '10046 trace name context forever, level 12';begin for i in 1 .. 100000 loop insert into t values (i);

临时表空间中没有文件造成的SELECT * FROM V$TEMP;解决：alter tablespace tempadd tempfile 'F:\oracle\oradata\sdusun\temp01.dbf' reuse;

Question:  What is supplemental logging, and how does supplemental logging work? Answer:  Database-level supplemental logging must be enabled for any Change Data Capture source database.  You can

ddl操作是否会产生undo?2010/08/18 byMaclean Liu1条评论ddl是否会产生undo?这可能是每一个初学Oracle的人都会有的疑问；ddl操作又不能rollback回滚，要什么undo数据呢？事实是几乎每个ddl操作都会产生undo,我们来探究一下:SQL> select vs.name, ms.value 2 from v$m

The following error was displayed during the start of Oracle SQL Developer Data Modeler (v3.3.0.734) on Windows:Unable to create an instance of the Java Virtual MachineLocated at path: ..\..\jdk\j

Linux下使用rlwrap开源工具，可以在oracle sqlplus下具有linux下命令行功能。比如上下翻命令，等等。一、安装[root@cms2 ~]#unzip rlwrap-0.28.zip[root@cms2 ~]# cd rlwrap-0.28[root@cms2 rlwrap-0.28]# ./configure ......

2014-02-25 18:13 by 潇湘隐者, 1387 阅读,0 评论,收藏,编辑安装了Oracle 12C后，启动数据库的过程中出现如下错误 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter fil

sysctl -P 报错解决办法问题症状修改 linux 内核文件 #vi /etc/sysctl.conf后执行sysctl  -P 报错error: "net.bridge.bridge-nf-call-ip6tables" is an unknown keyerror: "net.bridge.bridge-nf-call-iptables" is an unkn

http://www.tecmint.com/setting-up-prerequisites-for-oracle-12c-installation/

create table table1(column1 number, column2 date, column3 varchar2(1000), column4 clob);insert into table1select level, sysdate, level, level from dual connect by level 10;commit;

The following example illustrates how to describe the columns and values of a reference cursor, created from a dynamic DML statement using the DBMS_SQL API.Firstly, create a test table with some

select TO_DATE(decode('19461031',                      '0',                      NULL,                      to_date('19461031', 'YYYYMMDD'))),       decode('19461031', '0', NULL, to_char(to_da

select table_name, constraint_name, status, ownerfrom all_constraintswhere r_owner = :r_ownerand constraint_type = 'R'and r_constraint_name in ( select constraint_name from all_constraints

解压文件第一种方法：zcat  lnx_920_disk1.cpio.gz | cpio -idmvzcat  lnx_920_disk1.cpio.gz | cpio -idmvzcat  lnx_920_disk1.cpio.gz | cpio -idmv第二种方法 ：第一步： gunzip lnx_920_disk1.cpio.gzgunzip lnx_920

把下面的地址复制到讯雷里就可以下载,更新了11g安装包及10.2.0.5的补丁包---------------------------------------------------------------------------------------------------ORACLE 9iOracle9i Database Release 2 Enterprise/Sta

使用迅雷新建任务下载地址填写ftp://updates.oracle.com/patch_num>/ppatch_num>_version>_os>.zip就可以下载到你想要的补丁了。9.2.0.4 = 30952779.2.0.5 = 35019559.2.0.6 = 39484809.2.0.7 = 41634459.2.0.8 = 4547809（9i最终）10

ORACLE 10g下载地址Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)  http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zi

【Oracle补丁集下载大全】Oracle 9i、10g、11g补丁集下载大全patchset—最新下载！############################Oracle Database Patch Number############################9.2.0.4  = 30952779.2.0.5  = 35019559.2.0.6  

Run this PL/SQL block as SYS. This will create the Directory, grant the required privileges on the Directory and then create the External Table in the SYSTEM schema.DECLARE BDumploc VARCHAR2(200)

这种问题一般出现在用UNION将若干个select连接到一起，由于select后的列的个数不相等而造成的。比如select userid from table1unionselect userid,loginname from table1

idvalue1a1c1e2b2dselect ID,wmsys.wm_concat(Val) as Path  from testgroup by ID;---------------------------------------------------------

我们知道系统的响应时间等于ＣＰＵ服务的时间＋等待时间 Response Time = Service Time + Wait Time 服务时间代表的是“ CPU used by this session”,是CPU服务会话所花费的所有时间 分两种。1. 实例级。 select a.value "Total CPU time"from v$sysstat a

<br />触发器分两种<br /> <br />1、 语句触发器<br />      是在表上或者某些情况下的视图上执行的特定语句或者语句组上的触发器。能够与INSERT、UPDATE、<br />DELETE或者组合上进行关联。但是无论使用什么样的组合，各个语句触发器都只会针对指定语句激活一次<br />。比如，无论update多少行，也只会调用一次update语句触发器。<br /> <br />2、 行触发器<br />      是指为受到影响的各个行激活的触发器，定义与语句触发器类似，

<br />oracle的正则表达式(regular expression)简单介绍<br />目前，正则表达式已经在很多软件中得到广泛的应用，包括*nix（Linux, Unix等），HP等操作系统，PHP，C#，Java等开发环境。<br />Oracle 10g正则表达式提高了SQL灵活性。有效的解决了数据有效性，重复词的辨认, 无关的空白检测，或者分解多个正则组成的字符串等问题。<br />Oracle 10g支持正则表达式的四个新函数分别是：REGEXP_LIKE、REGEXP_INS

Sqlplus 可以实现不同数据库下的表复制 语法如下：COPY {FROM database | TO database | FROM database TO database}{APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)]USING queryA

The RR Datetime Format Element The RR datetime format element is similar to the YY datetime format element, but it provides additional flexibility for storing date values in other centuries. The RR datetime format element lets you store 20th century

最近进行了一个操作，删除表的某一个字段过程如下SELECT * FROM USER_SOURCE WHERE TEXT LIKE'%COLUMN_NAME%没有发现有程序用。ALTER TABLE TABLE1 DROP COLUMN COLUMN_NAME此过程有如下不足。没有考虑视图中是否引入该字段，SELECT * FROM USER_TAB_COLUMN WHERE COLUMN_NAME ='COLUMN_NAME'做完后需要，重写编译失效程序