使用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,不过缺省一般不带,不说了。

上一页 1 2 下一页
本文导航:
·输出结果
·测试过程

发表评论 _COUNT_条
Powered By Google
不支持Flash
·城市对话改革30年 ·新浪城市同心联动 ·诚招合作伙伴 ·企业邮箱畅通无阻
不支持Flash