Re: OT -- # tables in your db (was: Slow database)

From: Rodd Holman <rodney.holman_at_lodgenet.com>
Date: Thu, 29 Mar 2001 08:01:24 -0800
Message-ID: <F001.002DB94F.20010329080037@fatcity.com>

Happy Birthday Patrice!
Here you go:
SQL> select object_type, count(*)
2 from dba_objects

  3  where  owner != 'SYS'
  4  and    owner != 'SYSTEM'
  5  and    owner != 'CTXSYS'
  6  and    owner != 'DBSNMP'

7 group by object_type;

OBJECT_TYPE COUNT(*)
--------------- ----------

DATABASE LINK            6
FUNCTION                 6
INDEX                 6173
PACKAGE               3674
PACKAGE BODY          3650
PROCEDURE               11
SEQUENCE              1280
SYNONYM               4758
TABLE                 2961
TRIGGER                595
VIEW                  4430

11 rows selected.

Oracle 8.0.5
For those of you on 8i take out the MDSYS, ORDSYS, etc OWNERS. No fair counting Oracle cartridge OWNERS.

On Thursday 29 March 2001 08:26, Patrice Boivin wrote:
> "very complex" at 300 tables.
>
> I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159
> database links. 1064 views, again excluding SYS and SYSTEM.
>
> This is on Oracle 7.3.4.
>
> I am sure this is not the smallest db out there...
>
> (It's my birthday, so what if I feel a bit competitive today -- let's start
> a thread).
>
> : )
>
> Regards,
>
> Patrice Boivin
> Systems Analyst (Oracle DBA)
> Bedford Institute of Oceanography
> Fisheries and Oceans Canada
>

-- 
Rodd Holman
Oracle DBA
(605) 988-1373
rodney.holman_at_lodgenet.com
Comments made are my own opinions and views. They do not represent views, 
policies, or procedures of LodgeNet Entertainment Corporation


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rodd Holman
  INET: rodney.holman_at_lodgenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Mar 29 2001 - 10:01:24 CST