lot of oracle processes running

[Jayraj]

Hi all, Oracle processses comsuming 100% of cpu usage.. because of these /u01 is 100% filled up..I have moved someof the tar files out of the /u01 which are around 2 gb again /u01 is filled up..
how to deal with this issue

[Suraj K Sankari]

Hi,

Better ask DBA team to take care or ask them to restart the db or kill old instance which are not in used any more.

Suraj

[Hein van den Heuvel · Accepted solution]

>> Hi all, Oracle processses comsuming 100% of cpu usage.. because of these /u01 is 100% filled up.

It is possibly the other way around.

/u01 is filled up and the oracle processes are banging their heads against the wall trying to grab more space.

So what it typically located on /u01 and what might be filling it?

Oracle TRACE files or Alert logs ?
(Oracle udump and/or bdump directories?)
Oracle TEMP table spaces?

Use "du -s" to find which directories are big and growing when room is freed up.

Use find to look for recently modified files of significant size.

And, most importantly, as suggested before WORK TOGETHER WITH THE DBA, attacking this problem as a team.

Regards,
Hein.

[Steven E. Protter]

Shalom,

By itself 100% usage is not a problem. Systems are designed to be used.

However in this case I think your oracle instances are backed up waiting for access to /u01

You might want to tell us whats being written there. Archive logs, redo logs what not.

Expanding that file system may be in order.

SEP

[Maxim Yakimenko]

SEP, before extending it is better to determine what is /u01 :)

if this FS is archive logs store they must be archived and deleted

but I have suspiction that this FS is Ora home, and processes constanlty throw trace files to it