摘要：
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 阅读全文
posted @ 2018-06-12 09:55
钱若梨花落
阅读(618)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-06-11 15:00
钱若梨花落
阅读(908)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-06-08 14:27
钱若梨花落
阅读(674)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-06-08 10:21
钱若梨花落
阅读(711)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-06-06 18:39
钱若梨花落
阅读(1363)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-05-23 18:11
钱若梨花落
阅读(1068)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-05-23 16:20
钱若梨花落
阅读(160)
评论(0)
推荐(0)
摘要：
一、查询索引的高度 select index_name,blevel,leaf_blocks,num_rows,distinct_keys,clustering_factorfrom user_ind_statisticswhere table_name in( 'T1','T2','T3'); 2 阅读全文
posted @ 2018-05-23 15:56
钱若梨花落
阅读(2507)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-05-23 15:05
钱若梨花落
阅读(673)
评论(0)
推荐(0)
浙公网安备 33010602011771号