DB Control repository

Hi
 what exactly  DB Control repository contains ,,and where its located in our 
database, when its created , Actually i don't know anything about can u plz 
explain briefly. and one more thing i want to say " I was very new to oracle 
database so i may be ask some basic questions also ,don't think this guy is 
wasting my time by asking some low weight questions.....Thank u


Thank u 
singireddidba

> Hi
>  what exactly  DB Control repository contains:

Physically the repository is stored under SYSMAN schema and it contains the 
following objects (11GR2 example):

SQL> select count(*),object_type from dba_objects where owner='SYSMAN' group by 
object_type;

  COUNT(*) OBJECT_TYPE
---------- -------------------
        12 QUEUE
        13 SEQUENCE
         3 PROCEDURE
        75 LOB
         4 RULE SET
       196 PACKAGE
       196 PACKAGE BODY
        49 TYPE BODY
         1 MATERIALIZED VIEW
        97 TRIGGER
       729 TABLE

  COUNT(*) OBJECT_TYPE
---------- -------------------
       953 INDEX
       471 VIEW
        12 FUNCTION
       678 TYPE
         2 EVALUATION CONTEXT

16 rows selected.


Logically, the repository contains the metadata and events about the monitored 
database(s).  In a large environment, it's best to install ONE management 
server with centralized repository and register all other databases with the 
centralized repository/management server.  In such case you will not be 
using/installing DB control on each and every database.


> ,,and where its located in 
> our database, when its created

It depends on how it was installed -- by default it goes into SYSAUX 
tablespace:

SQL> select count(*),segment_type,tablespace_name from dba_segments where owner 
= 'SYSMAN' group by segment_type,tablespace_name;

  COUNT(*) SEGMENT_TYPE       TABLESPACE_NAME
---------- ------------------ ------------------------------
        48 LOBSEGMENT         SYSAUX
         2 NESTED TABLE       SYSAUX
        48 LOBINDEX           SYSAUX
       409 INDEX              SYSAUX
       254 TABLE              SYSAUX

SQL>


No problem with basic questions -- fire away -- we all had to start somewhere.

Thank u so much for ur kind reply ,,,,
Bhaskar