|
|
1번째 줄: |
1번째 줄: |
|
| |
|
| <!-- DATABASE -->
| |
| {| id="mp_contents" style="width:100%; height: 100%; font-size: small; border-spacing:0;"
| |
| <!-- 왼쪽 -->
| |
| | id="mp_contentsL" style="width: 100%; border:1px solid #a7d7f9; vertical-align:top; padding: 1em; overflow: auto; -moz-border-radius: 0.8em; -webkit-border-radius: 0.8em; border-radius: 0.8em;" | <div id="mp_featuredArticle" class="mp_contentsboxtitle" style="background-color:#bbddff; margin-bottom: 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;"><div style="float: left; margin: -8px 8px -8px 0px;"></div>
| |
| [[ORACLE Architecture]] </div>
| |
|
| |
| <div id="mp-tfa">
| |
| # [[ORACLE Architecture]]
| |
| # [[UNDO REDO]]
| |
| # [[ORACLE PARAMETER]]
| |
| # [[ORACLE Hidden PARAMETER]]
| |
| # [[ORACLE TABLESPACE]]
| |
| # [[ORACLE TEMPORARY TABLE]]
| |
| # [[ORACLE TEMPORARY TABLESPACE]]
| |
|
| |
| </div>
| |
|
| |
| <!-- Objejcts -->
| |
| <div id="mp_goodArticle" class="mp_contentsboxtitle" style="background-color:#bbddff; margin: 1.2em 0 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;"><div style="float: left; margin: -8px 8px -8px 0px;"></div>
| |
| [[Oracle Objejcts]]</div>
| |
|
| |
| # [[ORACLE COLUMN Addition, Deletion, Change]]
| |
| # [[ORACLE CREATE TABLE]]
| |
| # [[Oracle FK Creation PROCEDURE]]
| |
| # [[ORACLE LOB]]
| |
| # [[ORACLE DDL Generation Script]]
| |
| # [[ORACLE DDL TRIGGER]]
| |
| # [[ORACLE Extract ALL TABLE / COLUMN / COMMENT]]
| |
| # [[ORACLE FAQ]]
| |
| # [[ORACLE FUNCTION]]
| |
| # [[ORACLE TRIGGER]]
| |
| # [[ORACLE SEQUENCE]]
| |
|
| |
| <!-- SQL -->
| |
| <div id="mp_todayInHistory" class="mp_contentsboxtitle" style="background-color:#bbddff; margin: 1.2em 0 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;"><div style="float: left; margin: -8px 8px -8px 0px;"></div> SQL </div>
| |
| # [[ORACLE SQL Collection]]
| |
| # [[SQL INSERT Statement]]
| |
| # [[ORACLE NVL NVL2]]
| |
| # [[NVL NVL2 Fuction]]
| |
| # [[LNNVL Function]]
| |
| # [[ORACLE COALESCE]]
| |
| # [[SQL CONNECT BY]]
| |
| # [[ORACLE SQL ADVISOR]]
| |
| # [[SQL LATERAL Statement]]
| |
| # [[SQL REGULAR Expressions]]
| |
| # [[SQL TRANSLATE Function]]
| |
| # [[SQL TRUNCATE Statement Usage]]
| |
| # [[ORACLE XML Query]]
| |
| # [[Analysis Function]]
| |
|
| |
| # [[ORACLE PROCEDURE]]
| |
| # [[ORACLE PROCEDURE Sample]]
| |
| # [[ORACLE PROCEDURE Extraction Query]]
| |
| # [[ORAClE PROCEDURE FUNCTION LIST]]
| |
|
| |
| <!-- /본문 왼쪽 -->
| |
| |}
| |
| <!-- /본문 -->
| |
| </div>
| |
|
| |
| <!-- DATABASE -->
| |
| {| id="mp_contents" style="width:100%; height: 100%; font-size: small; border-spacing:0;"
| |
| <!-- 본문 오른쪽 -->
| |
| | id="mp_contentsR" style="border:1px solid #a7d7f9; vertical-align:top; padding: 1em; overflow: auto; background-color: #eef6ff; -moz-border-radius: 0.8em; -webkit-border-radius: 0.8em; border-radius: 0.8em; | <div id="mp_introduce" class="mp_contentsboxtitle" style="background-color:#bbddff; margin-bottom: 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;">[[ Monitoring/ Admin /Wait Event]]</div>
| |
| * Monitoring
| |
| # [[ORACLE DBA Command Script]]
| |
| # [[Drop Table procedure]]
| |
| # [[ORACLE NOLOGGING LOGGING]]
| |
| # [[ORACLE USER Creation]]
| |
| # [[Oracle standard edition issue]]
| |
| # [[ORACLE LOCK]]
| |
| * Admin
| |
| # [[ORACLE MONITORING]]
| |
| # [[ASH]]
| |
| # [[AWR]]
| |
| # [[AWR Daily Collection]]
| |
| # [[ORACLE V$SQL MONITOR]]
| |
| * Wait Event
| |
| # [[ORACLE Wait-Event]]
| |
| # [[ORACLE Wait-Event Perfermance View]]
| |
|
| |
|
| |
|
| |
| <!-- Performance Tuning -->
| |
| <div id="mp_participation" class="mp_contentsboxtitle" style="background-color:#bbddff; margin: 1.2em 0 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;"><div style="float: left; margin: -8px 8px -8px 0px;"></div>[[Performance Tuning]]</div>
| |
| # [[ORACLE XPLAN]]
| |
| # [[DBMS XPLAN]]
| |
| # [[Oracle Subquery Description Join Tuning]]
| |
| # [[NL Join]]
| |
| # [[JPPD (Join Predicate PushDown)]]
| |
| # [[NL Join Prefetch]]
| |
| # [[HASH Join]]
| |
| # [[ORACLE HINT List]]
| |
| # [[SQL MERGE]]
| |
| # [[Tuning point per JOIN]]
| |
| # [[ORACLE JOIN Order]]
| |
|
| |
| <!-- Oracle Tools -->
| |
| <div id="mp_CurrentEvents" class="mp_contentsboxtitle" style="background-color:#bbddff; margin: 1.2em 0 0.7em; padding: 0.2em 0.5em; font-size: 1.2em; line-height: 1.2em; overflow: visible; font-weight: bold; -moz-border-radius: 0.5em; -webkit-border-radius: 0.5em; border-radius: 0.5em;"><div style="float: left; margin: -8px 8px -8px 0px;"></div>[[Oracle Tools]]</div>
| |
| <div id="mp-itn">
| |
| # [[EXPORT DP]]
| |
| # [[SPM]]
| |
| # [[ORACLE LOGMINER]]
| |
| # [[ORACLE Sqlplus]]
| |
| </div>
| |
|
| |
| <!-- /본문 오른쪽 -->
| |
| <!-- /본문 -->
| |
| </div>
| |
|
| |
| |}
| |