Here is a script I’ve used to quickly hunt down objects and information about them. Very useful to find things like: exact spellings, other objects with a similar spelling, or owned by a different user, synonyms, etc.
Notes on Oracle’s solution to find object dependencies, DEPTREE. Written in 1991, and still included on installation.
Script to find all generations Of an object’s children. Children. Grandchildren. Great-Grandchildren. Great-Great-Grandchildren. Etc.
What if some of your objects require parent objects 10 layers deep first? ie: type, table, function, view, synonym, package, procedure, etc. All_Dependencies only goes one layer deep.
Here is a very complex script to find all the successive parents of an object.
Very Useful Scripts To Find Oracle Object Dependencies; Parents, and Children.
Fabulous to determine:
– The order of operations to create objects. Parents first. Then children.
– The impact of dropping a view, package, procedure.
– Causes of object invalidation such as another invalid object.
– ALL the tables that a package is accessing.
– Whether a package, function or procedure calls another prodecure.
– Obscure issues, such as references to variables in packages.
Oracle DBA Script To List Objects That Won’t Extend Due to lack of space.
A useful script to show how full the tablespaces are. I’ve used it many times!
Oracle Apps R12: DBA Analysis Of TableSpaces, Log, And Control Files
System tablespace is HUGE, compared to other installations I’ve done! 12 data files. Over 19 gigs!
Tablespace APPS_TS_TX_DATA has 57 files, and is about 62 gigs in size.
Continuing my analysis of Oracle Apps R12. This time, the actual files on the server. There are over 1/2 million…
More analysis of the Oracle Applications R12 sample database, VIS.
LOTS of: Objects, Packages, Triggers by Table, and Source Code
The schema, APPS owns: 51284 PACKAGE BODies, 32991 VIEWS, 4183 TRIGGERs
There are over 57 million lines of source code in the APPS schema alone!