RE: Oracle Baselines and Java Internals
- From: Peter Barnett <regdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Jul 2004 06:56:19 -0700 (PDT)
Jared,
There was some discussion about this at IOUG.
Apparently, in 10G there are now dba views that
require OEM or some other purchased tools to access.
Lots of grumbling on the part of DBAs about not having
full access to the data dictionary without spending
more money but no real explanation by Oracle.
Pete
--- Jared.Still@xxxxxxxxxxx wrote:
> > > Jared,
> > >
> > > >Track DDL_TIME, CREATION_DATE and TIMESTAMP for
> all objects.
> > >
> In the process of poking around in the data
> dictionary, I find
> that there are objects in sys.source$ that do not
> appear anywhere
> else. This is on 9.2.0.4.
>
> What appears are objects, all triggers, that have
> been created
> at one time, but no longer appear in dba_triggers or
> sys.obj$.
>
>
> The following SQL will dump source from sys.source$
> that does
> not have a corresponding object ID in sys.obj$.
>
> col obj# format 9999999
> col line format 9999999
> col source format a100
> set line 130
>
> select obj#, line,source
> from sys.source$ o
> where o.obj# in (
> select distinct obj#
> from sys.source$
> minus
> select s.obj#
> from dba_objects d, sys.source$ s
> where d.object_id = s.obj#
> )
> order by 1,2
> /
>
>
> I've just checked a 10g database, and it also has
> source that
> no longer appears in any DBA views.
>
> Anyone have a possible explanation?
>
> Jared
>
>
>
----------------------------------------------------------------
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
>
----------------------------------------------------------------
> To unsubscribe send email to:
> oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //www.freelists.org/help/fom-serve/cache/1.html
>
-----------------------------------------------------------------
>
=====
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne@xxxxxxxxxxx
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
