본문 바로가기

Infra/DataBase23

[Oracle] Startup ShutDown oracle@oracle $ ./svrmgrl SVRMGRL> connect internal SVRMGRL> startup SVRMGRL> exit oracle@oracle $ lsnrctl start --종료 oracle@oracle $ lsnrctl stop oracle@oracle $ svrmgrl SVRMGRL> connect internal SVRMGRL> shutdown normal 2009. 10. 12.
다중업데이트 update ABC85 A set A.job_dt =( select to_char(B.crea_dt,'yyyymmdd') from ABC85 B WHERE A.CREA_DT = B.CREA_DT ) 2009. 10. 12.
테이블 용량 확인 ------------------------------------------ select substr(A.tablespace_name,1,16) "Tablespace", SUM(B.BYTES)*COUNT(DISTINCT B.FILE_ID)/COUNT(B.FILE_ID)/1024/1024 "TOTAL SIZE (Mb)", (SUM(B.BYTES)*COUNT(DISTINCT B.FILE_ID)/COUNT(B.FILE_ID)/1024/1024)-(ROUND (SUM(C.BYTES)/1024/1024/COUNT(DISTINCT B.FILE_ID))) "USED SIZE(Mb)", TO_CHAR(100-(SUM(C.BLOCKS)*100*COUNT(B.FILE_ID)/(SUM(B.BLOCKS)*COUNT (DIST.. 2009. 10. 9.
현재 개발된 함수와 프로시저를 알수 있습니다 select u.name, o.name,o.obj#, decode(o.type#, 7, 'PROCEDURE', 8, 'FUNCTION') from sys.obj$ o, sys.user$ u where o.owner# = u.user# and o.type# in (7, 8) ; -현재 개발된 함수와 프로시저를 알수 있습니다. SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') "My IP Address" from dual; SELECT SYS_CONTEXT('USERENV','HOST') host from dual; 2009. 10. 9.

티스토리툴바