- 论坛徽章:
- 0
|
- [bigant@Free Town]$cat log
- Sat Jun 10 22:18:33 2006
- Completed checkpoint up to RBA [0x4210.2.10], SCN: 0x056d.f88e862a
- Sun Jun 11 00:55:04 2006
- ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY
- Sun Jun 11 01:05:03 2006
- ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY
- Sun Jun 11 01:12:36 2006
- Completed checkpoint up to RBA [0x4211.2.10], SCN: 0x056d.f8907331
- Sun Jun 11 00:52:29 2006
- [bigant@Free Town]$awk '{a[i++]=$0;}$0~/^ORA/&&a[i-2]~/Jun 11/{print a[i-2];print $0}' log
- Sun Jun 11 00:55:04 2006
- ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY
- Sun Jun 11 01:05:03 2006
- ORA-1631: max # extents 505 reached in table PERFSTAT.STATS$SQL_SUMMARY
- [bigant@Free Town]$
复制代码 |
|