Q

Applications and database 100% used

The mounting points where there are applications and database are 100% used. The system doesn't raise any warning yet but I think that it is nearly exploding. This is a machine still deployed in production, and there is no more space to extend partitions on the HDU.

Hi, I'm a beginner who has to solve an inherited trouble on a Suse-Linux machine with Oracle Database 10g. The problem is that the mounting points where there are applications and database are 100% used. The system doesn't raise any warning yet but I think that it is nearly exploding. This is a machine still deployed in production, and there is no more space to extend partitions on the HDU. After some googling I realized that maybe the problem is due to the temporary space used for long queries (that I can't analize now). How can I solve this problem? Thanks.

Tablespace situation from Oracle Enterprise Manager:

         Size(MB) Used(MB)  Used(%)  Free(MB) Datafile Type      Ext. 
mgmt  Seg. mgmt
SYSAUX   630.0    578.0     91.7     52.0     1        PERMANENT LOCAL
AUTO
SYSTEM   490.0    490.0     100.0    0.0      1        PERMANENT LOCAL
MANUAL
TEMP     9,109.0  0.0       0.0      9, 109.0  1        TEMPORARY LOCAL
MANUAL
UNDOTBS1 9,005.0  7.1       0.1      8,997.9  1        UNDO      LOCAL
MANUAL
USERS    10,632.5 7,457.7   70.1     3,174.8  1        PERMANENT LOCAL
AUTO

Result of command: df

Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/hda5             12385072   1840760   9915148  16% /
tmpfs                  1555792         4   1555788   1% /dev/shm 
/dev/hda1                99521      6758     87624   8% /boot
/dev/hda6             16513448  15675464         0 100% /opt
/dev/hda7             12384872   1343932  10411824  12% /var
/dev/hda4             32441328  30792896       504 100% /opt/mydb/db 

Result of command: fdisk -l

Disk /dev/hda: 80.0 GB, 80026361856 bytes
16 heads, 63 sectors/track, 155061 cylinders
Units = cylinders of 1008 * 512 = 516096 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/hda1   *           1         204      102784+  83  Linux
/dev/hda2             205        6446     3145968   82  Linux swap
/dev/hda3            6447       89667    41943384    f  W95 Ext'd (LBA) 
/dev/hda4           89668      155061    32958576   83  Linux
/dev/hda5            6447       31413    12583336+  83  Linux
/dev/hda6           31414       64702    16777624+  83  Linux
/dev/hda7           64703       89667    12582328+  83  Linux 

Result of command: find . -size +1000000 -print -exec ls -la {} ;

./opt/mydb/db/oradata/mydb/system01.dbf
-rw-r-----  1 oracle oinstall 513810432 Jun 15 17:30 
./opt/mydb/db/oradata/mydb/system01.dbf
./opt/mydb/db/oradata/mydb/sysaux01.dbf
-rw-r-----  1 oracle oinstall 660611072 Jun 15 17:30
./opt/mydb/db/oradata/mydb/sysaux01.dbf
./opt/mydb/db/oradata/mydb/undotbs01.dbf 
-rw-r-----  1 oracle oinstall 9442435072 Jun 15 17:30
./opt/mydb/db/oradata/mydb/undotbs01.dbf
./opt/mydb/db/oradata/mydb/users01.dbf
-rw-r-----  1 oracle oinstall 11148992512 Jun 15 17:30
./opt/mydb/db/oradata/mydb/users01.dbf 
./opt/mydb/db/oradata/mydb/temp01.dbf
-rw-r-----  1 oracle oinstall 9551486976 Jun 15 16:50
./opt/mydb/db/oradata/mydb/temp01.dbf
The fact that your disk volumes are at or near capacity should not have a major effect on Oracle performance. If any tablespace (including TEMP) needs more space and such space is not available, you will see an error. If you are experiencing a specific performance problem, please post the details.
This was last published in July 2006

Dig Deeper on Oracle database performance problems and tuning

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close