出道oracle dba 面试题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

出道oracle dba 面试题

出道oracle dba 面试题# Database - 数据库

z*y2010-09-02 07:09

1 楼

Suppose you get error from email:
18725760 ORA-1654: unable to extend index SURROUND.SAMPLEBI_0 by 6400
in tablespace SURROUNDINDX1
18725762 ORA-1654: unable to extend index SURROUND.SAMPLEBI_0 by 6400
in tablespace SURROUNDINDX1
18725771 ORA-1654: unable to extend index SURROUND.SAMPLEBI_0 by 6400
in tablespace SURROUNDINDX1
1. Tell me how to implement such alert?
2. How do you handle such alert？
思路很重要，答案不是唯一地。嗯，这是真实的一个案例，这个数据库有2T那么大
。

g*02010-09-02 07:09

2 楼

1) implement the following script as cron or windows job will send you the
alert you give in the above:
set sqlprompt ' '
set echo off
set feedback off
set verify off
set linesize 80
set pages 0
set term off
set heading off
spool $HOME/local/bin/log/mx_R3PROD.log
select
rpad(owner,8) owner,
rpad(tablespace_name,10) Ts_name,
rpad(segment_name,20) name,
rpad(segment_type,3)type,
rpad(extents,4) exts,
rpad(max_extents,5) Mx_ext,
rpad(initial_extent/1024,6) IKb,
rpad(next_extent/1024,6) NKb ,bytes/1

z*y2010-09-02 07:09

3 楼

客官，你已经足够好了。
是不是在加space 之前先看看available disk space 会更完整一些？
我给你100个包子吧。

【在 g*********0 的大作中提到】

: 1) implement the following script as cron or windows job will send you the
: alert you give in the above:
: set sqlprompt ' '
: set echo off
: set feedback off
: set verify off
: set linesize 80
: set pages 0
: set term off
: set heading off