Tuesday, March 8, 2016

what are the areas we use parallel options to speed up the tasks in oracle database ?

Here is the list of areas that I used parallel option for speedup the task,still working to use it in other areas too..

1. table/index creation paralell

CREATE INDEX <index_name>    ON <table_name>(col_name1) PARALLEL 35;


2.Rman
parallesism in oracle backup

configure device type disk parallelism 4;
configure device type sbt parallelism 4;


3.Data Guard MRP apply process

ALTER DATABASE RECOVER MANAGED database DISCONNECT FROM SESSION PARALLEL 5

4.data pump in paralell

expdp user=expdp_usr parallel=4 DUMPFILE=expdata%U.dmp
impdp parallel=4 DUMPFILE=expdata%U.dmp

5.stats collection use paralell

exec dbms_stats.gather_schema_stats( -
     ownname          => 'SCOTT', -
     estimate_percent => dbms_stats.auto_sample_size, -
     method_opt       => 'for all columns size repeat', -
     degree           => 25 ---->used to collect the stats in paralell
   )

No comments:

Post a Comment