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)