Home » RDBMS Server » Performance Tuning » SESSION CPU (AIX 10G)
SESSION CPU [message #358288] Mon, 10 November 2008 09:54 Go to next message
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
Re: SESSION CPU [message #358291 is a reply to message #358288] Mon, 10 November 2008 10:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Join top, v$process and v$session.

Regards
Michel
Re: SESSION CPU [message #358293 is a reply to message #358291] Mon, 10 November 2008 10:11 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member

can u send me syntax?
thanks
Re: SESSION CPU [message #358306 is a reply to message #358293] Mon, 10 November 2008 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SESSION CPU [message #358307 is a reply to message #358306] Mon, 10 November 2008 11:21 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
sorry but i need oracle script
didnt system.
thanks
Re: SESSION CPU [message #358310 is a reply to message #358307] Mon, 10 November 2008 11:27 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Query Tuning
Next Topic: gets,pins and reloads in v$library Cache
Goto Forum:
  


Current Time: Thu Dec 08 08:16:55 CST 2016

Total time taken to generate the page: 0.11139 seconds