Re: Anyone got a simple script to detect full tables?

On Fri, 9 Jul 1999 00:11:09 +0100, Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:
>In article <7m327p$mje$1_at_nnrp1.deja.com>, rcordingley_at_my-deja.com writes
>>run the following sql script from cron with a line like:
>
>Thanks, looks good to me.
>
>Andy
>--
>Andy Hardy. PGP key available on request
>===============================================================

Also, search on metals support for the string "Scrypt". There's a whole suite of unsupported scripts for stuff like you want. Some have bugs, of course. I believe these are also on the SupportNotes CD if you happen to get those. Also, several of the "Oracle DBA" books have cd's with useful scripts on them.

>>> http://support.oracle.com/MetaLink/libraries/est/oracle7/productReference/bulletins.html#SCR

jg
--
These opinions are my own.
http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply.

mailto:joel-garry_at_nospam.home.com                        Oracle and unix guy.