Home » RDBMS Server » Performance Tuning » Top SQL and Top sessions (Oracle 11g,Oracle 12c, Linux)
Top SQL and Top sessions [message #678167] Thu, 14 November 2019 04:25 Go to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Hi,

Can somebody explain the difference between top sql and top sessions.

Regards,
Balaji
Top SQL and Top sessions [message #678169 is a reply to message #678167] Thu, 14 November 2019 05:32 Go to previous messageGo to next message
BalajiDBA
Messages: 139
Registered: October 2018
Location: India
Senior Member
Hi,

Can somebody explain the difference between top sql and top sessions.

Regards,
Balaji
Re: Top SQL and Top sessions [message #678176 is a reply to message #678169] Thu, 14 November 2019 07:55 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Sessions are sessions and SQL are SQL.
I've never come across the concept of top sessions.
Top SQL in say statspack is SQL ranked by a certain criteria. That criteria is generally mentioned at the start of the list.

If you had a list of top sessions then it would have to be top according to some criteria. Did you have any particular criteria in mind?
Previous Topic: Solution for database hung
Next Topic: Database performance tuning (merged)
Goto Forum:
  


Current Time: Thu Mar 28 17:52:06 CDT 2024