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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 23 Nov 2000 19:23:04 +0100
Message-ID: <8vm9h4$4sl0n$2@ID-62141.news.dfncis.de>

Answers/remarks embedded

Hth,

Sybrand Bakker, Oracle DBA

"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!
>

All manuals are online at http://technet.oracle.com Try to read them before you start posting.

> 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?

Check out dba_segments

>
> Thanks,
>
> Mark.
>
Received on Thu Nov 23 2000 - 12:23:04 CST