Home » RDBMS Server » Server Administration » table space problem.Increasing rapidly (Oracle9i,windows2003 server)
table space problem.Increasing rapidly [message #356687] Sat, 01 November 2008 01:08 Go to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

Hi all,
My two .DBF file increase rapidly.I don't know why.
1.system01.dbf=20 GB (approx)
2.temp01=16.7 GB (approx)
Where as i don't have that much data.My dmp file was 8.1 GB.
After import from dump file there was no more trunsaction happend here.so why its occupied that much space.
Pls help me.

Regards
NadiaHq

[Updated on: Sat, 01 November 2008 02:43]

Report message to a moderator

Re: table space problem.Increasing rapidly [message #356724 is a reply to message #356687] Sat, 01 November 2008 07:35 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Hi,

Well, system is used for Oracle's data dictionary and temp is basically sort space. Pity you've imported your data into system, as a result there is no way you can see how much your data contributes to the total space.

Anyway, data within the database always takes up more space as Oracle spreads it out for better performance. Also remember that the dump file doesn't contain indexes and materialized views, which can take up significant volumes of space as well.

Best regards.

Frank
Re: table space problem.Increasing rapidly [message #356775 is a reply to message #356724] Sun, 02 November 2008 05:46 Go to previous messageGo to next message
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
Junior Member

hi all,
can u specify me is there any service of oracle is on for that lot of space need.because yesterday to till now 2 GB occupied.
Now its showing lok disk space.
So pls help me.
Regards
Nad
Re: table space problem.Increasing rapidly [message #356859 is a reply to message #356775] Sun, 02 November 2008 22:08 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Why did you not recreate Tempfile? And what is your Release DB? Why did you need to import SYSTEM tablespace?
Previous Topic: Help upgrading database
Next Topic: Script Perl consuming very much
Goto Forum:
  


Current Time: Sun Dec 04 02:37:04 CST 2016

Total time taken to generate the page: 0.26574 seconds