OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » SESSION CPU (AIX 10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SESSION CPU [message #358288]

Mon, 10 November 2008 09:54

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

hello

i need please scripts that say to me

what run in my db and how much CPU?

thanks

Report message to a moderator

Re: SESSION CPU [message #358291 is a reply to message #358288]

Mon, 10 November 2008 10:07

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Join top, v$process and v$session.

Regards
Michel

Report message to a moderator

Re: SESSION CPU [message #358293 is a reply to message #358291]

Mon, 10 November 2008 10:11

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

can u send me syntax?
thanks

Report message to a moderator

Re: SESSION CPU [message #358306 is a reply to message #358293]

Mon, 10 November 2008 11:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, because I have to work on it and I have not AIX and I think you can do it yourself on ksh (or whatever is your shell) with a little bit of work.

Regards
Michel

Report message to a moderator

Re: SESSION CPU [message #358307 is a reply to message #358306]

Mon, 10 November 2008 11:21

lioracle
Messages: 68
Registered: February 2008
Location: Israel

Member

sorry but i need oracle script
didnt system.
thanks

Report message to a moderator

Re: SESSION CPU [message #358310 is a reply to message #358307]

Mon, 10 November 2008 11:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In this case you can't have actual CPU values just what Oracle knows.
Query v$sesstat to get 'CPU used by this session' statistics.

Regards
Michel

Report message to a moderator

Previous Topic:	Query Tuning
Next Topic:	gets,pins and reloads in v$library Cache

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 02:49:48 CST 2024