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