| SQL�ｿｽ`�ｿｽ�ｿｽ�ｿｽ[�ｿｽj�ｿｽ�ｿｽ�ｿｽO |
|
�ｿｽ蝠ｶ�ｿｽ�ｿｽ/�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ/�ｿｽ窒�ｿｽ�ｿｽ�ｿｽs�ｿｽﾌ撰ｿｽ�ｿｽ揶黷ｷ�ｿｽ�ｿｽ |
|
�ｿｽo�ｿｽC�ｿｽ�ｿｽ�ｿｽh�ｿｽﾏ撰ｿｽ�ｿｽ�ｿｽ�ｿｽg�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽh�ｿｽJ�ｿｽ[�ｿｽh�ｿｽu * �ｿｽv�ｿｽﾍ使�ｿｽp�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ |
|
AND�ｿｽ�ｿｽ�ｿｽBETWEEN�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
HAVING�ｿｽ�ｿｽ�ｿｽWHERE�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
UNION�ｿｽ�ｿｽ�ｿｽUNION ALL�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽe�ｿｽ[�ｿｽu�ｿｽ�ｿｽ�ｿｽﾉ別厄ｿｽ�ｿｽ�ｿｽt�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
ROWID�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽﾔ搾ｿｽ�ｿｽﾍ使�ｿｽp�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ |
|
DISTINCT�ｿｽ�ｿｽ�ｿｽ�ｿｽEXISTS�ｿｽ�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
NOT IN�ｿｽ�ｿｽ�ｿｽ�ｿｽNOT EXISTS�ｿｽ�ｿｽ�ｿｽﾌ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ |
|
INDEX�ｿｽ�ｿｽ�ｿｽ�ｿｽg�ｿｽp�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi�ｿｽP�ｿｽj |
|
INDEX�ｿｽ�ｿｽ�ｿｽ�ｿｽg�ｿｽp�ｿｽ�ｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi�ｿｽQ�ｿｽj |
|
|
| �ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽf�ｿｽf�ｿｽ�ｿｽ�ｿｽﾌ取得 |
|
�ｿｽ�ｿｽ�ｿｽs�ｿｽv�ｿｽ�ｿｽﾌ取得�ｿｽF8i�ｿｽﾈ前�ｿｽi EXPLAIN PLAN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽs�ｿｽv�ｿｽ�ｿｽﾌ取得�ｿｽFSQLPLUS�ｿｽ�ｿｽAUTOTRACE�ｿｽi EXPLAIN PLAN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽs�ｿｽv�ｿｽ�ｿｽﾌ取得�ｿｽF9i�ｿｽﾈ降�ｿｽ�ｿｽ�ｿｽﾌ１�ｿｽi V$SQL_PLAN �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽs�ｿｽv�ｿｽ�ｿｽﾌ取得�ｿｽF9i�ｿｽﾈ降�ｿｽ�ｿｽ�ｿｽﾌ２�ｿｽi V$SQL_PLAN_STATISTICS_ALL �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽs�ｿｽv�ｿｽ�ｿｽﾌ取得�ｿｽFSQL�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽX�ｿｽAtkprof |
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽﾉつゑｿｽ�ｿｽ�ｿｽ |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽI�ｿｽi pfile�ｿｽ^spfile �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽi �ｿｽﾃ的�ｿｽ^�ｿｽ�ｿｽ�ｿｽI �ｿｽj |
| �ｿｽX�ｿｽ|�ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽh�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽN |
|
|
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽ`�ｿｽ�ｿｽ�ｿｽ[�ｿｽj�ｿｽ�ｿｽ�ｿｽO�ｿｽi �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾖ連 �ｿｽj |
|
SGA�ｿｽﾌ最托ｿｽT�ｿｽC�ｿｽY�ｿｽi SGA_MAX_SIZE �ｿｽj |
|
SGA�ｿｽﾌ��ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾇ暦ｿｽ�ｿｽi SGA_TARGET �ｿｽj |
|
�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽE�ｿｽo�ｿｽb�ｿｽt�ｿｽ@�ｿｽE�ｿｽL�ｿｽ�ｿｽ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽY�ｿｽi DB_CACHE_SIZE �ｿｽj |
|
�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽE�ｿｽo�ｿｽb�ｿｽt�ｿｽ@�ｿｽE�ｿｽL�ｿｽ�ｿｽ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽY�ｿｽi DB_BLOCK_BUFFERS �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽL�ｿｽv�ｿｽ[�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽY�ｿｽi SHARED_POOL_SIZE �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ[�ｿｽW�ｿｽE�ｿｽv�ｿｽ[�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽY�ｿｽi LARGE_POOL_SIZE �ｿｽj |
|
�ｿｽi�ｿｽ`�ｿｽu�ｿｽ`�ｿｽv�ｿｽ[�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽY�ｿｽi JAVA_POOL_SIZE �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽO�ｿｽE�ｿｽo�ｿｽb�ｿｽt�ｿｽ@�ｿｽT�ｿｽC�ｿｽY�ｿｽi LOG_BUFFER �ｿｽj |
|
SGA�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ固抵ｿｽi PRE_PAGE_SGA �ｿｽj |
|
PGA�ｿｽﾌ��ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾇ暦ｿｽ�ｿｽi PGA_AGGREGATE_TARGET �ｿｽj |
|
�ｿｽ\�ｿｽ[�ｿｽg�ｿｽG�ｿｽ�ｿｽ�ｿｽA�ｿｽT�ｿｽC�ｿｽY�ｿｽi SORT_AREA_SIZE �ｿｽj |
|
�ｿｽn�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽG�ｿｽ�ｿｽ�ｿｽA�ｿｽT�ｿｽC�ｿｽY�ｿｽi HASH_AREA_SIZE �ｿｽj |
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽ`�ｿｽ�ｿｽ�ｿｽ[�ｿｽj�ｿｽ�ｿｽ�ｿｽO�ｿｽi �ｿｽh/�ｿｽn�ｿｽﾖ連 �ｿｽj |
|
�ｿｽu�ｿｽ�ｿｽ�ｿｽb�ｿｽN�ｿｽT�ｿｽC�ｿｽY�ｿｽi DB_BLOCK_SIZE �ｿｽj |
|
�ｿｽS�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌ撰ｿｽ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi DB_FILE_MULTIBLOCK_READ_COUNT �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽJ�ｿｽo�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾔの指�ｿｽ�ｿｽi FAST_START_MTTR_TARGET �ｿｽj |
|
�ｿｽX�ｿｽV�ｿｽp�ｿｽx�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ托ｿｽ�ｿｽ�ｿｽ�ｿｽ鼾��ｿｽi DB_WRITER_PROCESSES �ｿｽj |
|
�ｿｽX�ｿｽV�ｿｽp�ｿｽx�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ托ｿｽ�ｿｽ�ｿｽ�ｿｽ鼾��ｿｽi DBWR_IO_SLAVES �ｿｽj |
| �ｿｽX�ｿｽ|�ｿｽ�ｿｽ�ｿｽT�ｿｽ[�ｿｽh�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽN |
|
|
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽ`�ｿｽ�ｿｽ�ｿｽ[�ｿｽj�ｿｽ�ｿｽ�ｿｽO�ｿｽi �ｿｽZ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽE�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽU�ｿｽN�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾖ連 �ｿｽj |
|
�ｿｽﾅ大ユ�ｿｽ[�ｿｽU�ｿｽ[�ｿｽv�ｿｽ�ｿｽ�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽi PROCESSES �ｿｽj |
|
�ｿｽﾅ托ｿｽZ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi SESSIONS �ｿｽj |
|
�ｿｽﾅ托ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽU�ｿｽN�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi TRANSACTIONS �ｿｽj |
|
�ｿｽﾅ托ｿｽJ�ｿｽ[�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi OPEN_CURSORS �ｿｽj |
|
�ｿｽJ�ｿｽ[�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽL�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi CURSOR_SHARING �ｿｽj |
|
�ｿｽZ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾅキ�ｿｽ�ｿｽ�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽJ�ｿｽ[�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽi SESSION_CACHED_CURSORS �ｿｽj |
| �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ[�ｿｽ^�ｿｽ`�ｿｽ�ｿｽ�ｿｽ[�ｿｽj�ｿｽ�ｿｽ�ｿｽO�ｿｽi �ｿｽ�ｿｽ�ｿｽﾌ托ｿｽ �ｿｽj |
|
�ｿｽW�ｿｽ�ｿｽ�ｿｽu�ｿｽﾌ難ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽi JOB_QUEUE_PROCESSES �ｿｽj |
|
SQL�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽX�ｿｽi SQL_TRACE �ｿｽj |
|
�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽX�ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽo�ｿｽﾍ撰ｿｽi USER_DUMP_DEST �ｿｽj |
|
�ｿｽg�ｿｽ�ｿｽ�ｿｽ[�ｿｽX�ｿｽt�ｿｽ@�ｿｽC�ｿｽ�ｿｽ�ｿｽﾅ托ｿｽT�ｿｽC�ｿｽY�ｿｽi MAX_DUMP_FILE_SIZE �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ関ゑｿｽ�ｿｽ體晢ｿｽv�ｿｽ�ｿｽ�ｿｽi TIMED_STATISTICS �ｿｽj |
|
�ｿｽ�ｿｽ�ｿｽv�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽW�ｿｽ�ｿｽ�ｿｽx�ｿｽ�ｿｽ�ｿｽi STATISTICS_LEVEL �ｿｽj |
|
|
|
|
