Data Pump

http://www.clip.gr.jp/~imai/PukiImaiWiki/index.php?Oracle/DataPump

Oracle Enterprise Manager

Linuxのコマンド

oracleユーザになり、$ORACLE_HOME/bin/emctl コマンドで起動できます。

$ORACLE_HOME/bin/emctl start dbconsole

停止は「stop」、起動しているかの確認は「status」を引数にしてください。

インデックスに関するコスト計算の調整

http://ameblo.jp/archive-redo-blog/entry-10048143385.html

OPTIMIZER_INDEX_CACHING、OPTIMIZER_INDEX_COST_ADJ

かあ。

実行計画参照ビュー

select ADDRESS, HASH_VALUE, SQL_ID, PLAN_HASH_VALUE, CHILD_ADDRESS,

CHILD_NUMBER, TIMESTAMP, OPERATION, OPTIONS, OBJECT_NODE, OBJECT#,

OBJECT_OWNER, OBJECT_NAME, OBJECT_ALIAS, OBJECT_TYPE, OPTIMIZER, ID,

PARENT_ID, DEPTH, POSITION, SEARCH_COLUMNS, COST, CARDINALITY, BYTES,

OTHER_TAG, PARTITION_START, PARTITION_STOP, PARTITION_ID, OTHER,

DISTRIBUTION, CPU_COST, IO_COST, TEMP_SPACE, ACCESS_PREDICATES,

FILTER_PREDICATES, PROJECTION, TIME, QBLOCK_NAME, REMARKS,

dbms_lob.substr(OTHER_XML, 1024) as OTHER_XML, EXECUTIONS, LAST_STARTS,

STARTS, LAST_OUTPUT_ROWS, OUTPUT_ROWS, LAST_CR_BUFFER_GETS,

CR_BUFFER_GETS, LAST_CU_BUFFER_GETS, CU_BUFFER_GETS, LAST_DISK_READS,

DISK_READS, LAST_DISK_WRITES, DISK_WRITES, LAST_ELAPSED_TIME,

ELAPSED_TIME, POLICY, ESTIMATED_OPTIMAL_SIZE, ESTIMATED_ONEPASS_SIZE,

LAST_MEMORY_USED, LAST_EXECUTION, LAST_DEGREE, TOTAL_EXECUTIONS,

OPTIMAL_EXECUTIONS, ONEPASS_EXECUTIONS, MULTIPASSES_EXECUTIONS,

ACTIVE_TIME, MAX_TEMPSEG_SIZE, LAST_TEMPSEG_SIZE

from V_$SQL_PLAN_STATISTICS_ALL

WHERE OBJECT_NAME = 'テーブル名'

ORDER BY TIMESTAMP DESC