| RE: Storage Problem [message #224144] |
Tue, 13 March 2007 04:20  |
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 #224347 is a reply to message #224189] |
Wed, 14 March 2007 01:00  |
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 #224446 is a reply to message #224347] |
Wed, 14 March 2007 05:36 |
 |
Mahesh Rajendran
Messages: 10707
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
