Hi all!
It’s not necessarily the DBA function, but how often someone of business came and ask you wich is the impact on recompiling one or other procedure?
It probably happen because the DBA usually make some magic and have a better understanding about objects relationship. It happens specially in cases there is no code governance…
So, you don’t have to handle all responsability and can switch some of that with developer, through DBA_DEPENDENCIES view.
The undertstanding is easy: The depended objects and the refered objects. If ou change the refered, all depended will be impacted by.
GREPORADB> @dependencies Enter value for owner: GREPORA Enter value for obj_name: TABLE_EXAMPLE OWNER Name TYPE DEPE REFERENCED REFERENCED_OWNER REFERENCED_NAME ------------------ ----------------------------------- ---------- ---- ---------- ------------------ ----------------------------------- GREPORA TOTALANSWEREDQUESTIONS FUNCTION HARD TABLE GREPORA TABLE_EXAMPLE GREPORA USERRESPONSESTATUS FUNCTION HARD TABLE GREPORA TABLE_EXAMPLE GREPORA VW_INPROGRESSFEEDBACKOPTS VIEW HARD TABLE GREPORA TABLE_EXAMPLE GREPORA EVENTSTARTDT FUNCTION HARD TABLE GREPORA TABLE_EXAMPLE GREPORA HAVEUSERANSWEREDANYTHING FUNCTION HARD TABLE GREPORA TABLE_EXAMPLE
Nice, hãn?
## @dependencies col owner for a18 col name for a35 col type for a10 col referenced_owner for a18 col referenced_name for a35 col referenced_type for a10 select owner,name,type,dependency_type,referenced_type,referenced_owner,referenced_name from dba_dependencies where referenced_owner like upper('%&owner%') and referenced_name like upper('%&OBJ_NAME%');
See ya!
Matheus.