发布时间：2018-11-15 14:41:06

select * from v$log;select * from v$logfile;9 17 ONLINE +DATA/txkhzs/onlinelog/group_17.2134.910290337 NO10 18 ONLINE +DATA/txkhzs/onlinelog/group_18.2135.910290339 NO11 19 ONLINE +DATA/txkhzs/onlinelog/group_19.2137.910290339 NO12 20 ONLINE +DATA/txkhzs/onlinelog/group_20.2138.910290341 NO13 .........【阅读全文】

发布时间：2018-11-13 14:46:07

create table t1 as select object_id,object_name from dba_objects where object_id<10;alter system switch logfile;SQL> select member from v$logfile;MEMBER--------------------------------------------------------------------------------/home/oracle/app/oradata/oracleogg/redo03.log/home/oracle/ap.........【阅读全文】

发布时间：2018-11-01 10:12:58

[oracle-ogg@oracleog archivelog]$dd if=/home/oralOg/oradata/siyang/redo02.log bs=512 skip=2 count=1|od一x1+0 records in1+0 records out0000000 2201 0000 0002 0000 0021 0000 8010 f98a0000020 030c 0000 120d 0000 da41 0070 0001 OOb7这里的rba信息如下:RBA:Ox000021.00000002.0010  rba的结构是由3.........【阅读全文】

发布时间：2018-10-31 10:44:58

xx......【阅读全文】

发布时间：2018-10-30 18:28:26

redo copy latch的个数都跟cpu_ count有关，大概是这么一个关系:2* cpu_ count，如下是我这里的情况:select latch#,name from v$latch  where name like '%redo copy%'select latch#,name,level# from v$latch_children where latch#=186 order by 3select latch#,name from v$latch where name like '%redo al.........【阅读全文】