Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find database options features used?

485263Jun 16 2006 — edited Aug 13 2007

Hello Oracle Gurus,
Can someone please tell me how can I find whether a database features is used in the database? e.g. I have a installation with partitioning, label security , etc installed but not sure which of these features is used.

I could query dba_tab_partitions, for example, to find if there are any partitioned tables in the database. Are there similar views/tables that I can use to find all non standard (extra cost) options like label security, data mining, streams, advanced secuirty, etc.? Can please someone reply with relavant view/table names or queries?

Thanks,
Santosh

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 10 2007

Added on Jun 16 2006

#general-database-discussions

5 comments

1,506 views