Home » RDBMS Server » Server Administration » Database is expanding very fast(Space Utilization)
Database is expanding very fast(Space Utilization) [message #224526] Wed, 14 March 2007 09:42 Go to next message
parvinder.infogen
Messages: 10
Registered: February 2007
Location: New Delhi
Junior Member

I have two schema each of around 1500 large tables,
on a HDD of 48 GB,
Even though not much new rows are added each day, but space on HDD is reducing very fast.

I have checked that few tables had given high next_extents etc,
and reduce them by re-building them

but still I am not able to recover space,
It was also observed that temp tablespace has taken around 20GB,

Can somebody help me to resolve this as I am novice to server administration
Re: Database is expanding very fast(Space Utilization) [message #224527 is a reply to message #224526] Wed, 14 March 2007 09:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Even though not much new rows are added each day, but space on HDD is reducing very fast.
I suppose you mean, FREE space.
I would check whether AUTOEXTEND ON is enabled for datafiles (and tempfiles and undotablespace).
If enabled for tempfiles/undo, disable it.
Also have a look at $ORACLE_BASE where the tracefiles/logfiles are typically generated.

[Updated on: Wed, 14 March 2007 09:47]

Report message to a moderator

Re: Database is expanding very fast(Space Utilization) [message #224528 is a reply to message #224526] Wed, 14 March 2007 09:47 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Are you check which datafiles increase frequently...

about temp tablespace no need to worry first create new temp tablespace with low size and drop old temp tablespace.

regards
Taj
Re: Database is expanding very fast(Space Utilization) [message #224612 is a reply to message #224528] Wed, 14 March 2007 14:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hi Taj,

I have manually increasing datafile size instead of we can use AUTOEXTEND ON.

Which one is best ??

Babu
Re: Database is expanding very fast(Space Utilization) [message #224615 is a reply to message #224612] Wed, 14 March 2007 14:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There no best/worst in this case. It DEPENDS.
Search before posting.
The immediate thread next to this talks about it
http://www.orafaq.com/forum/t/78409/42800/
Re: Database is expanding very fast(Space Utilization) [message #224650 is a reply to message #224612] Wed, 14 March 2007 23:16 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
There no best/worst in this case. It DEPENDS
I am agree with "Mahesh" comments.


regards
Taj
Previous Topic: Autoextend Yes/No
Next Topic: Looking for good place to discuss TOAD
Goto Forum:
  


Current Time: Mon Dec 09 20:18:39 CST 2024