You do not need cost of any query until the results are unacceptable. Fix things only when they break (My policy in tuning atleast). So, you know whats performing in unacceptable limits when people complain, take it from there and try tuning that component/query using oracle native tools like TKPROF, STATSPACK or other 3rd party tools.