摘要：
Mon Jun 11 21:59:52 2018LNS: Standby redo logfile selected for thread 2 sequence 132997 for destination LOG_ARCHIVE_DEST_10Mon Jun 11 21:59:55 2018Arc 阅读全文
摘要：
Mon Jun 11 14:06:23 2018 Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0xC9CCF40, rwsstd()+32] [flags: 0x0, count: 1] Errors 阅读全文
摘要：
Bug 14143011 : ORA-19606: CANNOT COPY OR RESTORE TO SNAPSHOT CONTROL FILE [oracle@test]$ tail -f rman_delete.log Backup Piece 3687 2018:06:08 01:05:13 阅读全文
摘要：
set linesize 200set pagesize 100column day format a15 heading 'Day'column d_0 format a3 heading '00'column d_1 format a3 heading '01'column d_2 format 阅读全文
摘要：
select distinct ab.TABLE_NAME, ab.SEGMENT_NAME, ab.TABLESPACE_NAME, ab.OWNER, sum(ac.BYTES / 1024 / 1024 / 1024) GB from dba_lobs ab, DBA_SEGMENTS ac 阅读全文
摘要：
Wed May 23 17:46:14 2018TT01: Standby redo logfile selected for thread 1 sequence 42251 for destination LOG_ARCHIVE_DEST_10Wed May 23 17:46:15 2018Err 阅读全文
摘要：
1. INDEX RANGE SCAN--请记住这个INDEX RANGE SCAN扫描方式drop table t purge;create table t as select * from dba_objects;update t set object_id=rownum;commit;crea 阅读全文
摘要：
一、查询索引的高度 select index_name,blevel,leaf_blocks,num_rows,distinct_keys,clustering_factorfrom user_ind_statisticswhere table_name in( 'T1','T2','T3'); 2 阅读全文
摘要：
select sql.*, (select SQL_TEXT from dba_hist_sqltext t where t.sql_id = sql.sql_id and rownum = 1) SQLTEXT from (select a.*, RANK() over(order by els 阅读全文