Home » RDBMS Server » Server Administration » How to search sql text.
icon9.gif  How to search sql text. [message #188549] Sat, 19 August 2006 07:04 Go to next message
sonaliakolkar
Messages: 3
Registered: August 2006
Junior Member
Hi all,

Plese give me the solution how i can retuirev the sql using oracle. As front end is D2k form 6i.

through session i got the sql_address , and i found the sql from v$sqlarea . but that sql does not satiscy me.

As firing the sqltext i didnt get the same result as in d2k.

How i can chek the nested sql .

Report message to a moderator

Re: How to search sql text. [message #188623 is a reply to message #188549] Mon, 21 August 2006 01:09 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
What's wrong with the SQL statements listed in views like V_$SQL, V_$SQLAREA and V_$SQLTEXT_WITH_NEWLINES?

Report message to a moderator

Re: How to search sql text. [message #188624 is a reply to message #188623] Mon, 21 August 2006 01:14 Go to previous message
sonaliakolkar
Messages: 3
Registered: August 2006
Junior Member
thanks i will check the last option.

Report message to a moderator

Previous Topic: ORA-28100: policy function schema RMSDEV is invalid
Next Topic: shutdwon and startup along with system reboot
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:47:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.