Database Administration (MOSC)

MOSC Banner

Create general purpose SE database using DBCA - shows Enterprise features

edited Mar 16, 2018 10:59AM in Database Administration (MOSC) 12 commentsAnswered ✓

When you create a General purpose database for Standard Edition or Standard Edition One using DBCA from the installed oracle binaries, what features of Enterprise are still installed by default.

The reason I ask is that looking at the dba_feature_usage_statistics table it shows lots of features set to true.e.g -

set pages 999

col c1 heading 'feature'    format a45
col c2 heading 'times|used' format 999,999
col c3 heading 'first|used'
col c4 heading 'used|now'

select
   name             c1,
   detected_usages  c2,
   first_usage_date c3,
   currently_used   c4
from
   dba_feature_usage_statistics
where
   first_usage_date is not null

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center