Ask the Expert

Applications and database 100% used

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

    Requires Free Membership to View

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 first published in July 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: