Home » SQL & PL/SQL » SQL & PL/SQL » sql_id (Oracle Database Server 10g )
sql_id [message #388911] Thu, 26 February 2009 10:57 Go to next message
averion
Messages: 42
Registered: January 2009
Location: US
Member
Experts,

How to find out which SQL_ID is from which procedures/fuctions.
Thanks,

Report message to a moderator

Re: sql_id [message #388912 is a reply to message #388911] Thu, 26 February 2009 11:00 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Sql_ID is associated with a sql statement and not tied with any procedure or function. As far as I know only way to trace it back is find the sql statement and check for the sql statement in user_source.

Regards

Raj

Report message to a moderator

Re: sql_id [message #388915 is a reply to message #388912] Thu, 26 February 2009 11:20 Go to previous messageGo to next message
averion
Messages: 42
Registered: January 2009
Location: US
Member
Thanks Raj,

But I need to modify certain queries in procedure/function/packages and all I have is the SQL_ID and the statements.

How can I find out which pl/sql statements is in which procedure/function/package.

Regards,

Report message to a moderator

Re: sql_id [message #388921 is a reply to message #388915] Thu, 26 February 2009 11:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If they are static SQL, use "grep" on the source.
If they are dynamic SQL, you can't. Ask the developers.

Regards
Michel

Report message to a moderator

Re: sql_id [message #388923 is a reply to message #388911] Thu, 26 February 2009 11:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>all I have is the SQL_ID and the statements.
How were these SQL_IDs obtained & by who?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Report message to a moderator

Re: sql_id [message #388967 is a reply to message #388923] Thu, 26 February 2009 16:54 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
on 10g program_id and program_line# in v$sql if the necessary sql is in cache. Otherwise just search user/all/dba_source if it from stored program units.

Report message to a moderator

Previous Topic: populate sequence
Next Topic: Where vs join (faster query )
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 18:25:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.