System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

lot of oracle processes running

SOLVED
Go to solution
Jayraj
Frequent Advisor

lot of oracle processes running

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
4 REPLIES
Suraj K Sankari
Honored Contributor

Re: lot of oracle processes running

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
Honored Contributor
Solution

Re: lot of oracle processes running


>> 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
Exalted Contributor

Re: lot of oracle processes running

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Maxim Yakimenko
Super Advisor

Re: lot of oracle processes running

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