I came across these pretty cool utilities that give lots of good information about the Oracle datafiles.
Here we pass the foo5.dbf file created in the earlier post to the dbv utility.
Below we pass the foo5.dbf datafile to the dbfsize utility
It tells us the data file is on a file system. And more importantly that it's size is 393216 x 8k blocks which is around 3GB, which is the size of the datafile that we added to the tablespace in the earlier post.
Here we pass the foo5.dbf file created in the earlier post to the dbv utility.
-bash-3.2$ dbv FILE=foo5.dbf DBVERIFY: Release 11.2.0.1.0 - Production on Thu Jan 12 16:12:10 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. DBVERIFY - Verification starting : FILE = /oracle/ORCLTBLSP/datafile/foo5.dbf DBVERIFY - Verification complete Total Pages Examined : 393216 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 127 Total Pages Processed (Seg) : 0 Total Pages Failing (Seg) : 0 Total Pages Empty : 393089 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Total Pages Encrypted : 0 Highest block SCN : 1004562 (0.1004562) |
Below we pass the foo5.dbf datafile to the dbfsize utility
-bash-3.2$ dbfsize foo5.dbf Database file: foo5.dbf Database file type: file system Database file size: 393216 8192 byte blocks -bash-3.2$ |
It tells us the data file is on a file system. And more importantly that it's size is 393216 x 8k blocks which is around 3GB, which is the size of the datafile that we added to the tablespace in the earlier post.
No comments:
Post a Comment