Re: Newbie Question: Where do I find Oracle 8 Stats?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 24 Nov 2000 11:48:21 -0000
Message-ID: <975066565.28748.0.nnrp-10.c30bdde2@news.demon.co.uk>

select * from dba_segments where owner not in ('SYS','SYSTEM');

"Mark G Phillips" <mphillips_at_delphius.freeserve.co.uk> wrote in message news:3a1d4529.26410565_at_news.ntlworld.com...
> I need to get some information out of an Oracle 8 installation. Now
> bear with me, because I know absolutely nothing about Oracle (I'm a
> telecomms application specialist). However, I've been asked to put a
> report together which requires amongst other things, statistics about
> an Oracle database. The nice thing of course is I have no
> documentation!
>
> Basically all I need is basic system information like all the table
> names that are currently being used, and basic storage and utilisation
> information for each table.
>
> Is there a table that Oracle uses to hold system statistics, which can
> be accessed fairly easily?
>
> Thanks,
>
> Mark.
>
Received on Fri Nov 24 2000 - 05:48:21 CST