z***y
发帖数: 7151 | 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*********0
发帖数: 80 | 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***y
发帖数: 7151 | 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
|
|
