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
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).