| Growing Oracle filling-up Linux partitions [message #177587] |
Thu, 15 June 2006 11:29 |
nysalsa
Messages: 1
Registered: June 2006
Location: Italy
|
Junior Member |
|
|
Hi, anybody that can help a beginner solving an inherited trouble on a Suse-linux machine with Oracle db
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 is nearly exploding. Ah, this is a machine still
deployed in production, and... no more space to extend partitions on the hdu.
After some google-ing 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 do for solving this trouble ? Follow some useful data (I hope).
Thanks
Bob
Tablespaces situation from Oracle Ent. 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
DB Oracle Database 10g 10.2.0.1.0
---------------------------------
Enterprise Edition Options 10.2.0.1.0
Installation Common Files 10.2.0.1.0
iSQL*Plus 10.2.0.1.0
Oracle Call Interface (OCI) 10.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Oracle Enterprise Manager Console DB 10.2.0.1.0
Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0
Oracle Net Services 10.2.0.1.0
Oracle ODBC Driver 10.2.0.1.0
Oracle One-Off Patch Installer 10.2.0.1.0
Oracle Programmer 10.2.0.1.0
Oracle Universal Installer 10.2.0.1.0
Oracle XML Development Kit 10.2.0.1.0
O.S.: SUSE LINUX Enterprise Server 9 (i586) 2.6.5 7.191 (32-bit)
HW details
----------
Hostname mydb-db1.oops.info (mydb-db1)
System Configuration i686
Machine Architecture GenuineIntel i686
Hardware Provider Intel Based Hardware
Memory Size (MB) 3038.66015625
Local Disk Capacity (GB) 70.404
Clock Frequency (MHz) 100
Number of CPUs 2 (Xeon(TM) CPU 3.06GHz)
Number of CPU boards 2
Number of IO devices 7
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
