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: 58
Registered: October 2018
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: 58
Registered: October 2018
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: 13759
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: Select query too slow
Goto Forum:
  


Current Time: Mon Dec 16 01:07:11 CST 2019