MARC

 008071116s2004        ulka                    000      kor
■020    ▼a8956741999
■0801  ▼a681.3.02
■082    ▼a005.7406▼bT454ㅇ▼223
■090    ▼a005.7406▼bT454ㅇ
■1001  ▼aThomas  Kyte  저
■24510▼a이펙티브  오라클▼b성능  향상을  위한  데이터베이스  설계  비법▼xEffective  Oracle  byDesign▼dThomas  Kyte  저▼e박민호  역
■260    ▼a서울▼b정보문화사▼c2004
■300    ▼a859p.▼b삽도▼c26cm
■505    ▼a머리말▼c16▼a용어  대역표▼c19▼a제1장  애플리케이션  구축을  위한  올바른  접근법▼a중요한  것은  팀  노력이다▼c38▼a문서를  읽어라▼c44▼a블랙박스  증후군을  피하라▼c50▼a이것은  데이터베이스이지,  데이터  더미가  아니다▼c66▼a테스트  환경을  구축하라▼c74▼a성능  향상을  위해서는  튜닝하지  말고  디자인하라▼c81▼a처음부터  성능  목표를  정의하라▼c8900▼a벤치마크,  벤치마크,  벤치마크▼c9411▼a시스템에  코드를  삽입하라▼c10222▼a권위에  도전하라▼c11333▼a지름길을  찾지  말라▼c11844▼a단순화하라▼c12055▼a제공된  기능을  사용하라▼c12566▼a요약▼c13577▼a제2장  성능  툴키트88▼aSQL*Plus▼c13999▼aEXPLAIN  PLAN▼c14400▼aAUTOTRACE▼c15811▼aTKPROF▼c19222▼aRunstats▼c21033▼aStatspack▼c22144▼aDBMS_PROFILER▼c23255▼aJDeveloper(그리고  디버깅)▼c23666▼a요약▼c24077▼a제3장  아키텍처와  관련된  결정88▼a공유  서버  대  전용  서버  연결에  대한  이해▼c24299▼a클러스터링  이용▼c25300▼a파티셔닝  이용  시기▼c26211▼a병렬  작업을  사용할  시기  알기▼c27522▼a요약▼c29033▼a제4장  효과적인  관리44▼aSPFILE을  이용하여  데이터베이스  시작하기▼c29255▼a데이터  파일의  관리를  오라클에  맡기기▼c30066▼a복구의  방탄화▼c30577▼a지역적으로  관리되는  테이블  영역  사용하기▼c31188▼a세그먼트  공간  관리를  오라클에  맡기라▼c32699▼a롤백  세그먼트  관리를  오라클에  맡기라▼c33600▼a요약▼c34211▼a제5장  문  처리22▼aSQL  문의  유형에  대한  이해▼c34633▼a문은  어떻게  실행되는가?▼c34744▼a쿼리의  시작과  끝▼c36055▼a수정  DML의  시작과  끝▼c36966▼aDDL  처리▼c37177▼a바인드  변수의  사용▼c37388▼a가능한  한  적게  파싱하기▼c40299▼a요약▼c42100▼a제6장  비용  기반의  최적화기  활용  극대화11▼aRBO가  사장된  이유▼c42522▼aCBO로  하여금  최선을  다  하도록  만들기▼c42833▼aCBO  최적화하기▼c44444▼a10053  이벤트를  사용하여  CBO  선택  추적하기▼c49355▼a요약▼c49966▼a제7장  효과적인  스키마  디자인77▼a스키마  디자인  기본  원칙▼c50288▼a테이블  종류  개요▼c51899▼aB*트리  인덱스  클러스터  테이블▼c51900▼a인덱스  조직  테이블(IOT)▼c53911▼a외부  테이블▼c54722▼a인덱싱  테크닉▼c55933▼a압축▼c57244▼a요약▼c59355▼a제8장  효과적인  SQL66▼a효율적인  SQL을  작성하는  데  필요한  것▼c59777▼a액세스  경로  이해하기▼c59888▼a조인에  대한  이해▼c62099▼a(물리적인)  스키마  문제▼c64300▼aSQL  바로  알기▼c64711▼a쿼리를  튜닝하지  말라▼c70522▼a기타  SQL  테크닉  개요▼c71233▼a요약▼c71244▼a제9장  효과적인  PL/SQL  프로그래밍55▼a왜  PL/SQL인가?▼c71666▼a가능한  한  적게  작성하라▼c72177▼a패키지를  사용하라▼c72788▼a정적  SQL을  사용하라▼c73599▼a대량  처리▼c74000▼a데이터  반환하기▼c75011▼a%TYPE과  %ROWTYPE을  사용하라▼c75722▼a호출자  권한  이용하기▼c76733▼a조회  작업을  효율적으로  수행하라▼c77144▼a자치  트랜잭션을  사용할  때  주의하기▼c78255▼a암시적  혹은  명시적  커서를  사용할지  선택하라▼c78666▼a요약▼c79677▼a제10장  그렇게  사고를  만났다88▼a무엇이  다른지를  찾는다▼c80099▼a한번에  한  가지만  변경한다▼c80700▼a이  한  가지를  변경하는  데는  충분한  근거가  있어야  한다.▼c80811▼a변화를  되돌릴  수  있어야  한다.▼c81222▼a테스트  사례를  작성한다 ▼c81333▼a요약▼c81744▼a부록  설치와  몇  가지  스크럽트55▼aBIG_TABLE  설정하기▼c82066▼a자주  사용되는  스크립트▼c82277▼aGEN_DATA▼c84088▼a찾아보기▼c84399
■9500  ▼c30,000

Preview

Export

ChatGPT Discussion

AI Recommended Related Books