Script:收集Flashback Database Log诊断信息

作者: Maclean Liu, post on September 30th, 2011

以下脚本可以用于收集10g以后的闪回数据库日志Flashback Database Log的诊断信息:

WITH flashback_database_log AS (SELECT ROUND((SYSDATE – oldest_flashback_time) * 24 * 60, 2) oldest_log_minutes, retention_target retention_target_minutes, flashback_size / 1048576 flashback_size_mb, estimated_flashback_size / 1048576 estimated_flashback_size_mb FROM v$flashback_database_log), flashback_database_logfile AS (SELECT COUNT(*) logs, SUM(BYTES / 1048576) size_mb, MIN(first_time) oldest_log, MAX(first_time) latest_log FROM v$flashback_database_logfile), flashback_usage AS (SELECT file_type, ROUND(mb_used, 2) mb_used, ROUND(mb_reclaimable, 2) mb_reclaimable, DECODE(total_mb, 0, . . . → Read More: Script:收集Flashback Database Log诊断信息

Leave a comment   Oracle, Oracle Flashback闪回技术, Oracle脚本script   ,  

11g r2中对闪回数据归档的增强

作者: Maclean Liu, post on October 19th, 2010

11g r1中引入了闪回数据归档新特性，其工作原理是为针对启用了归档方式的表，FBDA进程将创建对应于该表的内部历史表。历史表将拥有原始表的所有列加上某些时间戳列以便跟踪事务处理的变化，具体如下:

SQL> desc SYS_FBA_HIST_75718; Name Null? Type —————————————– ——– —————————- RID VARCHAR2(4000) STARTSCN NUMBER ENDSCN NUMBER XID RAW(8) OPERATION VARCHAR2(1) T1 NUMBER(38) T2 VARCHAR2(20) /* 注意其中T1,T2为原始表上的应用数据列 */ . . . → Read More: 11g r2中对闪回数据归档的增强

Leave a comment   Oracle, Oracle 11g新特性, Oracle Flashback闪回技术   , ,