ITPub博客

一.   出问题时的情景我在自己测试数据库上给大表 tb_table导完数据后，建立索引时，出现以下错误ORA-01578: ORACLE data block corrupted (file # 7, block # 28969)ORA-01110: data file 7: 'D:\ORACL...

checkpoint是什么？checkpoint是数据库的一个内部事件，这个事件激活以后会触发数据库写进程(DBWR)将数据缓冲(DATA BUFFER CACHE)中的脏数据块写出到数据文件中。checkpoint的作用是什么？checkpoint主要2个作用：1...

http://www.itpub.net/thread-977662-1-1.html 我的解决方法:现在的控制文件恢复方法:-- 1.备份RMAN> backup full database format 'd:ackupackup_%U';Starting backup at 25-APR-08using channel ORA_DISK_...

1.必须安装客户端可以连接到数据库2.数据库服务器监听器必须要静态注册LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS_LIST =  &nbsp...

一、Oracle跟踪文件    Oracle跟踪文件分为三种类型，一种是后台报警日志文件，记录数据库在启动、关闭和运行期间后台进程的活动情况,如表空间创建、回滚段创建、某些alter命令、日志切换、错误消息等。在...

统计出每个教师每门课的及格人数和及格率create table rock (教师ID number,学生ID number,学科名称 varchar2(40),成绩 number);insert into rock values(1,1,'数学',80);insert into rock values(1,2,'数学',50);in...

create table test_0210(id number,name varchar2(32),age number); insert into test_0210 values(1,'abc',32); insert into test_0210 values(2,'def',33); insert into test_0210 values(3,'def',45); commit; S...

http://www.itpub.net/thread-974423-1-2.html附件是总结的文档欢迎大家下载和交流

sql>shutdown immediate;冷备数据库所有数据文件SQL> startupORACLE instance started.Total System Global Area  101785252 bytesFixed Size          ...

宝宝昨天晚上和她爷爷奶奶坐火车回江西老家了让宝宝在家里带段时间,我和老婆就可以安心工作挣钱把房子装修好,宝宝回去后,确实是两个人舒服多了可以有自己的时间安排也希望宝宝在家健健康康成长这段时间有要辛苦...

SQL> select count(distinct b) from  2  (select dbms_rowid.rowid_block_number(rowid) b from t);COUNT(DISTINCTB)----------------          &nb...

SQL> create table t as select  * from dba_objects;sql>analyze table t compute statistics;SQL> select count(distinct b) from  2    (select dbms_rowid.rowid_block_number(rowid...

客户反映运行某个报表要45秒以上select id, role_id, login                       &nbsp...

表的分布情况 采用cbo 数据和索引都已分析 tb_role 为8960行  建有parent_id的索引tb_user 为8541行 建有role_id的索引SQL> select id, role_id, login   2 from tb_user e   3 wher...

优化前:SQL> set autotrace traceonlySQL> Select a.*,b.*  2    From tb_bet_log a  3    Full Outer Join tb_user b On a.client_id = b.id  4   Where ...

RMAN> run{2> allocate channel c1 type disk;3> backup full tag 'dbfull' format 'd:\backup\full%u_%s_%p' database4> include current controlfile;5> sql 'alter system archive log current';6> release chann...

C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Thu Apr 10 10:28:39 2008Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Con...

SQL> select * from test;        ID----------         1         2SQL> shutdown immed...

SQL> select * from test;        ID----------         1SQL> shutdown immediate;Database closed.Database dismounted.ORACLE in...

SQL> create table test(a int);Table created.SQL> insert into test values(1);1 row created.SQL> commit;Commit complete.Cocuments and SettingsPaul Yi>rman target /Recovery Manager: Release 9.2.0.4.0 - P...