269.632009933
9 6400 /u02/oradata/xport_dw.dbf
10 3200 +DATA/dw/datafile/dmarts.271.633226419
10 rows selected.
In the next example, you will see how to analyze datafile #9, the datafile for another bigfile
tablespace in our database, XPORT_DW. At the operating system command prompt, you can
analyze the file with five parallel processes, each processing 500 blocks, except for the last one:
Chapter 16: Managing Large Databases 551
$ dbv file=/u02/oradata/xport_dw.dbf start=1 end=1500 &
[1] 6444
$ dbv file=/u02/oradata/xport_dw.dbf start=1501 end=3000 &
[2] 6457
$ dbv file=/u02/oradata/xport_dw.dbf start=3001 end=4500 &
[2] 6466
$ dbv file=/u02/oradata/xport_dw.dbf start=4501 end=6000 &
[2] 6469
$ dbv file=/u02/oradata/xport_dw.dbf start=6001 &
[5] 6499
In the fifth command, we did not specify end=; if you do not specify end=, it is assumed that
you will be analyzing the datafile from the starting point to the end of the file. All five of these
commands run in parallel. The output from these commands looks similar to the following:
DBVERIFY: Release 11.1.0.6.0 -
Production on Sat Sep 15 15:15:42 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = /u02/oradata/xport_dw.dbf
DBVERIFY - Verification complete
Total Pages Examined : 1500
Total Pages Processed (Data) : 1476
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 24
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Total Pages Encrypted : 0
Highest block SCN : 4464912 (0.
Pages:
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824