Home » RDBMS Server » Server Administration » RE: Storage Problem
RE: Storage Problem [message #224144] Tue, 13 March 2007 04:20 Go to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

today i ran a sql statement to create a table and that took ages to complete so i had to use the task manager to end it.then i again logged in the database and found that the storage was 99 percent full.although jst 5-6 tables with very less data in those.if i remember right i had hardly used an storge may b around 2 percent.i followed the instructions in the doc.to compact the storage.but even that did not help.

i m total new to this.so can someone please suggest on this.


Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product 
PL/SQL Release 10.2.0.1.0 - Production 
CORE 10.2.0.1.0 Production 
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production 
NLSRTL Version 10.2.0.1.0 - Production 
Re: RE: Storage Problem [message #224189 is a reply to message #224144] Tue, 13 March 2007 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not sure i understand your situation.
In 10g, you can directly shrink the tables if you have enabled the row movement.
Try it and post the results.
Re: RE: Storage Problem [message #224347 is a reply to message #224189] Wed, 14 March 2007 01:00 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


thanx Mahesh for your reply.let me try to explain it again.i ran a sql statement to create a table.but the statement took a lot of time to execute or it freezed.so i had to use windows task manager to end the task.so i again logged on to the database.but what i noticed is that storage was 99% full.whereas i have hardly 5-6 table and no table has more than 100 records.so i followed the instruction to compact the storage but even that didnt help much.one thing which i would include is that the table was not created at all may be because i ended the task using task manager.i faced this problem after i ran the create table statement.it was just a simple create statement.hope i was able to clearly explain my problem.




Quote:
I am using 10g express edition.I just use it for practice purpose.so it provides a limited storage 4 gb.



regards,
Re: RE: Storage Problem [message #224354 is a reply to message #224347] Wed, 14 March 2007 01:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
it provides a limited storage 4 gb.

Yes, it is limitation.

http://forums.oracle.com/forums/thread.jspa?messageID=1674185&#1674185

regards
Taj
Re: RE: Storage Problem [message #224398 is a reply to message #224354] Wed, 14 March 2007 02:57 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

thanx Taj for that link.i will really go through the link provided.


regards,
Re: RE: Storage Problem [message #224446 is a reply to message #224347] Wed, 14 March 2007 05:36 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I understand it is express edition and i also aware that it will impose a 4gb limit.
Question is why would a few tables cause such a spike?
I assume you did not ive a specific storage parameters for the table.
So the possibilites are
the tablespace are defined with huge extents
or
The database was already running out space

[Updated on: Wed, 14 March 2007 05:37]

Report message to a moderator

Previous Topic: List Partition-8i
Next Topic: 2GB datafile
Goto Forum:
  


Current Time: Mon Dec 05 13:09:31 CST 2016

Total time taken to generate the page: 0.10420 seconds