OraFAQ Forum: Server Administration » oracle 8i: full sql text in v$sqlarea

Home » RDBMS Server » Server Administration » oracle 8i: full sql text in v$sqlarea

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 8i: full sql text in v$sqlarea [message #282574]

Thu, 22 November 2007 07:05

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.

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282576 is a reply to message #282574]

Thu, 22 November 2007 07:12

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

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282579 is a reply to message #282574]

Thu, 22 November 2007 07:19

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.

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282580 is a reply to message #282579]

Thu, 22 November 2007 07:20

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282582 is a reply to message #282574]

Thu, 22 November 2007 07:24

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

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282584 is a reply to message #282582]

Thu, 22 November 2007 07:29

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

v$sqltext

Regards
Michel

Report message to a moderator

Re: oracle 8i: full sql text in v$sqlarea [message #282591 is a reply to message #282582]

Thu, 22 November 2007 07:45

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

Report message to a moderator

Previous Topic:	Problem upgrading the database from 9i to 10g
Next Topic:	Reuse of Space in 9.2.0.1.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:50:48 CST 2024