how to clear the sqltext from v$sqltext
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to clear the sqltext from v$sqltext

  1. #1
    Join Date
    Jun 2001
    Posts
    17

    Angry

    hi can any one please help me

    that how to clear the SQLTEXT from V$SQLTEXT.

    radha

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    alter system flush shared_pool but it doesnt empty everything ok?

  3. #3
    Join Date
    Jun 2001
    Posts
    17
    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...?
    radha

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!


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