Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: September 16, 2016 - 8:31 am UTC

Last updated: September 17, 2016 - 4:07 am UTC

Version: 11g

Viewed 1000+ times

You Asked

I'm junior DBA and i join an organization in last month.
we are using oracle 11g Standard Edition.
we does not have licence of performance tuning so I have a performance tab disable in EM Manager .

I want to find out Top SQL , Top Activity , Top Session using a query not EM Manage.
and which column of table help me to find out solution of my queries.


Regards
Prakash

and Connor said...

v$sqlstats is a good place to start

select sql_text, buffer_gets, executions, sql_id, elapsed_time
from v$sqlstats
where buffer_gets > 1000000
  or disk_reads > 100000
  or elapsed_time > 1000000
order by 2 desc



Pick some numbers so that you get a reasonable set of results and work from there.

Is this answer out of date? If it is, please let us know via a Comment