Thanks Michael. dba_views does not have definition of fixed views. ------------------------------------ select * from dba_views WHERE VIEW_NAME IN ( 'GV$SESSTAT', 'GV$SESSION') ------------------------------------ no rows selected Paresh On Fri, Apr 15, 2011 at 1:42 PM, Michael Dinh <mdinh@xxxxxxxxx> wrote: > What about using text from dba_views? > > > > select * from dba_views where text_length>4000 > > > > Michael Dinh > > > > NOTICE OF CONFIDENTIALITY - This material is intended for the use of the > individual or entity to which it is addressed, and may contain information > that is privileged, confidential and exempt from disclosure under applicable > laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH > INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, > AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI > CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT > NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS > MESSAGE. If the reader of this email (and attachments) is not the intended > recipient, you are hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. Please notify the > sender of the error and delete the e-mail you received. Thank you. > > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Paresh Yadav > *Sent:* Friday, April 15, 2011 10:26 AM > *To:* oracle-l@xxxxxxxxxxxxx > *Subject:* Complete (more than 4000 char) text of fixed view definition? > > > > Hi, > > > > How can I get complete (more than 4000 char) text of fixed view definition? > > SQL> desc v$fixed_view_definition > > > > Name Null? Type > > ----------------------------------------- -------- ----------------------- > > > > VIEW_NAME VARCHAR2(30) > > VIEW_DEFINITION *VARCHAR2(4000)* > > > -- > Thanks > Paresh > > -- Thanks Paresh 416-688-1003