login.sql:

define_editor=vi

set serveroutput on size 1000000

set trimspool on

set long 5000

set linesize 100

set pagesize 9999

column plan_plus_exp format a80

column global_name new_value gname

set termout off

define gname=idle

column global_name new_value gname

select lower(user)||'@'||substr(global_name,1,decode(dot,0,length(global_name), dot-1)) global_name

from (select global_name, instr(global_name,'.') dot from global_name);

set sqlprompt '&gname> '

set termout on

------------------------------------------------------

set sqlplus autotrace

1. cd $ORACLE_HOME/rdbms/admin

2. login dba as system

3. execute @utlxplan;

4. create public synonym plan_table for plan_table;

5. grant all on plan_table to public

--------------------------------------------------------

runstats

create or replace view stats

as select 'STAT...' ||a.name name, b.value

from v$statname a, v$mystat b

where a.statistic#=b.statistic#

union all

select 'LATCH.'||name, gets

from v$latch;

[@more@]

ITPub博客

9i和10g的编程艺术里面的脚本