table space problem.Increasing rapidly [message #356687] |
Sat, 01 November 2008 01:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nadiahq
Messages: 16 Registered: March 2008 Location: KSA
|
Junior Member |
![ahoque2000](/forum/theme/orafaq/images/yahoo.png)
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Frank Naude
Messages: 4580 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
|
|
|
|
|