Flushing your shared pool will do it.

alter system flush shared_pool;

-----Original Message-----
From: Ron Krockett [mailto:[Email Address Removed]
Sent: Friday, January 31, 2003 1:29 PM
To: LazyDBA.com Discussion
Subject: how to delete Rows in v$SQLTEXT View ?


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






_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page