Thanks for the question, VINOD.
Asked: August 11, 2018 - 6:08 am UTC
Last updated: August 18, 2018 - 4:13 am UTC
Version: 12c
Viewed 1000+ times
You Asked
Hi Tom
I have a question regarding DBMS_SQLTUNE_UTIL0 package.
This seems to be helper package. Is it okay to use this
package directly in code or use of such internal packages
should be avoided? I did not find any documentation on this
package in Oracle Documentation.
Regards
Vinod
and Connor said...
Put simply - if its not documented, ideally you should not use it.
Because otherwise it is entirely you taking on the risk.
I can give you a relevant example here. In some versions of Oracle, the very nice routine in that package:
dbms_sqltune_util0.sqltext_to_sqlid
is broken, ie, it returns the *wrong* sqlid.
So if you were using it, then you'd be getting incorrect data and there's not much you can do about it, because it is an internal routine that was not documented anyway.
So extreme caution is the best policy here. If you are happy to accept the risks, then that's your call.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment