Home » RDBMS Server » Performance Tuning » Regarding sql id (11.2.0.4)
Regarding sql id [message #621819] Mon, 18 August 2014 11:35 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,
Application users did a test on datbase on 08/15.
Now the want me to generate awrsqrpt report for a certain query.
But i dont have sql_id and they dont have the query either.
In this scenerio what data should i ask them so that i could get sql_id
from v$sql or by combining v$session and v$sql.

Thanks,
Varun
Re: Regarding sql id [message #621820 is a reply to message #621819] Mon, 18 August 2014 11:40 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
On high level, an application user told you regarding poor performance of a screen/functionality. So, you could still dig in the DB objects responsible for the business logic of it. Once you get to know the DB object, you could make use of it to see the recent entries in the dynamic views.
Re: Regarding sql id [message #621825 is a reply to message #621819] Mon, 18 August 2014 12:48 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
But i dont have sql_id and they dont have the query either.


If you have not the query what you want to awrsqrpt on?
I want to paint my house but I have no house...

[Updated on: Mon, 18 August 2014 12:50]

Report message to a moderator

Re: Regarding sql id [message #621826 is a reply to message #621825] Mon, 18 August 2014 14:05 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Exactly Michal,
This is what i try to explain appication users.
I told them to replicate the issue.So once they run
the search functionality again,could you tell me what
can i ask for see the sql_id for their functionality.

Thanks,

Varun

[Updated on: Mon, 18 August 2014 14:08]

Report message to a moderator

Re: Regarding sql id [message #621828 is a reply to message #621826] Mon, 18 August 2014 14:20 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What problem are you trying to solve?

Re: Regarding sql id [message #621961 is a reply to message #621828] Wed, 20 August 2014 02:46 Go to previous message
cookiemonster
Messages: 13014
Registered: September 2008
Location: Rainy Manchester
Senior Member
If there's a particular process that's running slow then generally the best starting point is to trace the session.
Previous Topic: oracle performance metrics
Next Topic: explain plan details vary between display & display_cursor
Goto Forum:
  


Current Time: Thu Feb 22 00:01:06 CST 2018

Total time taken to generate the page: 0.02517 seconds