좀더 나은 나를 위하여

오라클 export import 관련 링크

프로그래밍/SQL 2012. 8. 31. 20:08

http://blog.naver.com/PostView.nhn?blogId=tyboss&logNo=70033321734&redirect=Dlog&widgetTypeCall=true

http://sangu12.egloos.com/2784067

http://blog.naver.com/PostView.nhn?blogId=sneri&logNo=110018379120&redirect=Dlog&widgetTypeCall=true

http://suyou.tistory.com/16

저작자표시

Posted by 빨강토끼

자바 메모리 문제 관련 링크

프로그래밍/JAVA 2012. 8. 31. 20:07

http://hckim.tistory.com/108

http://tinywolf.tistory.com/103

http://omen666.tistory.com/40

http://fly32.tistory.com/438

http://ssiso.net/cafe/club/club1/board1/content.php?board_code=javaStudy|javaTuning&idx=7401&club=javaStudy&cp=1&cb=1&search=&search_word=

http://donzbox.tistory.com/150

저작자표시

Posted by 빨강토끼

SELECT A.SEGMENT_NAME,
              ROUND(SUM(A.BYTES)/1024/1024) "SIZE_MB",
              A.SEGMENT_TYPE
FROM DBA_SEGMENTS A,
            DBA_TABLES B
WHERE A.SEGMENT_NAME = B.TABLE_NAME
      AND A.SEGMENT_TYPE IN ('TABLE','TABLE PARTITION')
      AND A.OWNER = '유저아이디'
GROUP BY A.SEGMENT_NAME, A.SEGMENT_TYPE
ORDER BY 2 DESC;