ITPub博客

               恢复案例：热备期间实例故障解决1、查看数据库归档及表空间信息：SQL> archive log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            d:oracleoradataxuearchiveOldest online

               恢复案例：基于时间点的不完全恢复1、对测试表插入数据SQL> insert into t values(2);SQL> insert into t values(3);SQL> commit;SQL> alter system switch logfile;[@more@]2、查看时间及表数据SQL> select to_char(sysdate,'yyyymmddhh24:mi:ss') from dual;TO_CHAR(SYSDATE,----------------2004072517:12:12SQL> select * from t;         A----------    &nb

                 恢复案例：归档模式下丢失全部数据文件的恢复1、模拟介质故障并启动数据库：SQL> host del d:oracleoradataxue*.dbfSQL> startup ORACLE 例程已经启动。Total System Global Area   24680476 bytesFixed Size                    75804 bytesVariable Size         &

             恢复案例：归档模式下丢失非系统表空间数据文件的恢复1、创建测试表、归档日志并关闭数据库：SQL> create table t(a int) tablespace xue;SQL> insert into  t values(1);SQL> commit;SQL> alter system switch logfile;SQL> shutdown immediate[@more@]2、模拟数据文件丢失：删除两个非系统数据文件：SQL> host del d:oracleoradataxuexue01.dbfSQL> host del d:oracleoradataxueusers01.dbf3、启动数据库，报错：SQL> startup

               Oracle10g for Solaris9(x86)安装指南 一、 安装环境检查： 机器环境：cpu:P4 1.7G ，内存:1G；OS：Windows 2000 Advaced Server(sp4) 虚拟机系统平台： Vmware Workstation 4.5.2+Solaris9(x86) 虚拟机资源分配：内存：512M，硬盘:10G   [@more@]硬件安装环境要求： 检查项目最低要求检查命令物理内存 512 MB # /usr/sbin/prtconf | grep "Memory size"交换空间1GB或两倍物理内存# /usr/

    环境：windows2000 server+oracle817    应用程序运行过程中报错，信息如下：    ORA-03232:无法分配81块（源于表空间3）的区[@more@]首先根据错误号查Metalink(125271.1:How to Choose Extent Size for Temporary Tablespace to Prevent ORA-3232):ORA-03232 unable to allocate an extent of string blocks from tablespace stringCause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the  tablespace's NEXT value. Action: Increas

This bulletin provides the Database Administrator a better understanding of checkpoint processing and a description of four key initialization parameters used for checkpoint tuning:            -  CHECKPOINT_PROCESS            -  LOG_CHECKPOINT_INTERVAL            -  LOG_CHECKPOINT_TIMEOUT       &nbs

       应用程序在执行一个存储过程时报如下错误：        ORA-01652: 无法通过256（在表空间NEW_TEMP中）扩展 temp 段         ORA-06512: 在"NEW1.PACK_DATA_FX", line 60         ORA-06512: 在"NEW1.PROC_FXTZ0", line 7 ORA-06512: 在line 1        [@more@]      通常来说如果出现该错误是由于临

              一条SQL语句的优化过程    很简单的一次调整，语句加了适当的索引后性能就有大幅的提升。当时看到这条语句的时候，第一感觉就是执行效率肯定低下。语句的功能是求某一客户当天产品的总销量。原来的语句是这样的：[@more@]select sum(sl0000) from xstfxps2 wheredhao00 in (select dhao00 from xstfxps1 where trunc(ywrq00)=trunc(sysdate)and khdm00='500000003913');已用时间: 00: 02: 49.04Execution Plan---------------------

您已经成功注册ITPUB Blog帐号。请进入http://blog.itpub.net/admin.php管理您的Blog站点。建议先修改Blog的名称并建立文档分类，系统已经默认建立了【初始分类】。登陆密码与itpub论坛帐号相同。如有问题请在斑竹区...

一、 一个查询例子：[php]SQL> break on deptno skip 1SQL> select ename,deptno,sal,2 sum(sal) over (order by deptno,ename) running_total,3 sum(sal) over (partition by deptno order by ename) department_total,4 row_number() over (partition by deptno order by ename) seq5 from emp;[/php][@more@][php]ENAME DEPTNO SAL RUNNING_TOTAL DEPARTMENT_TOTAL SEQ ---------- ---------- ---------- ------------- ---------------- ----------CLARK 10 2450 2450 2450 1KING 5000 7450 7450 2MILLER 1300 8750 8750 3FORD