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

Dig deeper on Oracle database performance problems and tuning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close