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.

Report message to a moderator

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: 4963
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.

Report message to a moderator

Previous Topic: STARTUP PFILE, CATAUDIT & Session ID....
Next Topic: rman instance crash and disapp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 01:04:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.