Oracle Procedure Or Function 확인

[참고]

http://jbongsu.blogspot.kr/2013/02/sql.html

http://kalipso.tistory.com/99

[참고]

# 전체 유저 #

select * from all_source where name = upper('프로시저명');

 > 결과 Column : OWNER, NAME, TYPE, LINE, TEXT

# 로그인한 유저 #

select * from user_source where name = upper('프로시저명');

 > 결과 Column : NAME, TYPE, LINE, TEXT

# 테이블 정보 확인 #

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') regdate from dual; 

select table_name, tablespace_name, num_rows from user_tables; 

# 인덱스 정보 확인 #

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') regdate from dual; 

select index_name, index_type, table_name, last_analyzed, tablespace_name, uniqueness from user_indexes; 

# 시퀀스 정보  확인 #

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') regdate from dual; 

select sequence_name, increment_by, min_value, max_value, last_number from seq; 

# 테이블 스페이스 확인 #

select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') regdate from dual; 

select tablespace_name, initial_extent, next_extent, contents,status from user_tablespaces; 

추가 팁 : 인덱스 리빌드 쿼리 문 생성하기 

SQL> Spool Monitor_index.sql 

SQL > Select 'Alter Index '||Index_name||' Monitoring Usage; ' 

from user_indexes; 

SQL > spool off 

Function 

SELECT * FROM USER_OBJECTS 

WHERE OBJECT_TYPE = 'FUNCTION' 

  

Procedure 

SELECT * FROM USER_OBJECTS 

WHERE OBJECT_TYPE = 'PROCEDURE' 

Package 

SELECT * FROM USER_OBJECTS 

WHERE OBJECT_TYPE = 'PACKAGE' 

Package Body 

SELECT * FROM USER_OBJECTS 

WHERE OBJECT_TYPE = 'PACKAGE BODY'