how to clear the sqltext from v$sqltext

hi can any one please help me

that how to clear the SQLTEXT from V$SQLTEXT.

alter system flush shared_pool but it doesnt empty everything ok?

thank you very much pondo realy it works & it clears upto 80%.

Ohhh realy pentastic... thank you for the help..


i have one more dought if i flush every day then it makes any performance issue...?

OH YES!, performance degradation!!!!, When the same statement need to be executed again it need to be refected from the disk, passed and executed. This is an expensive operation. You would want to have the mostly executed statements in the cache. That way you have a good cache hit. If you flush, then you would end up with a low cache hits.

May I know why would you want to flush the sqltexts?

Sam