RE: how to find the most resource intensive sql?
- From: Srinivasan Vasan <Vasan.Srinivasan@xxxxxxxxxxxxx>
- To: 'zhu chao' <chao_ping@xxxxxxxxxxx>,"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 13:51:32 -0000
STATSPACK only answers the first part of the query, not the second.
-----Original Message-----
From: zhu chao [mailto:chao_ping@xxxxxxxxxxx]
Sent: 11 March 2004 13:48
To: oracle-l@xxxxxxxxxxxxx
Cc: Srinivasan Vasan
Subject: Re: how to find the most resource intensive sql?
Why so many complicated tools?
Isn't statspack enough for you?
Regards
Zhu Chao
----- Original Message -----
From: "Srinivasan Vasan" <Vasan.Srinivasan@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Cc: "Srinivasan Vasan" <Vasan.Srinivasan@xxxxxxxxxxxxx>
Sent: Thursday, March 11, 2004 9:22 PM
Subject: RE: how to find the most resource intensive sql?
> You are asking 2 questions - one in the subject and one in your user's
query
> - hope the following helps (use a variation on the first one to suit your
> needs):
>
> Answer to 1:
> select a.executions, a.disk_reads, a.disk_reads/a.executions dre,
> a.buffer_gets,
> a.buffer_gets/a.executions bge, b.username,
> a.first_load_time,a.sql_text
> from v$sql a, all_users b
> where a.executions > 0
> and a.parsing_user_id = b.user_id
> order by 1 desc;
>
> Answer to 2:
>
http://searchoracle.techtarget.com/tip/0,289483,sid41_gci935720,00.html?trac
> k=NL-93
>
> Cheers,
>
> Vasan (x5707)
> Mailpoint 28
> ============================================
> Vasan Srinivasan * 020 8313 5707
> Infrastructure Service Manager * 020 8313 5646
> Oracle Technologies
> Churchill Insurance, IT Department
> Purple Floor, Phase 1, Churchill Court
> 1 Westmoreland Road,
> Bromley, Kent, BR1 1DP.
> * Vasan.Srinivasan@xxxxxxxxxxxxx
> Mobile * 07710 154 987
> http://oratech
> ============================================
> Views Presented here are not necessarily the views
> of my Employer
> ============================================
>
>
> -----Original Message-----
> From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
> Sent: 11 March 2004 13:12
> To: oracle-l@xxxxxxxxxxxxx
> Subject: how to find the most resource intensive sql?
>
> assuming you can't use statspack? Is there a query for this? I was asked
the
> following and I'm not sure how to answer it:
>
> 'A user comes to you and says they get to a point in the application and
hit
> a button. It's slow. You do not have any access to the application. How do
> you find the problem query in the database'
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
___________________________________________________________________________
>
>
> This email and any attached to it are confidential and intended only for
the
> individual or entity to which it is addressed. If you are not the
intended
> recipient, please let us know by telephoning or emailing the sender. You
> should also delete the email and any attachment from your systems and
should
> not copy the email or any attachment or disclose their content to any
other
> person or entity. The views expressed here are not necessarily those of
> Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
you.
>
> Churchill Insurance Group plc. Company Registration Number - 2280426.
> England.
>
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> 1DP.
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
___________________________________________________________________________
This email and any attached to it are confidential and intended only for the
individual or entity to which it is addressed. If you are not the intended
recipient, please let us know by telephoning or emailing the sender. You
should also delete the email and any attachment from your systems and should
not copy the email or any attachment or disclose their content to any other
person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you.
Churchill Insurance Group plc. Company Registration Number - 2280426.
England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
