DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ca i delete all rows in v$SQLTEXT ?

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    ca i delete all rows in v$SQLTEXT ?

    Hello all..
    Oracle 9.2
    can we drop all the rows in v$SQLTEXT view ?....i want to see what SQL statements are stored in there as i key in ?...

    Thanks
    Ron

  2. #2
    Join Date
    Jan 2002
    Posts
    113
    bounce the database
    Arm yourself with knowledge

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter system flush shared_pool;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width