thanks for your earlier responses!
in this post i would take up couple of performance related issues. these are regarding the high "parse to execute ratio" and high "cpu parse overhead". i am gtting a parse to execute ratio of 38 and "cpu parse overhead" is 22. i am getting all these statistics from TOAD.Pls mention what to interpret from these values and how to rectify them.
thanks once again.