Created
April 15, 2011 07:28
-
-
Save 544/921306 to your computer and use it in GitHub Desktop.
Oracleパラレルクエリ実行
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 確認 | |
SELECT * FROM V$PQ_SESSTAT | |
WHERE STATISTIC LIKE '%Parallelized'; | |
-- パラレルクエリ有効化 | |
ALTER SESSION ENABLE PARALLEL DML; | |
-- パラレルクエリ | |
SELECT/*+ PARALLEL ( A, 2 ) */ * FROM DUAL A; | |
ROLLBACK; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment