RE: make create table run faster?
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Apr 2009 07:30:40 -0700 (PDT)
You could make CTAS faster by:
1) Making sure that db_file_multiblock_read_count (and db_file_direct_io_count)
is set to maximum value (no need to set it on 10g and above)
2) Make sure parallel_max_servers parameter value is more than the parallelism
you are using for CTAS
3) Assuming that the select portion is doing full table scan or index fast full
scan, you can use parallelism there also. Make sure to use same degree of
parallelism for both create and select (i.e. create table test1 parallel 4 as
select /*+ full(test2) parallel(test2, 4) */ * from test2).
4) Query v$session_longops for monitoring the job.
Thanks,
Sai
http://sai-oracle.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
