How To Run DBV In Parallel On A Single Data File

How To Run DBV In Parallel On A Single Data File (文档 ID 369076.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.4 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***

GOAL

How to run DBV in parallel on a single data file?

SOLUTION

1. Identify the file# and name of the data file. 
 

connect / as sysdba
select * 
from   v$dbfile 
where  name like '%datafile_name%';

Or:

select * 
from   v$dbfile;

2.  Identify the number of blocks in the data file. 

2.1 Find Data Block Size 
 

connect / as sysdba
show parameter db_block_size 

NAME                                TYPE    VALUE 
----------------------------------- ------- ------ 
db_block_size integer                         8192

2.2 Calculate the the number of blocks. 
 

connect / as sysdba
select BYTES/<your block size> 
from   v$datafile 
where  FILE# = <your file number>; 

BYTES/8192 
---------- 
      5120

3. Determine how many parallel sessions has to be used. 

This example shows 3 parallel sessions. 

4) Start Parallel DBV sessions. 
 

$dbv FILE=filename START=1 END=2000 
$dbv FILE=filename START=2001 END=3500 
$dbv FILE=filename START=3501

(Note: END defaults to the last block of the file)