Re: Find Empty Tables

From: VM <vit100gain_at_earthlink.net>
Date: Fri, 30 May 2003 04:51:53 GMT
Message-ID: <JrBBa.25162$Io.2083597@newsread2.prod.itd.earthlink.net>

I wrote some events for a monitoring system that can do that and more. You can get it at aspeda.com

Here's the demo link:

http://www.aspeda.com/download/html/download_demo.html

Vitaliy
DBAToolZ.com

"Charles Davis" <cdavis10717_at_comcast.net> wrote in message news:3_Sdnd6lkMjJLEujXTWcqw_at_comcast.com...
> Hi, all!
>
> I manage several SAP R/3 databases that each contain 25,000 tables and
> exceed 1TB in size. They are of both 8i and 9i versions.
>
> Does anyone have a process or query that scales up well and that can find
> tables that are empty without doing a SELECT count(*) on each of the tables?
>
> Thx.
>
> charles
>
>
>
Received on Thu May 29 2003 - 23:51:53 CDT