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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation