|
|
|
使用Linux下script工具记录Oracle输出(2)http://www.sina.com.cn 2008年06月26日 16:25 《程序员》
在记录操作前执行 script 命令开始记录,最后输入 exit 退出记录,中间的所有操作都会被记录下来,以下是一个测试过程,中间步骤被省略: [oracle@jumper oracle]$ script Script started, file is typescript [oracle@jumper oracle]$ sqlplus "/ as sysdba" <...ignore operation here...> [oracle@jumper oracle]$ exit Script done, file is typescript 现在让我们来看看记录文件typescript中记录了什么内容: [oracle@jumper oracle]$ cat typescript Script started on Thu 26 Jun 2008 07:56:18 AM CST [oracle@jumper oracle]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 26 07:56:24 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> set linesize 120 SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; Session altered. SQL> col status for a8 SQL> col group# for 999999 SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ------- ---------- ---------- ---------- ---------- --- -------- ------------- ------------------- 1 1 14 1048576 1 YES INACTIVE 1.9008E+10 2008-06-23 00:42:36 3 1 15 1048576 1 YES INACTIVE 1.9008E+10 2008-06-25 14:29:37 4 1 13 1048576 1 YES INACTIVE 1.9008E+10 2008-06-20 14:56:12 5 1 16 1048576 1 NO CURRENT 1.9008E+10 2008-06-25 15:58:38 SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production [oracle@jumper oracle]$ [oracle@jumper oracle]$ exit Script done on Thu 26 Jun 2008 07:57:38 AM CST 这个工具是不是很有用途呢? 当然还有更强悍的 scriptreplay 工具可以replay script,不过缺省一般不带,不说了。
【发表评论 】
不支持Flash
|