Home » Infrastructure » Unix » help in AIX
help in AIX [message #357172] Tue, 04 November 2008 03:39 Go to next message
Messages: 146
Registered: May 2008
Senior Member

Hi all,

How can i find in AIX "The processes of top 10 %CPU used in that interval. The process id, the parent process id, full path command name, the start time, %CPU used, real memory used, virtual memory used. If the command is oracle, the sql of the oracle session is needed"

Thanks in advance
Re: help in AIX [message #357195 is a reply to message #357172] Tue, 04 November 2008 04:44 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you have the OS process id, the SQL statement is given joining v$process, v$session and v$sql.
Have a look at them in Reference manual.
The rest of the post is NOT Oracle related, so post it in a Unix forum.

Previous Topic: Connected to an idle instance
Next Topic: unix shell script to execute procedure with passing parameters
Goto Forum:

Current Time: Sun May 26 13:33:58 CDT 2024