Top Queries in PL / SQL

[bizoca]

Hi!

Personal, I have access to some instances in Oracle Enterprise Manager (Graphic Tool) to check the Snapshots of Top Viles in processes that run during the day at the bank. But a problem appeared on an instance where I do not have access via grid, and I need to know what the queries are high to try to improve them.
I would like to know if there is possibility of doing this through command lines in PL / SQL and which I can use to verify what is causing delay in the jobs.

Thanks !!!

[bizoca]

So, to explain better, with the V $ session, I have the open sessions on the bank. I need a view that gives me the queries that has high consumption of resources. Anybody know?

[bizoca]

Nobody knows??

[dr_gori]

Topic Moved for DBA Forum!
(because it is a performance issues, etc.)

[gilbertoca]

So, to explain better, with the V $ session, I have the open sessions on the bank. I need a view that gives me the queries that has high consumption of resources. Does anyone know?

You can run the ADDM through PL / SQL.
Your starting point [url=http://download.oracle.com/docs/cd/B193 ... htm#i36662]Running ADDM using DBMS_ADVISOR APIs

Another way is to check the moment the problem occurs and from there, harvest / analyze the bank through a pre-script -Defined: [url=http://download.oracle.com/docs/cd/B193 ... #sthref333]Diagnosing Database Performance Issues with ADDM

Gilberto

[tapenatti]

I think this is:

Select all

select username usr, 
       a.disk_reads disco, 
       a.executions exec, 
       Round((a.disk_reads / decode(a.executions, 0, 1, a.executions)), 2) media, 
       a.Rows_Processed linhas,        
       a.sql_text sql 
  from v$sqlarea a, dba_users b 
 where a.parsing_user_id = b.user_id 
   and disk_reads >= 1000 
 order by 2 desc, 4 desc;

[bizoca]

it worked out! ; D Much a lot Thank you !!!