Set Appropriate Parallel

http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19217-02/usingpe.htm#sthref2322

ALTER TABLE orders PARALLEL 4;
ALTER INDEX iorders PARALLEL 4;
SELECT /*+ PARALLEL(orders, 4) */ COUNT(*) FROM orders;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License