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
skm_karthik
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
joy_division
Messages: 4618
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 Sep 30 19:18:06 CDT 2016

Total time taken to generate the page: 0.27463 seconds