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 .

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: 4502
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?
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.

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


Current Time: Mon Dec 05 11:15:19 CST 2016

Total time taken to generate the page: 0.09206 seconds