https://www.adminschool.net/wiki/ 2026-04-22T07:52:52+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:tuning:etc&rev=1759498250&do=diff Oracle Tunning Etc * PGA영역 select * from v$resource_limit where rownum <= 2; * PGA영역 확장여부확인 set lines 500 set pages 500 select * from v$sysstat; STATISTIC# NAME CLASS VALUE STAT_ID ---------- ---------------------------------------------------------------- ---------- ---------- ---------- ... 327 workarea memory allocated 64 22822 2433935387 328 wo… text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:tuning:oracletrace&rev=1759498250&do=diff Oracle Trace Trace Define SQL-PLUS TOAD ORANGE MAXGAUGE text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:tuning:tablelock&rev=1759498250&do=diff Oracle Table Lock 처리방법 * ORA-00054 (resource busy and acquire with NOWAIT specified) 에러는 commit/rollback을 처리를 안했거나, 특정작업을 하고 있었거나 그 이유는 매우 다양하다. * DB를 재시작할 수 없는 상태에서는 Lock이 걸린 세션을 kill 해주어야 한다.