QUESTION POSED ON: 24 July 2006
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
|
