Online Patching Cycle
---------------------------
ADPATCH utility is no longer used in R12.2.0 and is being replaced by ADOP – AD Online Patching. There are five phases or life cycles of ADOP which are:
3 Apply Phase -
adop phase=apply patches=, workers=
After patch has been successfully applied,complete the patch cycle
Oracle E-Business Suite Release 12.2 installation comes with a new feature called “Online Patching” with two editions (versions) of the application code and seed data. The file system contains two complete copies of the Oracle E-Business Suite and technology files. In the database, we use the Edition-based Redefinition feature to create a new database edition for each online patching cycle.
The "Run Edition" is the code and data used by the running application. As a developer, you will connect to the Run Edition whenever you are engaged in normal development activity on the system.
The "Patch Edition" is an alternate copy of Oracle E-Business Suite code and seed data that is updated by Online Patching.
The Oracle E-Business Suite application-tier files are installed in a root directory of the customer's choosing. Within that root directory you will now find three important sub-directories:
1) How to see, the RUN, PATCH & NON-EDITIONED Filesystems?
fs1 - file system 1 (either run or patch edition)
fs2 - file system 2 (alternate of file system 1)
fs_ne - non-editioned file system, for data files
By just setting the ebs environment, shows the filesystems.
[applmgr@punitchi:applmgr]> . /u02/applR12/PRODDB/fs1/EBSapps/EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitc.lab.com Service/SID: PRODDB
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]>
2) How to identify the PATCH & RUN edition of filesystem?
[applmgr@punitchi:applmgr]>pwd
/u02/applR12/PRODDB/fs1/EBSapps/appl
[applmgr@punitchi:applmgr]> . EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]>
3) How to connect to the PATCH & RUN edition of filesystem?
[applmgr@punitchi:applmgr]> . /u02/applR12/PRODDB/fs1/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitc.lab.com Service/SID: punitchi
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]> echo $FILE_EDITION
run
[applmgr@punitchi:applmgr]>
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi.lab.com Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:P
Sourcing the PATCH File System ...
[applmgr@punitchi:applmgr]> echo $FILE_EDITION
patch
[applmgr@punitchi:applmgr]>
4) How to display edition status ?
To help keep track of what environment and edition you are connected to, it can be helpful to set the TWO_TASK or FILE_EDITION environment variable as your shell prompt.
[applmgr@punitchi:applmgr]> . EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi.lab.com Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:P
Sourcing the PATCH File System ...
[applmgr@punitchi:applmgr]> PS1='$TWO_TASK> '
punitchi_patch>
5) How to find out whether a system is in an Online Patching cycle using the "adop -status" command.
[applmgr@punitchi:applmgr]> adop -status
Enter the APPS username: apps
Enter the APPS password:
Current Patching Session ID: 7
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
punitc master PREPARE COMPLETED 05-Jun-16 03:57:39 +00:00 06-Jun-16 04:55:57 +00:00 36:58:18
FINALIZE COMPLETED 06-Jun-16 06:09:01 +00:00 06-Jun-16 06:54:41 +00:00 0:45:40
CUTOVER COMPLETED 06-Jun-16 06:59:47 +00:00 06-Jun-16 07:26:32 +00:00 0:26:45
CLEANUP COMPLETED 06-Jun-16 11:26:07 +00:00 06-Jun-16 11:28:53 +00:00 0:02:46
APPLY COMPLETED
File System Synchronization Used in this Patching Cycle: Full
For more information, run ADOP Status Report by using -detail option
Generating ADOP Status Report at location: /u02/applR12/PRODDB/fs_ne/EBSapps/log/status_20160625_172245/adzdshowstatus.out
Please wait...
Done...!
adop exiting with status = 0 (Success)
6) How to find names and status of past and present database editions using the ADZDSHOWED.sql script.
The below lists the existing database editions and identifies the OLD, RUN, and PATCH editions.
[applmgr@punitchi:applmgr]> sqlplus apps/********* @ADZDSHOWED.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Thu May 29 16:37:18 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
=========================================================================
= Editions
=========================================================================
Edition Name Type Status Current?
--------------- -------- -------- --------
ORA$BASE RETIRED
V_20140202_0749 OLD RETIRED
V_20140405_2132 RUN ACTIVE CURRENT
V_20140508_1528 PATCH ACTIVE
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[applmgr@punitchi:applmgr]>
7) How to change to the patch edition of database using SQL*Plus? /u02/applR12/PRODDB/fs1/EBSapps/appl/ad/12.0.0/sql
[applmgr@punitchi:applmgr]> sqlplus apps/********* @ADZDSHOWED.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jun 25 17:03:50 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exec ad_zd.set_edition('PATCH');
8) What are the Tools and Scripts for Edition-based Development?
[applmgr@punitchi:applmgr]> . /u02/app/applmgr/120/punitchi/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/app/applmgr/120/punitchi/fs1/EBSapps/appl
PATCH File System : /u02/app/applmgr/120/punitchi/fs2/EBSapps/appl
Non-Editioned File System : /u02/app/applmgr/120/punitchi/fs_ne
DB Host: punitc.lab.com Service/SID: punitchi
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]> which adop
/u02/applR12/PRODDB/fs1/EBSapps/appl/ad/bin/adop
[applmgr@punitchi:applmgr]> which xdfgen.pl
/u02/applR12/PRODDB/fs1/EBSapps/applfnd/12.0.0/bin/xdfgen.pl
[applmgr@punitchi:applmgr]> which xdfcmp.pl
/u02/applR12/PRODDB/fs1/EBSapps/appl/fnd/12.0.0/bin/xdfcmp.pl
[applmgr@punitchi:applmgr]>
9) Useful SQL*Plus scripts that provides information about the state of your editioned development environment. All ADZD* scripts are found under $AD_TOP/sql.
Add this directory to the SQLPATH environment variable so that you can refer to the scripts by simple name.
[applmgr@punitchi:applmgr]> SQLPATH=$AD_TOP/sql; export SQLPATH
[applmgr@punitchi:applmgr]> echo $SQLPATH
/u02/applR12/PRODDB/fs1/EBSapps/applad/12.0.0/sql
[applmgr@punitchi:applmgr]>
ADZDDBCC - database compliance checker, shows violations of the database object development standards documented in the Oracle E-Business Suite Developer's Guide, Part No. E22961. Warning: this script takes a long time to run.
ADZDSHOWED - Show database editions and current edition.
ADZDSHOWLOG - Show full diagnostic log for online patching infrastructure
ADZDSHOWLOGEVT - Show only event and error messages from online patching diagnostic log (a useful summary, without the detailed statement text).
ADZDSHOWLOGERR - Show only error messages from online patching diagnostic log.
ADZDSHOWEV TABLE_SYNONYM_NAME - Show editioning view column mapping for table.
ADZDSHOWTAB TABLE_SYNONYM_NAME - Show table information and related objects.
ADZDSHOWMV MVIEW_NAME - Show materialized view information and related objects.
ADZDSHOWTS - Show important tablespace status. Ensure that you have enough SYSTEM tablespace.
ADZDCMPED - Compare Patch Edition with Run Edition. Warning: this script may take a long time to run.
ADZDSHOWDDLS - Show stored DDL summary by phase.
ADZDALLDDLS - Show stored DDL statement text and status.
ADZDDDLERROR - Show stored DDL execution errors and messages.
adutlrcmp - Recompile all objects, with before/after status report. Warning: this script may take a long time to run.
The following scripts are for experts:
ADZDSHOWOBJS - Show Object Summary per edition. Counts of actual and stub (inherited) editioned object per edition.
ADZDSHOWAOBJS - Show Actual Objects in the current edition. These are the editioned objects that have been changed by the patch.
ADZDSHOWIOBJS - Show Inherited Objects in the current edition. These are the editioned objects that remain untouched in the Patch Edition.
ADZDSHOWCOBJS - Show Covered Object Summary per edition. Count of objects in old editions that have a replacement in the run edition.
ADZDSHOWCOBJX - Show Covered Object List. List of objects in old editions that have a replacement in the run edition.
ADZDSHOWSM - Show Seed Manager status.
ADZDSHOWTM - Show Table Manager status.
ADZDSHOWAD - AD (online patching) database object status
ADZDSHOWSES - Show sessions connected to the database (by edition).
ADZDSHOWDEP OBJECT_NAME - Show objects that OBJECT_NAME depends on.
ADZDSHOWDEPTREE OBJECT_NAME - Show full dependency tree of objects that OBJECT_NAME depends on.
---------------------------
Phases of ADOP(online patching)
ADPATCH utility is no longer used in R12.2.0 and is being replaced by ADOP – AD Online Patching. There are five phases or life cycles of ADOP which are:
a) PREPARE
b) APPLY
c) FINALIZE
d) CUTOVER
e) CLEANUP
c) FINALIZE
d) CUTOVER
e) CLEANUP
Steps:-
Download the patch and unzip on patch_top and go through the read me to check,what its going to do.
Prepare the system for patching
Prepare the system for patching
1. Run environment file(optional)
Note: The adop utility sets its own environment. There is therefore no need to source the environment before running it.
Note: The adop utility sets its own environment. There is therefore no need to source the environment before running it.
2.adop phase=prepare
3 Apply Phase -
adop phase=apply patches=, workers=
After patch has been successfully applied,complete the patch cycle
4. Finalize phase - Used to perform the final patching operations that can be executed while the application is still online:
adop phase=finalize workers= (called automatically)
adop phase=finalize workers= (called automatically)
5. Cutover phase - Used to perform the transition to the patched environment:
adop phase=cutover workers=
adop phase=cutover workers=
6. Cleanup phase - Used to remove old objects that are no longer needed:
adop phase=cleanup (called automatically)
Now synchronise the technology level between patch and run fc_clone.
adop phase=cleanup (called automatically)
Now synchronise the technology level between patch and run fc_clone.
7. adop phase=fs_clone
PATCHING CYCLE
----------------------------
The "Run Edition" is the code and data used by the running application. As a developer, you will connect to the Run Edition whenever you are engaged in normal development activity on the system.
The "Patch Edition" is an alternate copy of Oracle E-Business Suite code and seed data that is updated by Online Patching.
The Oracle E-Business Suite application-tier files are installed in a root directory of the customer's choosing. Within that root directory you will now find three important sub-directories:
1) How to see, the RUN, PATCH & NON-EDITIONED Filesystems?
fs1 - file system 1 (either run or patch edition)
fs2 - file system 2 (alternate of file system 1)
fs_ne - non-editioned file system, for data files
By just setting the ebs environment, shows the filesystems.
[applmgr@punitchi:applmgr]> . /u02/applR12/PRODDB/fs1/EBSapps/EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitc.lab.com Service/SID: PRODDB
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]>
2) How to identify the PATCH & RUN edition of filesystem?
[applmgr@punitchi:applmgr]>pwd
/u02/applR12/PRODDB/fs1/EBSapps/appl
[applmgr@punitchi:applmgr]> . EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]>
3) How to connect to the PATCH & RUN edition of filesystem?
[applmgr@punitchi:applmgr]> . /u02/applR12/PRODDB/fs1/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitc.lab.com Service/SID: punitchi
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]> echo $FILE_EDITION
run
[applmgr@punitchi:applmgr]>
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi.lab.com Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:P
Sourcing the PATCH File System ...
[applmgr@punitchi:applmgr]> echo $FILE_EDITION
patch
[applmgr@punitchi:applmgr]>
4) How to display edition status ?
To help keep track of what environment and edition you are connected to, it can be helpful to set the TWO_TASK or FILE_EDITION environment variable as your shell prompt.
[applmgr@punitchi:applmgr]> . EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/applR12/PRODDB/fs1/EBSapps/appl
PATCH File System : /u02/applR12/PRODDB/fs2/EBSapps/appl
Non-Editioned File System : /u02/applR12/PRODDB/fs_ne
DB Host: punitchi.lab.com Service/SID: PRODDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Please choose the environment file you wish to source [R/P]:P
Sourcing the PATCH File System ...
[applmgr@punitchi:applmgr]> PS1='$TWO_TASK> '
punitchi_patch>
5) How to find out whether a system is in an Online Patching cycle using the "adop -status" command.
[applmgr@punitchi:applmgr]> adop -status
Enter the APPS username: apps
Enter the APPS password:
Current Patching Session ID: 7
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
punitc master PREPARE COMPLETED 05-Jun-16 03:57:39 +00:00 06-Jun-16 04:55:57 +00:00 36:58:18
FINALIZE COMPLETED 06-Jun-16 06:09:01 +00:00 06-Jun-16 06:54:41 +00:00 0:45:40
CUTOVER COMPLETED 06-Jun-16 06:59:47 +00:00 06-Jun-16 07:26:32 +00:00 0:26:45
CLEANUP COMPLETED 06-Jun-16 11:26:07 +00:00 06-Jun-16 11:28:53 +00:00 0:02:46
APPLY COMPLETED
File System Synchronization Used in this Patching Cycle: Full
For more information, run ADOP Status Report by using -detail option
Generating ADOP Status Report at location: /u02/applR12/PRODDB/fs_ne/EBSapps/log/status_20160625_172245/adzdshowstatus.out
Please wait...
Done...!
adop exiting with status = 0 (Success)
6) How to find names and status of past and present database editions using the ADZDSHOWED.sql script.
The below lists the existing database editions and identifies the OLD, RUN, and PATCH editions.
[applmgr@punitchi:applmgr]> sqlplus apps/********* @ADZDSHOWED.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Thu May 29 16:37:18 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
=========================================================================
= Editions
=========================================================================
Edition Name Type Status Current?
--------------- -------- -------- --------
ORA$BASE RETIRED
V_20140202_0749 OLD RETIRED
V_20140405_2132 RUN ACTIVE CURRENT
V_20140508_1528 PATCH ACTIVE
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[applmgr@punitchi:applmgr]>
7) How to change to the patch edition of database using SQL*Plus? /u02/applR12/PRODDB/fs1/EBSapps/appl/ad/12.0.0/sql
[applmgr@punitchi:applmgr]> sqlplus apps/********* @ADZDSHOWED.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jun 25 17:03:50 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> exec ad_zd.set_edition('PATCH');
8) What are the Tools and Scripts for Edition-based Development?
[applmgr@punitchi:applmgr]> . /u02/app/applmgr/120/punitchi/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u02/app/applmgr/120/punitchi/fs1/EBSapps/appl
PATCH File System : /u02/app/applmgr/120/punitchi/fs2/EBSapps/appl
Non-Editioned File System : /u02/app/applmgr/120/punitchi/fs_ne
DB Host: punitc.lab.com Service/SID: punitchi
Sourcing the RUN File System ...
[applmgr@punitchi:applmgr]> which adop
/u02/applR12/PRODDB/fs1/EBSapps/appl/ad/bin/adop
[applmgr@punitchi:applmgr]> which xdfgen.pl
/u02/applR12/PRODDB/fs1/EBSapps/applfnd/12.0.0/bin/xdfgen.pl
[applmgr@punitchi:applmgr]> which xdfcmp.pl
/u02/applR12/PRODDB/fs1/EBSapps/appl/fnd/12.0.0/bin/xdfcmp.pl
[applmgr@punitchi:applmgr]>
9) Useful SQL*Plus scripts that provides information about the state of your editioned development environment. All ADZD* scripts are found under $AD_TOP/sql.
Add this directory to the SQLPATH environment variable so that you can refer to the scripts by simple name.
[applmgr@punitchi:applmgr]> SQLPATH=$AD_TOP/sql; export SQLPATH
[applmgr@punitchi:applmgr]> echo $SQLPATH
/u02/applR12/PRODDB/fs1/EBSapps/applad/12.0.0/sql
[applmgr@punitchi:applmgr]>
ADZDDBCC - database compliance checker, shows violations of the database object development standards documented in the Oracle E-Business Suite Developer's Guide, Part No. E22961. Warning: this script takes a long time to run.
ADZDSHOWED - Show database editions and current edition.
ADZDSHOWLOG - Show full diagnostic log for online patching infrastructure
ADZDSHOWLOGEVT - Show only event and error messages from online patching diagnostic log (a useful summary, without the detailed statement text).
ADZDSHOWLOGERR - Show only error messages from online patching diagnostic log.
ADZDSHOWEV TABLE_SYNONYM_NAME - Show editioning view column mapping for table.
ADZDSHOWTAB TABLE_SYNONYM_NAME - Show table information and related objects.
ADZDSHOWMV MVIEW_NAME - Show materialized view information and related objects.
ADZDSHOWTS - Show important tablespace status. Ensure that you have enough SYSTEM tablespace.
ADZDCMPED - Compare Patch Edition with Run Edition. Warning: this script may take a long time to run.
ADZDSHOWDDLS - Show stored DDL summary by phase.
ADZDALLDDLS - Show stored DDL statement text and status.
ADZDDDLERROR - Show stored DDL execution errors and messages.
adutlrcmp - Recompile all objects, with before/after status report. Warning: this script may take a long time to run.
The following scripts are for experts:
ADZDSHOWOBJS - Show Object Summary per edition. Counts of actual and stub (inherited) editioned object per edition.
ADZDSHOWAOBJS - Show Actual Objects in the current edition. These are the editioned objects that have been changed by the patch.
ADZDSHOWIOBJS - Show Inherited Objects in the current edition. These are the editioned objects that remain untouched in the Patch Edition.
ADZDSHOWCOBJS - Show Covered Object Summary per edition. Count of objects in old editions that have a replacement in the run edition.
ADZDSHOWCOBJX - Show Covered Object List. List of objects in old editions that have a replacement in the run edition.
ADZDSHOWSM - Show Seed Manager status.
ADZDSHOWTM - Show Table Manager status.
ADZDSHOWAD - AD (online patching) database object status
ADZDSHOWSES - Show sessions connected to the database (by edition).
ADZDSHOWDEP OBJECT_NAME - Show objects that OBJECT_NAME depends on.
ADZDSHOWDEPTREE OBJECT_NAME - Show full dependency tree of objects that OBJECT_NAME depends on.
No comments:
Post a Comment