Home » RDBMS Server » Server Administration » oracle 8i: full sql text in v$sqlarea
oracle 8i: full sql text in v$sqlarea [message #282574] Thu, 22 November 2007 07:05 Go to next message
maga
Messages: 17
Registered: November 2007
Junior Member
In use an oracle 8i.
is there a v$... that shows the execution plan for a query.

in thev$sqlarea there isn't the full_sqltext column, and I need to know what oracle is doing now.
Re: oracle 8i: full sql text in v$sqlarea [message #282576 is a reply to message #282574] Thu, 22 November 2007 07:12 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

is there a v$... that shows the execution plan for a query.
You can use "set autotrace trace exp" option.
http://asktom.oracle.com/tkyte/article1/autotrace.html

in thev$sqlarea there isn't the full_sqltext column, and I need to know what oracle is doing now.
you can use "sql_text" column...
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch3156.htm#15879
Re: oracle 8i: full sql text in v$sqlarea [message #282579 is a reply to message #282574] Thu, 22 November 2007 07:19 Go to previous messageGo to next message
maga
Messages: 17
Registered: November 2007
Junior Member
I know the v$sqlarea view but it shows only a part of the sqltext.

I can't trace every session.
I need to see what appens in the library cache.
Re: oracle 8i: full sql text in v$sqlarea [message #282580 is a reply to message #282579] Thu, 22 November 2007 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I need to see what appens in the library cache.

What do you mean?

There is no view giving the execution plan in 8i.

Regards
Michel
Re: oracle 8i: full sql text in v$sqlarea [message #282582 is a reply to message #282574] Thu, 22 November 2007 07:24 Go to previous messageGo to next message
maga
Messages: 17
Registered: November 2007
Junior Member
I need the full sql text in the library cache.
but I can't put session under trace
Re: oracle 8i: full sql text in v$sqlarea [message #282584 is a reply to message #282582] Thu, 22 November 2007 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sqltext

Regards
Michel
Re: oracle 8i: full sql text in v$sqlarea [message #282591 is a reply to message #282582] Thu, 22 November 2007 07:45 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

http://forums.oracle.com/forums/thread.jspa?threadID=588852&tstart=0

I hope you got your answer Smile
Previous Topic: Problem upgrading the database from 9i to 10g
Next Topic: Reuse of Space in 9.2.0.1.0
Goto Forum:
  


Current Time: Fri Dec 02 16:27:58 CST 2016

Total time taken to generate the page: 0.31032 seconds