Home » RDBMS Server » Server Administration » How to find unused datafile size (Oracle 9i, Solaris)
How to find unused datafile size [message #436799] Mon, 28 December 2009 07:05 Go to next message
Messages: 4
Registered: August 2009
Junior Member

Hi All,
we have to reduce unused datafile size. Is there any query to find out unused datafile (individually) size ? Pls suggest me.

Re: How to find unused datafile size [message #436803 is a reply to message #436799] Mon, 28 December 2009 07:55 Go to previous message
Messages: 4759
Registered: February 2005
Location: East Coast USA
Senior Member
Not sure of the question here. An unused datafile can be shrunk down to 1Mb if you wish.
do a join of DBA_DATA_FILES and DBA_EXTENTS. This will show you if a datafile is in use.

One of those I think answers your question.
Previous Topic: STARTUP PFILE, CATAUDIT & Session ID....
Next Topic: rman instance crash and disapp
Goto Forum:

Current Time: Fri Jul 28 06:38:21 CDT 2017

Total time taken to generate the page: 0.06026 seconds