avatar
出道oracle dba 面试题# Database - 数据库
z*y
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那么大
avatar
g*0
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
avatar
z*y
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。