Skip to Main Content
  • Questions

  • detecting De-supported and deprecated feature usage in Oracle database.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Michael.

Asked: August 25, 2022 - 11:45 pm UTC

Last updated: September 01, 2022 - 4:14 am UTC

Version: 19c

Viewed 10K+ times! This question is

You Asked

Have a customer database that has been upgraded through various databases releases… it currently is 19c. I have found some tablespaces are still dictionary managed tablespaces. This was deprecated in 8i.

Is there a oracle auditing option, or script or pre-existing tool (Auto Upgrade with analyze), that can be used to identify deprecated \ de-supported features?

With SQL Server I can create an extended event on sqlserver.deprecation_final_support, is there something similar for Oracle database products?

I have previously raised a SR with oracle, I was directed back to the database upgrade guide "10 Behavior Changes, Deprecated and De-supported Features for Oracle Database"

and Connor said...

I asked around internally, and the only mechanism we have is to examine the docs for each release, and then you check your instance.

Not ideal I know :-(


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Deprecated \ De-supported feature detection

Michael, September 01, 2022 - 12:12 am UTC

Connor

Thanks for the quick answer. I know its not ideal, it is what it is.

I will just delve through the manuals, and write a script of my own. It won't be complete, but it will be a fun learning exercise.

I am in the process of raising an enhancement request with Oracle, not expecting anything soon, but maybe a developer at Oracle will fix this in the future.

regards

Michael Lewis
Connor McDonald
September 01, 2022 - 4:14 am UTC

DBA_FEATURE_USAGE_STATISTICS might be of *some* use here, but its definitely not a full solution
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database