Linux is running on IBM Blade server & oracle 11gR1 is running .. when I run "Top" at shell it shows approx 95% of CPU is being used by oracle user.
When I see at COMMAND it shows oracle
I mean that >> User > Oracle is using almost 100% by COMMAND oracle.
I am confused.
How can I find that what oracle is using ??
You can press the letter 'c' in top to toggle between "command line" and "program name".
A CPU usage of 99 % is not necessarily a problem. If a system has resources available it would be foolish not to allocate all available resources to a process that demands it. If the general system response is slow, you have a problem with a bad process or hardware error that prevents proper resource allocation, or your system does not have the appropriate hardware or configuration to efficiently handle the requested tasks.
If you want to know what an oracle user or Oracle Database is doing, you need to check this from within the Oracle database.