Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Grabbing SQL statements from memory

Grabbing SQL statements from memory

From: Nexus Product Centre <clarkej_at_logiica.com>
Date: 19 Aug 1998 08:30:00 GMT
Message-ID: <01bdcb4b$8d076620$bf12ea9e@UKP014921.logica.co.uk> 





Hi guys and gals,



Can anyone help me with the following problem??



I have an Oracle 7.3.2.x database and need to track some SQL statements
that are causing a problem.



I can identify the problem user's sid and serial# from v$session and can
join to v$open_cursor to get the sql_text.



Unfortunately this is defined as VARCHAR2(60) so I get a truncated SQL
statement.



How can I retrieve the full statement???



TIA


Jon
Received on Wed Aug 19 1998 - 03:30:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US