| help in AIX [message #357172] |
Tue, 04 November 2008 03:39  |
panyam
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
